I want to update existing multiple records in appian table having a primary key. How can I do this ? is there a smart service to update bulk records in sql appian table ??
Discussion posts and replies are publicly visible
Sure. The write to datastore smart service takes multiple items. Just make the parameter taking the data a multiple.
I have the data in form of dictionary ...how can I retrieve multiple values from dictionary and pass it to individual field values in write to data store smart service
Is your dictionary not the same type as the CDT you're trying to update? Can you tell us any more details about the data you're starting with and what it ends up needing to do?
steps to perform:
1. Read column values from excel file and extract the data
2. Store the values in write to data store entity so that rows in appian db can be updated .
Note: Rows have primary key in appian table
© 2021 Appian. All rights reserved.