topic Re: Use JSON File as HTTP Body in tREST request in Talend Studio

Use JSON File as HTTP Body in tREST request

rayzorsan — Fri, 15 Nov 2024 23:35:53 GMT

Hi All,

I am trying to use a local JSON file as the body in a request using the tREST component. I also tried the tRESTClient component.

What is the simplest way to take a file and use it in the body of the HTTP request? I want to use the raw input from the file because when I use tMap it keeps escaping the special characters in the JSON.

INPUT:

{

"name":"Test",

"fruits":[

"Apples",

"Bananas"

]

}

OUTPUT:

{

"fileInfos": [

{

"name": "Test",

"fruits___": "[\"Apples\",\"Bananas\"]"

}

]

}

Thanks,

Ray

Re: Use JSON File as HTTP Body in tREST request

Anonymous — Mon, 25 Oct 2021 02:29:52 GMT

Have a try to read the file as a string using tFileInputRaw, pass the string to tRest as Http body (with post method).

Regards

Shong

Re: Use JSON File as HTTP Body in tREST request

rayzorsan — Mon, 25 Oct 2021 22:20:17 GMT

Hi Shong,

Thanks for your reply!

I was just finishing up some work with the Raw File components. Seems the key is to use global variables. I have a deadline to meet with this but will post a video or something later about how I am handling complex JSON structures. As it seems nested arrays create some pretty difficult to deal with special characters in the JAVA.

Talk soon,

Ray

Re: Use JSON File as HTTP Body in tREST request

rayzorsan — Tue, 25 Jan 2022 20:12:09 GMT

Hi All,

I was able to do this more simply using Talend and some python locally. You can:

Get the JSONs you need
run python as it is supported natively (tsystem or otherwise)
use tfilelist to reference the jsons
use tjavaflex to connect to a talend rest component
do the operation in the talend rest component ( I used trestclient)

Thanks,

Ray