Does any one know how we can add data table or dictionary in bot queue using add queue item activity. I tried to find you tube video and knowledge base also but no help. Also tired my luck on existing topics in this forum but did not find any.
Whenever i tried to add data table to queue it gives error “could not determine JSON object type for type System.Data.DataTable”.
Also is there any way i can add whole excel tab as one single collection in queue.
Usually each row is a separate transaction, so this is quite unusual. But if you have a valid reason there are options:
Store file location instead.
Serialize yourself. Import namespace Newtonsoft.Json, then use JsonConvert.SerializeObject(yourObject) to make it a string and store that. When getting object from queue use JsonConvert.DeserializeObject(Of DataTable)(queueItem.SpecificData(howyounamedit))
Please check your ID has write permissions on the database.
also make sure your query has all accurate columns/row names before updating the data into data table.
good morning
at the time of converting it back to a data table, it only has one value and not all the values as if it were a table, how could that be solved?
Thanks a lot
You can take it as a datarow. Or you can gather all the transactions and make it datatable as describe in above post (attached example).
If you are confused/stuck please send some smple data i Will send the code for that.
i was following this post and i checked out your workflow that you had shared. I am in a very similar situation . This is what i am trying to accomplish.
I have a source excel/database which contains million of data. I am creating a subset from that source file say process 10 rows at a time. I want to pass this subset 10 rows in one transaction add to queue . I dont want 10 separate transactions in that queue. so subsquently when that queue gets triggered each performer bot runner will work on a single transaction which contains 10 record.
I am attaching a sample excel file which contains some dummy data. Let me know your thiughts.
cheers !
since I cant upload a file. I am just posting a sample record from excel.