Connected Systems

Introduction

This article provides details of the various types of connected systems. Each connected system is custom for the service it connects to, and it will tailor fit integrations that use this connected system with fields specific to that third party system.

Common Properties

Each connected system has the following properties:

Field Description
Name The name of the connected system. Use a name that will uniquely identify this connection to the external system.
Description Supplemental information about the connected system that is displayed when selecting the system in the integration designer and in the application contents grid.

OpenAPI

Designers can use OpenAPI documents to generate a connected system that can inherit base URLs, authentication details, and a list of operations. Then, using that connected system, the designer can create integrations for those operations. Appian will automatically generate an expression for the URL with rule inputs for any path parameters. It will also generate required headers and query parameters.

In addition to the common properties, an OpenAPI connected system has the following properties:

Field Description
System Logo An image document used to visually represent the external system or service being connected to. The logo is displayed in the integration designer and in the process modeler on integrations that connect to this system (using the Call Integration Smart Service). If no document is selected a default logo will be used instead.
OpenAPI/Swagger Document An OpenAPI documents (formerly known as a Swagger document) defines a standard interface to a RESTful API. They can be read by a human or computer to understand the capabilities of a web service without access to source code/documentation. By uploading these to your connected system, Appian can inherit base URLs, authentication details, and a list of operations.
Base URL A consistent prefix for the URLs of this connected system's integrations. This value supports environment specific configuration for variation across environments. This value can be selected from the list of base URLs that are inherited from the attached OpenAPI document.
Authentication The type of authentication that integrations leveraging this connected system will use. For authentication options, see connected system authentication.

Amazon Machine Learning

NOTE: Amazon ML is no longer available to new Amazon customers

Easily connect to Amazon Web Services Machine Learning models to make predictions based on your data. Pick from available models and quickly map your data to build smarter applications for fraud detection, demand forecasting, targeted marketing, and more.

See Amazon documentation on requesting real time predictions.

In addition to the common properties, an Amazon Machine Learning connected system has the following properties:

Field Description
Access Key Id Amazon uses a custom authentication schema that requires a special signing of the request using an access key, secret access key, and region. The access key id, along with an associated secret access key and region, are used to access Amazon services. Your access key id is the first piece of a set of programmatic credentials that can be generated for Amazon Identity and Access Management (IAM) user accounts.
Secret Access Key Your secret access key is the second piece of a set of programmatic credentials that can be generated for Amazon IAM user accounts.
Region Your region is the third piece of a set of programmatic credentials that can be generated for Amazon IAM user accounts.
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details.

Operation

Name Description Type
Run a Prediction Run a prediction on an existing Amazon Machine Learning model READ

aml_integration.png

Blue Prism

Blue Prism Robotic Process Automation (RPA) Connected System provides an easy way to integrate software robots into your business process, and eliminate repetitive and error-prone tasks that people perform. Automatic discovery of the available Blue Prism processes and their data inputs makes it quick and easy to set up.

See Blue Prism documentation on exposing and calling web services.

In addition to the common properties, an Blue Prism connected system has the following properties:

Field Description
Username Blue Prism account used to execute the Blue Prism process or object
Password Blue Prism account used to execute the Blue Prism process or object
Host URL The Host URL for your Blue Prism instance
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details. Host URL will be validated by testing the connection. Username and Password are per process and will be validated when executing a process or object

Operations

Name Description Type
Execute Blue Prism Process Calls a Blue Prism Process that was exposed as a web service WRITE
Execute Blue Prism Business Object Calls an action defined in a Blue Prism business object WRITE

Execute Blue Prism Process

Calls a Blue Prism Process that was exposed as a web service

bp_integration_process.png

Execute Blue Prism Business Object

Calls an action defined in a Blue Prism business object

bp_integration_business_object.png

Notes

  • Blue Prism is a WRITE type Integration. For this reason, the Integration must be called as a smart service.
  • Encrypted fields in Blue Prism are exposed in WSDLs as text values. Therefore, we are not able to identify if a Blue Prism field is marked as encrypted or not. We will show those fields as text fields if they are present.
  • Date/Time/DateTime fields will appear as text fields with placeholder text on how to properly format the input
  • If your Blue Prism process or object has nested collections, the designer can simply enter a dictionary representing the collection row and Appian will properly format the request. ={row:{textInput:"abc", numberInput: 3.14}}
  • Asynchronous and long running Blue Prism processes are not supported
  • Please also see the Appian Skill for information on how to call Appian from Blue Prism.

