Hi everyone,
Iโm trying to get my workflow webhook to update a column for specific rows in another app table with an if statement. Iโm not sure how to write the json for this.
@tingtingandrea
You can also refer to this post as well
Hey @LeventK ,
Iโve looked over almost all the documents and I cant seem to get it to work. It keeps giving me error messages. Iโm using webhook Present: Appsheet: Edit Row
Thanks
{
โActionโ: โEditโ,
โPropertiesโ: {
โTimezoneโ: โPacific Standard Timeโ
},
โRowsโ: [
<<Start: Filter(volunteer, [email]=[_thisrow].[email])>>
{
โemailโ:"<<[email]>>"
<<If: [General Onboarded timestamp]="">>
โGeneral Onboarded timestampโ: โ<<[#ask-notion timestamp]>>โ
<>
},
<>
]
}
@tingtingandrea
Here it is:
{
"Action": "Edit",
"Properties": {
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: Filter("volunteer", [email]=[_thisrow].[email])>>
{
"email":"<<[email]>>"
"General Onboarded timestamp": "<<IFS(ISBLANK([General Onboarded timestamp]),[#ask-notion timestamp])>>"
},
<<End>>
]
}
Thanks @LeventK,
I think I missed something. Iโm getting an error message. Also Iโm realizing I dont know how to use code blocks on here:
Failed: Action not performed because 3 errors are present. Error: Workflow rule โAdd Notion 2โ action โEdit Timestampโ Body template. Expression โFilter(volunteer, [email]=[_thisrow].[email])โ is invalid due to: Unable to find table โvolunteerโ. Error: Workflow rule โAdd Notion 2โ action โEdit Timestampโ Body template. Start expression โFilter(volunteer, [email]=[_thisrow].[email])โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table. Error: The webhook body is empty.
@tingtingandrea
I believe itโs my badโฆInside the FILTER() expression, you need to wrap your tablename within quotes. So the payload shall be like this:
{
"Action": "Edit",
"Properties": {
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: Filter("volunteer", [email]=[_thisrow].[email])>>
{
"email":"<<[email]>>"
"General Onboarded timestamp": "<<IFS(ISBLANK([General Onboarded timestamp]),[#ask-notion timestamp])>>"
},
<<End>>
]
}
@LeventK
dam, similar error. Do I need to fill in the body? It still says that it canโt find the table:
@tingtingandrea
Wonโt you be placing that JSON payload inside the Body parameter already??
@LeventK
I have it as a file on gdrive
@tingtingandrea
Are you using it as a JSON body template?
@LeventK
yes I am. I did actions, that worked but for some reason edit isnt working. I did all the same things while changing the payload obviously. Is it possibly an issue where the app Iโm using the webhook in doesnt have the table, itโs a table inside another app?
Hi @LeventK, dont mean to bug. But, Iโm not sure if you saw my previous message. Thanks.
Yes @tingtingandrea I saw your post, but I havenโt understood what you exactly mean with โโฆ Is it possibly an issue where the app Iโm using the webhook in doesnt have the table, itโs a table inside another app?..โ
Hi @LeventK I have 2 apps. The 1st app has the table โVolunteerโ, the 2nd app which Iโm using the webhook in, does not have the table โVolunteerโ. I want to trigger edit for โVolunteerโ in 1st app from the 2nd app.
How is your webhook workflow setup? Ensure that you have selected:
@LeventK, What info do I need in my Body vs my Body template JSON file?
I think thatโs my issue
@tingtingandrea
You either use the Body or Body Template, you canโt use both. Try with Body only first and then re-try with using the template only. Also please ensure that both of the apps are under the exact same appsheet account.
@LeventK I tried both body and body template and neither worked. It still gave me the error, cannot find table โVolunteerโ. The rest of the webhook setup is as you have labeled in the previous image. Iโm not sure what Iโm doing wrong at this point. They are both the same account as well.
Can you check if your Volunteer table in the second app accepts EDIT?
Hi @LeventK, yes it is editable. Iโm able to run actions on the same table. Itโs only the edit action that doesnt work.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |