Technical table who stores Account ID

Question

Hello,We are doing a bit of inventory and I was wondering if there is a table that we could check to see the Account ID mentioned in this documentation:https://experienceleague.adobe.com/en/docs/experience-platform/destinations/catalog/social/facebook The one mentioned as: Account ID: Your Facebook Ad Account ID. You can find this ID in your Facebook Ads Manager account. When entering this ID, always prefix it with act_. We would like to check it from query service, so we can know which destinations are using which accounts.We have inspected the technical tables, but this field doesn't seem to be available.Thanks in advance

brekrut · Accepted Answer

@cristobalor

This information is not stored in the data lake of AEP, but this information is available in the target connections end point.

/GET https://platform.adobe.io/data/foundation/flowservice/connections

Please see the documentation below as reference.

https://developer.adobe.com/experience-platform-apis/references/destinations/#tag/Target-connections

Here is an example of the /GET call for the target connections end point.

{
            "id": "28a480b1-94a3-49a3-988b-e802dbfb03dd",
            "createdAt": 1694109414574,
            "updatedAt": 1694109414574,
            "createdBy": "<<value>>",
            "updatedBy": "<<value>>",
            "createdClient": "<<value>>",
            "updatedClient": "<<value>>",
            "sandboxId": "<<value>>",
            "sandboxName": "<<value>>",
            "imsOrgId": "<<value>>",
            "name": "FB Destination Feed",
            "description": "FB Destination Feed",
            "connectionSpec": {
                "id": "b2584c83-9351-48fe-92f1-fb7244ae205b",
                "version": "1.0"
            },
            "state": "enabled",
            "auth": {
                "specName": "oauth2",
                "params": {
                    "accountId": "<<Facebook Account ID value>>"
                }
            },
            "version": "\"0300917d-0000-0200-0000-64fa0ee60000\"",
            "etag": "\"0300917d-0000-0200-0000-64fa0ee60000\"",
            "lastOperation": {
                "started": 0,
                "updated": 0,
                "operation": "create"
            }
        }

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded