Json formatting

Hi @Vinny_LaRocca ,

It seems that the Json Data provided had a missing curly braces which was making the json as invalid.

But on correction of the format, we can get the validated data in a Json Object by performing a Deserialization using the Deserialize Json Activity.

For this we would need to understand, what is meant by the recent submission, Is it the first data present in the json ? Also, If you could provide the Expected Output that you require from this data, we could provide suggestions on retrieving the same.

An Initial Check :

A Direct conversion to Datatable, since the values is a Json Array :
image

Newtonsoft.Json.JsonConvert.DeserializeObject(Of System.Data.Datatable)(strJson("results")(0)("values").ToString)

Let us know if you were able to achieve your necessary requirements.