Appsheet api increment column

[Pethipojquis56]

Iam calling an api which i wish to increment/add one to a column. how do i do that? I have treid the following does not seem to work.

"input extra matrial":"<<[input extra matrial]>>+1"

"input extra matrial":"<<[input extra matrial]+1 >>"

"input extra matrial":"<<[input extra matrial]>>+1 "

[Marc_Dillon]

Set up an action to increment the column, and call the action through the API.

[dbaum · Accepted solution]

@Pethipojquis56 wrote:

"input extra matrial":"<<[input extra matrial]+1 >>"

---

Among your examples, this follows the appropriate syntax for expression variables.

Are you sure your syntax is the problem? Does the webhook task include other data updates that work? Does the task have the right table selected in its properties?

An alternate approach would be to create an action within the app that increments the column value and then call that action from the API rather than the generic "Edit" action.

[Pethipojquis56]

is their a limit to how many rows you can edit via api? i got the increment to work but it stops at row 25. Does calling an action via api just as effecient as api edit?

[dbaum]

---

@Pethipojquis56 wrote:

is their a limit to how many rows you can edit via api?

---

Not per se, although it can time out--for example, if the edits trigger complex recalculations in other columns. I've used the API to process 1000s of rows.

---

@Pethipojquis56 wrote:

i got the increment to work but it stops at row 25.

---

Confirm that you included in the API call all the rows to be edited.

---

@Pethipojquis56 wrote:

Does calling an action via api just as effecient as api edit?

---

I don't know.