topic Re: How to convert JSON file to an array ? in Talend Studio

How to convert JSON file to an array ?

Eric_Talend — Fri, 15 Nov 2024 23:35:27 GMT

Hello,

I must call an API with PUT http method.

I have an JSON file but this API must have an JSON array.

I search and I search any solution (with tWriteJSONField or with "tConvertType"/"tReplace") but none solution is OK.

Has anyone ever had this use case ?

Kind regards.

Re: How to convert JSON file to an array ?

Anonymous — Wed, 27 Oct 2021 02:18:19 GMT

Can you show an example to explain what the Json data looks like? With tWriteJSONField, we can create a Json string as seen below, it contains an array element.

Re: How to convert JSON file to an array ?

Eric_Talend — Wed, 19 Jan 2022 16:04:46 GMT

Hello,

I still have the problem.

I have this :

and this is the description of tWriteJSONField :

But at the end, I don't have my JSON in array format. 😩

I'm not an expert of JSON format.

Kind regards

Re: How to convert JSON file to an array ?

Eric_Talend — Wed, 19 Jan 2022 16:16:35 GMT

I would like to add this precision :

the start of "logrow6"

Finaly, insert with API not working.

My main problem is the my JSON file is not an array.

The API must have an JSON array.

Re: How to convert JSON file to an array ?

Anonymous — Thu, 20 Jan 2022 04:15:57 GMT

@Eric Vincent , see below screenshot which showing how to define an array element.

Please try again and let me know if you have any problem.

Regards

Shong

Re: How to convert JSON file to an array ?

Eric_Talend — Thu, 20 Jan 2022 14:48:29 GMT

Hello,

thanks for your proposition.

I try to add this in my job but the result is not good.

When I add with CURL, I have this code :

curl -X PUT "https://myURL/api/table/rows" -H "accept: application/json" -H "Authorization: Basic XXX" -H "Content-Type: application/json" -d "[ { \"logindelagent\": \"XXX\", \"identifiantastre\": \"111\", \"projetservice\": \"XXX\", \"rattachement\": \"XXX\", \"responsable\": \"XXX\", \"statut\": \"XXX\" }]"

it is this code that I want to reproduce in json.

Kind regards.

Re: How to convert JSON file to an array ?

Eric_Talend — Thu, 20 Jan 2022 15:15:07 GMT

oh, I will try to add with CURL by removing "\" before each data and it's KO.

So, I must have this caracter before each element 😞