https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/ba-p/2283196 <P><STRONG>NOTE</STRONG>: MY POSTINGS REFLECT MY OWN VIEWS AND DO NOT NECESSARILY REPRESENT THE VIEWS OF MY EMPLOYER, ACCENTURE.</P> <P>&nbsp;</P> <P>DIFFICULTY LEVEL:&nbsp;<STRONG><FONT color="#808000">INTERMEDIATE</FONT><BR /></STRONG><SPAN>Assumes a good knowledge and/or familiarity of&nbsp;REST web services and Scripting in ServiceNow. Assumes having taken the class&nbsp;<A href="https://nowlearning.servicenow.com/lxp/en/now-platform/scripting-in-servicenow-fundamentals-on-demand?id=learning_course_prev&amp;course_id=8375763b83566d10ec0ea230ceaad358" target="_self" rel="noopener noreferrer">SSNF</A>&nbsp;and has good intermediate level of knowledge and/or familiarity with Scripting in ServiceNow.&nbsp;</SPAN></P> <HR /> <P dir="ltr"><SPAN>Some time ago I had to create a REST Web Message to retrieve information from a server. It occurred to me that there really had not been many examples written on this for ServiceNow. At least from the code perspective. So I thought I would share. This really isn't that complicated, and you should be able to glean what you need from the ServiceNow documentation, but I thought I would present a working example to play with anyway.</SPAN></P> <P>&nbsp;</P> <P dir="ltr"><SPAN>In this example we will be using a test REST web service site called: 'cat-facts'. This will return a success string (true/false), and from 1 to any number we specify; of facts about cats.</SPAN></P> <P dir="ltr">&nbsp;</P> <P dir="ltr"><SPAN>The idea here is to retrieve data from a REST Web Service and then parse the results into a JSON object for further use.</SPAN></P> <P>&nbsp;</P> <P dir="ltr"><SPAN>What is needed:</SPAN></P> <P>&nbsp;</P> <OL> <LI><SPAN>Web Service end-point. This will be:&nbsp;</SPAN> <OL> <LI><SPAN><A href="https://catfact.ninja/facts?limit=&lt;&lt;some" target="_blank" rel="noopener">https://catfact.ninja/facts?limit=&lt;&lt;some</A>&nbsp;number&gt;&gt;</SPAN></LI> <LI><SPAN>If the number is not provided it is automatically assumed to be 10.</SPAN></LI> </OL> </LI> <LI><SPAN>ServiceNow REST Message</SPAN></LI> <LI><SPAN>Fix Script to run our test code and parse the results</SPAN></LI> </OL> <P>&nbsp;</P> <H3><SPAN><SPAN><BR /><SPAN>Lab 1.1: Creating the Rest Message</SPAN></SPAN></SPAN></H3> <P>&nbsp;</P> <OL> <LI><SPAN>Navigate to <STRONG>System Web Services &gt; REST Message</STRONG>.</SPAN></LI> <LI><SPAN>Click on the <STRONG>New</STRONG> button to create a new REST Message.</SPAN></LI> <LI><SPAN>Fill in the form with the following:</SPAN> <OL> <LI><SPAN><STRONG>Name</STRONG>: CatFacts</SPAN></LI> <LI><SPAN><STRONG>Accessible from</STRONG>: All application scopes</SPAN></LI> <LI><SPAN><STRONG>Description</STRONG>: Retrieve facts about cats!</SPAN></LI> <LI><SPAN><STRONG>Endpoint</STRONG>: <A href="https://catfact.ninja/facts" target="_blank" rel="noopener">https://catfact.ninja/facts</A>&nbsp;</SPAN></LI> <LI><STRONG>Authentication type: </STRONG>No authentication</LI> <LI><SPAN>Right-click on the form header and choose <STRONG>Save</STRONG>. This will auto-generate four HTTP methods (get, put, post, delete). &nbsp; We will only be using "get" for the purposes of this article.</SPAN></LI> </OL> </LI> </OL> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_0-1703804168873.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316453i8C2224E7D89DDE7B/image-dimensions/847x434?v=v2" alt="sabell2012_0-1703804168873.png" title="sabell2012_0-1703804168873.png" /></span></P> <P>&nbsp;</P> <P><SPAN><SPAN><SPAN>4. In the HTTP Methods related list click on the "<STRONG>Default GET</STRONG>" method.</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN><SPAN><SPAN>5. Change the </SPAN><SPAN>Endpoint </SPAN><SPAN>to: <A href="https://catfact.ninja/facts?limit=&lt;&lt;some" target="_blank" rel="noopener">https://catfact.ninja/facts?limit=</A>${limit}</SPAN></SPAN></SPAN></SPAN></P> <P><SPAN><SPAN><SPAN>6. Right-click on the form header, and <STRONG>Save</STRONG> your work.</SPAN></SPAN></SPAN></P> <P><SPAN>7. Scroll to the bottom of the form and from the <STRONG>Variable Substitution</STRONG> related list click the <STRONG>New</STRONG> button. </SPAN></P> <P><SPAN>8. Fill out the form with the following:</SPAN></P> <P class="lia-indent-padding-left-30px"><SPAN><SPAN><SPAN><SPAN>a. </SPAN><STRONG>Name</STRONG><SPAN>: limit</SPAN></SPAN></SPAN></SPAN></P> <P class="lia-indent-padding-left-30px"><SPAN><SPAN><SPAN><SPAN>b. <STRONG>Escape type</STRONG>: No escaping</SPAN></SPAN></SPAN></SPAN></P> <P class="lia-indent-padding-left-30px"><SPAN><SPAN><SPAN><SPAN>c. </SPAN><STRONG>Test Value</STRONG><SPAN>: 5&nbsp; &nbsp; &nbsp; <EM>&lt;-&nbsp;</EM></SPAN></SPAN></SPAN></SPAN><EM>we will be pulling back five facts about cats.</EM></P> <P class="lia-indent-padding-left-30px"><SPAN>d. Click <STRONG>Submit</STRONG> to save the variable.</SPAN></P> <P class="lia-indent-padding-left-30px">&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_3-1703804651276.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316456iB2EDDD52E0DDE5C3/image-dimensions/831x679?v=v2" alt="sabell2012_3-1703804651276.png" title="sabell2012_3-1703804651276.png" /></span></P> <P>&nbsp;</P> <P><SPAN><SPAN><SPAN>9. Scroll down to the bottom of the Method form, and choose the "<STRONG>Test</STRONG>" link under the related links. &nbsp; </SPAN></SPAN></SPAN></P> <P><SPAN>This will execute the REST Message with the number value of 5. &nbsp; </SPAN></P> <P><SPAN><SPAN><SPAN>10. You will get a 200 result (success), and five facts about cats!</SPAN></SPAN></SPAN></P> <P><SPAN><SPAN>&nbsp;</SPAN></SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_4-1703804734431.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316457i3C82A79B4BF81BA1/image-dimensions/829x545?v=v2" alt="sabell2012_4-1703804734431.png" title="sabell2012_4-1703804734431.png" /></span></P> <P>&nbsp;</P> <P><SPAN><SPAN><SPAN>Our REST Message is now ready to be consumed - a fancy programmer term meaning: "used".</SPAN><BR /></SPAN></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <H3><SPAN><SPAN><SPAN>Lab 1.2: Fix Script to Run Consume the REST Message</SPAN><BR /></SPAN></SPAN></H3> <P>&nbsp;</P> <P><SPAN><SPAN><SPAN>So now comes the cool stuff. We will be creating code to execute the REST Message, and then convert the response to a JSON object so that we can actually make some use of it.</SPAN><BR /></SPAN></SPAN></P> <P>&nbsp;</P> <OL> <LI><SPAN>Navigate to <STRONG>Fix Scripts</STRONG>.</SPAN></LI> <LI><SPAN>Click the <STRONG>New</STRONG> button.</SPAN></LI> <LI><SPAN>Fill out the form with the following:</SPAN> <OL> <LI><SPAN><STRONG>Name</STRONG>: Cat Facts</SPAN></LI> <LI><SPAN><STRONG>Description</STRONG>: Test script to consume the CatFacts REST Message</SPAN></LI> <LI><SPAN><STRONG>Script</STRONG>:</SPAN><SPAN><SPAN><BR /></SPAN></SPAN></LI> </OL> </LI> </OL> <P>&nbsp;</P> <LI-CODE lang="javascript">var location = 'FS: CatFacts'; var webService = 'CatFacts'; var command = 'Default GET'; // case sensitive var limit = 5; var message = gs.getMessage('---&gt; [{0}]\n', [location]); try { var restMessage = new sn_ws.RESTMessageV2(webService, command); restMessage.setStringParameter('limit', parseInt(limit)); var response = restMessage.execute(); // REST return var httpStatus = response.getStatusCode(); // response status code var responseBody = response.getBody(); // stringified JSON returned info var jsonBody = JSON.parse(responseBody); // turn it into a true JSON object // Now we can begin using the response message += gs.getMessage('\tResponseBody: {0}\n', [responseBody]); var facts = jsonBody.data; var success = httpStatus == 200; message += gs.getMessage('\tfacts.length: {0}\n', [facts]); message += gs.getMessage('\tjsonBody.success: {0}\n', [success]); message += 'Facts:\n'; if (success) { for (var i = 0; i &lt; facts.length; i++) { message += gs.getMessage('\t[{0}]: {1}\n', [i, facts[i].fact]); } } } catch(err) { gs.error('---&gt; ERROR: ' + err); } gs.info(message); </LI-CODE> <P>&nbsp;</P> <P style="padding-left: 60px;"><SPAN>4. Right-click on the form header and <STRONG>Save</STRONG> your work.</SPAN></P> <P style="padding-left: 60px;"><SPAN><SPAN>&nbsp;</SPAN></SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_8-1703805674456.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316464i49805022EA26CA13/image-dimensions/826x545?v=v2" alt="sabell2012_8-1703805674456.png" title="sabell2012_8-1703805674456.png" /></span></P> <P>&nbsp;</P> <P style="padding-left: 60px;"><SPAN><SPAN><SPAN>5. Navigate to System Logs &gt; System Log &gt; All and filter Message for ---&gt;</SPAN></SPAN></SPAN></P> <P style="padding-left: 60px;">&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_7-1703805632061.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316462i00AB775E7D7D0F92/image-dimensions/841x557?v=v2" alt="sabell2012_7-1703805632061.png" title="sabell2012_7-1703805632061.png" /></span><SPAN><SPAN><SPAN><BR /></SPAN></SPAN></SPAN></P> <P><SPAN><SPAN><BR /><SPAN>And there you have it! In this article I demonstrated:</SPAN></SPAN></SPAN></P> <P>&nbsp;</P> <OL> <LI><SPAN>How to create a REST Message</SPAN></LI> <LI><SPAN>How to add a variable to the REST Message method</SPAN></LI> <LI><SPAN>How to test a REST Message method</SPAN></LI> <LI><SPAN>How to call a REST Message from a script</SPAN></LI> <LI><SPAN>How to use a variable in a REST Message from a script</SPAN></LI> <LI><SPAN>How to parse the returned results into JSON from the REST Message</SPAN></LI> <LI><SPAN>How to consume (a.k.a. use) the JSON results</SPAN></LI> </OL> <P>&nbsp;</P> <P>Enjoy!</P> <P>Steven Bell.</P> <P>&nbsp;</P> <P><FONT color="#FF9900"><SPAN><STRONG>If you find this article helps you, don't forget to log in and mark it as "Helpful"!</STRONG></SPAN></FONT></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sabell2012_0-1703794648636.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/316448i80EE0ED62DC439B4/image-size/medium?v=v2&amp;px=400" alt="sabell2012_0-1703794648636.png" title="sabell2012_0-1703794648636.png" /></span></P> <HR /> <P><SPAN>Originally published on:&nbsp;<SPAN class="local-date">09-06-2016 01:50 AM</SPAN></SPAN></P> <P>I updated the code, fixed broken links, and brought the article into alignment with my new formatting standard</P> Thu, 28 Dec 2023 23:31:09 GMT sabell2012 2023-12-28T23:31:09Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/ba-p/2283196 <P><SPAN>Some time ago I had to create a REST Web Message to retrieve information from a server. It occurred to me that there really had not been many examples written on this for ServiceNow. At least from the code perspective. So I thought I would share. This really isn't that complicated, and you should be able to glean what you need from the ServiceNow documentation, but I thought I would present a working example to play with anyway.</SPAN></P> Thu, 28 Dec 2023 23:31:09 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/ba-p/2283196 sabell2012 2023-12-28T23:31:09Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283197#M3994 <P>Hi Steve,</P><BR /><P></P><BR /><P>When I ran the fix script in my Dev instance I received following error. Can you help me with this</P><BR /><P></P><BR /><P></P><BR /><PRE style="box-sizing: border-box; overflow: auto; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 12px; padding: 8.5px; margin-top: 0px; margin-bottom: 9px; line-height: 1.42857; word-break: break-all; word-wrap: break-word; color: #485563; border: 1px solid #cccccc; border-radius: 3px; background-color: #f5f5f5;">Evaluator: java.util.NoSuchElementException &nbsp; &nbsp; &nbsp; Caused by error in Script Include: 'JSON' at line 145 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 142: &nbsp; &nbsp; &nbsp; &nbsp; }, &nbsp; &nbsp; &nbsp; &nbsp; 143: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 144: &nbsp; &nbsp; &nbsp; &nbsp; decode: function(source) { ==&gt; 145: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return new SNC.JSONParse().decode(source); &nbsp; &nbsp; &nbsp; &nbsp; 146: &nbsp; &nbsp; &nbsp; &nbsp; }, &nbsp; &nbsp; &nbsp; &nbsp; 147: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 148: &nbsp; &nbsp; &nbsp; &nbsp; type: "JSON" &nbsp; java.util.LinkedList.remove(LinkedList.java:788) java.util.LinkedList.removeFirst(LinkedList.java:134) java.util.LinkedList.pop(LinkedList.java:601) com.glide.script.JSONParse.handleObjectEnd(JSONParse.java:296) com.glide.script.JSONParse.tokenize(JSONParse.java:73) com.glide.script.JSONParse.jsFunction_decode(JSONParse.java:53) sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:597) org.mozilla.javascript.FunctionObject.callVarargs(FunctionObject.java:613) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:457) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c899.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:145) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c900.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:158) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c2814.call(&lt;refname&gt;:13) org.mozilla.javascript.gen.c2814.exec(&lt;refname&gt;) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:233) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:105) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:72) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:63) com.glide.script.Evaluator.evaluateString(Evaluator.java:91) com.glide.update.UpdateManager2.testFixScript(UpdateManager2.java:600) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.evaluateScript(ScriptFixXMLHttpProcessor.java:122) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.startWork(ScriptFixXMLHttpProcessor.java:100) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:86) com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52) com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:67) com.snc.apps.ScriptFixXMLHttpProcessor.process(ScriptFixXMLHttpProcessor.java:77) com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:143) com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:100) com.glide.processors.AProcessor.runProcessor(AProcessor.java:409) com.glide.processors.AProcessor.processTransaction(AProcessor.java:183) com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:165) com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:32) com.glide.sys.ServletTransaction.run(ServletTransaction.java:34) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) java.lang.Thread.run(Thread.java:682)<BR style="box-sizing: border-box;" />Evaluator: java.util.NoSuchElementException &nbsp; &nbsp; &nbsp; Caused by error in Script Include: 'JSON' at line 158 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 155: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3. Invalid JSON is accepted (member names not enclosed in quotes) &nbsp; &nbsp; &nbsp; &nbsp; 156: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4. Bare encoded strings are decoded twice. &nbsp; &nbsp; &nbsp; &nbsp; 157: */ ==&gt; 158: JSON.parse = function(s) { return new JSON().decode(s); }; &nbsp; &nbsp; &nbsp; &nbsp; 159: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 160: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;/* &nbsp; &nbsp; &nbsp; &nbsp; 161: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Convert a JS object to a JSON string. &nbsp; Note that this is not completely ES5 compatible: &nbsp; java.util.LinkedList.remove(LinkedList.java:788) java.util.LinkedList.removeFirst(LinkedList.java:134) java.util.LinkedList.pop(LinkedList.java:601) com.glide.script.JSONParse.handleObjectEnd(JSONParse.java:296) com.glide.script.JSONParse.tokenize(JSONParse.java:73) com.glide.script.JSONParse.jsFunction_decode(JSONParse.java:53) sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:597) org.mozilla.javascript.FunctionObject.callVarargs(FunctionObject.java:613) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:457) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c899.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:145) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c900.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:158) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c2814.call(&lt;refname&gt;:13) org.mozilla.javascript.gen.c2814.exec(&lt;refname&gt;) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:233) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:105) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:72) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:63) com.glide.script.Evaluator.evaluateString(Evaluator.java:91) com.glide.update.UpdateManager2.testFixScript(UpdateManager2.java:600) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.evaluateScript(ScriptFixXMLHttpProcessor.java:122) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.startWork(ScriptFixXMLHttpProcessor.java:100) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:86) com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52) com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:67) com.snc.apps.ScriptFixXMLHttpProcessor.process(ScriptFixXMLHttpProcessor.java:77) com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:143) com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:100) com.glide.processors.AProcessor.runProcessor(AProcessor.java:409) com.glide.processors.AProcessor.processTransaction(AProcessor.java:183) com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:165) com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:32) com.glide.sys.ServletTransaction.run(ServletTransaction.java:34) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) java.lang.Thread.run(Thread.java:682)<BR style="box-sizing: border-box;" />Evaluator: java.util.NoSuchElementException &nbsp; &nbsp; &nbsp; Caused by error in script at line 13 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11: var responseBody = response.getBody(); // stringified JSON returned info &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12: &nbsp; &nbsp; &nbsp; ==&gt; &nbsp; 13: var parsed = JSON.parse(responseBody); // turn it into a true JSON object &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15: // Now we can begin using the response &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16: gs.print(responseBody); &nbsp; &nbsp; &nbsp; java.util.LinkedList.remove(LinkedList.java:788) java.util.LinkedList.removeFirst(LinkedList.java:134) java.util.LinkedList.pop(LinkedList.java:601) com.glide.script.JSONParse.handleObjectEnd(JSONParse.java:296) com.glide.script.JSONParse.tokenize(JSONParse.java:73) com.glide.script.JSONParse.jsFunction_decode(JSONParse.java:53) sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:597) org.mozilla.javascript.FunctionObject.callVarargs(FunctionObject.java:613) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:457) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c899.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:145) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c900.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:158) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c2814.call(&lt;refname&gt;:13) org.mozilla.javascript.gen.c2814.exec(&lt;refname&gt;) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:233) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:105) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:72) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:63) com.glide.script.Evaluator.evaluateString(Evaluator.java:91) com.glide.update.UpdateManager2.testFixScript(UpdateManager2.java:600) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.evaluateScript(ScriptFixXMLHttpProcessor.java:122) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.startWork(ScriptFixXMLHttpProcessor.java:100) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:86) com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52) com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:67) com.snc.apps.ScriptFixXMLHttpProcessor.process(ScriptFixXMLHttpProcessor.java:77) com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:143) com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:100) com.glide.processors.AProcessor.runProcessor(AProcessor.java:409) com.glide.processors.AProcessor.processTransaction(AProcessor.java:183) com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:165) com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:32) com.glide.sys.ServletTransaction.run(ServletTransaction.java:34) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) java.lang.Thread.run(Thread.java:682)<BR style="box-sizing: border-box;" />Evaluator: java.util.NoSuchElementException &nbsp; &nbsp; &nbsp; Caused by error in script at line -1 java.util.LinkedList.remove(LinkedList.java:788) java.util.LinkedList.removeFirst(LinkedList.java:134) java.util.LinkedList.pop(LinkedList.java:601) com.glide.script.JSONParse.handleObjectEnd(JSONParse.java:296) com.glide.script.JSONParse.tokenize(JSONParse.java:73) com.glide.script.JSONParse.jsFunction_decode(JSONParse.java:53) sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:597) org.mozilla.javascript.FunctionObject.callVarargs(FunctionObject.java:613) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:457) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c899.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:145) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c900.call(sys_script_include.d2426c9ec0a8016501958bf2ac79c775:158) org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1227) org.mozilla.javascript.gen.c2814.call(&lt;refname&gt;:13) org.mozilla.javascript.gen.c2814.exec(&lt;refname&gt;) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:233) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:105) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:72) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:63) com.glide.script.Evaluator.evaluateString(Evaluator.java:91) com.glide.update.UpdateManager2.testFixScript(UpdateManager2.java:600) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.evaluateScript(ScriptFixXMLHttpProcessor.java:122) com.snc.apps.ScriptFixXMLHttpProcessor$ScriptFixWorker.startWork(ScriptFixXMLHttpProcessor.java:100) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:86) com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52) com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:67) com.snc.apps.ScriptFixXMLHttpProcessor.process(ScriptFixXMLHttpProcessor.java:77) com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:143) com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:100) com.glide.processors.AProcessor.runProcessor(AProcessor.java:409) com.glide.processors.AProcessor.processTransaction(AProcessor.java:183) com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:165) com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:32) com.glide.sys.ServletTransaction.run(ServletTransaction.java:34) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) java.lang.Thread.run(Thread.java:682)<BR style="box-sizing: border-box;" /><STRONG style="box-sizing: border-box;">[0:00:01.495] Total Time</STRONG></PRE> Tue, 06 Sep 2016 13:08:12 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283197#M3994 sagarAgarwal 2016-09-06T13:08:12Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283198#M3995 <P>Sagar:</P><BR /><P></P><BR /><P>I'm not sure; I have not see that error before when working with this. &nbsp; Is it consistent, does it happen every time? &nbsp; I have attached my script to the article for download. &nbsp; Give that a try and see if it works.</P><BR /><P></P><BR /><P>Steven</P><BR /> Tue, 06 Sep 2016 14:01:59 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283198#M3995 sabell2012 2016-09-06T14:01:59Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283199#M3996 <P>What version are you on? I think JSON.parse demands helsinki, but might be wrong.</P><BR /><P></P><BR /><P>//Göran</P><BR /> Tue, 06 Sep 2016 16:12:14 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283199#M3996 Goran WitchDoc 2016-09-06T16:12:14Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283200#M3997 <P>Goran:</P><BR /><P></P><BR /><P>Not sure, but I don't think that is the issue. &nbsp; I have been using JSON for a couple of years+ in ServiceNow. &nbsp; Fuji definitely had the libraries.</P><BR /><P></P><BR /><P>Steven.</P><BR /> Tue, 06 Sep 2016 20:13:02 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283200#M3997 sabell2012 2016-09-06T20:13:02Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283201#M3998 <P>Ahh mixed it all together from this blog post: <A title="ECMAScript 5 in ServiceNow Helsinki!" __default_attr="5411" __jive_macro_name="blogpost" class="jive_macro jive_macro_blogpost" data-orig-content="ECMAScript 5 in ServiceNow Helsinki!" data-renderedposition="10_290_258_16" href="https://www.servicenow.com/community?id=community_blog&amp;sys_id=585de229dbd0dbc01dcaf3231f9619db">ECMAScript 5 in ServiceNow Helsinki!</A></P><BR /><P>just remember "helsinki" from the title and something about JSON.parse was added as a class function, but just that part was with "recent release".</P><BR /> Tue, 06 Sep 2016 20:27:04 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283201#M3998 Goran WitchDoc 2016-09-06T20:27:04Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283202#M3999 <P>Yeah, had forgotten that article. &nbsp; Hmmm, maybe you are right. &nbsp; I will have to go and see if I can find a Geneva or earlier instance, and play a bit. &nbsp; Let you know.</P><BR /><P></P><BR /><P>I did these articles on Geneva:</P><BR /><P><STRONG style="font-size: 16px; font-family: arial, helvetica, sans-serif; color: #666666;"><A title="" _jive_internal="true" href="https://www.servicenow.com/groups/servicenow-user-group-us-tx-north-texas/blog/2016/01/26/mini-lab-using-ajax-and-json-to-send-objects-to-the-server" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #266fc8;">Mini-Lab: Using Ajax and JSON to Send Objects to the Server</A></STRONG><SPAN style="color: #666666; font-family: arial, helvetica, sans-serif; font-size: 16px;"> - 1/26/2016</SPAN></P><BR /><P><SPAN style="color: #666666; font-family: arial, helvetica, sans-serif; font-size: 16px;"><STRONG style="font-size: 16px; font-family: arial, helvetica, sans-serif; color: #666666;"><A title="" _jive_internal="true" href="https://www.servicenow.com/groups/servicenow-user-group-us-tx-north-texas/blog/2016/01/28/mini-lab-syslog-writing-entries-into-the-system-log-using-ajax" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #266fc8;">Mini-Lab: Writing Entries Into the System Log Using Ajax and JSON</A></STRONG><SPAN style="color: #666666; font-family: arial, helvetica, sans-serif; font-size: 16px;"> - 1/28/2016</SPAN></SPAN></P><BR /><P></P><BR /><P><SPAN style="color: #666666; font-size: 16px; font-family: arial, helvetica, sans-serif;">I didn't publish anything JSON before that, but I swear I used it waaay before that, and it wasn't a library port either. &nbsp; <span class="lia-unicode-emoji" title=":confused_face:">😕</span></SPAN></P><BR /><P></P><BR /> Tue, 06 Sep 2016 20:51:24 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283202#M3999 sabell2012 2016-09-06T20:51:24Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283203#M4000 <P>Hi,</P><BR /><P></P><BR /><P>I was using Geneva instance.</P><BR /><P>One more weird thing happened, when I tried to retrieve the update set you have attached in this post in my dev instance it was not getting added. Once I click on upload button its redirecting me to retrieved update sets list. I tried it to retrieve it in a fresh dev instance too but same issue, update set is not added in the list.</P><BR /><P></P><BR /><P>Thanks &amp; regards</P><BR /> Wed, 07 Sep 2016 09:08:01 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283203#M4000 sagarAgarwal 2016-09-07T09:08:01Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283204#M4001 <P>Sagar:</P><BR /><P></P><BR /><P>That XML was a direct to table file, not an update set. &nbsp; &nbsp; In other words when you upload it using Import XML it will end up in the Fix Scripts table. &nbsp; Check there. &nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><BR /><P></P><BR /><P>Okay, did a little research. &nbsp; Looks like some things were actually in Geneva, not sure what patch. &nbsp; Now, the interesting part. &nbsp; JSON.stringify, and JSON.parse are both ECMA 5.1 and later! &nbsp; Sooo, looks like you called it Goran!</P><BR /><P></P><BR /><P><A href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/parse" title="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/parse">JSON.parse() - JavaScript | MDN</A></P><BR /><P><A href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/stringify" title="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/stringify">JSON.stringify() - JavaScript | MDN</A></P><BR /><P></P><BR /><P>Where does this leave you? &nbsp; Well, there is a Polyfill for this. &nbsp; You could implement that as a Script Include on your instance and see if that allows the example to work. </P><BR /><P></P><BR /><P><A href="http://bestiejs.github.io/json3/" title="http://bestiejs.github.io/json3/">JSON 3</A> &lt;-- JSON Polyfill definition with .parse and .stringify</P><BR /><P></P><BR /><P>Awhile back I wrote an article on how to implement Polyfills in ServiceNow. &nbsp; You might give it a try and see if it fixes the issue.</P><BR /><P></P><BR /><P><A title="Mini-Lab: Extending ServiceNow JavaScript Using ECMAScript 6 Polyfills" __default_attr="4767" __jive_macro_name="blogpost" class="jive_macro jive_macro_blogpost" data-orig-content="Mini-Lab: Extending ServiceNow JavaScript Using ECMAScript 6 Polyfills" data-renderedposition="428.9062194824219_7.997159004211426_474_15" href="https://www.servicenow.com/community?id=community_blog&amp;sys_id=fd5d6629dbd0dbc01dcaf3231f961989">Mini-Lab: Extending ServiceNow JavaScript Using ECMAScript 6 Polyfills</A></P><BR /><P></P><BR /><P><STRONG>Clarification</STRONG>: &nbsp; You will need to implement the JSON 3 polyfill to possibly get this to work. &nbsp; My article does not describe the JSON implementation, just a how to do polyfills in ServiceNow.</P><BR /><P></P><BR /><P>Steven.</P><BR /> Wed, 07 Sep 2016 11:00:24 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283204#M4001 sabell2012 2016-09-07T11:00:24Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283205#M4002 <P>can't Sagar use the JSON.encode() and JSON.decode? those works in Geneva right? </P><BR /> Wed, 07 Sep 2016 13:34:27 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283205#M4002 Goran WitchDoc 2016-09-07T13:34:27Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283206#M4003 <P>Goran:</P><BR /><P></P><BR /><P>Yeah, but not so easy to use in this case. &nbsp; You would still need to parse the stringified JSON somehow. &nbsp; Decode won't work on it I believe.</P><BR /><P></P><BR /><P>Steven.</P><BR /> Thu, 08 Sep 2016 21:40:35 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283206#M4003 sabell2012 2016-09-08T21:40:35Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283207#M4004 <P>Thanks Steve Bell for this step-by-step example, it's really helpful.</P><BR /><P></P><BR /><P>Remark: I think that in the point 6, you wanted to say "<STRONG><A title="k-external-small" class="jive-link-external-small" href="http://catfacts-api.appspot.com/api/facts" rel="nofollow" target="_blank">http://catfacts-api.appspot.com/api/facts</A><SPAN>?</SPAN></STRONG>number=5" and not "<STRONG><A title="k-external-small" class="jive-link-external-small" href="http://www.programmableweb.com/api/cat-facts" rel="nofollow" target="_blank">http://www.programmableweb.com/api/cat-facts</A><SPAN>?</SPAN></STRONG>number=${number}", don't you ? The latter returns HTML content and not JSON</P><BR /><P><span class="lia-inline-image-display-wrapper"><img src="https://www.servicenow.com/community/image/serverpage/image-id/181637i669474B45F6FD423/image-size/large?v=v2&amp;px=999" title="html-content.png" alt="html-content.png" /></span></P><BR /><P></P><BR /><P>while the other return JSON content as expected</P><BR /><P><span class="lia-inline-image-display-wrapper"><img src="https://www.servicenow.com/community/image/serverpage/image-id/181639i1C688BA2FB3D684C/image-size/large?v=v2&amp;px=999" title="JSON-content.png" alt="JSON-content.png" /></span></P><BR /> Mon, 12 Sep 2016 07:13:24 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283207#M4004 Ximizu 2016-09-12T07:13:24Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283208#M4005 <P>Ximizu:</P><BR /><P></P><BR /><P>Thank you, and yes! &nbsp; The screen shot wasn't completely accurate either. &nbsp; Great catch, thank you! &nbsp; The article has been corrected.</P><BR /><P><BR />Steven.</P><BR /> Mon, 12 Sep 2016 12:52:04 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283208#M4005 sabell2012 2016-09-12T12:52:04Z https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283209#M4006 <P>Hello Steve,</P><BR /><P>This post was really awesome as very new to this.</P><BR /><P></P><BR /><P>I have followed your step and but got an issue.</P><BR /><P></P><BR /><P>I am not able to get this in json format but http status is 200.What might be the issue here.Please help..</P><BR /><P></P><BR /><P><span class="lia-inline-image-display-wrapper"><img src="https://www.servicenow.com/community/image/serverpage/image-id/181641i52258283DEBD9F67/image-size/large?v=v2&amp;px=999" title="find_real_file.png" alt="find_real_file.png" /></span></P><BR /> Fri, 17 Feb 2017 06:26:39 GMT https://www.servicenow.com/community/developer-blog/mini-lab-retrieving-and-parsing-the-json-results-from-a-rest-web/bc-p/2283209#M4006 salu 2017-02-17T06:26:39Z