Integrating with Microsoft Flow
Microsoft offers an integration platform called Flow.
The building blocks are basically triggers and actions. Applications are called Connectors here.
Make sure to watch the introductory film to get a good idea of how the platform works.
Getting started
To start a flow where i-Reserve plays a role, a custom connector must first be created.
To do this, the Microsoft API must be called in i-Reserve and the file that is generated from it must be saved.
A custom connector can then be created by importing this file (importing via the URL call works by default not).
In principle, nothing needs to be adjusted to the definition.
However, an Oauth 2.0 connection must be made.
After this, it is possible to create flows and set up a connection.
The steps in a row:
- Open the page <your domain>/api/rest/microsoft/swagger
- Save the content in a text file and name it, for example, "swagger.json"
- Open Power Automate and go to "Custom connector"
- Click on "Import an OpenApi file"
- Select the file "swagger.json"
- Open the configuration i-Reserve and go to System > Oauth clients
- Create a new client and give it a logical ID and a secure key (via a password generator)
- Go to PowerAutomate with these details and fill in the fields "Client ID", "Client secret" and "Refresh URL" The latter is a copy of the "Token URL"
- Open the i-Reserve configuration and go to System > Users
- Create a connection user with the correct rights
- Log out with your current user from the management panel.
This is not a mandatory step. But in the next step the user with which you are already logged in is selected. To prevent this, you must first log out, and only log in when selecting the account. - Go to test and make a connection. For this, the user from the previous step must be used.
This connection can now be used when creating automations.