Related

Product Now Available: Managed PostgreSQL Databases Product
Can I assign a firewall while creating a droplet via API? Question Question
token url in google smart home action authantication Question Question

Question

How do I import data via webhook?

Posted October 5, 2019 363 views
APIPostgreSQL

I have a service that emails me a dataset daily. However, I would like to house all of my exported data in a single database.

My data service has an webhook export option (rather than the email option I use now). The export config settings seem straightforward. They need a webhook URL and request method (POST) and some dataset formatting options.

Is this something I can set up with a managed database with Digital Ocean?

(My use of the database is intended just for querying with Microsoft PowerBI/PowerQuery)

Add a comment
drymutters
By:
drymutters
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
jasonjpeters October 5, 2019

Yes, however you will need to have some semblance of middleware running in a droplet (or other server/machine) that would manage querying the service, consume the result, and store it in the DO Managed DB. The language you choose is your choice.

An example is recently a co-developer and I wrote a script (PHP) that from a droplet queried our CRM service via a webhook that returned a JSON object of the tasks he and I had completed during the week, formats it, and sends the data to our department manager via email. The reason we did this is for a “Bragging” email that is sent to our sales department weekly.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help