3600541 - How to perform date-wise extraction for the OData entity ChangeDocumentCollection

• The business requires extracting the changes made to tickets during the date range 2022.10.07 - 2022.10.14.
• How to perform date-wise extraction for the OData entity ChangeDocumentCollection?

SAP Cloud for Customer

Let's say you want to filter the changes made on the date range 2022.10.07 - 2022.10.14. Please use the URL:

https://my123456.crm.ondemand.com/sap/c4c/odata/v1/changedoclist/ChangeDocumentCollection?$filter=BusinessObject eq 'ServiceRequest' and (ChangeDateTime ge datetime'2022-10-07T00:00:00' and ChangeDateTime le datetime'2022-10-14T00:00:00')

Additionally, if you want to extract the data using MS Excel, please reorder the parameters. For instance, to extract data for the date range 2022.10.07 - 2022.10.14, use the URL below.

https://my123456.crm.ondemand.com/sap/c4c/odata/v1/changedoclist/ChangeDocumentCollection?$filter=(ChangeDateTime ge datetime'2022-10-07T00:00:00' and ChangeDateTime le datetime'2022-10-14T00:00:00') and BusinessObject eq 'ServiceRequest'

, where 123456 represents the tenant number.

• 2310920 - Datetime Filter not Working Using OData Service
• 2330688 - How to Use Methods And Filters in OData Services
• OData Service for Change Documents | SAP Help Portal

Change Log, ChangeDocumentCollection, ChangeDateTime, le, ge, OData, Change history, filter , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To

SAP Cloud for Customer core applications all versions