Bulk add queue items datatables

Hi, so I need help
With the data table in bulk activity . I have the queues reading from a share point. Now im in transaction Data. I want to store information in the data table like the name, status. Etc. how do i achieve this without having to read from an excel sheet. Reframework

@Sira,

It’s bit confusing question. If you have to use add bulk queueitems then you should have your data in Datatable.

If you are reading data from SharePoint or any other location, you don’t have any other option to read data and store it into Datatable except Read range activity.

Honestly, I don’t think add bulk queueitem and not reading data from excel will work together here. I hope you have strong reason for not following the best practice here.

Thanks,
Ashok :slight_smile:

Is there any way to get the datatable in bulk add queue items . By name, status information

@Sira,

Are you talking about retrieving DataTable from Queue?

Yes thanks any suggestions

@Sira,

Unfortunately, no quick or instant way. We will have to use Get QueueItems which will return you max 100 QueueItems at a time. If your data beyond it use Skip property to paginate next QueueItems.

Once you retrieve all the QueueItems then again deserialize the SpecificContents into DataTable.

Alternate option: You can use Orchestrator API’s which might be hard option for non so much technical person but it’s less or more same steps like earlier approach.

Thanks,
Ashok :slight_smile:

1 Like

How can I add the metadata to a bulk queue item?

@Sira

Meta data can be added as specific content like each data a separate column

Cheers

Can you explain im in get transaction Data im new working on reframework or show example please

@Sira

Once you read the data from sharpeoint…it is stored in dattaable lets day dt…

Then dt can be directly added if you need reference add a reference column to datatable or directly just use the dttaable in add bulk wueue…

As this would be linear…in get trans data you would just use if conditin with in_transacitonnumber=1 and on then side add assign with out_transactionitem = somevalue and on else gi e nothing to out_transitn …and add bulk queue goes into process

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.