Dear community, I’m using Microsoft’s cognitive services for my OCR and receive a JSON from the service. I have used the deserialize JSON activity, but now am left wondering how to navigate the JSON. The JSON returned by Microsoft is a single JSON file that contains several arrays of JSON (one for …

Dear community, I seem to have cracked it: JSON arrays can be referenced with their index. For example, if I want to get the word “OCR” in the example above, I should put in a message box: outputJSON(“recognitionResults”)(0)(“lines”)(1)(“words”)(0)(“text”).ToString Thanks for the help! Have a ni…

Selecting specific element from ARRAY of JSON within a JSON

Help

Phil March 21, 2019, 12:15pm 5

Hi Ronanpeter,
See attached the output from the Microsfot Cognitive Services API. It should be valid according to the JSON validator. Thanks!

Have a nice day,
Phil

Testfile.json (7.2 KB)

Topic		Replies	Views
Parsing JSON Key/Value pairs from Microsoft Form Recognizer Help	20	5173	January 15, 2021
Select specific value in JSON Help activities , question , json	1	862	January 20, 2020
Need help with reading stuff from JSON Help studio , question , json	11	1461	December 6, 2019
Trying to parse JSON Activities activities , web , question	1	290	August 9, 2023
How to select specific data from a string Community datatable , excel , selector , uiautomation , pdf , mail , outlook , activities , data_scraping , regex , string , question , data_manipulation	15	1314	February 11, 2021

Selecting specific element from ARRAY of JSON within a JSON

Related topics