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.
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