Skip to main content
Question

Table Webhook Using API Runs, Does Not Add Record

  • February 18, 2022
  • 0 replies
  • 31 views

I have a webhook in one of my tables that creates a new record in another app's table when it is triggered and populates it with data from the current table. I am able to get the webhook to run but once it runs, the new record is not created and there are no errors that are populated. Has anybody else face this sort of issue? I am using JSON and have posted my request body below:

{
"to": "table-name",
"data": [
{
"42": {
"value": [Merged Project - Source Record ID#]
},
"16": {
"value": "[Additional Information]"
},
"40": {
"value": [Client Contact Record ID#]
},
"44": {
"value": [Form Reference #]
},
"11": {
"value": "[Date Created]"
},
"35": {
"value": "[Commercial Job Price]"
},
"9": {
"value": "[Job #]"
},
"122": {
"value": "[Ground Mount]"
}
}
]
}



thank you in advance!

------------------------------
Automation
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Registered
  • February 18, 2022

You're missing some double quotes in your JSON.  Try this:

{
"to": "table-name",
"data": [{
"42": {
"value": "[Merged Project - Source Record ID #]"
},
"16": {
"value": "[Additional Information]"
},
"40": {
"value": "[Client Contact Record ID #]"
},
"44": {
"value": "[Form Reference #]"
},
"11": {
"value": "[Date Created]"
},
"35": {
"value": "[Commercial Job Price]"
},
"9": {
"value": "[Job #]"
},
"122": {
"value": "[Ground Mount]"
}
}]
}



------------------------------
Jeff Peterson
------------------------------