Reading a JSON file and update values in a List

Question

General Question: For updating a json file--> reading it as csv file with no delimiter and then update the rows by identifying the pattern using regx functions and save it as .JSON OR read it as json with name value pair then update the values and save as .JSON which is the correct way.

TheOC · Answer

hi @sreejithmp

As always with Alteryx, there are many ways to approach a task, and theres not always a clear cut right answer. My suggestion would be the latter, as it would be easier to troubleshoot if there was a problem with your workflow. Additionally you have the option of using the first method, but extracting the name/value pairs with a json parse tool within Designer.

Hope this helps,
TheOC