How I do bring in a Json file to see the different fields and value from Postman

[Jay2022]

hi,

I am new to working with Json file in Alteryx so i need to know how to pull data our of a Json file to see all the fields and data values.

[dana_mcdonough]

Hi @Jay2022 :

See the following article which explains how to easily parse your JSON file with a parse tool: JSON file parsing . There is a sample workflow in this article as well which you can download and mimic.

Thanks!

Dana

[Jay2022]

@dana_mcdonough sorry, this solution did not work for me! thank you for sharing

[Felipe_Ribeir0]

Hi @Jay2022 

Take a look at the attached example, i am geting information from this API, it is for test purposes (https://jsonplaceholder.typicode.com/photos), and transforming the JSON into a table. The steps to do it are more or less the same.

Maybe it is more or less what you want.

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

Thanks.

[Felipe_Ribeir0 · Accepted solution]

Hi @Jay2022 

This made sense for you? It was what you were looking for?