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

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

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