Thanks for answering guys.
Apologies if i seem terse, but neither the labels nor the duplication are not the problem.
To briefly explain, my app records metadata of photos our community takes daily. The reason why the “FEED” has a lot of the same entries is because our community often takes photos in similar locations. So the recurring entries are warranted.
Af far as keys and labels, I am using ref columns. The “LOCALE” sheet has a “ID KEY” which the “FEED” sheet is referencing in each record. Updating the name of the ref column in the app works fine.
The problem is that the “FEED” and “LOCATION” sheet also has a “Location Label” column that records that actual location name the ref column is referencing in the spreadsheet. This lets me read the location label of the “Location” Ref column when viewing the spreadsheet (as the the recorded “LOCALE ID” key column is gibberish).
My questions is based on updating the “Location Label” column in the spreadsheet.
All that said
I have been trying for hours to write a simple webhook script that will update the “Location Label” values in the “FEED” Table when i update the corresponding “Location Label” values in the “LOCATIONS” Table.
But i’ve can’t figure it out. The templates I’ve created do not launch, and every modification I make produces a new error.
This is best i could come up with
{
“Action”: “Edit”,
“Rows”: [
<<Start: SELECT(The Feed_Raw[KEY ID (input sheet)], AND(
IN([AREAS COUNTIES KEY ID],The Locale_Numbers[LOCALE KEY ID]),
NOT(IN([Areas & Counties],The Locale_Numbers[Locale Entries]))
))>>
{ “AREAS COUNTIES KEY ID”: " <<[LOCALE KEY ID]>>"
“Areas & Counties”: “<<[Areas & Counties]>>”
},
<>
]
}
The script (I think) says "when a edit happens in the “LOCALE” table, look for all the rows in the “FEED” table. If a there’s a name in the FEED’s “Area” column that is not in the LOCATION’s “Locale Entry” column, update the “Area” name in the FEED table.
I get a the following error
“Webhook HTTP post request failed with exception {“Message”:“REST API invoke request failed: The HTTP Body which should contain the API Action, Properties, and Row data is missing.”} The remote server returned an error: (400) Bad Request.”
If someone could refer to a sample app that demonstrates the webhook feature (or create an example script for me), that would help a great deal. Please just dont refer me to the webhook pages on the Appsheet site. I’ve already checked those out and I’m still confused because the examples are different than the actual webhook interface.
