Bots From Extension: restclient
REST Client - Read, Write and invoke APIs using REST Client
This extension provides 7 bots.
Bot @restclient:invoke
Bot Position In Pipeline: Source Sink
Invoke APIs using REST Client. Input data is passed through to output.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| method | Text | post | HTTP method to use. Example: post, put |
| payload_template* | Text | Name of the template where payload is stored. | |
| encoding | Text | json | Encoding for the payload: Options are json or urlencode |
| username | Text | The UserName for authentication | |
| password | Text | The Password for authentication | |
| credential_name | Text | Name of the predefined credential from the config | |
| use_session | Text | Name of the previously saved session in this pipeline | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline | |
| verify | Text | no | If HTTPS, verify SSL certificate. Values can be 'yes' or 'no' |
This bot also accepts wildcard parameters. Any additional name = 'value' parameters are passed to the bot.
Bot @restclient:login
Bot Position In Pipeline: Source Sink
Login to the server using OAuth2.0 mechanism
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| method | Text | post | HTTP method to use. Example: post, put |
| encoding | Text | json | Encoding for the payload: Options are json or urlencode |
| token_path | Text | Path in the response JSON that contains the token. If provided, token will be attached to the Authorization header of the save_session. |
|
| username | Text | The UserName for authentication using basic authentication | |
| password | Text | The Password for authentication using basic authentication | |
| secret_name | Text | Name of the secret from the vault to be used as payload for login. Must be of type http-oauth | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline | |
| update_session_headers | Text | no | Save the response headers to the session. (yes/no) |
| verify | Text | no | If HTTPS, verify SSL certificate. Values can be 'yes' or 'no' |
| debug_dataset | Text | Saves all the debug information including headers and other sensitive information to the specified dataset. |
This bot also accepts wildcard parameters. Any additional name = 'value' parameters are passed to the bot.
Bot @restclient:post-json
Bot Position In Pipeline: Sink
Post each input row as JSON data to the specified URL. The status and response data are added as addtional columns in the output dataframe
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| secret_name | Text | Name of the secret from the vault | |
| use_session | Text | Name of the previously saved session in this pipeline | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline | |
| verify | Text | no | If HTTPS, verify SSL certificate. Values can be 'yes' or 'no' |
This bot also accepts wildcard parameters. Any additional name = 'value' parameters are passed to the bot.
Bot @restclient:read
Bot Position In Pipeline: Source
Read data using REST Client
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| method | Text | get | HTTP method to use. Example: get, post, put |
| payload | Text | Payload to send along with POST or PUT. Must be a JSON formatted string. | |
| encoding | Text | json | Encoding for the payload: Options are json or urlencode |
| result_path | Text | The Path to look for JSON Objects in the result | |
| username | Text | The UserName for authentication | |
| password | Text | The Password for authentication | |
| secret_name | Text | Name of the secret from the vault | |
| use_session | Text | Name of the previously saved session in this pipeline | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline | |
| verify | Text | no | If HTTPS, verify SSL certificate. Values can be 'yes' or 'no' |
| save_to_location | Text | Absolute location to save response at the given location in minio. Sample template: <folder_name>/<filename>.<format> | |
| upload_file | Text | Minio location of the file, that needs to be uploaded along with API request |
This bot also accepts wildcard parameters. Any additional name = 'value' parameters are passed to the bot.
Bot @restclient:read-bulk
Bot Position In Pipeline: Sink
Read data using REST Client with the parameters provided in the input dataset
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| use_session | Text | Name of the previously saved session in this pipeline | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline |
Bot @restclient:read-text-data
Bot Position In Pipeline: Source
Read text data using REST Client
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| sep | Text | , | Specify the sep that needs to be parsed from the obtained response |
| columns* | Text | False | Specify the comma separated column names to which extracted strings need to be added as values |
Bot @restclient:write
Bot Position In Pipeline: Sink
Write input data using REST Client
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| url* | Text | The URL for getting the data | |
| method | Text | post | HTTP method to use. Example: post, put |
| envelope | Text | Envelope for the payload. | |
| encoding | Text | json | Encoding for the payload: Options are json or urlencode |
| include_cols | Text | Columns to be included in the payload.If envelope & include_cols both are provided, only include_cols will be accessable to envelope. |
|
| batch_size | Text | The number of rows written at a time. | |
| username | Text | The UserName for authentication | |
| password | Text | The Password for authentication | |
| secret_name | Text | Name of the secret from the vault | |
| use_session | Text | Name of the previously saved session in this pipeline | |
| save_session | Text | Name of session that needs to be stored in the context of current pipeline | |
| verify | Text | no | If HTTPS, verify SSL certificate. Values can be 'yes' or 'no' |
| debug_dataset | Text | Saves all the debug information including headers and other sensitive information to the specified dataset. |
|
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 3 | Seconds to wait before retrying on failure. |
This bot also accepts wildcard parameters. Any additional name = 'value' parameters are passed to the bot.