I2Rest Basic PowerApps Connector - Revision history

Alexei.baranov at 05:40, 13 July 2020

2020-07-13T05:40:50Z

Alexei.baranov at 17:56, 12 July 2020

2020-07-12T17:56:43Z

Alexei.baranov at 17:27, 12 July 2020

2020-07-12T17:27:41Z

Alexei.baranov at 17:23, 12 July 2020

2020-07-12T17:23:37Z

Alexei.baranov: Created page with "{{DISPLAYTITLE:Creating MS PowerApps connector to i2Rest Server}} This scenario shows you an example how to create PowerApps custom connector to i2Rest Server.
It assume..."

2020-07-12T17:00:14Z

Created page with "{{DISPLAYTITLE:Creating MS PowerApps connector to i2Rest Server}} This scenario shows you an example how to create PowerApps custom connector to i2Rest Server. It assume..."

New page

{{DISPLAYTITLE:Creating MS PowerApps connector to i2Rest Server}}

This scenario shows you an example how to create PowerApps custom connector to i2Rest Server. 
It assumes that you have completed the case [[Configuring_OAuth2_authorization|Configuring OAuth2 authorization]]

1. Open PowerApps Custom connector page: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 22 17.png|500px]] 

2. Press "New custom connector": 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 24 19.png|500px]] 

3. Select "Import an OpenAPI from URL": 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 25.png|500px]] 

4. Enter Connector name and URL for the Open API (<code><your_i2Rest_server>/swagger20/<mount_point></code>): 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 52.png|500px]] 

5. Press Continue: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 34 01.png|500px]] 

6. Press "Security->". Enter fields Client Id, Client secret. Copy value of Token URL and paste it to Refresh URL: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 44 17.png|500px]] 

7. Press Definition->: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 44 58.png|500px]] 

8. Press "Create connector" on top of screen, then click on "2. Security" tab: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 45 44.png|500px]] 

9. Copy value of field "Redirect URL" and paste it into the redirect_uri parameter in your i2Rest Server configuration file: 
"TSTCLNT":{"redirect_uri":"<nowiki>https://global.consent.azure-apim.net/redirect</nowiki>",
"description":"Test client",
"valid_scopes":["run_program"],
"valid_grant_types":["authorization_code"]}

10. Restart i2Rest Server to apply changed redirect_uri

11. Open "4. Test" tab :
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 46 19.png|500px]] 

12. Press "New connection": 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 46 41.png|500px]] 

13. Press "Create". It will start OAuth2 authorization code and open Login page: 
[[File:Login_V14_-_Mozilla_Firefox_12.07.2020_19_41_20.png|500px]] 

14. Enter IBM i user ID (i2Rest Server configuration file) and password and press Login: 
[[File:Login V14 - Mozilla Firefox 12.07.2020 18 48 05.png|500px]] 

15. Press "Allowed" to allow client TSTCLNT to run programs on IBM i under authority of USRX. New connection will be created: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 48 32.png|500px]] 

16. Go back to "Custom Connectors" tab: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 48 59.png|500px]] 

17. Press "Edit" (pencil icon) and go to "4. Test" tab, you'll see newly created connection in "Selected connection" field: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 49 31.png|500px]] 

18. Enter operation parameters: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 50 04.png|500px]] 

19. Press "Test operation" to call API using OAuth2 token: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 50 30.png|500px]] 

You'll see the response from i2Rest Server: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 50 30.png|500px]] 

Press "Test operation" again - server will respond with incremented <code>output.echo</code> value, job will be the same: 
[[File:Power Apps - Mozilla Firefox 12.07.2020 18 50 54.png|500px]] 

We just finished creating a new MS PowerApps Custom connector to i2Rest Server.

@@ Line 10: / Line 10: @@
 . Select "Import an OpenAPI from URL":<br/>
-[[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 25.png|500px]]<br/><br/>
+[[File:Power Apps - Mozilla Firefox 13.07.2020 8 35 41.png|500px]]<br/><br/>
 . Enter Connector name and URL for the Open API (<code><your_i2Rest_server>/swagger20/<mount_point></code>), press Import:<br/>
-[[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 52.png|500px]]<br/><br/>
+[[File:Power Apps - Mozilla Firefox 13.07.2020 8 35 45.png|500px]]<br/><br/>
 . Press Continue:<br/>
@@ Line 19: / Line 19: @@
 . Press "Security->". Enter fields Client Id, Client secret. Copy value of Token URL and paste it to Refresh URL:<br/>
-[[File:Power Apps - Mozilla Firefox 12.07.2020 18 44 17.png|500px]]<br/><br/>
+[[File:Power Apps - Mozilla Firefox 13.07.2020 8 33 07.png|500px]]<br/><br/>
 . Press Definition->:<br/>

@@ Line 41: / Line 41: @@
 [[File:Power Apps - Mozilla Firefox 12.07.2020 18 46 41.png|500px]]<br/><br/>
-. Press "Create". It will start OAuth2 authorization code and open Login page:<br/>
+. Press "Create". It will start OAuth2 authorization code flow and open Login page:<br/>
 [[File:Login_V14_-_Mozilla_Firefox_12.07.2020_19_41_20.png|500px]]<br/><br/>

@@ Line 1: / Line 1: @@
 {{DISPLAYTITLE:Creating MS Power Apps connector to i2Rest Server}}
 This scenario shows you an example how to create Power Apps custom connector to i2Rest Server.<br/>
-It assumes that you have completed the case [[Configuring_OAuth2_authorization|Configuring OAuth2 authorization]]
+It assumes that you have completed the case [[Configuring_OAuth2_authorization|Configuring OAuth2 authorization]] and [[Using_secured_connections|secured main gate with https]]
 . Open Power Apps Custom connector page:<br/>
@@ Line 12: / Line 12: @@
 [[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 25.png|500px]]<br/><br/>
-. Enter Connector name and URL for the Open API (<code><your_i2Rest_server>/swagger20/<mount_point></code>):<br/>
+. Enter Connector name and URL for the Open API (<code><your_i2Rest_server>/swagger20/<mount_point></code>), press Import:<br/>
 [[File:Power Apps - Mozilla Firefox 12.07.2020 18 32 52.png|500px]]<br/><br/>