Database records not updated in an api workflow on a list

gbourdeau · 2025-01-20T12:43:55.361Z

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:

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

Capture d’écran 2025-01-20 à 09.28.533024×1974 385 KB
Update Records
I used the “Make changes to a thing” method in the workflow to handle the updates.

Capture d’écran 2025-01-20 à 09.29.073024×1974 357 KB
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.
    
    Capture d’écran 2025-01-20 à 09.29.483024×1974 345 KB
API Workflow on List
I created an API workflow on a list that uses the values from the custom states.

Capture d’écran 2025-01-20 à 09.29.533024×1974 410 KB

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.

Capture d’écran 2025-01-20 à 13.40.143024×1974 439 KB

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

romanmg · 2025-01-20T15:54:03.251Z

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).

image1920×1253 102 KB

gbourdeau · 2025-01-21T15:28:30.844Z

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.

FireShot Capture 334 - La tournée CIVB - Bubble Editor - bubble.io2800×1576 362 KB

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