Comaparing two json files in uipath

[mehtah (Himanshu)]

Hello Community,
I have 2 json files and my task is to compare the two json files. I need to check whether they both are consisting of same data or not. If not then I need to figure out which data is not matching. Help me setup a workflow for the same. Am attaching the screenshots of two json files below.

[Edwin_Barahona]

Hi @mehtah,

in essence what you need to do is deserialize the JSON text into an object you can iterate/compare.

Here’s an example

Json Parsing - Json array in Json Object

Below is my Json file which i want to parse to get all the values in dictionary with keys and values as string . Getting Error in line 12 OUNew and LegalEntity . { “trackingnumber”:“ORA0000005806”, “requestorEmail":"xyz@xyz.com”, “requestorName”:“xyz “, “supplierName”:“Uline”, “supNumber”:“1068”, “businessCenterId”:“United States”, “isActiveSite”:false, “supplierAddress”:“12575 Uline Drive Pleasant Prairie WI US 53158”, “siteCode”:“1845046”, “OU”:””, “OUNew”:[ “101” ], “LegalEn…

Additionally, Here are some resources (there’s a lot to read)

Deserialize Json (uipath.com)
JObject Class (newtonsoft.com)
Newtonsoft.Json.Linq Namespace