Create a PowerApps application using Pilot-Things API

Step1 : Create PowerApps's connector

• Click on PowerApps menu called  "Data"> "Custom connector"
• Click on menu called " Create a custom connector"

• Name the connector
• Import the hereunder definition file

https://pilot-things.zendesk.com/hc/article_attachments/360008889791/Pilot-things_Connector.json

• Click on Continue to create the connector

• Click on the following boutton "Create the connector"

like on the example hereunder

Step2 : Host setup 

• Click on the tab called "General"

• Fill in the fied named "Host" with your Pilot-things's URL

like on the example hereunder

Step3 : Add a connection

• Click on the tab called "Test"

• Click on "New connection"

• Fill in the fields with your account Pilot Things login and password

• Click on "Create"
• Select the connection that you have just created

The connection is ready.

• You must save the connector.

Test : Check the connectivity between PowerApps & Pilot Things

• Go on the menu "Test"

Example using GetAlerts operation :

• Select "getAlertsUsingGET" in operation's menu

• To check if your connector is well configured, look response code (200 ok)

Use case : Create an application with PowerApps

• Select "Home" and after select "Begin an application"

1.                               2.   

• Click ok "Insert" > "Data Table"

• Click on "Add data source"

• Double click on your connector that you have just created in the Step 1

• Then, double click on your connection

• Finnally, you can close the window.

• Insert a button in the menu "Insert">"Button"
• Click on the button
• Tape this line on the button's fonction field

 Alerts is the collection's name. You can acces to this collection in the menu "Display">"Collection".

getAlertsUsingGET is the operation's name.

For more information about function "ClearCollect" consult this website :  

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

You have to add your collection to your "data source"

• Step 1 : Click on your data source to add collection
• Step 2 : Select your collection's name

• Check fields that you want to see
• To extract "data" field, add this line on the button's function field

Data field is available in the new collection called "Data_alerts".

For more information about the function "Ungroup", go on this site:  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby