Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Create custom connector that allows GET call to pull only most recent data

(0) ShareShare
ReportReport
Posted on by

Hello there:

 

I am trying to use Power Automate to set up some flows coming out of Formsite's API. I've successfully set up custom connectors by form for results, but I need to GET only the form data that has been run since the last call. Formsite has fields called "after_id" and "after_date" that can be used for this purpose, but their documentation is pretty minimal. 

 

The most likely seeming solution so far seemed to be using a polling trigger. This MS article was a good start for me, but it seems like it's doing something more complicated than what I need: Use a polling trigger for Microsoft Power Automate | Microsoft Learn

 

Seems like I have to get one of those two fields mentioned above to act as a variable and pass the date or id field from the previous call to it. I've got "?$filter last_date gt 0" as parameter on the URL, and I can see in the JSON where the needed fields to reference are (in the header), but I can't just use what would make sense to me, which would be:

 

Select the query parameter to monitor state changes: $filter

Specify the value to pass to selected query parameter: "last_date" gt "date"

Select a collection that contains trigger data: header

 

Realize I'm probably thinking about this naively, so I appreciate any pointers.

 

Thanks a bunch,

Dave

 

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics