This was immensely helpful!! I tried many ways to get JSON data into a CSV cleanly with as few hacks as possible and this was the most comprehensive and clean way. Thank you!
Im new to Alteryx and spent several hours today for parsing json data. Thank you for making this video , I followed as you mentioned and was able to get my work done.
Love your work and the way you explain things so clearly. Thanks to you, I learned Alteryx within a few hours and couldn't get myself off the software because I was doing so well. Thanks a ton! Keep producing more content. I would love to see more about Tableau and Alteryx.
This is great. I've been trying to figure out how to do this for several days. I feel like Alteryx should make it easier than this, but this isn't too bad. The JSON Parser tool is worthless.
This was great, it let me solve my issue. You mention parsing JSON subnodes, do you have any advice on that? My JSON has a list of problems and your video showed me how pull out the problems & put them to excel, one row per problem. But within each problem there can be multiple comments, each comment has four fields (timestamp, ID, userid/enterer, and comment-body). Right now it's concatenating those four fields and concatenating all comments into one string/cell in the problem's row; I'd like to skip the ID field & convert the timestamp to a more readable form; otherwise I'm fine with concatenating the fields and concatenating all comments into one cell.
Yes, I have some advice on JSON subnodes. You'll want to use a combination of the Tile tool and the Transpose tool. You want to get the data in a format where Alteryx can easily discern the hierarchy. The Tile tool can break out item where 1 is the first item, and 1.2 is the second element of the first item. Let me know if that helps.
Nathan, have you used Alteryx with Quick Base specifically where it concerns JSON and APIs ? Using Alteryx to make a API call to Quick Base to pull data?
Hi there, I've used Alteryx to make API calls and to download a JSON formatted payload. You'll need to use the Download tool (found on the Developer palette) to make the API call. There's a JSON Parse tool on the same palette.
Hi NPT, I have a query.. I am using a big json file 7 gb and converting it to a blob by selecting "split blobs to chunks" option. But the splitted blob is not combined properly by the blob converter. My data is good until blob 1 but after blob 1, since its split in middle of a json field, its not working.. Please suggest any options
I'm having trouble parsing a complicated api json output, any advice on what to do if you have no standard record id? for ex. my fields look like this when i run the api --> 0.children.0.children.0.children.0.children.0.field --> i need to get to field but they're not aligned in the table the same way. Is there a good tool available for me to parse this into a table of table until i can see the structure? it's very hard to get through this data set as they don't appear to have a unique identified for the record. they appear to be using the # in the name to represent groups of data rather than individual records. sorry if very confusing... i am very confused by this api LOL
Hi Eric, thanks for the comment. Yes, you can use the JSON parse tool. At the time I created this video, the JSON parse tool was not processing EVERY JSON file the way I hoped. I found a few examples where the format had several levels (hierarchies) of key/value pairs and the tool struggled to parse correctly. I feel that the BLOB tool allows the user to parse with greater control. I've run into the same issue with the Download tool. I have had greater success with the Run Command tool to perform cURL operations. In the end, use what gets the job done and Alteryx has many options!
Sorry About the content is very poor and you didn't cover many topics you go over the topic very fast and you ignored the level of background for your audience
5yrs after and I got the job done. Thank you Nathan
This was immensely helpful!! I tried many ways to get JSON data into a CSV cleanly with as few hacks as possible and this was the most comprehensive and clean way. Thank you!
Glad it helped Krithika!
This was the best Alteryx tutorial on RUclips that i have ever seen. You saved me hours of work! Thank you for your service.
Im new to Alteryx and spent several hours today for parsing json data. Thank you for making this video , I followed as you mentioned and was able to get my work done.
Love your work and the way you explain things so clearly. Thanks to you, I learned Alteryx within a few hours and couldn't get myself off the software because I was doing so well. Thanks a ton! Keep producing more content. I would love to see more about Tableau and Alteryx.
More to come!
Great video .. very concise and easy to follow. I was wonder how the approach would be when dealing with many to one elements
This is great. I've been trying to figure out how to do this for several days. I feel like Alteryx should make it easier than this, but this isn't too bad. The JSON Parser tool is worthless.
Glad the video helped. I struggled with tool for bit as well. Let’s hope it gets redesigned.
Crystal clear, man. Appreciate it.
Thanks Luis! Much appreciated!
This was a great, easy to follow video that helped me out tremendously. Thank you!
Thanks TaRan, I'm glad the video helped!
Hi Nathan,
Thanks for your insight. Please can you do a video on how to parse a multi-nested JSON dataset? Thanks.
This is an awesome vid. The data I test with is updated in JSON and the Alteryx tool isn't the easiest.
Thanks Joel! Yeah, the tool is a little bit challenging to use. Glad the video helped.
Super helpful video, thank you!
Glad it was helpful!
Very helpful - thanks!
You're welcome!
This was great, it let me solve my issue. You mention parsing JSON subnodes, do you have any advice on that? My JSON has a list of problems and your video showed me how pull out the problems & put them to excel, one row per problem. But within each problem there can be multiple comments, each comment has four fields (timestamp, ID, userid/enterer, and comment-body). Right now it's concatenating those four fields and concatenating all comments into one string/cell in the problem's row; I'd like to skip the ID field & convert the timestamp to a more readable form; otherwise I'm fine with concatenating the fields and concatenating all comments into one cell.
Yes, I have some advice on JSON subnodes. You'll want to use a combination of the Tile tool and the Transpose tool. You want to get the data in a format where Alteryx can easily discern the hierarchy. The Tile tool can break out item where 1 is the first item, and 1.2 is the second element of the first item. Let me know if that helps.
Incredible tutorial. Thank you so much!
You’re welcome, Richard!
Nathan, have you used Alteryx with Quick Base specifically where it concerns JSON and APIs ? Using Alteryx to make a API call to Quick Base to pull data?
Hi there, I've used Alteryx to make API calls and to download a JSON formatted payload. You'll need to use the Download tool (found on the Developer palette) to make the API call. There's a JSON Parse tool on the same palette.
@@NPT Thank you for the hint. I got this working now.
Hi NPT, I have a query.. I am using a big json file 7 gb and converting it to a blob by selecting "split blobs to chunks" option. But the splitted blob is not combined properly by the blob converter. My data is good until blob 1 but after blob 1, since its split in middle of a json field, its not working.. Please suggest any options
I'm having trouble parsing a complicated api json output, any advice on what to do if you have no standard record id? for ex. my fields look like this when i run the api --> 0.children.0.children.0.children.0.children.0.field --> i need to get to field but they're not aligned in the table the same way. Is there a good tool available for me to parse this into a table of table until i can see the structure? it's very hard to get through this data set as they don't appear to have a unique identified for the record. they appear to be using the # in the name to represent groups of data rather than individual records. sorry if very confusing... i am very confused by this api LOL
Why the blob input? Can't the JSON Parse tool handle a raw JSON file?
Hi Eric, thanks for the comment. Yes, you can use the JSON parse tool. At the time I created this video, the JSON parse tool was not processing EVERY JSON file the way I hoped. I found a few examples where the format had several levels (hierarchies) of key/value pairs and the tool struggled to parse correctly. I feel that the BLOB tool allows the user to parse with greater control. I've run into the same issue with the Download tool. I have had greater success with the Run Command tool to perform cURL operations. In the end, use what gets the job done and Alteryx has many options!
@@NPT Awesome. Thanks! Great video.
Hi If we have comments in a json file how can we pass in alteryx because if i pass i couldn't able to get the output
interesting Nathan. Thanks a lot
Thank you!
You're welcome!
Grt work
better ways to do it
Sorry About the content is very poor and you didn't cover many topics you go over the topic very fast and you ignored the level of background for your audience
What are you talking about? This was great. And the background of someone on RUclips is impossible to predict. So basically...f off.
What more are you looking for? I've used Alteryx once and this solved everything for me and got me going. It was an awesome vid.
Really helpful video, thanks!
You’re welcome Ryan!