Database records not updated in an api workflow on a list

[gbourdeau]

Hi everyone,

I’m trying to update some database records using an API workflow on a list. Here’s what I’ve done so far:

1. Set Up API Workflow
   I created an API workflow to update records and manually defined the parameters.
   

   

2. Update Records
   I used the “Make changes to a thing” method in the workflow to handle the updates.
   

   

3. Trigger API Workflow
   I created an API workflow triggered by a button click. In this step, I:

   • Set up custom states to define:
     • A list of animations to be updated (using a search method).
     • A random ID to assign to each updated record.
     • A refund status.
       
       

4. API Workflow on List
   I created an API workflow on a list that uses the values from the custom states.
   

   

Everything appears to be set up correctly, and there are no visible errors.

When I run the workflow:

• The list of animations to update is successfully retrieved.
• The workflow on the list starts and finishes as expected.
• However, no records are updated.
  
  

I’m unsure what I’m doing wrong. Can anyone help identify the issue?

[romanmg]

First thing I’m noticing is the value you’re sending to the backend workflow for “DbAnimation.” I believe you want this to say “This DbAnimation”.

What you’re doing currently is sending the same DbAnimation for every item in the list (i.e. the first item only).

[gbourdeau]

Hi, thanks for your message. You were correct—I made that error while trying to figure out what was going wrong. Even after making the change, the issue persists.

I can retrieve the list of items to be updated, and I see the update tasks for each item, but none of the items are actually being updated. Additionally, I’m not seeing any errors in the logs.

Am I missing something that would allow a workflow to update a table?