Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Invoke web service and extract data from Json to Excel File

ADMIN

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.

waj
waj

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?

ADMIN

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.

Thank You!

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.

ADMIN

By using custom object and loop you can do that. Kindly refer attached screenshot.


Login or Signup to post a comment