Attention: The Marketo Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.

Bulk Extract - by asset ID

Pavel_Ivanov
Level 2

Bulk Extract - by asset ID

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
    }
}

 

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk Extract - by asset ID

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).