Editing rows from one app to another

[tingtingandrea]

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.

[LeventK]

@tingtingandrea

help.appsheet.com

Updating Records in a Table

How to update records using the API.

[LeventK]

@tingtingandrea
You can also refer to this post as well

JSON Template Generator: Google Sheet for Creating Webhook Templates Tips & Tricks 💡

Sometimes you have to map a LOT of columns from one table to another and create a really big JSON template. I had to do a table with over 100 columns, so I built a template generator to provide a dropdown menu of columns and add all the extra characters. [Screen Shot 2020-07-09 at 2.36.45 PM] [Screen Shot 2020-07-09 at 2.37.14 PM] Just paste in your two rows of column headers, and use the dropdown to finish generating your template. The sheet is public, but view-only. Copy the template to…

[tingtingandrea]

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]>>”
<>
},
<>
]
}

[LeventK]

@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>>
	]
}
		

[tingtingandrea]

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.

[LeventK]

@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>>
	]
}	

[tingtingandrea]

@LeventK
dam, similar error. Do I need to fill in the body? It still says that it can’t find the table:

[LeventK]

@tingtingandrea
Won’t you be placing that JSON payload inside the Body parameter already??

[tingtingandrea]

@LeventK
I have it as a file on gdrive

[LeventK]

@tingtingandrea
Are you using it as a JSON body template?

[tingtingandrea]

@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?

[tingtingandrea]

Hi @LeventK, dont mean to bug. But, I’m not sure if you saw my previous message. Thanks.

[LeventK]

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?..”

[tingtingandrea]

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.

[LeventK]

How is your webhook workflow setup? Ensure that you have selected:

[tingtingandrea]

@LeventK, What info do I need in my Body vs my Body template JSON file?

I think that’s my issue

[LeventK]

@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.

[tingtingandrea]

@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.

[LeventK]

Can you check if your Volunteer table in the second app accepts EDIT?

[tingtingandrea]

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.