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

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

SAP Hybris Cloud for Customer

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

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

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.

EMail Collection, OData, Data Model , KBA , odata service , odata feed , data model , LOD-CRM-INT-API , OData API (C4C Only) , Problem

SAP Cloud for Customer add-ins 1802 ; SAP Hybris Cloud for Customer add-ins 1711