Query having different results in "Preview" and in actual "Run"

[Padierfind]

Hello everyone,

I'm quite new to Retool, so please bear with me.

I've tried to update my database using an API request when someone clicks on a button in a table.

The setup looks like this:

The idea is that I use {{table1.recordUpdates[i].name}} to get the updated name of the current column I want to update. And it does display the value as you can see below:

Now, if I click on "Preview" it shows the API request exactly as I would expect:

But if I click on "Run" suddenly the "name" field is null:

Any help to why this is happening would be greatly appreciated!

Thank you and have a great day

[victoria]

Hey @Padierfind! Happy to help with this. To double check, are you editing your table before running the query? As in, is there data inside recordUpdates?