Bulk add queue items returned invalid statuscode "bad request"

Result - Copy.xlsx (17.1 KB)
attached is the excel file am trying to convert in to data table and add in the queue using add bulk queue items.
while doing so i am getting the above error
there was a similar thread for the given thread

but that is not matching with my problem whye because i tried all following ,

  • hard coded the queue name , so that it excatly matches my orch queue
  • removed the first row while reading the excel with out header so that spanish colum names might not create an issue.
    *i read the excel only from A1 to V4 so that i dont read the last 8 columns which has only blank values.
    i still got the error
    reagarding queue it has “unique reference” option given while i created it
    any suggestions / solutions would be really appreciated.

ok , it worked when i created another queue with out unique reference . so may be some of the column with same values in multiple rows would have prevented the queue items from adding.
now , i do have a unique reference but that is not a single column its a combination of columns. how to proceed in this case ?

(A late reply, but posting it since it might help others looking for the solution/workaround)

If you have set the “Unique Reference” to True while creating the Queue, then the datatable that you provide as input to the activity must contain the column Reference in it. Else, the activity will return Bad Request exception.

Ref: About Queues and Transactions

If you want to create a unique reference that is not a single column, combine the data from required columns and add it to the column Reference for that particular row.