Reading Jason File

[GAVIN.RUDLING]

Good Day Team.

I am battling to read a Json file script into a collection using the Json VBO and getting the following error message: "Internal : Could not execute code stage because exception thrown by code stage: Data Type mismatch in array"

However if I paste the text string into any Json viewer online I don't get the error, assuming because its not trying to put it into a table.

Any suggestions ?

Regards
Gavin

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

[ewilson · Accepted solution]

@GAVIN.RUDLING,

We just posted an update to the JSON VBO on the DX yesterday. I'd suggest downloading the new version and use the JSON to Collection (Skipping JArray) action.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---json

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[GAVIN.RUDLING]

Thanks Eric, It's working as expected. Much appreciated

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

[GAVIN.RUDLING]

Thank you Eric. It worked perfectly as expected.

[guyngreen678]

I have downloaded the latest version of the utility, but I am getting the same Data Type mismatch when trying to convert my JSON response into a collection.  The utility works with the file returned from Azure Form Recognizer v2.1, but not with v3.0.  They appear very similar when comparing them via text files.  Any ideas?

------------------------------
Christopher Wiles
------------------------------

[guyngreen678]

Nevermind, I forgot to use the Skipping JArray option and it now works.

------------------------------
Christopher Wiles
------------------------------