Extracting value from JSON file

Help Activities
,
2

Hi @tainan.ramos,

A very rudamentary way is to read the json file as text file by using the Read Text File activity. This returns a string. Then you can determine if that text string has “x-cod” by using

If condition = TextStringReadFromFile.contains("x-cod")

If true, Then extract value.
Before extracting the value in the Then block you can use DeserializeJson activity to extract value of Json using
Some helper code for json parsing / value extraction in UiPath : Iterating through Jobject - #6 by jeevith

Else do nothing - skip the parsing / extraction.

Hope this gives you some ideas.

2 Likes