> For the complete documentation index, see [llms.txt](https://timetackle.gitbook.io/tackle/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://timetackle.gitbook.io/tackle/api-categories/export.md).

# Exports

## POST /export-sheets

> Export calendar data

```json
{"openapi":"3.0.3","info":{"title":"Tackle API","version":"1.0.0"},"servers":[{"url":"https://api.timetackle.com/external-api/v1"}],"paths":{"/export-sheets":{"post":{"summary":"Export calendar data","parameters":[{"in":"query","name":"page","required":true,"schema":{"type":"integer"},"description":"The page number of the results to retrieve."},{"in":"query","name":"limit","required":true,"schema":{"type":"integer","maximum":500},"description":"The number of results to return per page. Maximum value is 500."}],"requestBody":{"required":true,"content":{"application/json":{"schema":{"$ref":"#/components/schemas/ExportRequest"}}}},"responses":{"200":{"description":"Successful export response","content":{"application/json":{"schema":{"oneOf":[{"$ref":"#/components/schemas/MergeAllResponse"},{"$ref":"#/components/schemas/GroupedResponse"}]}}}}}}}},"components":{"schemas":{"ExportRequest":{"type":"object","properties":{"groupId":{"type":"integer","nullable":true,"description":"If provided, calendarIds will be ignored."},"calendarIds":{"type":"array","items":{"type":"string"},"default":[],"nullable":false,"description":"If not provided, all calendars data will be exported."},"startDate":{"type":"string","format":"date","description":"If not provided will be exported current months data."},"endDate":{"type":"string","format":"date","description":"If not provided will be exported current months data."},"since":{"type":"string","format":"date-time","description":"If not provided will be exported all data"},"timezone":{"type":"string"},"mergeAll":{"type":"boolean","default":true,"description":"If true, data from different calendars will be merged into a single array; if false, data will be in a key-value format with the calendarId as the key."},"filters":{"type":"object","properties":{"tag":{"type":"array","items":{"type":"string"},"default":[],"description":"(array of string, default none) To filter data by tags applied. Tag key value should be in format key:value or key if tag value is empty. Example [”Account:Tackle”, “Break”, “Daily:Sync”]"},"rsvp":{"type":"boolean","default":false},"allDay":{"type":"string","enum":["INCLUDE","EXCLUDE"]},"search":{"type":"array","items":{"type":"string"},"default":[]},"hasCrmAccount":{"type":"boolean","default":false},"hasCrmOpportunity":{"type":"boolean","default":false},"hasCrmOpportunityOwner":{"type":"boolean","default":false},"hasCrmStage":{"type":"boolean","default":false},"crmAccountTags":{"type":"array","items":{"type":"string"},"default":[]},"crmOpportunityTags":{"type":"array","items":{"type":"string"},"default":[]},"crmOpportunityOwnerTags":{"type":"array","items":{"type":"string"},"default":[]},"crmStageTags":{"type":"array","items":{"type":"string"},"default":[]}}},"formatting":{"type":"object","properties":{"date":{"type":"string","enum":["MM_DD_YYYY","DD_MM_YYYY","YYYY_MM_DD"],"default":"MM_DD_YYYY","description":"Date format options."},"time":{"type":"string","enum":["HOUR_MIN_AMPM","HOUR_MIN_24"],"default":"HOUR_MIN_AMPM","description":"Time format options."},"duration":{"type":"string","enum":["HOURS_IN_DECIMAL","HOUR_MIN"],"default":"HOURS_IN_DECIMAL","description":"Duration format options."},"excludeResource":{"type":"boolean","default":false,"description":"Attendee filter, excludes resource-type attendees if true."},"excludeOrganizer":{"type":"boolean","default":false,"description":"Attendee filter, excludes organizer attendees if true."},"singleColumnTag":{"type":"boolean","default":true,"description":"Shows all tags in single column"}}},"fields":{"type":"object","properties":{"tags":{"type":"boolean","default":true},"sumAll":{"type":"boolean","default":false},"endDate":{"type":"boolean","default":true},"endTime":{"type":"boolean","default":true},"subject":{"type":"boolean","default":true},"dayTotal":{"type":"boolean","default":false},"duration":{"type":"boolean","default":true},"location":{"type":"boolean","default":false},"dayOfWeek":{"type":"boolean","default":false},"startDate":{"type":"boolean","default":true},"startTime":{"type":"boolean","default":true},"eventNotes":{"type":"boolean","default":false},"createdDate":{"type":"boolean","default":true},"createdTime":{"type":"boolean","default":true},"description":{"type":"boolean","default":false},"createdByName":{"type":"boolean","default":false},"createdByEmail":{"type":"boolean","default":false},"conferenceLinks":{"type":"boolean","default":false},"organizedByName":{"type":"boolean","default":false},"organizedByEmail":{"type":"boolean","default":false},"allAttendeesByName":{"type":"boolean","default":false},"allAttendeesByEmail":{"type":"boolean","default":false},"acceptedAttendeesByName":{"type":"boolean","default":false},"declinedAttendeesByName":{"type":"boolean","default":false},"acceptedAttendeesByEmail":{"type":"boolean","default":false},"declinedAttendeesByEmail":{"type":"boolean","default":false},"tentativeAttendeesByName":{"type":"boolean","default":false},"tentativeAttendeesByEmail":{"type":"boolean","default":false},"notRespondedAttendeesByName":{"type":"boolean","default":false},"notRespondedAttendeesByEmail":{"type":"boolean","default":false},"crmAccountId":{"type":"boolean","default":false},"crmAccountName":{"type":"boolean","default":false},"crmOpportunityId":{"type":"boolean","default":false},"crmOpportunityName":{"type":"boolean","default":false},"crmOpportunityOwnerId":{"type":"boolean","default":false},"crmOpportunityOwnerName":{"type":"boolean","default":false}}}}},"MergeAllResponse":{"type":"object","properties":{"success":{"type":"boolean"},"data":{"type":"object","properties":{"data":{"type":"array","items":{"type":"object","properties":{"calendar":{"type":"string","description":"Title of the calendar"},"calendarId":{"type":"string","description":"Id of the calendar"},"eventId":{"type":"string","description":"Id of the event"},"endDate":{"type":"string","description":"End date of the event"},"subject":{"type":"string","description":"Subject of the event"},"allAttendeesByEmail":{"type":"string","description":"All attendees email"},"description":{"type":"string"},"duration":{"type":"string"},"createdDate":{"type":"string"},"createdTime":{"type":"string"},"startTime":{"type":"string"},"endTime":{"type":"string"},"startDate":{"type":"string"},"tags":{"type":"string"}}}},"pagination":{"type":"object","properties":{"hasNext":{"type":"boolean"},"hasPrevious":{"type":"boolean"},"page":{"type":"integer"},"totalElements":{"type":"integer"},"limit":{"type":"integer"}}},"authRequired":{"type":"array","items":{"type":"string"}}}}}},"GroupedResponse":{"type":"object","properties":{"success":{"type":"boolean"},"data":{"type":"object","properties":{"data":{"type":"object","additionalProperties":{"type":"array","items":{"type":"object","properties":{"calendarId":{"type":"string","description":"Id of the calendar"},"eventId":{"type":"string","description":"Id of the event"},"endDate":{"type":"string"},"subject":{"type":"string"},"allAttendeesByEmail":{"type":"string"},"description":{"type":"string"},"duration":{"type":"string"},"createdDate":{"type":"string"},"createdTime":{"type":"string"},"startTime":{"type":"string"},"endTime":{"type":"string"},"startDate":{"type":"string"},"tags":{"type":"string"},"Tag2":{"type":"string"},"Tag3":{"type":"string"}}}}},"pagination":{"type":"object","properties":{"hasNext":{"type":"boolean"},"hasPrevious":{"type":"boolean"},"page":{"type":"integer"},"totalElements":{"type":"integer"},"limit":{"type":"integer"}}},"authRequired":{"type":"array","items":{"type":"string"}}}}}}}}}
```