How to extract JSON fields

[Anonymous]

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
}

]

}

[Anonymous · Accepted solution]

Try the following configuration

[Anonymous]

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?

[Anonymous]

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.