How do I compare two JSON Object's (Not JSON Arrays) and show the differences?

Help Studio
, ,
1

Here it is having object inside object. I just want to compare the data.

image
image557×768 25.8 KB

2

Hi @companir

  1. You can use the “Deserialize JSON” activity to convert the JSON objects into dynamic variables or objects.
  • Provide the JSON string or file as input to the activity.
  • Assign the output to two variables, let’s say “jsonObj1” and “jsonObj2”.

  1. Initialize an empty list variable, let’s call it differences, to store the differences between the JSON objects.

  2. Use a For Each activity to iterate through the properties/keys of jsonObj1. Choose the appropriate iterator type based on the data structure of the JSON object (e.g., Dictionary or JObject).

  3. Inside the For Each loop, check if the current property/key exists in jsonObj2 using an If activity.

  4. If the property/key exists in jsonObj2, compare the corresponding values of both JSON objects using an If activity.

  • Convert the values to strings for comparison (if necessary) using the ToString method.
  • If the values are different, add the property/key, value from jsonObj1, and value from jsonObj2 to the differences list.
  1. After the For Each loop completes, you can display or process the differences list as per your requirements.

Hope that helps :slight_smile:

3

But here the JSON is having object inside an object format, right? How do you iterate in such case?

4

@companir
Use a For Each activity to iterate through the properties/keys of jsonObj1 using the Get JToken activity.
Set the Token field to jsonObj1.
Set the TypeArgument to Newtonsoft.Json.Linq.JProperty.
Inside the For Each loop, check if the current property/key exists in jsonObj2 using the JToken.HasValues method.

  • Use an If activity with the condition jsonObj2.HasValues(Of Newtonsoft.Json.Linq.JProperty)(Function(x) x.Name = item.Name).

If the property/key exists in jsonObj2, compare the values of both JSON objects using an If activity.

  • Use an If activity with the condition Not JToken.DeepEquals(jsonObj1(item.Name), jsonObj2(item.Name)).

This is a little bit complicated. Alternatively you could also write custom Code and invoke it.

further information on getting specif values here: Nested JSON Deserialization and get specific values

5

Which package has Get JToken Activity? Didn’t find anything on internet.

6

Hi @companir you don’t need an extra Package except UiPath.WebAPI.Activities. A possible solution is descirbed here: Need to extract multiple data from JSON - #2 by ppr