topic Re: loop variables in tREST POST method in Talend Studio

loop variables in tREST POST method

SR2210 — Sat, 16 Nov 2024 02:26:52 GMT

Hi,

I have a job to extract data from an API and i'm using tREST component with a POST method.

These are the sample data from my API;

{
  "data": [
    {
      "name": "Lisa",
      "product": "product1",
      "unit": "unit1",
    },
    {
      "name": "Lisa",
      "product": "product1",
      "unit": "unit2",
    },
    {
      "name": "Lisa",
      "product": "product1",
      "unit": "unit3",
    }
]
}

so currently what i'm doing is i have 3 tREST component in my job to call all the data, each component has different value in the HTTP Body as below;

tREST_1 : "{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit1\"}"

tREST_2: "{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit2\"}"

tREST_3: "{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit3\"}"

my question is, is it possible to loop the unit instead of defining one by one unit in 3 different tREST component? is there any way that i can only use 1 tREST component but able to extract data for all units?

please let me know if i need to explain in detail, thanks!

Re: loop variables in tREST POST method

manodwhb — Thu, 14 May 2020 07:28:42 GMT

@SR2210 , you can use in tfixedflow have all three body and iterate by using tFlowtoIterate and use tjava component to print that body using a global variable and call the tRest component.

tfixedflowInput>>Main>>tFlowtoIterate>>Iterate>>tjava>>on component Ok>>tRest

Re: loop variables in tREST POST method

SR2210 — Thu, 14 May 2020 10:40:04 GMT

Hi @manodwhb, thank you for your reply.

This is my first time using tfixedflowinput, can you help to explain which mode should i select here and how do i define all three body in the component? Also, how do i call that in tREST HTTP Body section?

really appreciate your help, thank you in advance

Re: loop variables in tREST POST method

manodwhb — Thu, 14 May 2020 10:47:06 GMT

@SR2210 , use Inline content and check the below link to more about this component.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/1UUiC6QzuUN4eQE4niDz4w

Re: loop variables in tREST POST method

manodwhb — Thu, 14 May 2020 11:59:37 GMT

@SR2210 , your job design should be like below.

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 02:45:17 GMT

Hi @manodwhb,

i'm not sure if i'm doing this correctly. I managed to print the body in tJava component and link it to tREST as below;

is that how i should call the body in HTTP Body section in tREST? If yes, when i run the job i got a "204" error that means no content. I'm sure that the data is there as i have tried to define the body directly in tREST and the data is shown correctly.

Please assist, thank you

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 02:58:58 GMT

@manodwhb, i've tried as below but got the same "204" error.

tJava component

tRest component

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 04:50:03 GMT

@SR2210 , print the body in java and check that is that correct on or not which you were passing. bypassing same body from postman is it working?

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 05:15:48 GMT

Hi @manodwhb, I've print the body and it's showing correct as what i defined in tfixedflowinput. i tried to use the same body in tREST and postman and it's working

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 05:20:17 GMT

@SR2210 ,then it could be a body that you need to pass in ", please check.

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 05:21:47 GMT

@SR2210 , if you have access to the API, you can check payload has passed from Talend in the backend.

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 05:54:37 GMT

@manodwhb it's not working..

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 05:59:56 GMT

@SR2210, Great.

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 06:11:12 GMT

@manodwhb sorry if you missed my message, i was saying it is not working. i think that the ((String)globalMap.get("body")) in my tREST fails to get the value from tJava. i have tried with "" and without still it's showing the same error

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 06:13:01 GMT

@SR2210 , can you check in the backend to that API what json payload coming to API?

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 06:14:22 GMT

unfortunately i dont have access to the API

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 07:37:47 GMT

@SR2210, is that api can be tested with any bodayone? and what was payload you set in tfixedflow input?show that payload.

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 07:47:43 GMT

@SR2210 , when you pass below body it was working right in trest component? if yes you need to check that in tfixedflow are you passing the same way or not if yes you are passing you need to check the api url is the same are you using.

"{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit1\"}"

Re: loop variables in tREST POST method

SR2210 — Fri, 15 May 2020 08:56:32 GMT

@manodwhb okay it's working now. what i did was remove all the \ in the body and remove tJava component. tFlowToIterate is linked directly to tREST.

in tfixedflowinput i define it like this;

{"name":"Lisa","product":"P1","unit":"unit1"} instead of "{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit1\"}"

@manodwhb wrote:

@SR2210 , when you pass below body it was working right in trest component? if yes you need to check that in tfixedflow are you passing the same way or not if yes you are passing you need to check the api url is the same are you using.

"{\"name\":\"Lisa\",\"product\":\"P1\",\"unit\":\"unit1\"}"

Thank you for your help

Re: loop variables in tREST POST method

manodwhb — Fri, 15 May 2020 09:09:49 GMT

@SR2210 , i have asked to use tjava to print the payload before passing to api to know that are you passing correctly or not.