Formula Text to format JSON for webhook
I'm trying to make a JSON webhook sendinblue and for the emails to use I use a formula text that grabs all the emails related and formats them for the JSON like this [{"email":"me@example.com"}, {...
Forum Discussion
So this is all I could get from support. If anyone else wants to see JSON message as it is after the webhook fills in fields and sends it off go to uservoice and vote! I'm thinking if you want to make a formula field with JSON within it then it may be possible by adding these formats somehow but I'm not sure how to go about it
ActionWorkFlows" : [
{
"actionId" : 2,
"active" : true,
"cause" : {
"queryString" : "",
"triggerFields" : [],
"triggerOnAllFields" : true,
"typeId" : 1,
"typeName" : "OnRecordChange"
},
"description" : "",
"effect" : {
"format" : "JSON",
"headers" : {
"Content-Type" : "application/json",
"api-key" : "XXXXXXXXXX"
},
"isComplete" : true,
"template" : "{\r\n \"to\":[22],\r\n \"replyTo\": {\"email\": \"email@email.com\", \"name\": \"Chuck\"},\r\n \"templateId\":1,\r\n \"params\": {\r\n \"balance\": \"[23]\",\r\n\"last_payment_date\":\"[24]\"\r\n }\r\n}",
"typeId" : 3,
"typeName" : "DoWebHook",
"url" : "https://api.sendinblue.com/v3/smtp/email",
"verb" : "POST"
},
"label" : "Past Due Notice",
"lastRunDate" : "2019-04-09 15:08:43",
"lastRunDateMS" : 1554822523098,
"owner" : "email@email.com",
"when" : "a"