2687413 - How to Access the External ID Mapping of Accounts and Products Using OData

You want to access the External IDs from replicated Accounts and Products using the OData API V2 service -> C4CODATAAPI, but you cannot find the ExternalIDMapping collection or the navigations.

• SAP Cloud for Customer.

1. Open the URL https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/$metadata in Google Chrome, Postman tool or any other tool that works with OData REST APIs(myXXXXXX represents the URL of your C4C system).
2. See there is no ExternalIDMapping collection or navigation property listed in the service metadata.

The ExternalIDMapping collection is not yet available in the C4CODATAAPI service.

You can access the ExternalIDMapping collection by using the service C4CODATA (although the service is marked as deprecated, it will only be retired on February of 2020).

To get the external ID mappings you can use the following URLs:

• Account External ID Mapping -> https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codata/AccountCollection?$expand=ExternalIDMapping
• Product External ID Mapping -> https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codata/ProductCollection?$expand=ExternalIDMapping

OData API V2 Reference

External ID Mapping, ExternalIDMapping, ProductCollection, AccountCollection , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem