Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ulonis
Contributor II
Contributor II

Patching JSON Data via CKAN API to a Website

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.)

modules.PNG

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.)

REST_basic.PNG

REST_advanced.PNG

 

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

Labels (4)
0 Replies