topic Re: tRest HTTP Body in PUT Method in Talend Studio

tRest HTTP Body in PUT Method

Anonymous — Thu, 30 May 2019 01:37:20 GMT

Hi Guys, Can anyone guide me on the below requirement.

I have a better understanding of GET & DELETE methods and struck with PUT. I have to update two attributes(fields) in my client console.

I have a spreadsheet with four columns, ID, Name, Name2 & Name3. The requirement was to update Name3 & Name4 for each IDs. I will pass ID in the URL to update records (https://aaa/bbb/cccc/2.0/dddd/ffff/1010), and I have done this before. For PUT method, we required to pass HTTP Body in tRest. And it's mandatory to include ID & Name here, since those are unique matches to update Name3 & Name4. (pl see below JSON)

{
"name": "Test1",
"id": "1010",
"name3": "test123",
"name4": "test456"
}

Please guide me to achieve this by providing components and flow?

Thanks in Advance!!

KarthI

Re: tRest HTTP Body in PUT Method

nfz11 — Fri, 31 May 2019 01:29:50 GMT

The tRestClient component is better suited for this as it has more features than tRest. You would construct the JSON body however you want before the tRestClient, e.g. with a tWriteJSONFields or tJavaRow component. Declare a String schema variable called 'string' that contains the body. tRestClient will read the body from here. Select the 'PUT' method in the tRestClient and fill out any other variables you need. You can use variables in the URL and relative path fields in tRestClient so you can dynamically build your REST URL with the ID, for example. Set the content type to JSON.

See here for the full documentation on tRestClient.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/~V42EBQClKxKQghNvzHF1g

Re: tRest HTTP Body in PUT Method

Anonymous — Fri, 31 May 2019 20:43:51 GMT

Thanks, dude. Its worked but still, I am facing runtime error. I have googled a bit and found may be a chance of missing Environment variables(JAVA PATH) in my machine, but files(jdk & jre) advanced versions exist.

Attached the screenshot for reference. Please advice.

Re: tRest HTTP Body in PUT Method

nfz11 — Fri, 31 May 2019 20:55:55 GMT

Did you move your project around or put it in a new folder? That looks like Talend cannot find the project at the location where you are trying to run it.

Re: tRest HTTP Body in PUT Method

Anonymous — Fri, 31 May 2019 21:22:34 GMT

My Project inside the workspace, but still it's showing the error.

Re: tRest HTTP Body in PUT Method

nfz11 — Fri, 31 May 2019 21:44:13 GMT

You could try building the project again or restarting Studio.

Re: tRest HTTP Body in PUT Method

Anonymous — Fri, 31 May 2019 23:54:15 GMT

Hi, The above issue has been fixed. But now we are facing the issue in tRESTClinet, can you please help us to fix the below.

Error Detail: