AnsweredAssumed Answered

Timezone for Bulk export API of activity

Question asked by Saptarshi Konar on Nov 6, 2019
Latest reply on Nov 7, 2019 by Sanford Whiteman

I am confused regarding the timezone, when a bulk export API for activity is called.

Example-

API- /bulk/v1/activities/export/create.json

JSON - {
     "format": "CSV",
   "filter": {
            "createdAt": {
                  "startAt": "2018-10-16T00:00:00Z",
                  "endAt": "2018-10-16T23:59:59Z"
               }
         }
}

 

I have tested with Date Range

  •                   "startAt": "2018-10-15T00:00:00Z",
                      "endAt": "2018-10-16T23:59:59Z"
  •                     "startAt": "2018-10-17T00:00:00Z",
                      "endAt": "2018-10-17T23:59:59Z"

API - /bulk/v1/activities/export/{exportId}/file.json

Result- No data found for all this time range

But when the input is -

                  "startAt": "2018-10-16T00:00:00Z",
                  "endAt": "2018-10-17T23:59:59Z"

Result- 13 records found 

 marketoGUID

leadId

activityDate

1913

1234

2018-10-16T16:26:06Z

1916

1234

2018-10-16T16:26:13Z

1921

1234

2018-10-16T16:31:22Z

1923

1234

2018-10-16T16:31:52Z

1929

134

2018-10-16T16:32:03Z

1947

118

2018-10-16T17:36:00Z

1950

113

2018-10-16T17:36:10Z

1969

113

2018-10-16T18:34:35Z

1972

213

2018-10-16T18:34:41Z

2003

987

2018-10-16T21:07:29Z

2006

987

2018-10-16T21:07:41Z

2012

1171

2018-10-16T21:12:10Z

2014

1171

2018-10-16T21:12:22Z

So which time zone is considered at the time of request and what is the timezone of the activityDate in the CSV output?

Outcomes