Bulk AddQueueItemsparameters must not be null

[sharu_priya]

Hi Folks,

I wanted to add 10k records to orchestrator queue from excel.

I used read range and stored the data in datatable and tried adding it to the queue using add bulk queue item and getting the attached error.

I tried both commit type but no luck.

Please help.

[Anil_G (Anil Gorthi)]

@sharu_priya

Can you check if your dt is empty by any chance

You can remove orch folder path as it is already connected to the same folder(optional)

Cheers

[sharu_priya]

you mean my inputfile?

i am getting the below error

I have 10k records in the excel

[RajKumar_DC (RajKumar Durai)]

Hi @sharu_priya,

Try to give your your Queue name with “” like below

[Anil_G (Anil Gorthi)]

@sharu_priya

Your input should contain only those columns which are to be added to queue…if you already have a schema defined then it ahpuld match…and if unique reference is enabled…then Reference is a mandatory column

Cheers

[sharu_priya]

Thanks… but it does not work

[sharu_priya]

Hey Thanks much… Can you please explain in detail?

[Anil_G (Anil Gorthi)]

@sharu_priya

Say your items needed in queue are name and age and if unique reference is set in queue then your columns would be name ,age and Reference…please check below for more details on different options available

And also…while reading data did you check the add headers column?

And as well the column names should contain only letters,number and underscores …no special characters are allowed…

Bulk Add Queue Items in UiPath Orchestrator | UiPath RPA

https://docs.uipath.com/orchestrator/docs/bulk-uploading-queue-items-using-a-csv-file

[sharu_priya]

Hi Anil,

I tried same as the video… and checked unique reference too

[Anil_G (Anil Gorthi)]

@sharu_priya

Can you show the columns in your csv please

Does it include Reference column? And what other columns are there? …those columns shpuld not have special characters

Cheers

[Rahul_Unnikrishnan]

Hello @sharu_priya

Please check dtOutpur.Rows.Count to check the number of rows in the datatable. Also, Have you already added any data to the queue or have you configured any input schema while creating queue?

If not you can directly use your datatable in the Bulkadd queue item. But the datatable should have some rows.

Thanks

[sharu_priya]

Hi Rahul…
I have solved … in my column name there was a full stop…i removed that and i tried… it works

[sharu_priya]

There was a full stop…i removed and tried . Thank you