Payload sturcture in automation calling a webhook

I’m created a custom tasak under Automation to call a webhook which the webhook is created using Google Apps Script publish as web app. I’m able to get the event object from AppSheet but the payload part which i defined with a body template seems odd when received.

Under [contents] there seems to be extra double quotes “{}” which is causing trouble when i try to get the objects inside. Are the double quotes “{}” intended for the payload POST or am I doing anything wrong?

{“postData”:{“contents”:"{ “UpdateMode”: “”, “Application”: “請假系統”, “TableName”: “Google Sheets”, “UserName”: “”, “At”: “2021/5/20 下午 01:20:40” , “Data”: { “applicant”: “xyz@gmail.com”, “leavecategory”: “annual leave”, “note”: “Applied in portal”, “startdate”: “2020/7/1”, “startperiod”: “上午 09:00:00”, “enddate”: “2020/7/1”, “endperiod”: “下午 06:00:00”, “agent”: “GCP team” } }",“length”:378,“name”:“postData”,“type”:“application/json”},“parameters”:{},“parameter”:{},“contextPath”:"",“queryString”:"",“contentLength”:378}

0 13 554
13 REPLIES 13
Top Labels in this Space