topic Re: how to get the data from post request to trestclient and convert json data to csv file?? in Talend Studio

how to get the data from post request to trestclient and convert json data to csv file??

amit_n — Sat, 16 Nov 2024 06:32:51 GMT

how to get the data from post request to trestclient and convert json data to csv file??

in postman i am able to get the data from post request.

URL :

https://io_dynamics_crm_data/entity_name

body:

{
"TimeStamp_Input": "2019-02-10T02:00:00.00Z",
"EntityAndEventsJSON_Input": "{\"EntityAndEventsList\":{\"EntityName\":\"indskr_positiongroups\",\"Events\":[33,34]}}"
}

result:

{
"@odata.context": "https://io-dynamics.com/data/v8.2/$metadata#Microsoft.Dynamics.",
"JSONOutput": "{\"AuditDataSet\":[{\"AuditID\":\"cdbb2002-9430-e911-b8b3-0004ff9d738f\",\"ChangedBy\":\"a6eba981-bb15-e911-a981-000d3af49b9e\",\"ChangedColumns\":null}]

}

how to get the data from the trestclient to invoke the body to the trestclient.

Re: how to get the data from post request to trestclient and convert json data to csv file??

Anonymous — Wed, 20 Feb 2019 08:52:17 GMT

Hi,

Did you try tRest Component instead of tRestClient? Please refer the link below for details.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/8F133z8E6BVS9WpHKRkYUw

The output data can be transferred parsed by JSON extract component of Talend and can be further passed to csv output file.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: how to get the data from post request to trestclient and convert json data to csv file??

amit_n — Thu, 21 Feb 2019 05:49:50 GMT

i tried with the different method ..i have used the json string and pass it to the trestclient component.

now i am able to get the response in the i tlogrow. I have attached the screen shot of the trestlient post response . please let me know how to extract these response through textractfiledjson or any other component to convert it into csv file.

json1.JPG
json2.JPG
json3.JPG

Re: how to get the data from post request to trestclient and convert json data to csv file??

Anonymous — Thu, 21 Feb 2019 05:55:56 GMT

Hi,

Please refer the below posts so that you will get idea about how to extract JSON fields.

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/LcNrhqdlyheCLpwyUwgJQw

https://community.talend.com/t5/Design-and-Development/Consuming-REST-API-and-extracting-JSON-Fields/td-p/52975

The second link is a real world example done by one of the Talend community member.

This should give you a path to resolve your use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: how to get the data from post request to trestclient and convert json data to csv file??

amit_n — Thu, 21 Feb 2019 12:43:09 GMT

I have tried with the textractjsonfield to extract the data from response from trestrest client.

I am getting blank . Please find the attached screen shot. let me know where m doing wrong.

response_data_trestclient.JPG
json1.JPG
json2.JPG

Re: how to get the data from post request to trestclient and convert json data to csv file??

Anonymous — Thu, 21 Feb 2019 13:01:50 GMT

Hi,

Your JSON output seems to be embedded in a XML message. Why are you not parsing the XML first?

You will have to first pick the JSON Ouput message and then parse the data.

Please use tLogrow at each stage till you get correct output. Then you will be able to monitor the results in each stage and can identify the error also easily.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