Microsoft Azure LUIS

Easily connect to Microsoft Azure Language Understanding (LUIS) machine learning models to understand what your users want in their own words. Integrations using this connected system will allow you to provide a user's input and LUIS will extract the intent and associated entities represented by the text.

See Microsoft documentation on getting predictions from an endpoint.

In addition to the common properties, a Microsoft Azure LUIS connected system has the following properties:

Field Description
Subscription Key Subscription keys can been found in your Azure portal or in the “Publish” tab of the LUIS application. In the “Publish” tab, any key that is NOT labeled “Starter_Key” is a subscription key.
Subscription Key Region Region for LUIS Endpoint API. The region in which you publish your LUIS app corresponds to the region or location you specify in the Azure portal when you create an Azure LUIS endpoint key. When you publish an app, LUIS automatically generates an endpoint URL for the region associated with the key.
Starter Key This key can be found in the “Publish” tab of the LUIS portal for any of your LUIS apps and is called “Starter_Key”. This key is also referred to as the “Programmatic Key” in the Microsoft documentation.
Starter Key Region Region for LUIS Programmatic API. The authoring region app can only be published to a corresponding publish region.
Bing Spell Check Subscription Key Specifying this value allows you to run spell check on query text before sending it through the model. You can create a Bing Spell Check key in your Azure portal.
Use Staging? When checked, Appian will query your staging model. Use this feature to validate changes to your model. You should always uncheck this box in production using import customization.
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details.

Operation

Name Description Type
Get Predictions from Endpoint Predict the intent and associated entities using an existing model READ

luis_integration.png

Google Cloud Natural Language

Easily connect to Google Cloud Natural Language machine learning models. Extract structure and information from text, including both sentiment and key subjects such as people, places, and events. Integrations using this connected system will allow you to provide a text value and select which types of information to analyze.

See Google documentation on text analysis.

This is part of the Appian AI offering. You can request credentials and start using this service free of charge. Please see Appian AI for more details.

In addition to the common properties, a Google Cloud Natural Language connected system has the following properties:

Field Description
API Key Google API keys can be generated from Google’s cloud console. Be sure to restrict the API key to Google Natural Language.
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details.

Operation

Name Description Type
Run Analysis Run analysis on provided text READ

gcnl_integration.png

Google Cloud Vision

Easily connect to Google Cloud Vision machine learning models. Extract structure and information from images, including logos, landmarks, and text (Optical Character Recognition). Provide an image and select different dimensions to analyze.

See Google documentation on image detection and annotation.

This is part of the Appian AI offering. You can request credentials and start using this service free of charge. Please see Appian AI for more details.

In addition to the common properties, a Google Cloud Vision connected system has the following properties:

Field Description
API Key Google API keys can be generated from Google’s cloud console. Be sure to restrict the API key to Google Cloud Vision.
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details.

Operation

Name Description Type
Run Analysis Run analysis on provided image READ

gcv_integration.png

Notes

  • This connected system does not currently support the asyncBatchAnnotate function, which means we do not support PDF/TIFF files with the services we are leveraging (Google has noted this limitation in their API documentation).

Salesforce

Manage your customer information and interactions. Find, update, create, or delete records within your Salesforce instance.

Two connected systems are available for Salesforce. Each has a different form of authentication available.

Connected System Description Salesforce Documentation
Web Server OAuth Each Appian user will be required to login to their Salesforce account to authenticate Salesforce Web Server OAuth Authentication Flow
Username-Password OAuth All integrations will use a shared Salesforce username and password. Individual Appian users do not need their own Salesforce accounts. Salesforce Username-Password OAuth Authentication Flow

Both Salesforce connected systems have the same operations available; however, any integration created under one connected system cannot be migrated to the other. For example, if you create a SOQL Query integration under Web Server connected system, you cannot change it to use a Username-Password connected system. To resolve, you would recreate the integration from the Username-Password connected system.

Web Server OAuth Connected System

Each Appian user will be required to login to their Salesforce account to authenticate. You must provide users a way to authenticate using OAuth 2.0.

Please see Salesforce Web Server OAuth documentation for more details.

In addition to the common properties, a Salesforce (Web Server OAuth) connected system has the following properties:

Field Description
Redirect URL Each connected system provides a callback URL that must be added to your Salesforce environment. In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “Edit”. Add the callback URL in the field "Callback URL". See Salesforce set up documentation for more details.
Instance URL Instance URL will be used for authorization. This URL is used to configure your integration object and when executing your operations. e.g. https://na59.salesforce.com
Client Id In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “View”. The Client Id will be listed on this page as “Consumer Key”. See Salesforce set up documentation for more details.
Client Secret In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “View”. The Client Secret will be listed on this page as “Consumer Secret”. See Salesforce set up documentation for more details.
Scopes In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “View”. The scopes will be listed on this page as “Selected OAuth Scopes”. This connected system requires API and refresh token access. You must provide API access using either the api or full scope. Please see Salesforce scope documentation for more details.
Authorize Uses the provided configuration information to authorize the designer in a new window. See OAuth 2.0: Authorization Code Grant for more details.

sf_web_server_connected_system.png

Operations

Name Description Type
Create SObject Adds a new business object to Salesforce WRITE
Update SObject Updates data for an existing business object in Salesforce WRITE
Delete SObject Removes a business object from Salesforce WRITE
SOQL Query Allows querying a Salesforce instance using the Salesforce Object Query Language (SOQL) READ
SOSL Search Allows searching a Salesforce instance using the Salesforce Object Search Language (SOSL) READ
Describe SObject Provides introspection into the metadata of the given Salesforce objects READ
Describe All SObjects Provides introspection into the objects available in the target Salesforce instance READ

Username-Password OAuth Connected System

Provide a single Salesforce user’s credentials to authenticate. All integrations will use a shared Salesforce username and password. Individual Appian users do not need their own Salesforce accounts.

Please see Salesforce Username-Password OAuth documentation for more details.

In addition to the common properties, a Salesforce (Username-Password OAuth) connected system has the following properties:

Field Description
Instance URL Instance URL will be used for authorization. This URL is used to configure your integration object and when executing your operations. e.g. https://na59.salesforce.com
Client Id In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “View”. The Client Id will be listed on this page as “Consumer Key”. See Salesforce set up documentation for more details.
Client Secret In the Salesforce Setup portal, navigate to “App Manager”, and then find your App and select “View”. The Client Secret will be listed on this page as “Consumer Secret”. See Salesforce set up documentation for more details.
Username The username used to sign into the provided Salesforce instance
Password The password used to sign into the provided Salesforce instance
Security Token This is an automatically-generated user security token from Salesforce. In the Salesforce personal settings for the user, select “Reset My Security Token” to generate a new security token. When authorizing, this security token will be appended to the password. Please see Salesforce security token documentation for more details.
Test Connection Uses the provided configuration information to connect to the target system. Returns success or error with details.

sf_username_password_connected_system.png

Operations

Name Description Type
Create SObject Adds a new business object to Salesforce WRITE
Update SObject Updates data for an existing business object in Salesforce WRITE
Delete SObject Removes a business object from Salesforce WRITE
SOQL Query Allows querying a Salesforce instance using the Salesforce Object Query Language (SOQL) READ
SOSL Search Allows searching a Salesforce instance using the Salesforce Object Search Language (SOSL) READ
Describe SObject Provides introspection into the metadata of the given Salesforce objects READ
Describe All SObjects Provides introspection into the objects available in the target Salesforce instance READ

Operations

Create SObject

Adds a new business object to Salesforce

Note: Create SObject is a WRITE type Integration. For this reason, the Integration must be called as a smart service.

sf_integration_create_sobject.png

Update SObject

Updates data for an existing business object in Salesforce

Note: Update SObject is a WRITE type Integration. For this reason, the Integration must be called as a smart service.

sf_integration_update_sobject.png

Delete SObject

Removes a business object from Salesforce

Note: Delete SObject is a WRITE type Integration. For this reason, the Integration must be called as a smart service.

sf_integration_delete_sobject.png

SOQL Query

Allows querying a Salesforce instance using the Salesforce Object Query Language (SOQL)

sf_integration_soql_query.png

Allows searching a Salesforce instance using the Salesforce Object Search Language (SOSL)

sf_integration_sosl_search.png

Describe SObject

Provides introspection into the metadata of the given Salesforce objects

sf_integration_describe_sobject.png

Describe All SObjects

Provides introspection into the objects available in the target Salesforce instance

sf_integration_describe_all_objects.png

FEEDBACK