Salesforce Composite API Request (Patch)

Question

To enable the use of API's to update fields in Salesforce i need to use the REST Patch API request.

Updating a single object is working using /services/data/vXX.X/sobjects;

But if i need to update multiple records i read i need ot use the composite request: services/data/vXX.X/composite/sobjects

The payload is a JSON input (also mentioned in the header in content-type) in the following format, formatting the payload is done via a formula to ensure the flexibility in the different Fields.

{"allOrNone" : true,
"records" : [{
"attributes" : {"type" : "OBJECTNAME" },
"id" : "IDXX" ,
"FIELD1" : "INPUT1",
"FIELD2" : "INPUT2"
}]
}

I've tested the solution and it is working in POSTMAN and in WORKBENCH but it isn't working in Alteryx.

Have searched the internet but i didn't get any answers.

Does somebody have this working (PATCH request on Salesforce using COMPOSITE request).

If so, could you help me to solve this?

I've also tried to build the JSON field via the JSON Build transformation but got stock in the nested fields (see example above).

JoostvdVeen · Answer

Thanks for the response but id already had seen your comment and tried this. If i add the content-type as parameter from a column of field it doesn't change.

Same if i add the json body as text from a column of as text in the download tool.

It is only not working for the Salesforce composite PATCH request, if i perform a PATCH request for a single object it is working.

dreldrel · Answer

Hey @JoostvdVeen, you may be experiencing a similar issue to the one described in the post below, which is quite common. If your settings work in Postman, then try slightly adjusting the settings in your Formula and Download tools. I've shared a few suggestions in the post that could be useful. Hope this helps.

Link: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/POST-API-Request-via-Download-Tool/m-p/1431996#M353893