Bulk Extract - by asset ID | Community
Skip to main content
Level 2
August 20, 2024
Question

Bulk Extract - by asset ID

  • August 20, 2024
  • 1 reply
  • 994 views

Hi, apologies for I'm about to sound really green and awkward probably.

I'm really new to the Bulk Extract capabilities of Marketo, but am thinking that it might solve some issues I'm facing. I am looking to create an extract that will give me all email opens for a particular asset (email/program) for a particular time frame. I'm using the Bulk Extract method and crating a job via

POST https://113-XEI-808.mktorest.com/bulk/v1/activities/export/create.json?access_token=XXXXXXXXXX

The body of the request is the following. I'm trying to use the asset (program) ID to limit the results, but it shows me results for a number of other assets too:

 

 

{ "format": "CSV", "filter": { "createdAt": { "startAt": "2024-08-14T00:00:00-00:00", "endAt": "2024-08-30T23:59:59-00:00" }, "activityTypeIds": [ 10 ], "assetId": 2724 } }

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
Level 10
August 20, 2024

In this context I don’t believe assetId(s) is a supported filter. Instead, use primaryAttributeValueIds and primaryAttributeValues (note both are arrays, even if they have only one item).

PavelIv1Author
Level 2
August 22, 2024

I'm trying with a lot of different variants and can't manage to make it work. I tried with IDs and name of the program. I must be doing something super wrong.

 

 

{ "format": "CSV", "filter": { "createdAt": { "startAt": "2024-08-14T00:00:00-00:00", "endAt": "2024-08-30T23:59:59-00:00" }, "activityTypeIds": [ 10 ], "primaryAttributeValue": "2024-08 Customer Campaign - Wave 5" } } }