Extract values from Array in QueueItem

[sai_krishna_somisetty (sai krishna)]

hi everyone,

i’m getting queueItem with below form of data

[{“Employee”:“XYZ”,“CourseID”:“UiPath”,“Designation”:“SE”,“Experience”:3.0},{“Employee”:“Pqr”,“CourseID”:“UiPath”,“Designation”:“SDEII”,“Experience”:4.0}]

How to extract Employee data from above queueitem dataType. i need both XYZ and Pqr.

Thanks in advance.

[NIVED_NAMBIAR (NIVED N)]

U need to deserialize the json string and then extract the values by dictionary based approach.

[sai_krishna_somisetty (sai krishna)]

how to convert queue item to Json datatype??

[ppr (Peter Preuss)]

@sai_krishna_somisetty
have a look here for selecting the info from JSON String:

Retrieve parts of JArray using Linq query

Hi All, I had some doubt, any solutions would be highly appreciated I have a JArray somenthing like : → “[ {‘fileType’:‘Matched’,‘filePath’:‘C:\Shared\XX1’,‘fileName’:‘1234_Por_compensar.xlsx’},{‘fileType’:‘Threshold’,‘filePath’:‘C:\Shared\XX1’,‘fileName’:‘1001_Por_compensar_tolerancia.xlsx’}]” I want a linq query that every time on firing results in the fetching up of the specific component like related to above string when i fire the Linq for 1st part of Jarray for key fileType i.e 'fileT…

@sai_krishna_somisetty

i’m getting queueItem with below form of data

[{“Employee”:“XYZ”,“CourseID”:“UiPath”,“Designation”:“SE”,“Experience”:3.0},{“Employee”:“Pqr”,“CourseID”:“UiPath”,“Designation”:“SDEII”,“Experience”:4.0}]

Here it would be helpfully to give more details on the source (DataType, variable…, Screenshot from Debugger Local Panels…) holding this JSON String

[sai_krishna_somisetty (sai krishna)]

consider this image as reference and help to process this data from studio.