Disclaimer
Your use of this download is governed by Stonebranch’s Terms of Use, which are available at Stonebranch Integration Hub - Terms of Use.
Overview
A Web service is a method of communication between two electronic devices over a network.
This Universal Extension provides the capability to call endpoints of foreign APIs. It is beneficial for Stonebranch SaaS customers that are accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their datacenter. As the integration is triggered from the Universal Agent, no additional firewall port for the Universal Agent needs to be opened.
Version Information
Template Name | Extension Name | Extension Version |
---|---|---|
Web Service Integration | ue-webservice | 1.2.1 |
Software Requirements
This integration requires a Universal Agent and a Python runtime to execute the Universal Task.
Software Requirements for Universal Template and Universal Task
Requires Python 3.7.0 or higher. Tested with the Universal Agent bundled Python distribution.
Software Requirements for Universal Agent
Both Windows and Linux agents are supported.
Universal Agent for Windows x64 Version 7.1.0.0 and later.
Universal Agent for Linux Version 7.1.0.0 and later.
Software Requirements for Universal Controller
Universal Controller Version 7.1.0.0 and later.
Key Features
This Universal Extension provides the following key features.
Support for communicating with APIs using the HTTP(S)/REST protocol.
Support for Authorization towards the foreign API using Basic Authentication or access token.
Support for HTTP Methods GET, POST, PUT, DELETE, PATCH.
Support for SSL Protocol.
Ability to use proxy between Universal Agent and target web service.
Ability for configuration of custom exit codes based on the web service response payload (Supported for JSON payloads).
Import the Universal Template
To use this downloadable Universal Template, you first must perform the following steps.
- This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true.
- To import the Universal Template into your Controller, follow the instructions here.
- When the files have been imported successfully, refresh the Universal Templates list; the Universal Template will appear on the list.
Configure Universal Task
For a new Universal Task, create a new task, and enter the required input fields.
Input Fields
The input fields for this Universal Extension are described in the following table.
Field | Input type | Default value | Type | Description |
---|---|---|---|---|
Protocol | Required | HTTP(S)/REST | Choice | The communication protocol to be used towards the foreign API. |
HTTP Version | Required | 1.1 | Choice | The Hypertext Transfer Protocol version. |
Authorization Type | Required | Basic | Choice | The authorization type to be used for communicating with the foreign API. The following options are available.
|
Credentials | Optional | - | Credentials | Credentials for "Basic" Authorization Type. The Credentials definition should be as follows.
Required when Authorization Type is "Basic". |
Token | Optional | - | Large Text | The authentication access token. Required when Authorization Type is "Token". |
Add Authorization Data To | Optional | Request Header | Choice | Specifies where to include the Token in the request. The following options are available.
Required when Authorization Type is "Token". |
Authorization Header Prefix | Optional | Bearer | Text | The prefix for the Token. The token value is appended to the Authorization Header Prefixin the request Authorization header. For example: Bearer <token_value>. Required when Add Authorization Data To is "Request Header". |
URL | Required | - | Text | The URL to be called. |
HTTP Method | Required | GET | Choice | The HTTP method to be used in the request. The following options are available.
|
Timeout | Optional | - | Integer | The time (in seconds) that the request will wait for the server to send data before closing the connection. If Timeout is not filled, the request will wait (hang) until the connection is closed. |
URL Query Parameters | Optional | - | Array | The list of parameters key/value pairs to be sent in the query string for the request. |
Payload Type | Optional | Raw | Choice | The type of data to be sent in the request body. The following options are available.
Required when HTTP Method is "POST", "PUT" or "PATCH". |
Payload Source | Optional | Form | Choice | For Payload Type of value "Raw", it specifies how the payload will be provided. The following options are available.
Required when Payload Type is "Raw". |
MIME Type | Optional | application/json | Choice | The MIME type to be used in the request's header. The following options are available.
Required when Payload Type is "Raw". |
Other Value For MIME Type | Optional | - | Text | The MIME type to be included in request's header in case "Other" is selected as MIME Type value. Required when MIME Type is "Other". |
Form Data | Optional | - | Array | The list of parameters key/value pairs to be sent in the request body. The request header will include ""x-www-form-urlencoded" as a "Content-Type" in this case. |
Payload | Optional | - | Large Text | The payload to be sent in the request body. Required when Payload Source is "Form". |
Payload Script | Optional | - | Script | The script to be used as a payload source. Required when Payload Source is "Script". |
HTTP Headers | Optional | - | Array | The list of HTTP Headers key/value pairs to be sent with the request. If "Content-Type" header is provided, it will be disregarded by the extension, as the MIME Type field is used for this purpose. |
Proxies | Optional | - | Text | The proxy servers to be used, in the format of values separated by comma. For example: http://ip1:port1,ftp://ip2:port2 |
SSL Options | Required | False | Boolean | Displays the available SSL options. |
SSL Certificate Verification | Optional | True | Boolean | Enables certificate verification. Certificate verification is auto-enabled in case field "CA Bundle Path" field is populated. Required when SSL Options is checked. |
CA Bundle Path | Optional | - | Text | Path and file name of the Certificate Authority bundle to use in certificate verification. The file should be in PEM format. |
Client Private Key Path | Optional | - | Text | Path and file name of the private key file for SSL client side authentication. The file must be in PEM format. |
Client Certificate Path | Optional | - | Text | Path and file name of the public key certificate for SSL client side authentication. The file must be in PEM format. |
Print Result Body To
| Optional | STDOUT | Choice | Specifies where to print the web service output payload. The following options are applicable.
|
Process Exit Code Mapping
| Required | False | Boolean | Flag that determines whether exit code mapping is enabled or not. |
Path Expression
| Optional | - | Choice | Field visible only when Process Exit Code Mapping is checked and it is required when visible. The JSON path that is used to check the provided patterns that are set-up on the Response Exit Code Mapping array. |
Response Exit Code Mapping
| Optional | - | Array | Field visible only when Process Exit Code Mapping is checked and it is required when visible. Array that maps regular expression patterns to exit codes. Provided exit codes should be in the range [100-255]. |
SSL Certificate Authority File Discovery
This Universal Extension is bundled with certifi library, utilized as the default certificate discovery mechanism. However, more complex SSL verification scenarios are supported, according to the configured fields as described below.
Server SSL verification by default CA
Certifi provides a wide range of certificates signed by well-known Certificate Authorities, used for SSL Server verification.
Related Universal Task fields:
- SSL Options: enabled
- SSL Certificate Verification: enabled
Server SSL verification by custom CA
For SSL Server verification against hosts that have certificates signed by a custom Certificate Authority, certificates bundled with_certifi_ library shall not be enough. In such cases, the custom certificate should be provided as input.
Related Universal Task fields:
- SSL Options: enabled
- SSL Certificate Verification: enabled
- CA Bundle Path: populated
Server and Client SSL verification
Additional security layer can be achieved with two-way SSL verification, where both the Server is verified by the Client, and the Client is verified by the Server. This scenario is common for hosts with self-signed certificate, however it can be used to any SSL Client verification.
Related Universal Task fields:
- SSL Options: enabled
- SSL Certificate Verification: enabled
- CA Bundle Path: populated
- Client Certificate Path: populated
- Client Private Key Path: populated
For HTTPS provided URL and disabled SSL Options, the established connection will still be secured over SSL protocol, however no certificates will be taken into consideration.
Exit Code Mapping
As part of task configuration, it is possible for the user to define custom exit codes that depend on the contents of web service response body.
This might be useful in the following cases:
When the task is used in a workflow and based on the contents of the web service response body the workflow needs to follow a different path. Exit codes can be used in workflows to follow different branches.
When retry needs to be configured, based on the content of the web service response body. Task retry can be configured based on exit code.
For example, a user can configure the Universal Controller task to retry execution when Exit code is X. Exit code X can be configured by the user when web service response payload field JSON "document.status" is equal to value "Under Processing".
The fields related to this functionality are the following.
Process Exit Code Mapping
Should be checked to enable this functionality.Path Expression
The JSONPath expression (JSONPath Syntax).Response Exit Code Mapping
A list of pairs (Pattern/Exit Code). If pattern provided as python regular expression is matched, then the configured Exit Code will be applied.
The web service output JSON body is parsed with the Path Expression. The matched response body content, is evaluated against the list of patterns provided on Response Exit code Mapping array. When a pattern is matched, the extension will return the respective Exit Code.
The following features and restrictions are applied.
It is possible to provide multiple pairs of Pattern/Exit Code. The extension will return the corresponding Exit Code, on the first match in the array.
Provide
.*
as a pattern, to match any value returned by the JSONPath.Provided exit codes should be between 100 and 255.
An error will be raised in case:
No match found.
Wrong Path Expression is provided.
The result body is not of type JSON.
The custom exit codes that intent to be considered successful, they have to be configured during appropriately in the Result Processing Details section.
Exit Code Processing
Option "Success Exit Code Range" to be selected in this field.Exit Codes
To be filled with the list of exit codes that the user expects to result success task (Ranges can be provided. For example: 0,100-255).
Task Examples
No Authorization Task Configuration
Example of Universal Task for "None" Authorization Type.
Basic Authorization Task Configuration
Example of Universal Task for "Basic" Authorization Type.
Token Authorization Task Configuration
Example of Universal Task for "Token" Authorization Type.
An access token can be saved also as a Credential Token field and retrieved with the respective built-in UAC Function.
Task Configuration for SSL Protocol
Example of Universal Task for SSL Options checked.
Task Configuration for POST request with JSON payload and use of proxy server
Example of Universal Task for SSL Options checked.
Printing Result Body to STDOUT
Example showing the result body of the web service printed to STDOUT.
Response Code Output Field
Example showing the value of the output field "Response Code" filled with the actual response code from web service result.
Task Configuration for Exit Code Mapping Scenario
The following example scenario describes the configuration of a task where the user expects an exit code equal to "150" if the employee is "Tiger Nixon".
- Task inputs for Web Service Integration Details.
- Task Inputs for Result Processing Details:
Here the Exit Codes field is filled with two elements, "0" and the range [100-255] where the expected exit code ("150") falls in.
- Task Results:
Task Output
Output Only Fields
Field | Type | Description |
---|---|---|
Response Code | Text | The web service response code. |
Exit Codes
The exit codes for this Universal Extension are described in the following table.
Exit Code | Status Classification Code | Status Classification Description | Status Description |
---|---|---|---|
0 | SUCCESS | Successful Execution | SUCCESS: Task executed successfully <Additional information>. |
1 | FAIL | Failed Execution | FAIL: <Unexpected error description> |
3 | AUTHORIZATION_ERROR | Insufficient Permissions | AUTHORIZATION_ERROR: The authorization credentials provided for the request are invalid. |
21 | FOREIGN_API_REQUEST_ERROR | Bad request to third party API | FOREIGN_API_REQUEST_ERROR: Client side error when sending the request. |
22 | FOREIGN_API_RESPONSE_ERROR | Validation error response from third party API | FOREIGN_API_RESPONSE_ERROR: Server side error. |
23 | FOREIGN_SERVER_ERROR | Destination URL not found or redirected | FOREIGN_SERVER_ERROR: Not Found |
24 | EXIT_CODE_MAPPING_ERROR | Error occurred during Exit Code Mapping | EXIT_CODE_MAPPING_ERROR: Invalid Path Expression |
Extension Output
In the context of a workflow, subsequent tasks can rely on the information provided by this integration as Extension Output.
result
section includes the following attributes.
Attribute | Type | Description |
---|---|---|
code | number | Response's exit code. |
headers | array | Array of the response's HTTP headers in header/value format |
body | string | Body of the response. |
body_json | object | Response Body in JSON format |
An example of the Extension Output for a successful REST API call is presented below.
{
"exit_code": 150,
"status_description": "SUCCESS: Task executed successfully with mapped exit code.",
"invocation": {
"extension": "ue-webservice",
"version": "1.2.1",
"fields": {
"protocol": "HTTP_REST",
"http_version": "1.1",
"authorization_type": "None",
"credentials_user": null,
"credentials_password": null,
"oauth2_token": "",
"add_authorization_data_to": null,
"url": "https://dummy.restapiexample.com/api/v1/employees",
"http_method": "GET",
"timeout": null,
"url_query_parameters": {},
"payload_type": null,
"payload_source": null,
"mime_type": null,
"other_value_for_mime_type": "",
"form_data": {},
"payload": "",
"payload_script": null,
"http_headers": {},
"proxies": "",
"use_ssl": false,
"trusted_certificates_file": "",
"ssl_hostname_check": false,
"private_key_certificate": "",
"public_key_certificate": "",
"result_body_medium": "None",
"path_expression": "data.[*].employee_name",
"exit_code_mapping": {
"Tiger Nixon": "150"
},
"process_exit_code_mapping": true
}
},
"result": {
"code": 200,
"headers": [
{
"header": "Content-Encoding",
"value": "gzip"
},
{
"header": "Content-Type",
"value": "application/json"
},
{
"header": "Display",
"value": "staticcontent_sol, orig_site_sol"
},
{
"header": "Response",
"value": "200"
},
{
"header": "Vary",
"value": "Accept-Encoding,User-Agent,Origin"
},
{
"header": "Transfer-Encoding",
"value": "chunked"
}
],
"body": "{\"status\":\"success\",\"data\":[{\"id\":1,\"employee_name\":\"Tiger Nixon\",\"employee_salary\":320800,\"employee_age\":61,\"profile_image\":\"\"},{\"id\":2,\"employee_name\":\"Garrett Winters\",\"employee_salary\":170750,\"employee_age\":63,\"profile_image\":\"\"}, {\"id\":3,\"employee_name\":\"Ashton Cox\",\"employee_salary\":86000,\"employee_age\":66,\"profile_image\":\"\"},{\"id\":4,\"employee_name\":\"Cedric Kelly\",\"employee_salary\":433060,\"employee_age\":22,\"profile_image\":\"\"},{\"id\":5,\"employee_name\":\"Airi Satou\",\"employee_salary\":162700,\"employee_age\":33,\"profile_image\":\"\"}"
"body_json": {
"status": "success",
"data": [
{
"id": 1,
"employee_name": "Tiger Nixon",
"employee_salary": 320800,
"employee_age": 61,
"profile_image": ""
},
{
"id": 2,
"employee_name": "Garrett Winters",
"employee_salary": 170750,
"employee_age": 63,
"profile_image": ""
},
{
"id": 3,
"employee_name": "Ashton Cox",
"employee_salary": 86000,
"employee_age": 66,
"profile_image": ""
},
{
"id": 4,
"employee_name": "Cedric Kelly",
"employee_salary": 433060,
"employee_age": 22,
"profile_image": ""
},
{
"id": 5,
"employee_name": "Airi Satou",
"employee_salary": 162700,
"employee_age": 33,
"profile_image": ""
}
]
}
}
STDOUT and STDERR
STDOUT and STDERR provide additional information to User. The populated content can be changed in future versions of this extension without notice. Backward compatibility is not guaranteed.
Document References
This document references the following documents.
Document Link | Description |
---|---|
Universal Templates | User documentation for creating, working with and understanding Universal Templates and Integrations. |
Universal Tasks | User documentation for creating Universal Tasks in the Universal Controller user interface. |
Credentials | User documentation for creating and working with credentials. |
Resolvable Credentials Permitted Property | User documentation for Resolvable Credentials Permitted Property. |
Integration Modifications
Modifications applied by users or customers, before or after import, might affect the supportability of this integration. The following modifications are discouraged to retain the support level as applied for this integration.
- Python code modifications should not be done.
- Template Modifications
- General Section
- "Name", "Extension", "Variable Prefix", "Icon" should not be changed.
- Universal Template Details Section
- "Template Type", "Agent Type", "Send Extension Variables", "Always Cancel on Force Finish" should not be changed.
- Fields Restriction Section
The setup of the template does not impose any restrictions, However with respect to "Exit Code Processing Fields" section.- Success/Failure exit codes need to be respected.
- In principle, as STDERR and STDOUT outputs can change in follow-up releases of this integration, they should not be considered as a reliable source for determining success or failure of a task.
- General Section
Users and customers are encouraged to report defects, or feature requests at Stonebranch Support Desk.
Changelog
ue-webservice 1.2.1 (2022-12-22)
Enhancements
Changed
: The following Input Field Labels are improved to bring more context on the surrounding functionality (#31203):- Choice OAuth2Token in Authorization Type renamed to: Token
- Optional text field OAuthToken renamed to: Token
- Checkbox field Use SSL renamed to: SSL Options
- Checkbox field SSL Hostname Check renamed to: SSL Certificate Verification
- Optional text field Trusted Certificate File renamed to: CA Bundle Path
- Optional text field Public Key Certificate renamed to: Client Certificate Path
- Optional text field Private Key Certificate renamed to: Client Private Key Path
Changed
: Payload input field is not mandatory anymore (#30639)
Up to ue-webservice-1.2.0, input field Payload was mandatory for HTTP Methods POST, PUT, PATCH. Starting from ue-webservice-1.2.1 it is not necessary to provide data payload.
Fixes
Fixed
: Field Pattern in Response Exit Code Mapping table is now evaluated as python regular expression, instead of literal string (#31224)Fixed
: Parse properly the JSON response when this is a list of objects (#30966)
ue-webservice 1.2.0 (2022-06-23)
Deprecations and Breaking Changes
Deprecated
: "Print Result Body to" STDOUT functionality is intended to be used only for informational purposes. Users authoring workflows which read STDOUT from tasks originating from this Universal Template, are encouraged to read this information from EXTENSION_OUTPUT instead of STDOUT. In future releases the Response Body will be part only of EXTENSION_OUTPUT. (#28541)
Enhancements
Added
: JSON body response formatted and printed in the Extension Output in new JSON attribute 'body_json
' (#28541)
Fixes
Fixed
: JSON body was not printed on STDOUT in certain cases of content-type combinations (#28080)
ue-webservice 1.1.0 (2022-03-10)
Enhancements
Added
: Exit Code Mapping (#27233)Added
: Print Response status on output only field (#26782)Added
: Print Response Body in STDOUT (#26766)