Extracting info from JSON file received through REST API

  • 104 Views
  • Last Post 3 weeks ago
ayushk@abm-bmpl.com posted this 4 weeks ago

Hi,

I used Rest Api client to extract data from a webpage in json format. Now I want to do two things

1. Convert data in json format into excel file.

2. Extract data from a particular index field to be used in further process.

Order By: Standard | Newest | Votes
Intellibot Support posted this 4 weeks ago

Hi,

Please find the sample automation  below on how to extract data from Json Format, Hope it helps!

https://drive.google.com/file/d/13O4E40vEne7zLgcvNZ-ducRNE53o8rgN/view?usp=sharing

Thanks & Regards,

Intellibot Support.

ayushk@abm-bmpl.com posted this 3 weeks ago

Hi,

I tried the method you shared. I received the error as shown in image below.

My json file is nested like:

{    "Members": [            {                "Id"1,                "Name""JohnDoe",            }                       ] }

I want to access the ID and Name data

Intellibot Support posted this 3 weeks ago

Hi,

Please find the sample automation  below on how to extract the above mentioned data from Json Format, Hope it helps!

https://drive.google.com/file/d/10DAmdA9QIAyUyimpfHtPXegEpI0HK5Rs/view?usp=sharing

Thanks & Regards,

Intellibot Support.

ayushk@abm-bmpl.com posted this 3 weeks ago

Hi,

I'm still getting the same error "Conversion from type 'JObject' to 'String' is invalid".

And the database members has multiple objects. The above format was just an example of how the database is nested.

Consider the structure of the database as below:

{

   "Members":[

      {

         "ID":"1",

         "Name":"JohnDoe"

      },

      {

         "ID":"2",

         "Name":"JaneDoe"

      },

      {

         "ID":"3",

         "Name":"JamesFranco"

      }

]      

}

 

 

Thanks

Intellibot Support posted this 3 weeks ago

Hi,

Our team will connect with you over the email and share the details on this.

Thanks & Regards,

Intellibot Support.

Close