I have an action created (a purchase link -to a square URL for that service) to take me to a purchase page. Then nothing! I need data back!
Iโm wondering if I can invoke appsheets REST API for square Developer webhooks!
I want to send webhooks to the square developer and back then once finished to set values into my g sheets for taking payments
Solved! Go to Solution.
This is possible through appsheet now without the use of a โzapโ? Sorry Iโve done a lot of research and theyโre older videos of q&aโs nothing recent about automation besides 4-21-21
I was tempted to creating a cloud run bucket to host my own rest api lol
Appsheet can send out webhooks. It cannot receive any response from those sent-out webhooks.
Outside services can interact with Appsheet through its REST API.
Not sure what exactly your question is.
I want to send a POST (Json) webhook to square developer to take a (payment) purchase
End Goal is that,
I want square developer api (webhook) to invoke the appsheet api returning values thru (json) for any purchase made to square developer api.
Should I set up a table for the return values or have them updated to a row if it matches values from the webhook sent in best case.
Thatโs entirely up to you.
Still lost Iโm trying to Receive โpostโ webhooks from the square payments api. I entered my endpoint using appsheets api adding my app ID and table name into the required fields. Square generated a signature key. Iโm testing the endpoint I entered on the square developer site sending test events to appsheets api with a 400 response showing. Any help?
That doesnโt appear to be anywhere near a correct payload structure for Appsheetโs API.
You may have figured it out by now but if not, what you need is an intermediate (endpoint or lambda function) between Square and AppSheet that will receive the webhook from Square and invoke the AppSheet API with the correct payload.
I have not! however I am invoking the api finally!! 200 response OK!
SQUARE & APPSHEET
But I canโt get the json body to add data to my spread sheet.
I made a spreadsheet of the column values in json and created a template it looks great i copied it and tried to make a call to webhook response but Iโm lost with โcustom or appsheet apiโ and where to enter the data! Iโm just receiving http POST JSON data not requesting it
Youโve got to show us exactly what youโre doing if you need more help (screenshots!), I cannot decipher your description.
What are you showing in the first screenshot, is that some text editor? That payload template looks correct. Are you just confused that it is supposed to go in the Body field of the webhook configuration?
You seem to be attempting to send a webhook from Appsheet to Appsheet. Why are attempting to do this? That does not align with any of the rest of this thread.
Yes! Iโm frustrated I deleted everything, In the automation pane. I just need to configure the settings for the bot to get the payload in so that when square sends them automatically thru notifications I can have the payload data put into the columns of that spreadsheet. The old workflow is understanding but the automation pane is confusing.
โYesโ, what?
Iโm still confused what youโre trying to do here. Youโre showing an Appsheet API payload in one screenshot, then an un-configured webhook from Appsheet in another. Neither of which has anything to do with Square.
If I had to guess, Iโd say youโre thinking that your Appsheet webhook Bot is supposed to be receiving a webhook from Square, or something like that. That is 100% definitely not how any of this works.
Are you sending webhooks from Square (I have no experience with Square and have no idea if it supports setting up outgoing webhooks). Otherwise, as Bellave mentioned, you need to be setting up some third intermediary service To poll Square, and send to Appsheet.
You know if you really looked at what I sent you would see everything is coming from square! The notification that Iโm SENDING! FROM SQUARE IS indeed invoking the APSHEETS API that displays failed and says that the ACTION IS MISSING in DETAILS of the the first picture I showed THAT DISPLAYS THE AUDIT LOG INFO. The script in the text editor came from the AUTO GENERATED body template of the spreadsheet I have in my application WHICH APPSHEET AUTO GENERATED FOR ME WHAT ARE YOU MISSING?
Wow, ok. Good luck with that.
You can stay off the thread thank you much
Marc is doing his best to help you untangle the knots you seem to have gotten yourself into. This is truly a wonderful community that thrives because of people like him.
Nobody can help if the request is confusing or flawed to begin with.
Thank you for your comment on the thread! Iโve seen your replies all over the community you gave and give wonderful information and relative alternative resources to accommodate the trouble problems people entangle themselves into. Marc hasnโt supplied anything but questions and provided informational resources I previously looked up before I decided post on this wonderful community for help.
Something like this I was looking at a minute ago
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |