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.
Solved! Go to Solution.
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
@dana_mcdonough sorry, this solution did not work for me! thank you for sharing
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.