topic Re: Json Format ( POST/PUT REST API ) in Talend Studio

Json Format ( POST/PUT REST API )

Aymen1 — Sat, 16 Nov 2024 00:58:50 GMT

Hello team,

I am a beginner with talend and I am looking to do a POST of this Json format

{

"data": [

{

"a": 46302,

"b": 816768,

"c": "5.000000"

}

]

}

How can I have this format with tWriteJsonField component ?? -- my message error : {"code":404,"message":"Json invalide"}

In advance, thank you for your answer .

Re: Json Format ( POST/PUT REST API )

aminegac — Fri, 11 Dec 2020 09:46:29 GMT

I have the solution, with each json extract component write the "json looppath querry" like this "$" and you will access the next element in the tree, ie you will get more details. then at the end, in the component "json extract" same thing but for the fields write the final fields of the json object like this "$ .id" "$ .name" "$ .firstname"

Re: Json Format ( POST/PUT REST API )

Aymen1 — Tue, 15 Dec 2020 13:30:58 GMT

I'm really thankful @amine kacem : it seems a good solution .

But i tried the solution in the picture and it works

Re: Json Format ( POST/PUT REST API )

aminegac — Thu, 17 Dec 2020 14:19:13 GMT

@Not defined Not defined welcome , i will also try yours ,thanks , i tried it in the past and it did not work because of that tree structue at right ,i did not knew what to put , i will try to do as you did.