Power Platform Community Forum Thread Details

I am a newbie doing some research. From my understanding, if we have a third-party company owns a database and they have given me a subscription key to the API, I think i need to create a webhook first. This webhook should be able to "scan"/"Monitor" the third-party API and check for records that have been created/edited/modified in any way, and trigger my power automate flow, where the flow contains the data of the record that caused the trigger. - even if it's simply been removed, I need the data of the removed record. So I can know exactly which record to remove from my SQL database.

Basically, CompanyA has their database, and given me a subscription to their API. Whenever they change/modify a record, I need that to be updated in my SQL Server Database for MY company to consume/use.

To mark my solution as accepted, please help me answer these questions:

1) Is the above paragraph an accurate statement. Am I missing any "steps"? Or should I be going about this completely differently?
2) If a webhook is required, Can you please provide documentation towards creating a webhook with the intention of triggering a power automate flow.
3) if a webhook is NOT required, how do I go about creating a custom Power Automate trigger for a third-party API?
The only other option i see is a timed power autmate flow that will run every say... 5 minutes, query the api, and store the needed records. 5 minute later, when the flow runs again, it will pull the newly queried records. Then it will compare those pulled records to the contained records, and IF there is an update, it will make the update in my SQL, and if not, it gets ignored. But this solution sounds very "heavy", a whole LOT of actions/day, I will most certainly exceed daily limitations AND this uses a premium connector already. (I think?) just sounds.... excessive/expensive

Categories:

Building flows

Hello ,

I understand you are looking into how to use the Power Automate HTTP Webhook connector.

Here is a link to a video that can help with the webhook connector. It’s a YouTube video that explains how the connector works (about four and a half minutes in you’ll see an example for recommended use of the webhook connector).
https://www.youtube.com/watch?v=muNvUbWgFaU

You can also create custom connectors as well.
https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank

If you already have a purchased Power Automate Per User license you should be ok to use either option.

I hope this helps 😊

Regards,

Kristie

Community Support Team

If this post helps, then please click on the "Accept it as the solution" to help the other members find it more quickly.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs