Connections

This section helps you set up connections required for accessing APIs from services that use connections.

To set up such a connection, you begin by creating a connection in Integration Service. The connections that you create in Integration Service are accessible within the same organization and tenant as your coded automation where you're working. You can use the connections object to access the connections you previously created in Integration Service, and then access the corresponding APIs.

After you complete the automation and publish it to Orchestrator, you have the option to override the initial connection configurations you performed in code.

Prerequisites

Create a connection in Integration Service:

Go to Integration Service and navigate to Connections.
Select Add connection, and create a connection for one of the following applications:
- Google Drive
- Gmail
- Google Sheets

Steps

Open an existing coded automation from the same organization, and tenant where you initially created your connection.
Inside the Execute() body, type connections, and then press Ctrl + Space to see the available connections.
Depending on the application for which you previously created the connection, you can choose from the following connection types:
- Drive
- Gmail
- GoogleSheets
Further configure your connection by adding the Orchestrator folder name and the desired connection address, separated by underlines.
For example, a Gmail connection for the My Workspace folder in Orchestrator, and for the [email protected] address would be written in code as: connections.Gmail.My_Workspace_john_doe_gmail_com.

Recommendation
We recommend you to create your connections in one step to avoid potential errors. We also recommend you to create a variable for the connection. This way, if changes occur in Integration Service, you'll avoid updating every instance of the connection throughout your automation. Use the following approach:
```
var myGmailConnection = connections.Gmail.My_Workspace_john_doe_gmail_com;var myGmailConnection = connections.Gmail.My_Workspace_john_doe_gmail_com;
```
Avoid creating your connections in two separate steps like:
```
var myGmailConnection = connections.Gmail;
myGmailConnection.My_Workspace_john_doe_gmail_com;var myGmailConnection = connections.Gmail;
myGmailConnection.My_Workspace_john_doe_gmail_com;
```
Once you've established the connection, you can access the relevant APIs specific to a service through that connection.
For example, if you have set up a Gmail connection as follows: var myGmailConnection = connections.Gmail.My_Workspace_john_doe_gmail.com, you can use the service's API using myGmailConnection.

Overriding the connection in Orchestrator

Publish your project to Orchestrator.
Go to the Orchestrator feed where you've published the project.
Go to the published process and select Edit.
In Process Configuration, choose the coded automation containing your configured connection as the entry point.
In Package Requirements, find and select the corresponding connection type for your coded automation.
Be careful to select the connection type for your coded automation, as connections for XAML files within your project also appear in the list.
Identify and select the account address you plan to associate with the connection when it runs.