How can extract data from JSON response?

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi,
I have a webservice connector and I am looking to extract “resources”. I’m trying extract the resource list so I can pipe it into another another API call

{
  "meta": {
    "query_time": 0.010216441,
    "pagination": {
      "offset": 0,
      "limit": 100,
      "total": 5
    },
  },
  "resources": [
    "AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA",
    "BBBBBBBB-BBBB-BBBB-BBBB-BBBBBBBBBBBB",
    "CCCCCCCC-CCCC-CCCC-CCCC-CCCCCCCCCCCC",
    "DDDDDDDD-DDDD-DDDD-DDDD-DDDDDDDDDDDD"
  ]
}
2

Assuming “response” is your return json object, you can do the following.

import org.json.JSONObject;

(new JSONObject(response)).getString("resources")
3

This is in IdentityNow, HTTP Operations. I don’t see a way to parse JSON objects that way just seeing “Response Information” and Response Mapping which just uses JSON to pull out specific fields. I can’t figure out how for it to give me the resources data.

4

Hi @0xdaniel, you can look at the following, it may help.

SailPoint IdentityNow - Introduction to loopback connectors (linkedin.com)

5

Appreciate it, I saw that article. Right now I’m trying to figure out how to extract specific fields from the first query.