Bulk Extract - by asset ID

[Pavel_Ivanov]

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

[SanfordWhiteman]

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

[Pavel_Ivanov]

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