Skip to main content
Community site session details

Community site session details

Session Id : C2405mG01ZH/2nhwboDYsb
Power Automate - Building Flows
Answered

Could use help with API pull request in Flow

Like (0) ShareShare
ReportReport
Posted on 17 Aug 2023 14:42:08 by 50

Im sorry if something similar is asked elsewhere, with a quick search I couldn't find the answer.

 

This could get long so I'll try to split it into a broad overview of what I'm trying to do and the specific question I have:

Broad Aim:

At my organization, we use Microsoft for pretty much everything.  I.e. Teams/Power Bi/Outlook/etc...

Previously, I've connected Power Bi to Redcap using the API, looks like this:

powerBiRedcap.png

 

Well,  my colleague and I have a public facing redcap survey setup for people in our organization to place "tickets" with us. They need tech support, etc... place a ticket.  It creates a redcap record and we can go look at it.

Separately, we also use MS Teams and it's built in tasks and planner to keep track of things we're working on.  Looks like this:

tasks.png

 

Well, I'm starting to dig into the possibility of combining the two.  Namely, if someone placed a ticket in Redcap, using the redcap API to port that over to Teams.


There's going to be a LOT of things to figure out about this, more than this question will allow, but for now I'm trying to figure out one thing.

 

My specific Question:

 

I'm struggling with the http request in MS Flow.  Here are the options:

API.png

 

 

I've no idea what to plug in where.  I see in the Redcap API playground it mentions POST here: 

redcapPOst.png

 

But not sure how I plug that in.  Any ideas or experience?



Obviously they'll be steps to do AFTER I connect such as parsing the results etc... but those would be for a different question.  For now I just want to connect.

  • JC-24071247-0 Profile Picture
    50 on 17 Aug 2023 at 15:46:09
    Re: Could use help with API pull request in Flow

    Thank you.  I'll look into it.

  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 17 Aug 2023 at 15:42:58
    Re: Could use help with API pull request in Flow

    Hi @JoeCrozier,

     

    Yes, you are correct. Unfortunately, that one is premium. 

     

    As far as I am aware there is no HTTP type of action available within Power Automate cloud flows (which is non-premium) which can connect to third-party services. 

     

    Alternatively, you could try and use a desktop flow instead. That might be an option?

     

    Power Automate desktop flows have a Invoke web service action which is non-premium: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/web

     

     

  • JC-24071247-0 Profile Picture
    50 on 17 Aug 2023 at 15:37:56
    Re: Could use help with API pull request in Flow

    Ah! Thank you.  That said, I BELIEVE the http connector you show is a premium one? (I think, im not looking right this second).  If thats the case do you know if theres a non-premium alternative?

  • Verified answer
    Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 17 Aug 2023 at 15:30:42
    Re: Could use help with API pull request in Flow

    Hi @JoeCrozier,

     

    The Send an HTTP request you are currently using is specifically for Graph API resources. In this case you want to connect with the Redcap API endpoints. In that case I would suggest to use the HTTP connector. 

     

    Have a look at this documentation:

    https://learn.microsoft.com/en-us/training/modules/http-connectors/1-introduction

     

    Can you try something like the example below (in your case you want to add more keys and values to the Queries section)

     

    redcap_api.png

     

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete