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

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