Deserialize JSON Format

Help Studio
, ,
1

I have attached a sample JSON text file. I am trying to pull modelYear and the LicensePlateNumber from the JSON. Can anybody provide a workflow on how to pull that information?
json.txt (1.4 KB)

2

Hi,

In short, your json is a JObject with some JArrays.

// JObject
{
  "responseRecords": [ // JArray
    {
     ...
      "vehicles": [ // JArray
        {
          ...
          "modelYear": "1986",
          ...
          "licensePlateNumber": "87096ST" 
          ...
        }
      ]
    }
  ]
}

If you want get the modelYear and licensePlateNumber for the first vehicle (by your sample) you need assign:

firstVehicle = jsonObj("responseRecords")(0)("vehicles")(0)

The firstVehicle variable is a JToken, now you can get what you need by assigning:

movelYear = firstVehicle("modelYear")

firstVehicle = firstVehicle("licensePlateNumber")

Please note that here we are considering that you have only one responseRecords and only one vehicles. If you can have more items, consider use a For Each.

3

Thank you I will try it out and let you know how it works.

4

flow
flow426×520 18 KB

Would I use the assign activity after the Deserialize JSON activity and then a message box to see if it pulled the correct information?

5

Exactly, use the variable that you defined in the output of Deserialize JSON, replace the “jsonObj” sample that I wrote for that.

6

what type of variable should firstVehicle be?

variable
variable969×286 13.2 KB

7

I changed it to jtoken. my message box it showing all the information though.

8

message
message812×623 98.2 KB

9

Hi, check the attachment:

Main.xaml (6.1 KB)

10

Alexandretpered,
Thank you for the help on this, Nice Work!

11

Any idea how I would assign the the pulled modelyear and licensePlate to its own variable? If I wanted to add those values to a excel sheet. We used a message box to show the model year of the vehicle, how would I store that year in a variable. I will eventually be needing to store multiple modelyears in a variable and then writing them to excel. Any Ideas?

12

I think I got the above figured out, I just used an assign activity to collect them into a variable

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.