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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
RA6
Creator
Creator

Sending json data via tRESTClient

Hello folks,

 

I am currently retrieving data from a database, convert it to json and trying to send it through Rest service to a url.

 

0683p000009M93h.png

 

0683p000009M9GG.png

 

On execution, i am displaying the response using a tlog; the statusCode is "200" but the body and the string is empty:

[statistics] connecting to socket on port 3450
[statistics] connected
2020-01-09 19:46:29|Bgoo64|Bgoo64|Bgoo64|13788|Flux|_cXuq8BgoEeqgX817LbQYlg|0.1|platform||begin||
200||
200||
200||
2020-01-09 19:46:32|Bgoo64|Bgoo64|Bgoo64|13788|Flux|_cXuq8BgoEeqgX817LbQYlg|0.1|platform||end|success|2705
[statistics] disconnected
Job Flux_Recouvrement_2 ended at 19:46 09/01/2020. [exit code=0]


Can you advice please?

Thank you.

Labels (2)
1 Reply
rmartin2
Creator II
Creator II

Hi,

 

If you're giving a JSON, you need to send it via the "string" column, not the body. A JSON isn't a Document. Only XML can be.

So in input, send an empty Body, and a fields "string" in String, with your JSON inside, and you're good 0683p000009MACn.png

 

Sincerely,