Bulk item with unique ref

[Hazem_Saleh]

Hello all,
im adding the a table with column reference which is work

Lets say i got 50 rows

and next run i have 100 rows including the old 50 rows !
how to add only the new 50 ("without for each " its very slow)

BR/Hazem

[sven.wullum1]

Hi!

Make a column ‘reference’ of type string in your datatable and populate it with what you want as a reference

[Hazem_Saleh]

Hi,
Yes i have it as string my issue is how to filter them

im using process all independently but its notworking !

[ashokkarale]

@Hazem_Saleh,

This you will have to configure in Orchestrator level while creating Queue.

Make sure you are checking Enforce unique references checkbox. With this duplicate or already exists queue id’s with reference will not be added.

Thanks,
Ashok

[Hazem_Saleh]

Thanks i do that its working but extremally slow im processing around 10k per day.
just populate queue up to 10 minutes each run

anyway around this!
or shall i add it to the DB directly !

BR

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @Hazem_Saleh

Bulk Add Queue Item doesn’t provide Unique Reference, Take a foreach row in datatable in that take Add Queue Item activity and put CurrentRow("ReferenceColumn").ToString in Reference property.

Screenshot:

And as suggested by @ashokkarale follow those steps also,

@ashokkarale

Make sure you are checking Enforce unique references checkbox. With this duplicate or already exists queue id’s with reference will not be added.

Now you are good to go!

Regards,
Ajay Mishra

[ashokkarale]

@Hazem_Saleh,

In that case, I would suggest API approach.

Thanks,
Ashok

[Hazem_Saleh]

Thanks any quick tutorial
thanks in advance

[ashokkarale]

@Hazem_Saleh,

Didn’t find exactly for bulk queue item but here is one as starter for you. Search for more you will get it or understanding this one you can do it yourself.

How to add a Queue Item through orchestrator API calls via postman - Part 9

Thanks,
Ashok

[Anil_G (Anil Gorthi)]

@Hazem_Saleh

You can directly use bulk add queue items instead of looping and usinng add queue item

Also if you know how many to ignore you can use skip to skip those values directly and save only the remaining

Cheers

[Hazem_Saleh]

Thanks all, i think i will take the api approach
after i changes my queue item its shows on the orch

The queue with P-test was only for testing and not in config !

BR

[ashokkarale]

@Hazem_Saleh ,

Glad I’m able to help you. Please don’t forget to mark my answer as solution so it will be helpful to other community members as well.

Thanks,
Ashok