Marketing Cloud - Mapping between EmailID and AssetID

Question

I am pulling campaign assets using the REST API, similarly to the method described here. However, the emails connected to the campaign are not marked as "type": "EMAIL", but as "type": "CMS_ASSET", with the itemID linking to Content Builder's Asset ID.

What I need to do is to connect the campaign information to specific sends on the job level. In the _Job data view, I have the Content Builder's Email ID available.

What are the possible ways by which I can retrieve the mapping between the Email ID and Asset ID?

Answer 1

I believe the value you're looking is actually called legacyID in the returned payload from the POST /asset/v1/content/assets/query route.

Let's assume you're payload looks like this:

{
    "page":
    {
        "page":1,
        "pageSize":500
    },
    "query":
    {
            "property":"data.campaigns.campaigns.campaignId",
            "simpleOperator":"equal",
            "value":4394

    },
    "fields":
    [
        "data",
        "name"
    ]
}

In response you're going to receive something like this:

{
    "count": 1,
    "page": 1,
    "pageSize": 500,
    "links": {},
    "items": [
        {
            "id": 43210,
            "customerKey": "AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEEE",
            "assetType": {
                "id": 321,
                "name": "htmlemail",
                "displayName": "HTML Email"
            },
            "name": "Your Email",
            "data": {
                "campaigns": {
                    "campaigns": [
                        {
                            "campaignId": 1234,
                            "campaignAssociationId": 4321
                        }
                    ]
                },
                "email": {
                    "options": {
                        "characterEncoding": "utf-8"
                    },
                    "legacy": {
                        "legacyId": 1020304,
                        "legacyKey": "AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEEE",
                        "legacyType": "email",
                        "legacyCategoryId": 10203
                    }
                }
            },
            "legacyData": {
                "legacyId": 1020304,
                "legacyKey": "5d449885-ac1b-49be-b20d-488d36175f36",
                "legacyType": "email",
                "legacyCategoryId": 10203
            },
            "modelVersion": 2
        }
    ]
}

From here you need to extract the data.legacy.legacyId or legacyData.legacyId properties