Forum Discussion

Qrew Member

3 years ago

Table Webhook Using API Runs, Does Not Add Record

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 on...

APIs and custom code

JeffPeterson1

Qrew Captain

3 years ago

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
------------------------------

Automation
Qrew Member
3 years ago
I just tried adding the double quotes to every field and I got the same results.

------------------------------
Automation
------------------------------
- JeffPeterson1
  Qrew Captain
  3 years ago
  Try it like this:
  
  {
  "to": "table-name",
  "data": [{
  "42": "[Merged Project - Source Record ID #]",
  "16": "[Additional Information]",
  "40": "[Client Contact Record ID #]",
  "44": "[Form Reference #]",
  "11": "[Date Created]",
  "35": "[Commercial Job Price]",
  "9": "[Job #]",
  "122": "[Ground Mount]"
  }]
  }
  
  ------------------------------
  Jeff Peterson
  ------------------------------