How to parse a JASON file

Question

Hi Team,

When fetched the data from salesforce, it is fetched in JASON format. Attached is the screenshot of how the data looks like when I click on browse tool. How to parse that data into required text format to be able to perform further operations on it?

Thanks,

Capture.PNG

caltang · Answer

There’s a good post here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/JSON-Parse-to-table/td-p/891580

If you’re stuck, kindly provide the JSON file and maybe the community can help!

fmvizcaino · Answer

Hey @psuhane ,

You have to use the Json Parse tool. Here is more information about it. https://help.alteryx.com/20231/designer/json-parse-tool

On your help menu, you can find an example of the tool.

Best,

Fernando Vizcaino