Invoke web service and extract data from Json to Excel File
This example gives an idea on how to invoke a web service and extract particular data from the Json response, using regular expressions and store into Excel file.
1 person likes this idea
Any way to do it so the json output is interpreted into a table? This way we don't have to create one parse for each variable?
You can convert this Json output into custom object by using action called "Convert Json to Custom Object". Accordingly you can work on same object.
Maybe I'm missing it, but I'm still failing to see how to convert it into a table. For instance, so I can paste it into an excel file without having to code each individual variable. What I'm looking for, to put it simply, is to do the same thing you can do when you read data from a website table as a table and write it to excel. Maybe that can be done with the custom object, but I don't see it. Thoughts? I attached a crude sample output with only one row of data.
By using custom object and loop you can do that. Kindly refer attached screenshot.