Hello again. I am looping from a JObject that I deserialized previously: [image] This are the way how the for each is working an setup. It works fine for getting EndProcessing data: [image] But I am also trying to get some info, and I cant find the way to reach it: [image] The info is there…

given string was failing as it was reported as invalid JSON removed " (see yellow marks) was accepted SpecificContent expects simple dataypes, otherwise we can store serialized objects Driven how a valid JSOn would look like, a serialized string with the \" was created JSON was parseable Log Ou…

would it be possible that you can share a sample JSON as txt / txt file. For Sure mask your sensivtive data. quitem(“SpecificData”)(“DynamicProperties”)(“ID”).toString was tested?

[image] ppr: (“SpecificData”)(“DynamicProperties”)(“ID”) Hello again Peter! I had tried: [image] qitem(“SpecificData”).tostring: “{"DynamicProperties":{"ItemKey":"49477","ID":"49477","EntryType":"SecretThings"}}” qitem.ToString @“{ ““Reference””: ““49477"”, ““StartProcessing””: ““2021…

first round: given json was not accepted / parsed. I did edited and removed some " check yellow marks then it was working [grafik] it looks that a serialized string is within Specific Content. In a second round we should over come. Please check if the yellow marks are part of json or not. For …

Also have a look here: [image] Deserialize Json to DataTable with a Json Column Studio @ajgb find some starter help here: JSON-QueueItem_To_Datatable.xaml (10.6 KB) for a later parsing the specialcontent.string just Parse the Content of SpecificData into a JObject - jo …

Yeah It works, when I have time I will read and practice with all your guides in the forum, and other tutorials for Linq and Json Objects. Thank you Peter, as always, you really are an MVP.

Get the specific data from a queue item retrieved from api in a loop (JSON object)

Help Studio

ppr (Peter Preuss) September 9, 2021, 10:19pm 6

Also have a look here:

Topic		Replies	Views
Extract values from Array in QueueItem Help orchestrator , question	4	1278	January 30, 2021
How to retreive <INumerable<QueueItem>> type from the Queue Learning Hub	23	2746	July 6, 2020
Want to retrive the queitem[] one by one in array Help studio	12	1850	July 3, 2019
Extracting Specific Data Json Studio studio , question , variables_management	3	1840	September 26, 2021
Dont know how extract the data I need in a Json Object Something Else linq	4	1839	August 26, 2021

Get the specific data from a queue item retrieved from api in a loop (JSON object)

Related topics