I have an issue when trying to upload datatable to queue with Bulk Add Queue items activity , the error msg is “Operation returned an invalid status code ‘BadRequest’”
I guess the problem is with datatable size it contains +26k rows i had the idea to use for each but i didn’t know how to do it , maybe there is another solution any help please ?
Check if the datatable column names contain any (.). If the column name contain any dot(.), it will give the same error. Else try add queue item activity in the for each row in datatable activity with different column names.
Possible cause of this error could be due to the size of the data table you are trying to upload. If you try to upload each row as a queue item, it will take 7.2 hours even if you assume one row takes one second.
If you are sure that the datatable structure and colums are correct, you can split the table into batches & try uploading each batch. Try this query: