Table editable save handler how to pass a path parameter to a rest api query

App Building
, ,
1

Hi,

How can I pass a path parameter to a rest api query in the save handler of a table with editable cells?

Retool table save handler
Retool table save handler1698×1157 152 KB

2

Check out this topic - How to use additional scope (additionalScope) in your queries

3

I managed to get it working but this gets too complicated to use at this moment because the changesetArray only contains the changed fields and the rest api needs all the field values to update the record.

4

Definitely agreed that this can be a bit complex currently! :disappointed:

For users running into this, you can have some Javascript, similar to the below snippet, that combines the two properties

table1.data.filter(x=>formatDataAsObject(table1.changesetArray).id.includes(x.id)).map(x=>_.merge(x, table1.changesetArray.filter(y=>y.id===x.id)[0])  )