TULIP DOCS (LTS4)specs/models/M_CONN_FUNC
Connector Function
Connector functions are configured requests defined on connectors that apps can utilized for sending and receiving data to the source of the connector. They abstract over the specifics of SQL or HTTP to present a standard input and output signatures composed of known variable types. For example a function 'Get Work Orders' might have a signature such as:
INPUTS:
1. Status (string)
2. Customer (string)
OUTPUTS:
1. Array of work orders
- Delivery date (date)
- Part ID (string)
- Part count (number)App editors can use these functions in apps without worrying about complex issues such as authentication, networking, how to write queries, HTTP headers, etc. Defining how the inputs are used to retrieve the data, is different for SQL and HTTP connectors.
Fields for all connector functions:
| Name | Description |
|---|---|
| name | The name of the connector |
| is saved | Once a connector is saved the inputs and outputs can no longer be modified |
| inputs | The composition of variable types an app must provide to call the connector function |
| outputs | The composition of variable types an app can expect to receive from the connector function. |
Additional fields for SQL connector functions:
| Field | Description |
|---|---|
| Use multiple rows | A boolean value that indicates whether the expected output is a single object matching the defined outputs, or an array of objects matching the defined ouput. |
| Query | The SQL query used to retrieve the data. The query can utilize connector inputs in its definition. More on SQL queries |
Additional fields for HTTP connector functions:
| Field | Description |
|---|---|
| HTTP Request Method | One of: GET, HEAD, POST, PUT, PATCH, DELETE more info |
| Authentication | If the authentication is unset at the connector level, it can be set at the function level. |
| Request Headers | A list of request header key/value pairs. These values can utilize input values. |
| URL Path | The path portion of the HTTP request. The path can utilize input values. |
| Query Parameters | A list of key/value pairs that are added to the query portion of the request URL. These values can utilize input values. |
| Request Body | The request body can be one of four types: JSON, form URL-encoded, plain text or XML. The request body can utilize input values. |
| Response Body | Whether the response body is JSON or XML. This setting determined how extracts are used to determine output values. |
| Outputs extractors | For HTTP connectors each output must also define the extractor for retrieiving the data from the body, header or cookie of the HTTP response. |