topic Re: How to extract JSON fields in Talend Studio

How to extract JSON fields

Anonymous — Fri, 08 Nov 2019 16:38:11 GMT

Hi,

I'm looking to extract the following data from below... id, name, startDate, endDate, completeDate of each, but also need to extract startAt, isLast, and maxResults (pagination data for a loop). I can do this in 2 different tRest/textractJSONfields but it seems unnecessary. I was hoping someone could help me figure out how to do this in 1 set of steps. Any help would be much appreciated!

{
"maxResults": 50,
"startAt": 0,
"isLast": false,
"values": [
{
"id": 16,
"self": "https://URL/jira/rest/agile/1.0/sprint/10",
"state": "closed",
"name": "Sprint 5",
"startDate": "2012-10-30T07:23:07.217-07:00",
"endDate": "2012-11-21T07:23:07.217-08:00",
"completeDate": "2012-11-26T15:44:56.080-08:00"
},
{
"id": 587,
"self": "https://URL/jira/rest/agile/1.0/sprint/555",
"state": "closed",
"name": "Sprint 1",
"startDate": "2016-10-01T13:23:00.000-07:00",
"endDate": "2016-10-28T13:23:00.000-07:00",
"completeDate": "2016-11-02T08:12:50.437-07:00",
"originBoardId": 200
}

]

}

Re: How to extract JSON fields

Anonymous — Fri, 08 Nov 2019 18:01:58 GMT

Try the following configuration

Re: How to extract JSON fields

Anonymous — Fri, 08 Nov 2019 18:36:18 GMT

This is exactly what I was looking for thanks! I was under the impression you should always use JSONPath when working with JSON values, is that not the case... just curious?

Re: How to extract JSON fields

Anonymous — Fri, 08 Nov 2019 19:02:20 GMT

I've used Xpath in use cases like yours, where you have JSON lists to iterate as well as higher level objects that would be common across all list items. You can probably accomplish with JSONPath but Xpath is pretty straightforward.