Exporting Interactions from SAP Marketing Cloud

[arlene_milano]

Hi

We are following the blog :https://www.sap.com/cxworks/article/2589632519/extract_sap_marketing_cloud_data_with_cds_based_expor...

and in using this : Get Interactions with DeltaToken

GET /sap/opu/odata4/sap/cdi_cds/cdi_cds/sap/i_mkt_inter &$select=InteractionContactId,Interacti Host: {{SMC_HOST}} Prefer: odata.maxpagesize=10 Authorization: *

We are not seeing a way to get the 'Last changed' timestamp to fetch the Delta. Can someone help with that?

thanks

Arlene

[former_member226]

Hi,

In case you are looking for delat extraction then you need to pass "odata.track-changes" to the "Prefer" header and then a delta token will be generated. See e.g. below:

https://my322222.s4hana.ondemand.com/sap/opu/odata4/sap/cdi_cds/cdi_cds/sap/i_mkt_interaction/0001/F... gt 2021-10-25T08:21:09Z&$select=InteractionContactId,InteractionType

You can then use the datalink for the next records.

In case you are just performing the full extraction then you can(with the same URL as above) use "Prefer" header value as "odata.maxpagesize=<number>". See e.g. below:

For detailed explanation, pls do checkout https://help.sap.com/viewer/ccc9cdbdc6cd4eceaf1e5485b1bf8f4b/1709.latest/en-US/50f4ee6253134d3cafa25...

Thanks

Saurabh