Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
how to update database with the database adapter? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to update database with the database adapter?

Received Response
18
Views
2
Comments
edited Jul 24, 2019 4:58PM in Integration 2 comments

Summary

need to update rows based on a value found in one of the fields

Content

Hello Gurus,

I'm processing data from a database using the DB adapter. I'm able to get data from the database.

after processing that data, i want to use the primary key from that row of data to update a field value.

 

the workflow is:

Get data from DB
     for each row
          process data
          update a field in db to know its been processed.
     end loop
end orchestration

 I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!