SAP Knowledge Base Article - Public

3445622 - Exporting Data from SAP Cloud for Customer (C4C) to Excel Using OData Collections

Symptom

You are trying to export/extract data from C4C to Excel using OData Collection for Specific BO.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Cloud for Customer

Resolution

Extraction of Data from SAP Cloud for Customer (C4C) to Excel Using OData Collections is possible following below steps

Determine the OData service URL for accessing the data you want to extract. This URL typically follows a pattern like: 

https://<tenant>.crm.ondemand.com/sap/c4c/odata/v1/<entitySetName>

For Example: You would like to extract ServiceRequest Collection, then URL will be

https://<tenant>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection

  • Open Excel and navigate to the "Data" tab.
  • Click on "Get Data" or "From Other Sources" depending on your Excel version.
  • Choose "From OData Feed" or "From OData Data Feed".
  • Enter the OData service URL (https://<tenant>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection) in the provided field and click "OK".
  • Choose logon method, If you are using Username and Password method then you can choose Basic-> Provide credentials and choose URL that you want to extract the data.

  • Click on connect and load the data, Now you can see the expected BO data extracted without any issue.
  • Now you can Save the Excel file with an appropriate name.

Keywords

Extract  data Excel extraction , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer core applications all versions