Get value from a table in tExtractJSONFields component

ShZ — Fri, 03 Nov 2023 15:58:22 GMT

Hi everyone,

I am very new to Talend and started to develop jobs on my own with the online documentation.

My input is a CSV file which contains an ID list. I am iterating on each ID from this list to make an API call thanks to the tRestClient component. The JSON response shows a table containing many events related to the object (see at the end of the post).

My goald is to get the EventDate value corresponding to the event having EventType = 5 for my current Id.

I put a JSONPath expression (which seems to work as expected) to filter my result

in my tExtractJSONFields

and mapped the "EventDate" field :

But it seems that I have no output row :

Can someone help me with that issue ?

Thanks a lot.

Full JSON response :

{

"ResultItem": [

{

"EventDate": "2023-02-08T13:32:04.937Z",

"EventType": 5,

"UserId": "05c92833-a140-4fc7-9484",

"UserLastName": "DUPONT",

"UserFirstName": "Martin",

"UserMail": "martin.dupont@company.com",

"Description": "Event 5 description",

"ElementOldVersion": null

{

"EventDate": "2023-02-08T13:30:51.410Z",

"EventType": 2,

"UserId": "5dd93538-5160-492b-9552",

"UserLastName": "THOMAS",

"UserFirstName": "Robert",

"UserMail": "robert.thomas@company.com",

"Description": "Event 2 description",

"ElementOldVersion": null

{

"EventDate": "2023-02-08T13:24:07.140Z",

"EventType": 1,

"UserId": "97da651a-1ff4-45cd-bd5a",

"UserLastName": "PETIT",

"UserFirstName": "Luc",

"UserMail": "luc.petit@company.com",

"Description": "Event 1 description",

"ElementOldVersion": null

{

"EventDate": "2023-02-08T13:23:15.993Z",

"EventType": 9,

"UserId": "97da651a-1ff4-45cd-bd5a",

"UserLastName": "PETIT",

"UserFirstName": "Luc",

"UserMail": "luc.petit@company.com",

"Description": "Event 9 description",

"ElementOldVersion": null

}

"ResultCode": 0,

"Message": "Operation successful"

}

Re: Get value from a table in tExtractJSONFields component

jonlar — Sun, 05 Nov 2023 15:42:48 GMT

Hi,

First off your filter will not work as intended. As you can see from your screen shot, there is no outputted data from your tExtractJson component. To fix this, simply remove the single quotes from the filter value since the field type is a numerical value and not a string. So your filter should look like this -> "$.ResultItem[?(@.EventType == 5)]"

Then to retrieve the EventDate field, simply use the following expression "$.EventDate"

Hope this helps

Re: Get value from a table in tExtractJSONFields component

ShZ — Sun, 05 Nov 2023 17:08:29 GMT

Hi jonlar,

Thanks a lot, this helped 😊

Re: Get value from a table in tExtractJSONFields component

jonlar — Mon, 06 Nov 2023 11:06:38 GMT

My pleasure 🙂 Glad that helped!

topic Re: Get value from a table in tExtractJSONFields component in Talend Studio

Get value from a table in tExtractJSONFields component

Re: Get value from a table in tExtractJSONFields component

Re: Get value from a table in tExtractJSONFields component

Re: Get value from a table in tExtractJSONFields component