Connect powerapps to 3rd party RESRT

Question

Trying to connect powerapps to 3rd party REST service, this service requires an authentication token. I can do this easy enough with requests and python, but someone wants to do it in powerapps.

I need to pass this token from powerapps to the REST service something like this:

Python

headers = {"content-type": "application/json", "Authorization": "Xy454uu99blahblah"}
result_get = requests.get(url, headers=headers)

anyway to do this? I don't know a whole lot about powerapps?

Python

headers = {"content-type": "application/json", "Authorization": "Xy454uu99blahblah"}
result_get = requests.get(url, headers=headers)

score 2 · Accepted Answer · answered Aug 01 '19 at 19:50

2

You can't call 3rd party rest directly from PowerApps. You will need to use a Flow to return the data.

Here is a similar answered question Rest API calls with PowerApps

Hope this helps.

answered Aug 01 '19 at 19:50

ChrisMoncayo

36
1

score 0 · Answer 2 · answered Aug 02 '19 at 02:13

In addition to using Flow as suggested by @ChrisMoncayo, you can also use a custom connector that can be called directly from PowerApps. The linked resource has more information about creating a custom connector for your API (or feel free to post new questions if you have problems when creating one).

score 0 · Answer 3 · answered Aug 03 '19 at 06:29

Here's how I've done this type of token auth in the past using a Custom Connector and Flow:

Create a Custom Connector to your REST endpoint (NOT token server)
Create a new Flow (named finalDataCall) with PowerApps as trigger
Create an HTTP Action to call the token server using a GET method
Add a parse JSON action to get the token alone
In Flow, add your Custom Connector as an Action.
- For all parameters except the token, choose "Ask in PowerApps".
- Use the token parsed from the JSON above to pass in the token parameter
Add a Response Action in Flow to shape the response
For the OnSelect property in PowerApps (assuming user pushes a button) use:

ClearCollect(
    colFinalDataCall,
    finalDataCall.Run(
        queryParam1.Text,
        queryParam2.Text,
        queryParam3.Text,
        queryParam4.Text)
)

This will collect the response from the Flow call into PowerApps so you can manipulate the data.

Not for the faint of heart, but its been operating soundly for me for over a year now.

Here is the original forum post with pictures.

Connect powerapps to 3rd party RESRT

Python

Python

3 Answers3