In this article, we’ll provide a basic overview of Funnel’s webhook and how it can be used. Please see this article for technical documentation and examples.
What is it?
A webhook is a way to connect an application with Funnel to create an automated file import flow. Funnel’s webhook essentially waits to be notified that a new file is available somewhere, before fetching and importing it.
What can it be used for?
The main use case for Funnel’s webhook is to automate the ingestion of files from websites/locations that are unable to send files to Funnel via email. For example, if you have data in BigQuery, or files in cloud storage, such as Google Cloud Storage, OneDrive or Google Drive.
How to set it up?
To set up the webhook, you must send a request to a webhook URL generated by Funnel. This request needs to contain a link (or several links) to files supported by Funnel’s self-service file import connector. Please see the technical documentation for more in-depth information. A technical user, such as a developer or data engineer will usually set up the webhook, but less technical users can also experiment with Zapier.
Pros
Import data into Funnel via a fully automated flow, customized for your organization
It opens up the possibility of pre-processing the data in your own application before sending it to Funnel
Once set up, it requires very little maintenance
It utilises Funnel’s existing self-service file import connector
Cons
The webhook usually requires someone technical to set it up
If it’s possible to set up a scheduled email report, it is usually a better option as it’s easier to configure
Possible use cases (obtain data from the following locations)
Amazon Redshift (Using AWS S3 and AWS Lambda)
Microsoft OneDrive
Other cloud solutions (Using Zapier with Funnel’s webhook)