MS Access Data to Zapier

[GBalcom]

Hello all!
Hope everyone is having a great Friday!! I've used access a bunch in the past to automate tasks within our office and create data bridges between our ERP and engineering software. Now our software stack will soon includes an online store, and online accounting (QB Online). Both of these can utilize Zapier, to pull data in and out of.

How can I tie this with my onsite data? :banghead: One option seems to be the use of Webhooks, (new to me). Has anyone had to do this yet? Any pitfalls/advice? Any other methods that may work besides Webhooks? All advice appreciated!

 

[theDBguy]

Hi. This is the second time I've heard of the term webhook. I looked it up and I guess it means basically a push notification to the user when the requested information is available for retrieval or use. It is different from web services, which is more common. So, in your case, you'll have to ask yourself if a webhook (push) is what you need, or do you need to pull (web services) the information you need from the online system?

 

[GBalcom]

Just wanted to give an update. I think I found a simpler way to handle this. Apparently, with Zapier, you can set it up to parse emails (you tell it the structure of your email template, then it can extract the data). I'm going to try this route, as I already know how to send an email with VBA. We'll see it if is the best route in the long run.

I don't understand the webhook thing. Seems like I'd have to host a webpage or something.

 

[isladogs]

Thought I'd heard of webhooks before when I was getting SMS and voicemail to work with Access using Twilio. Basically I think its like an API that works in both directions.
See this article https://sendgrid.com/blog/whats-webhook/