JSON Parse

[synergy825]

Hi,

I am very new to Alteryx, and I was wondering how does the JSON Parse tool work.  Attached is the workbook with the JSON file, and I want to be able to pull its fields and values.  Also, is it possible to convert it into a CSV format?  I am not sure how to utilize this in a workflow.  Any help would be greatly appreciated!  Thanks!

[Felipe_Ribeir0]

Hi @synergy825 

The JSON did not came, please attach it.

[Garabujo7]

Hello @synergy825 ,

Have you seen the one tool example for the JSON Parse Tool?

Gabriel

[synergy825]

Hi @Felipe_Ribeir0,

it wont let me attach the JSON file.  Do you know how I can do that?

[Felipe_Ribeir0]

Inside your workflow do this and attach the resulted file:

[synergy825]

Hi @Garabujo7,

I tried to run it but I got an error message.  I am probably doing it wrong or the JSON file is not compatible?

[synergy825]

Here is the file @Felipe_Ribeir0 

[Felipe_Ribeir0 · Accepted solution]

Hi @synergy825 

Here is one way of doing this, just output it as you wish:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[synergy825]

Thank you @Felipe_Ribeir0 !  This helps in my understanding of this tool.  Much appreciated!

[synergy825]

HI @Felipe_Ribeir0 , I was reviewing the Alteryx flow again, and I had a question that perhaps you can answer:

For the delimiter, can you please explain the "\0" used?  Also, for the code page, how do you know when to select Unicode UTF-8?  Thanks again for your help!