Get Array Count from Web Svc Call in Call Studio

[SANJ21]

Running CVP v12.6. I am using the Rest_Client element in CS to do a web service call and am getting a JSON array response back. I have a requirement to handle calls based on the array counts. Within an Action Element-Set Value element, I tried doing a JSON.parse and using the length() to get the count but am either getting an error or null value depending on the iterations I tried. Can someone provide the right syntax if this can be done? The JSON data I get back is in this format below:

{"Results":[
   {"Name":
    "Address":
    "Phone":
   }
   {"Name":
    "Address":
    "Phone":
   }]
}

[janinegraves]

Use this: JSON.parse({Data.Element.Rest01.response_body}).Results.length;

[SANJ21]

Thanks Janine. I have the following in an Action Element - Set Value:

var val = {Data.Element.restZipcodeLookup.response_body};

var path = JSON.parse({Data.Element.restZipcodeLookup.response_body}).Results.length;

JSONPathUtil.eval(val,path);

However, looking at the logs, I am seeing the value as null. I also have a Decision element after this to do other things if the count is more than the current counter but it's failing there as well...probably because I'm not getting a valid value. Any ideas?

[SANJ21]

NM.

This looks like how it should be:

var val = JSON.parse({Data.Element.restZipcodeLookup.response_body}).Results.length;

var path = "$";

JSONPathUtil.eval(val,path);

Just need to fine tune my app to handle the result.

[janinegraves · Accepted solution]

No. You ONLY need to do this one line - it'll return the length into
your localVariable:

JSON.parse({Data.Element.restZipcodeLookup.response_body}).Results.length;

[SANJ21]

ah, simpler. Thank you.