topic Reading Jason File in Product Forum

Reading Jason File

GAVIN.RUDLING — Wed, 12 Oct 2022 10:44:00 GMT

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
------------------------------

RE: Reading Jason File

ewilson — Wed, 12 Oct 2022 10:52:00 GMT

@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
------------------------------

RE: Reading Jason File

GAVIN.RUDLING — Wed, 12 Oct 2022 11:48:00 GMT

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

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

RE: Reading Jason File

GAVIN.RUDLING — Wed, 12 Oct 2022 12:41:00 GMT

Thank you Eric. It worked perfectly as expected.

RE: Reading Jason File

guyngreen678 — Tue, 03 Jan 2023 20:49:00 GMT

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
------------------------------

RE: Reading Jason File

guyngreen678 — Tue, 03 Jan 2023 20:52:00 GMT

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

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