Forum Discussion

BrandonDrake's avatar
BrandonDrake
Qrew Cadet
6 years ago

Re: Unable to Connect to Zapier.

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

2 Replies

  • ChetanMadaan's avatar
    ChetanMadaan
    Qrew Member
    6 years ago
    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
    ------------------------------
    • ChetanMadaan's avatar
      ChetanMadaan
      Qrew Member
      6 years ago
      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
      ------------------------------