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 Member · Accepted solution]

Hi bhaskar.idp. The other option you have is using the $batch operation to update the instances of the CBO.

For that option you will need the following:

1. Get the UUID from the CBO

Example query: https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/YY1_CBO_NAME_CDS/YY1_CBO_NAME?$format=jso... eq 'value'

From the result you must get the SAP_UUID attribute.

2. Use the $batch operation

URL: https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/YY1_CBO_NAME_CDS/$batch

Body:

--batch
content-type: multipart/mixed;boundary=changeset

--changeset
content-type: application/http
content-transfer-encoding: binary

MERGE YY1_CBO_NAME(guid'<the one you get from the SAP_UUID value>') HTTP/1.1
Accept: application/json
content-type: application/json
SAP-CUAN-ForceSynchronousProcessing: X

{
    "Att1": "Value1",
    "Att2": "Value2"
}

--changeset--
--batch--

With that you will be able to update the CBO instance. Let me know if you need more help.

Regards,