How To Extract The Data From A JSON – In UiPath

Posted on by Sharath Raju

Some business processes may consume the JSON as an input/output to exchange data to/from a web server.

When receiving data from a web server, the data is always a string.

Let’s explore how to extract the field from a JSON string!!!

Example

Implementation using UiPath :

Let us implement a workflow which consumes a JSON string and extracts the required fields.

Step 1:
Drag “Assign” activity into the designer panel and assign some JSON string as shown below.

“{
‘fruit’: ‘Apple’,
‘size’: ‘Large’,
‘color’: ‘Red’
}”

Extract Data from JSON string 1

Step 2:
Drag “Deserialize JSON” activity into the designer panel to deserialize a JSON string. Supply the variable “json_Data” to it as input and create a variable called “out_Json” of JsonObject type.

Extract Data from JSON string 2Extract Data from JSON string 3

Step 3:
Drag “Message Box” activity into the designer panel to display the “Fruit Name”.

Extract Data from JSON string 4.PNG

Similarly, we can extract any number of required fields by passing the names of the appropriate tokens 🙂

Step 5:
Finally, let’s run the project to display the “Fruit Name”.

Extract Data from JSON string 5.PNG

Click here to download the Source Code…

Hope it has helped you…

Published by Sharath Raju

I am an engineer by profession and by heart :) It's been 7+ years since I have been working with software development and robotic process automation. I have implemented close to 80+ RPA processes in total by using Uipath. It is so true that someone learns more by not reading something but by practicing the skill. I have been trying to understand exactly where people who are just starting out their career struggle and understand the pain of struggling for hours trying to figure something out.I can help you with that. Having a passion to share my piece of content, I have created step-by-step easy-to-digest courses. My goal is to help you get ready for the future by learning new talents and becoming more productive by providing you with relevant and useful courses. I'm still learning and exploring my field of work :) Every feedback should be as valuable as you are to me, please feel free to reach out to me if you have any feedback, questions, or need any help.Thank You...

5 thoughts on “How To Extract The Data From A JSON – In UiPath”

  1. Vasundhara
    May 3, 2020 at 5:46 pm

    Hi Sharath, I tried this. It is not working. I am getting this error:- Validation Error: Compiler error(s) encountered processing expression “json_obj.SelectToken(“fruit”)”. Option Strict On disallows implicit conversions from ‘Newtonsoft.Json.Linq.JToken’ to ‘String’. Can you please help?

    Reply
    1. Vasundhara
      May 3, 2020 at 5:52 pm

      Just had to add .ToString after SelectToken; for eg: json_obj.SelectToken(“fruit”).ToString
      Please update the post 🙂

      Reply
      1. Sharath Raju
        May 3, 2020 at 5:54 pm

        Exactly, it works for few activities without .ToString and fails for few 🙂
        Thanks Vasundhara !!!

  2. Vivek N
    May 5, 2020 at 5:33 pm

    I have a field called duration and the output is some number like 80099 (in ms), but i want this number to be number itself and not a string, how to do this??

    Reply
    1. Sharath Raju
      May 5, 2020 at 5:35 pm

      Hi Vivek
      We have to explicitly convert it to “Number”
      Because the processed output will be a object always:)

      Thanks!!

      Reply

Leave a Reply

%d bloggers like this: