Create a new post/get request when a row is added

How can we use appsheet to send a post or get request to an external service once, a new row is added?

I am trying to use a webhook post request using json but unable to do them using appsheet. Can anyone help me with a sample app or example which can help me find the fields i need to write?

This should be one of the most easiest webhook set up to integrate external service.

2 Likes

Another useful resources could be one of sample app Appsheet master placed in this portfolio.

https://www.appsheet.com/samples/How-to-add-records-from-Enumlist-with-Webhook?appGuidString=ffcd5128-f160-4948-b940-094f5d1a629c

@Aleksi

1 Like

Thanks, that was of help.
But I am getting an error while executing it:

Failed: Action not performed because 1 errors are present. Error: Failed to parse JSON due to Unexpected character encountered while parsing value: D. Path ‘Message’, line 1, position 110… Invalid JSON value starts with: Dear Home\n An Order has been placed:\n\nDesign Name: 2565\nQuantity: 18\nSizes: L , XL , XXL\nStyle.

Can you help?

Not sure what you are exactly doing with webhook, but it is obviously something wrong with your JSON syntax. Place your JSON, webhook body here.

1 Like

{
“username” : “user”,
“password” : “psw”,
“recipientIds” : “919874462242-1502182973@g.us”,
“Message” : “Dear <>\n An Order has been placed:\n\nDesign Name: <>\nQuantity: <>\nSizes: <>\nStyle: <>\nRemarks: <>\n Rate: <>\n Order is valid for 30 days”
}

What is this part?

I assume you are trying to dynamically construct the “message” body. Is there any possibility you generate those message inside the appsheet Virtual column on the same row? Probably with longtext type field. I call this VC [Message]

Then pass VC value into JSON body, which looks much simpler and easy set ups.

At the end, your JSON should be like this simple.

{
“username” : “user”,
“password” : “psw”,
“recipientIds” : “919874462242-1502182973@g.us”,
“Message” : “<<[Message]>>”
}

1 Like