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’
}”
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.
Step 3:
Drag “Message Box” activity into the designer panel to display the “Fruit Name”.
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”.
Click here to download the Source Code…
Hope it has helped you…
Like this:
Like Loading...
Related
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...
View all posts by Sharath Raju
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?
Just had to add .ToString after SelectToken; for eg: json_obj.SelectToken(“fruit”).ToString
Please update the post 🙂
Exactly, it works for few activities without .ToString and fails for few 🙂
Thanks Vasundhara !!!
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??
Hi Vivek
We have to explicitly convert it to “Number”
Because the processed output will be a object always:)
Thanks!!