I must be missing something really simple here,
I want to edit multiple rows all at once using a webhook in the entire table (because doing it line by line would probably time out as itโs recalculating a varible).
I keep getting " Row key field โIDโ value is missing ", Heres the Body.
{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows":
[
<<start: filter("Subscriptions", true)>>
{
"Amount Owing": "<<sum([Related Overdue Invoices][Amount Remaining])>>"
}
<<end>>
]
}
What am I Missing?
Hereโs the settings im using
Solved! Go to Solution.
Yep, and I donโt know what the limit is. Youโll have to experiment.
The Edit is applied to each row individually. You need to specify the key field name and value for each row to be updated.
Like this? @Phil
"Rows":
[
<<start: filter("Subscriptions", true)>>
{
"ID" : "<<[ID]>>"
"Amount Owing": "<<sum([Related Overdue Invoices][Amount Remaining])>>"
}
<<end>>
]
Give it a try and see what happens.
Another Error Iโve been getting, 700 Rows too much?
Error:
"Unable to add/edit/delete row in table 'Subscriptions'. โ The remote server returned an error: (413) Request Entity Too Large."
Yep, and I donโt know what the limit is. Youโll have to experiment.
I would switch to GAS for such bulk updates.
Not sure it will solve your problem but worth testing those alternatives?
Instead of construct <> within a template, you create slice beforehand and select slice name when you set up webhook. Not sure the appsheet architecture, but this filtering process potentially consuming huge amount of time to select rows before changing value action is fired. Could reduce the time and api would start before TIMEOUT happens?
Within the JSON boty, user โselectorโ instead of <> <> expression. Technically this may bring no change in terms of required amount of time but worth testing it. For this feature, how to write syntax you can visit this docs. https://help.appsheet.com/en/articles/2680586-reading-records-from-a-table This selector is introduced in GET / READ the selected row out of API call, but it could be used in EDIT verb as well.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |