Forum Discussion

Automation's avatar
Automation
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 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
------------------------------

3 Replies

  • 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's avatar
      Automation
      Qrew Member
      I just tried adding the double quotes to every field and I got the same results.

      ------------------------------
      Automation
      ------------------------------
      • JeffPeterson1's avatar
        JeffPeterson1
        Qrew Captain
        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
        ------------------------------