Extract data from JSON

Help Studio
#1

Hi All,

I have extracted data of Orchestrator queue in JSON format and from this i need to fetch the values of Invoice_Date, Seller_ID ,and VIN_Number and store them into variables for future use.
Challenge over here is that there are multiple values of these as the queue contains 10 items description.
Can anyone suggest how it can be done.
All of the these values can be found in Message field of JSON attached.

@Lahiru.Fernando @RobotMaster @GBKnew1.json (11.7 KB)

#2

@Jayesh_678 can you also please support in the above query

#3

@J0ska can u please support in the above query

Thanks
Som

#4

Please send the Json output in notepad. I am unable to open JSON file.

#5

One of the ways of doing this by using SelectToken from the Json response, another way is by using Regex expressions.

Solution by using SelectToken is below, See output panel

For each of the response Json, we would need to use below 3 sequences

image
image1907Ă—905 74.9 KB

image
image1521Ă—675 55.1 KB

image
image1127Ă—542 8.4 KB

Extracting your json response as below, which contained the parameters you mentioned

{
“DynamicProperties”:{
“Invoice_Date”:“05/07/2019 09:11:00”,
“Seller_ID”:“4916882”,
“Seller_Name”:“DT INVENTORY”,
“PO_Number”:“PXAA”,
“Aucton_Location”:“Tolleson, AZ”,
“VIN_Number”:“KMHTC6AD9HU309121”,
“Year”:“2017”,
“Make”:“Hyundai”,
“Model”:“Veloster”,
“Price”:“80”
}
}

You can use assign activity and store formattedJson.SelectToken(“DynamicProperties.Seller_ID”).ToString into a variable
Similarly for formattedJson.SelectToken(“DynamicProperties.Invoice_Date”).ToString
and formattedJson.SelectToken(“DynamicProperties.VIN_Number”).ToString for each of the parameters mentioned

1 Like