Discussions

Expand all | Collapse all

Unable to Connect to Zapier.

  • 1.  Unable to Connect to Zapier.

    Posted 02-03-2020 12:48
    I am trying to Post Data into Zapier on modification of an activity and it doesn't seem to work.

    The same webhook if pointed to a different URL (i.e. https://webhook.site/) works just fine.

    I sense that something might be blocking webhooks to zapier. I have tried deleting and recreating the zap (hence getting a new webhook ID) and the problem persists.

    Anyone else having a similar issue?

    Thanks,
    Chetan


  • 2.  RE: Unable to Connect to Zapier.

    Posted 02-03-2020 12:54
    Hello Chetan, 

    I have just recently begun using Zapier as well.  You are mentioning that you are looking for the Zap to trigger on modification of an activity.  Is this based on a record updated in Quick Base?  From what I can tell, Zapier does not have a trigger for an updated record in Quick Base, the only trigger for Quick Base to Zapier is a new record.

    ------------------------------
    Brandon Drake
    JHI Group
    Monroeville OH
    ------------------------------



  • 3.  RE: Unable to Connect to Zapier.

    Posted 02-03-2020 13:27
    Hi Brandon,

    Thanks for the reply. I have been using Zapier for a few years now. So, I am pretty familier with what goes in there.

    What I am doing is triggering a webhook whenever there is a modification to one of the records in the quick-base table(activites) and then catch that webhook on Zapier's end.

    The problem is that when the webhook is pointed to Zapier end-point, it doesn't seem to be working but when the same webhook is pointed to webhook.site or other testing material. It works just fine.

    I did opened a case with the support and will post back the resolution (if any) here.


    ------------------------------
    Chetan Madaan
    ------------------------------



  • 4.  RE: Unable to Connect to Zapier.

    Posted 02-04-2020 11:00
    It looks like the issue was with a POST request. I changed the webhook to be a a GET request and included everything as part of the URL and it worked.

    Official reply from support was:
    When Zapier receives a request it cannot parse it does nothing. This is inline with what we are seeing as well.

    I think that the issue you are having in particular is that the request body is not formatted to something that both Quick Base and Zapier know how to parse. Quick Base doesn't understand form requests so I'm not sure what is going through to Zapier. You should try using either XML or JSON and it should work, presuming there are no syntax errors. I'm afraid that writing out a request for you is a bit beyond the scope of both my role in support and my personal expertise. I can however give you all the resources I can find:

    Zapier Support: https://zapier.com/blog/updates/72/postput-xml-raw

    Quick Base Webhooks FAQ: https://help.quickbase.com/user-assistance/webhooks_support.html

    JSON Validator: https://jsonlint.com/

    QB XML Example: https://help.quickbase.com/api-guide/understandreference.html#sample_text

    Inspect HTTP requests: https://hookbin.com/

    Case Closed!

    ------------------------------
    Chetan Madaan
    ------------------------------