Sample RESTMessageV2 Parse JSON Response

sample_restmessagev2.js

//  NOTE: this sample was run in a ServiceNow instance running release version Fuji Patch 4
(function sampleRequest() {
    try {
        var request = new sn_ws.RESTMessageV2();
        request.setHttpMethod('get');
        request.setEndpoint('https://rawgit.com/anonymous/f1c4664cafd6caf855fd/raw/f7ca3b022045e2c9f49dd2b453dea0cecc09888c/sample_json.json');


        var response = request.execute();
        var httpResponseStatus = response.getStatusCode();
        var httpResponseContentType = response.getHeader('Content-Type');
        var parser = new JSONParser();
        var parsed = {};
        var httpResponseBody;


        gs.print("http response status_code: " + httpResponseStatus);
        gs.print("http response content-type: " + httpResponseContentType);


        //  if request is successful then parse the response body

        if (httpResponseStatus == 200 && httpResponseContentType == 'application/json;charset=utf-8') {
            httpResponseBody = response.getBody();

            //  parse JSON string returned from request into a json object
            parsed = parser.parse(httpResponseBody);

            // iterate over JSON object only printing the id property of JSON objects in results array
            for (var i = 0; i < parsed.results.length; i++) {
                gs.print('id: ' + parsed.results[i].id)
            }
        }

    }
    catch (ex) {
        var message = ex.getMessage();
    }
})();

Super useful! Would you mind making an example for XML too?

This is awesome! I'm sure it works for instances later Fuji too?

Glad it helped. It should work post Fuji, but you should check the API docs at developer.servicen-now.com to verify and see any new features they have added to the API.

…

-Bryan

On Tue, Nov 12, 2019 at 2:42 AM Sailesh ***@***.***> wrote: This is awesome! I'm sure it works for instances later Fuji too? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://gist.github.com/3063766969d20edecdd9?email_source=notifications&email_token=AAHNLFPYPFHPOLYVRJ5SOY3QTKB7VA5CNFSM4JMBS56KYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF4BHA#gistcomment-3080816>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHNLFIUAUHWVSW7GGQIWITQTKB7VANCNFSM4JMBS56A> .

-- Bryan Barnard bmbarnard@gmail.com

@bryanbarnard
missing ";" at 31
"gs.print('id: ' + parsed.results[i].id)"