Integrate Microsoft Power Apps with Rampiva Automate (API)

Owned by Daniel Boteanu (Unlicensed)
Last updated: Nov 17, 2023
5 min read

The material in this document is for informational purposes only. The products it describes are subject to change without prior notice, due to the manufacturer’s continuous development program. Rampiva makes no representations or warranties with respect to this document or with respect to the products described herein. Rampiva shall not be liable for any damages, losses, costs or expenses, direct, indirect or incidental, consequential or special, arising out of, or related to the use of this material or the products described herein.

Introduction

This article describes how to submit a Rampiva Automate job from Microsoft Flow using the API.

As an example, we will submit a job when a response is submitted in a Microsoft Form.

When creating a Flow that performs other tasks, it can be useful to first manually perform the tasks in the Rampiva Automate web interface and to monitor the endpoints called and the responses received in the browser network tab. Additionally, the Rampiva API documentation is available at http://localhost/openapi, where localhost is the server where Automate is installed.

 

This article is part of a series:

Prerequisites 

Instructions

A. Create a Form to Capture the Job Requests

1

Open Microsoft Forms at https://www.office.com/launch/forms

2

Select New Form.

3

Name the form Rampiva Job Submitter.

This form will be used as a trigger. Whenever a response is submitted, a Flow will connect to Rampiva Automate and submit a job with the Job Name and Source Data parameters defined in this form. The fields we will use in the table in this guide are an example, and can be adjusted to correspond to the required parameters of the Rampiva workflow used.

4

Add a field named Job Name of type Text.

5

Add a field naed Source Data of type Text.

6

Click Share and copy the link to the form, for use later in this guide.

B. Create the Power Apps Flow

1

Open Microsoft Power Apps at https://make.powerapps.com/

2

Select the Flows tab.

3

Create a New flow of the type Automated cloud flow.

4

Name the flow Submit Rampiva Job.

 

5

Select the flow trigger When a new response is submitted, from the Microsoft Forms app.

6

In the Form Id field, select the form previously created.

7

Add a New step with the action Get response details, from the Microsoft Forms app.

This step will be used to parse the response of the form and make the fields accessible to other steps in the flow.

 

 

8

In the Form Id field, select the form previously created.

9

In the Response Id field, select the Reponse Id object from the Dynamic content section.

10

Add a New step with the action HTTP, from the HTTP app.

 

11

Set the Method to POST.

12

Set the URL to:

https://automate.rampiva.com/api/v1/scheduler/jobs
13

Type in the header key:

Authorization
14

Type in the header value corresponding to the API Key authentication header, for example

Bearer 265fa20a-ba69-47a0-aab5-034fba50e062:fzMQKFhuOb63ydsOFmJJtExe6mttWFSr
15

Set the Body to:

16

Replace the text TODO Job Nameand TODO Job Name with the field Job Name and Source Location from the Dynamic content section, from the Get response details step.

17

Click Save in the top-right section of the screen to save the flow.

 

C. Test the Flow

1

Open the link to the form previously created.

 

 

2

Fill out the form with a sample Job Name and Source Location and Submit.

 

3

Return to Power Apps, to the Flows tab and select the Submit Rampiva Job application.

4

Open Rampiva Automate.

D. Troubleshooting

1

If a job is not created in Rampiva Automate, open the flow run history event and inspect the input and output body of the HTTP operation for anomalies or errors.