Patching JSON Data via CKAN API to a Website

Ulonis — Mon, 30 Sep 2024 12:30:38 GMT

Hi,

i moved myself into a dead end and a solution seems impossible to find right now. Maybe you can help me.

To my situation: It "should be" a simple job. Got some simple structured Data from an Oracle DB (3 Colums / 4 Rows) which has to be put on an Webserver as a JSON. I thought: so far no problem. I worked out the Data, used the tWriteJsonField to put the rows into a JSON loop and, from what i saw, the JSON looked good and was sorted out.
After this i added the tRestClient (fast forward lots of problems in communication... i got the information this is not a RESTful service but an older CKAN API to work with.)

With this hint things are now as follows:

I put the JSON Data into the REST input Column "String", Body should be empty as needed.
URL is provided as needed from the CKAN API documentation. https://docs.ckan.org/en/2.10/api/#ckan.logic.action.patch.resource_patch
To patch the data on the correct place i got an id and an auth token too. The auth should be in the header and the id somewhere in the body as far as i know.
I guess my error is to be found on this point here. Either i put one of both informations on the wrong place or i did configure the tRestClient wrongly. (ID is missing in the following screenshots, as this was an attempt where i put it right into the JSON looped Data.)

Running the Job will push me an HTTP 409 Conflict. Moving and changing up the positions of the ID and auth to other config fields doesn't change anything.

Thank you in advance for any help, hints or solutions,

Patrick

topic Patching JSON Data via CKAN API to a Website in Talend Studio

Patching JSON Data via CKAN API to a Website