Having trouble with Batch Export Activity IDs | Community
Skip to main content
FirstEnt_Develo
FirstEnt_Develo
Level 2
January 23, 2020
Solved

Having trouble with Batch Export Activity IDs

  • January 23, 2020
  • 3 replies
  • 5796 views

Hi everyone,

I am trying to set up a daily process to retrieve all of our unsubscribes from the activity batch export. However, when I specify the activity ids that I want, the batch is ignoring them and returning the full data set. Not sure what is going on here, TIA.

Here is my json that I am sending as part of my request. I know that 9 is the unsubscribe id, I just have 5 in there as a test

"{

      "format": "CSV",

      "filter":{"createdAt":{"startAt":"2019-12-27T00:00:00Z","endAt":"2019-12-28T00:00:00Z"} },

      "activityTypeIds": [5,9]

}"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman
{
   "format" : "CSV",
   "filter" : {
      "createdAt" : {
         "startAt" : "2019-12-27T00:00:00Z",
         "endAt" : "2019-12-28T00:00:00Z"
      }
   },
   "activityTypeIds" : [ 5, 9 ]
}‍‍‍‍‍‍‍‍‍‍

That doesn't conform to the JSON schema.

It should be:

{
   "format" : "CSV",
   "filter" : {
      "createdAt" : {
         "startAt" : "2019-12-27T00:00:00Z",
         "endAt" : "2019-12-28T00:00:00Z"
      },
      "activityTypeIds" : [ 5, 9 ]
   }
}‍‍‍‍‍‍‍‍‍‍

3 replies

M
Mark_Price
Level 6
January 23, 2020

What happens if you remove the 'Z' on the end of the date/times? 

FirstEnt_Develo
FirstEnt_DeveloAuthor
Level 2
January 23, 2020

Hi Mark,

just left the date, still the same problem

M
Mark_Price
Level 6
January 24, 2020

hmm..  did you check what the activityTypeIds are ? 

This will retrieve a list:  

https://developers.marketo.com/rest-api/lead-database/activities/#describe  

In my instance values 4 and 5 aren't listed.   Not sure if that's true for all, but worth checking 

Harish_Gupta6
Harish_Gupta6
Level 6
January 24, 2020

Didn't see Activity type 5 in my instance but Activity 9 is for Unsubscribe and below are the step which we are using:

1) Get the Access Token

2) Get the nextPageToken Eg

URL:/rest/v1/activities/pagingtoken.json
Pass DateTime: 2019-01-01T00:00:00-08:00 in the query parameter
3) Fetch the activities and add nextPageToken  and Activitytypeids in the query parameter in the request
Harish Gupta
FirstEnt_Develo
FirstEnt_DeveloAuthor
Level 2
January 24, 2020

hm... I'll try this, but I'd like to do it with the batch option, if possible. If this works, though, I guess we will switch over.

The 5 type was just a placeholder for my testing

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
January 24, 2020
{
   "format" : "CSV",
   "filter" : {
      "createdAt" : {
         "startAt" : "2019-12-27T00:00:00Z",
         "endAt" : "2019-12-28T00:00:00Z"
      }
   },
   "activityTypeIds" : [ 5, 9 ]
}‍‍‍‍‍‍‍‍‍‍

That doesn't conform to the JSON schema.

It should be:

{
   "format" : "CSV",
   "filter" : {
      "createdAt" : {
         "startAt" : "2019-12-27T00:00:00Z",
         "endAt" : "2019-12-28T00:00:00Z"
      },
      "activityTypeIds" : [ 5, 9 ]
   }
}‍‍‍‍‍‍‍‍‍‍
FirstEnt_Develo
FirstEnt_DeveloAuthor
Level 2
January 27, 2020

Thank you Sanford,

I had copied the json from another process and didn't realize it sits inside the filter. Now I'm getting a 500 error when trying to download the file, but I'm sure it's unrelated.

EDIT: I was running the batch for a day that had no unsubscribes, which resulted in the 500 error. 

Terms & ConditionsAccessibility statement

Loading footer...