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.

API

Accepted answers

Felipe_Ribeir0

Hi @Jay2022

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

All comments

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

Hi @Jay2022

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703