Has anyone built a Power Automate flow to pull Opportunity records from the SKY API?

Hayden Riebe

We are working on creating a Power Automate flow to pull a list of Opportunity records from the SKY API Opportunities endpoint and would like to know if anyone in the community has successfully done this. If so, would you be willing to share your flow design or any insights you learned along the way?

I recently watched a bbcon session that demonstrated building a flow to pull data from the Query API, and I was able to replicate that with my own copy flow. However, the Opportunities endpoint behaves differently from Query API, so the same approach doesn’t directly apply.

The challenge for us is that we cannot create a query or export in RE that includes Opportunity IDs, but those IDs are available through the API.

Has anyone designed a Power Automate flow specifically for the Opportunities endpoint, and if so, what approach did you take? Even high-level guidance on how to structure such a flow would be very helpful.