SAP Marketing Cloud Odata API with Upsert function Integration with AWS

[bhaskar_idp]

Hi,

I have created CBO to consume data from external system in AWS.
I created custom communication scenario and arrangement. I am trying to post the data into system by using sap_upsert import function but not able to post it.

I am using Postman with x-csrf token but still not able to do.

Please check here for error.

Please check the payload here.

Any idea on this?

If this is not possible i need to use CUAN_BUSINESS_DOCUMENT_IMP_SRV service to import the data.

For all of my scenario's we are avoiding integration with SCPI.

Regards,

Bhaskar

[former_member226]

Hi Bhaskar,

When using"Sap_upsert" no need to pass any payload/body. "Sap_upsert" is a function import(or in other words action) for which system do not expect any data as body/payload. You need to pass everything in the URL itself as mentioned in the official documentation.You can also find a detailed explanation here: https://answers.sap.com/questions/12698514/upsert-in-odata-service.html

For example you have a BO Named YY1_TEST1103 whose root node is also called as "YY1_TEST1103". This BO Contains 3 fields: ID,ID_ORIGIN, TEST. In such case in order to trigger a upsert request you just need to call following URL with POST method:

https://<HostName>/sap/opu/odata/SAP/YY1_TEST1103_CDS/YY1_TEST1103Sap_upsert?ID='sk@sap.com.de'&ID_ORIGIN='EMAIL'&TEST='API'

postman-api-call.png

I hope it helps a bit.

BR
Saurabh