topic Thank you for your comment. I in Product Forum

Obtaining JSON data from a URL using HTTP GET

ritesh_a_ramkhe — Thu, 01 Dec 2016 17:12:00 GMT

I am trying to develop a VBO which will use a HTTP GET request to obtain JSON data from a URL and then be able to store the JSON data as a collection so the different object values can be used for automation. Does anyone have any ideas as to how this can be done, or any examples which may help?

A simple way to obtain JSON

shahariar_k_bhu — Thu, 01 Dec 2016 18:22:00 GMT

A simple way to obtain JSON data from a URL: -------------------------------------------------------------------------------------------- In: URL Out: Result (JSON data) Code stage VB.NET: Dim webClient As New System.Net.WebClient Result = webClient.DownloadString(URL) -------------------------------------------------------------------------------------------- Alternatively, you can use HttpWebRequest class in VB.net / C# to perform requests. HttpWebRequest is detailed at: http://msdn.microsoft.com/en-us/library/system.net.httpwebrequest.aspx JSON to Collection: Import JSON business object from C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO. Use Convert JSON to Collection or something action to translate the JSON data into a collection.

Thank you for your comment. I

ritesh_a_ramkhe — Thu, 01 Dec 2016 19:04:00 GMT

Thank you for your comment. I managed to get the JSON data into a text data item. However when the JSON to collection action stage is run, the following error appears: ""Internal : Could not run the object because one of the code stages has a compile error, use Check for Errors for a list of problems

Managed to sort the issue out

ritesh_a_ramkhe — Thu, 01 Dec 2016 19:38:00 GMT

Managed to sort the issue out by including Newtonsoft.Json.dll in the Blue Prism directory. However the resultant collection stores the values I need to extract in arrays of objects. Is there a way to extract particular values from an array within a collection?

JSON:Array in a collection is

shahariar_k_bhu — Thu, 01 Dec 2016 19:51:00 GMT

JSON:Array in a collection is simply a collection, so you could loop through the main collection, and access the fields using their corresponding field name. For example: Loop over collection -> have a calculation stage where you have the expression: [Collection.JSON:Array.FIELDNAME] and store the result to a data text item. Or you could handle that part using code blocks, set the JSON collection as input with some filter criterias, and a filtered collection as output.

I tried it using the loop

ritesh_a_ramkhe — Thu, 01 Dec 2016 22:24:00 GMT

I tried it using the loop method you described above and it works as intended. Thanks for the help!