Hello,
I am having trouble correctly invoking the api to edit a specific row. I am able to add rows fine so my guess is there is an issue specifying the current key being edited.
When the workflow rule is triggered, I want to update the same row(s) that triggered the workflow. I tried using [_Thisrow] but that doesnโt work. any suggestions?
{
โActionโ: โEditโ,
โPropertiesโ: {
โLocaleโ: โen-USโ,
โLocationโ: โ47.623098, -122.330184โ,
โTimezoneโ: โPacific Standard Timeโ,
โRunAsUserEmailโ: "YourEmail@google.com"
},
โRowsโ: [
{
โ{Row Key}โ: โ?โ
}
] }
The easiest way to do this is to let AppSheet generate the JSON body for you.
See topic โCreating a JSON Body Template Fileโ in this article help.appsheet.com - Invoking Webhooks from a Workflow Rule or Scheduled Report
Make certain you specify the webhook URL for the webhook first as described under topic โURLโ in that article.
The generated JSON body will populate all of the fields of the record including the key fields. You must populate the key fields when doing an update. All other fields in the row are optional.
Invoking Webhooks from a Workflow Rule or Scheduled Report help.appsheet.com
@Philip_Garrett_Appsh I can get it to work but it is not a solution because it takes very long to load and is posting the same values multiple times, however, I donโt have this issue when I specify the next or previous row {_rownumber+1}.
User | Count |
---|---|
43 | |
29 | |
24 | |
22 | |
13 |