Hi! I´m trying to update a value in my process model by using an script task (change value to "true" and saves it into the field "facturada) and then using the writeRecords smart service
My configuration is:
1. Script Task:
The value "true" is saved into the field "facturada" of my record. It´s important to say that I´m updating an ARRAY
2. Write Records Smart Service
In the beginning, I was updating the entire record, but this was causing that my data got duplicated (f.example if I created 2 rows, there were 4 rows). So I´m trying to update just the field I want ("facturada")
(The target in my last picture is the field I want to update (recordLineas.....recepcionada))
The error that appears is the following:
How can I fix this? Thanks a lot
Discussion posts and replies are publicly visible
You first need to modify the data in Appian before writing it to the DB. In cases where I need to do a more complex modification of data, I create an Expression which takes that data as an input. Then I can test that separately. As I suggested in the other conversation, use foreach and a!update to modify fields in a list of records.