SAP Knowledge Base Article - Public

2580081 - Error Message "We couldn't get the data from the Data Model" While Exporting EMail via Excel Using OData Services

Symptom

You have requirement to export all E-Mail via excel using OData Services and you are getting the below error message:

We couldn't get the data from the Data Model

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

1. Go to Excel.
2. Select Data view.
3. Select From Other Sources.
4. Select From Odata Data Feed.
5. Add the URL.

Cause

This is due to invalid special characters found during XML rendering for any specfic OData field.

Resolution

1. Skip the first 10000 records and then execute for a certain group of records for example next 100 records.
https://<Your Tenant>/sap/c4c/odata/v1/c4codata/EMailCollection?$skip=10000&$top=100

2. If error is found then split the set of 100 records into 50 and then execute.

https://<Your Tenant>/sap/c4c/odata/v1/c4codata/EMailCollection? $skip=10000&$top=50
https://<Your Tenant>/sap/c4c/odata/v1/c4codata/EMailCollection? $skip=10050&$top=50

3. If no errors are found then proceed for the next set of 100 records.
https://<Your Tenant>/sap/c4c/odata/v1/c4codata/EMailCollection?$skip=10100&$top=100

Repeat the above steps until all the records have been analyzed. After getting list of all the erroneous records, the corresponding field for all those Email IDs should be edited to remove those special characters.

Keywords

EMail Collection, OData, Data Model , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer 1802 ; SAP Hybris Cloud for Customer 1711