How to create an API using Workflow with webhook to access my Database?

candidosales · March 6, 2024, 9:52pm

Hi,

I would like to create a workflow that works as an API that can be accessed via trigger using a Webhook. Inside this workflow, I will return some data from my database.

I would like to know if it is possible to do this. And I have more questions:

Can the webhook handle query parameters? For example: https://retool.api.webhook?param1=true&param2=abc
Can the webhook filter which kind of HTTP verb I can provide? For example: I would like to trigger some workflow only by GET requests.

If you have any examples of creating this kind of API, I would really appreciate it!

Thanks!

Paulo · March 14, 2024, 11:31pm

Hi @candidosales, it is possible to do this!

Check out this topic. I highly recommend you to download @PeteTheHeat's Workflow, create one from this JSON on your end, and see a great example of your use case.

Let us know if you have any questions!