Good afternoon - I'm in the process of learning to make COS calls to REST-based web services and while I am having success, I'm struggling on how to parse out the results (I admit I'm very green at this): Here's the code retrieving the JSON response:
w !,"Get the JSON" Set Result = {}.%FromJSON(Request.HttpResponse.Data)</pre> This has Result as a Library.DynamicObject.
I can then write out the response using:
w !,Result.%ToJSON()This works, I can see the response is valid and what I want. Here is the JSON returned (de-identified):
{ "RecordIDs": [ { "ID": "1234", "Type": "INTERNAL" }, { "ID": "1234", "Type": "EXTERNAL" } ], "ContactIDs": null, "Items": [ { "ItemNumber": "320", "Value": null, "Lines": [ { "LineNumber": 0, "Value": "1", "Sublines": null }, { "LineNumber": 1, "Value": "100063287", "Sublines": null } ] } ] }What is the easiest method to get the LineNumber Values out? I could potentially have several so I'm trying to get an output kind of like Value1~Value2~Value3 so I can piece them out later.
Appreciate any advice - I'll keep pluggin away on it.
</body></html>