Queue Items Requests Related

[Sayed_Tabrez]

   "SpecificContent": {
        "EmployeeName": "John Kensington",
        "ContactNumber": "+4457899",
        "RelocationDistance": 500,
        "Description": "Home relocation",
        "ExpenseCode": "UI234",
        "Amount": 1000,
        "RequirePass": true
     },
 **for this we can write like this in add data table**
{item("SpecificContent")("AccountNumber").ToString}

      "SpecificData": "{\"DynamicProperties\":{\"EmployeeName\":\"John Kensington\",\"ContactNumber\":\"+4457899\",\"RelocationDistance\":500,\"Description\":\"Home relocation\",\"ExpenseCode\":\"UI234\",\"Amount\":1000,\"RequirePass\":true}}",
 **How can we need to write in add data table**

[lrtetala (Lakshman Reddy)]

Hi @Sayed_Tabrez

Please check on this

Select few fields in QueueItems and convert to Datatable

@vijayakumarkj please try this first use build datatable and create a datatable with 3 columns and name it dt dt = queueitems.Select(function(x) refdt.Rows.Add(New Object(){x.Reference,x.SpecificContent("FirstName").ToString,x.SpecificContent("LastName").ToString})).CopyToDataTable Hope this helps cheers

Regards,

[vrdabberu (Varunraj)]

Hi @Sayed_Tabrez

Please check the below thread

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

Regards

[Sayed_Tabrez]

i found how to get Queue item. our requirement is get data from specific data not specific content

Orchestrator - Queue Items Requests

[vrdabberu (Varunraj)]

Hi @Sayed_Tabrez

The output is an IEnumerable right so please try with the below linq:

JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)