Hello, @Allan_Zimmermann I start using workitems and it’s very helpful.
I would like to know how to change or add a element value in the “object” payload. I want to change two elements, “perfil” and “estado” values depending on what I get the a webpage when processing a item.
Initial payload:
workitem.payload is a dictionary with all the values.
So you can reference the values per name or ID and you can use collection activities on it. UpdatePayload.xaml (25.1 KB)
@Allan_Zimmermann I have another question about the IF statement row("key").tostring =workitem.payload("currency").ToString inside the “Foreach DataRow”.
I have more than 30,000 elements to process but every time an item is processed it has to go through each row until a match has been found. It’ll take a lot of time to process everything.
Exemple:
It fills in some data in the corresponding cell of the excel file and workitem.
So… Is there a better way to do that?