PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Loop through JSON response

edited May 16, 2017 5:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Trying to consume response from 3rd part RESTApi

I'm successfully getting response however can only get 1st iteration of response.  See response below.   Anyone willing to share how to loop JSON/Document?

Environment PT 8.54

JSON Response below:

[

      {

      "city": "Will Rogers",

      "county": "Los Angeles",

      "state": "CA",

      "zip": "90403"

   },

      {

      "city": "Santa Monica",

      "county": "Los Angeles",

      "state": "CA",

      "zip": "90403"

   }

]

Sample PeopleCode:

Local string &url;

Local string &jsonString1;

Local Document &DOC;

Local boolean &b_ret;

&url = "https://myserver.com/resttest/pro?";

&url = &url | "zip=" | &Postal;

&str = %IntBroker.ConnectorRequestUrl(&url);

&jsonString1 = &str;

&DOC = CreateDocument("COM", "JSON_GEN", "V1");

&string = &DOC.GenJsonString();

  

&b_ret = &DOC.ParseJsonString(&jsonString1, False);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center