Webhook Post

[Jonyskids]

I am trying to learn webhooks in Appsheets. I would like to make a http post to a third party url.

This is what I have so far:

Task Name: webhook
Table Name: table 1
Preset: Custom
url <<WebHookURL>>/add/item1/<<item1>>/item2/<<item2>>/item,3/<<item3>>/item4/<<item4>>.  (I am not sure if this is correct?)
Http Verb: Post
HTTP Content Type: json
Body:
HTTP Headers: Name: "Key"
                              Value: "9erwuewp9ufewuee"
Body Template:
Body Template Data Source:

I would like to request the following content

{
"item1": <<item1>>,
"item2": <<item2>>,
"item3": <<item3>>,
"item4": "item4",
"item5": <<item5>>
}

[jballester · Accepted solution]

Hi Jony,

My recommendation would be to consult and consult again;
1º - Appsheet Webhook Automation
2º- Know the requirements established by third party url

Most platforms that work with webhooks simply require a call through a hash webhook url. (url absolute). Along with this call, a body in json format. Nothing else.
From here, I attach a simple configuration where;

Url: Webhook hash provided to you by a third party. In the example the webhook hash url is contained in the [Webhook-Hash] field.
HTTP Verb: Post
Http Content type: JSON
Body: Leave it blank
HTTP Headers: the third party's url might require authorizations, etc. Check your requirements or, failing that, leave it blank.
Body Template: Create. Appsheet will automatically create a ready-made .json with all the fields contained in the table record. Simply review and leave those you need to transfer on the webhook. (In your first automatic json template that you make, I invite you to check the differences with the content items1,2,3... that you indicate in the post)

This would be to publish in a third-party url.
The next step that requires more learning would be to publish with custom urls based on the recipient's API. Appsheet Support WebHook automatization has examples for building urls with variables and expressions.

Good luck with learning

 

[Jonyskids]

I followed your instructions before you sent them and found success!  I am struggling to handle what I believe to be returned information.

I get a success pop up and based on the recipients API it is sending back:

{ "task_id": "e5caaac5-4a6d-4078-b2d3-b973d907b611", "status": "success", "message": ""}

I would like to update my Task ID column in my table which is "Table 1"

I switched on Return Value and did a name of task_id and type of text.

I then went to Processes and add a "Run a data action" chose Set Row Values, Set These Columns to : Task ID=[WebHook Respond].[task_id]

I hit test under the bot and then execute on Webhook and get my success popup. No update to my table. Execute on Run a data action I get success pop up. No table update. 

Am I headed down the correct path here? 

I appreciate any effort on behalf!

[Jonyskids]

Changed nothing but it is working now. (Maybe executing from Processes got it done.)

Thanks!