Hi, I’m trying to POST 250k rows of data form excel file (uploaded to dataTable) to Table on Azure Blob with HTTP Request UiPath activity.
The problem is looping through 250k items it takes hours to POST all rows.
Do you know if it’s possible to somehow change JSON Body property.
Is it possible to loop through 250k rows in datatable and create one JSON with 250k entries and POST all 250k items by one HTTP POST request?
There is body of POST HTTP request for each row in dataTable, after each row HTTP request is send to server and everything is ok, status 201.
{‘CCd’:’"+row.item(0).toString+"’,‘DocNo’:’"+row.item(1).toString+"’,‘CreatedBy’:’"+row.item(4).toString+"’,‘CreatedOn’:’"+strDateFixed+"’,‘UserType’:’"+row.item(7).toString+"’,‘PartitionKey’:‘7dec2020’,‘RowKey’:’"+strRowKey+"’}"