Technical table who stores Account ID

[CristobalOr]

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 solution]

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