Devo SDK
App Vendor: Devo
App Category: Analytics & SIEM
Connector Version: 1.5.0
API Version: v1
About App
The Devo SDK app allows users to add or remove data from Devo lookup tables, ensuring efficient data management and automation.
The Devo SDK app is configured with Orchestrate to perform the following actions:
Create Lookup Table With CSV | This action creates a lookup table with a CSV file. |
Delete Lookup Table Row | This action deletes a row in the lookup table. |
Write to Lookup Table | This action writes data to a lookup table. |
Write to Table | This action writes data to a table. |
Action Name | Description |
|---|
Configuration Parameters
The following configuration parameters are required for the Devo SDK app to communicate with the Devo SDK enterprise application. The parameters can be configured by creating instances in the app.
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Certificate | Enter the contents of the certificate file. | Password | Required | |
Private Key | Enter the contents of the private key file. | Password | Required | |
Chain Key | Enter the contents of the chain key file. | Password | Required | |
Relay Server | Enter the relay server to use. | Text | Optional | Default value: us.elb.relay.logtrust.net |
Escape Quotes | Choose true to escape double quotes in field values, preventing lookup failures. | Boolean | Optional | Default value: false |
Escape Newline | Choose true to escape new line characters (\n) in field values, preventing lookup failures. | Boolean | Optional | Default value: false |
Action: Create Lookup Table With CSV
This action creates a lookup table with a CSV file.
Action Input Parameters
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Lookup Name | Enter the lookup name to which you need to add data. Example: csv_data | Text | Required | |
CSV File Path | Enter the path of the CSV file to upload. Example: /tmp/971xx575-70x1-4883-a03b-3afdab389075/table.csv | Text | Required | |
Lookup Key | Enter the lookup key to use in the lookup table. Example: ip_list | Text | Required | In this action, Lookup Key denotes the primary key of the table. |
Types | Enter the data types for the lookup fields as a list, where each type corresponds to the column's position. Example: $LIST[str, ip4, float] | List | Optional | Allowed values: str, int, int4, int8, float, bool, ip4 |
Example Request
[
{
"types": [
"int",
"int",
"ip4"
],
"lookup_key": "Rate",
"lookup_name": "Test_data_5",
"csv_file_path": "/tmp/f388486b-64a1-406e-a9ac-9ef4d71a74e0/Sheet1"
}
]Action: Delete Lookup Table Row
This action deletes a row in the lookup table.
Action Input Parameters
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Lookup Name | Enter the lookup name from where you need to delete data. Example: phishing_table | Text | Required | |
Lookup Fields | Enter a list of fields from a single row in the lookup table to delete. Example: $LIST[11, HEX12, COLOR12] | List | Required | |
Lookup Headers | Enter the list of the headers of the lookup table. Example: $LIST[KEY, HEX, COLOR] | List | Required | |
Primary Key Index | Enter the index of the primary key for proper data indexing. Example: 0 | Integer | Required | |
Header Types | Enter the data types for the lookup fields as a list, where each type corresponds to the column's position. Example: ['int', 'str', 'str'] | List | Optional | Allowed values: str, int, int4, int8, float, bool, ip4 Default value: str |
Example Request
[
{
"headers": [
"Rate",
"Number",
"IP Address"
],
"key_index": "0",
"lookup_name": "phishing_table",
"header_types": [
"int",
"int",
"ip4"
],
"delete_fields": [
600,
6,
"192.168.1.16"
]
}
]
Action: Write to Lookup Table
This action writes data into a lookup table.
Action Input Parameters
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Lookup Name | Enter the lookup name to which you need to add data. Example: Sample_name | Text | Required | |
Lookup Fields | Enter a list of fields to add to the lookup table. Each item in the list is a column point. Example: $LIST[33, hex33, color33] | List | Required | |
Primary Key Index | Enter the index of the primary key for proper data indexing. Example: 0 | Integer | Required | |
Lookup Headers | Enter the headers to parse. Example: $LIST[KEY, HEX, COLOR] | List | Required | |
Write Type | Enter the write type. | Text | Required | Allowed Modules: FULL / INC |
Header Types | Enter the data type for the lookup header fields as a list, where each type corresponds to the column's position. Example: $LIST['int', 'str', 'str']. | List | Optional | Allowed values: str, int, int4, int8, float, bool, ip4 Default value: str |
Example Request
[
{
"headers": [
"Rate",
"Number",
"IP Address"
],
"key_index": "0",
"write_type": "INC",
"lookup_name": "Sample_name",
"header_types": [
"int",
"int",
"ip4"
],
"lookup_fields": [
1010,
16,
"192.168.1.2"
]
}
]Action: Write to Table
This action writes data to a table.
Action Input Parameters
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Table Full Name | Enter the full name or path of a table. Example: demo.ecommerce.data | Text | Required | |
Data | Enter the data to write to a table. Example: $LIST["phishing", "ransomware"] | List | Required |
Example Request
[
{
"table_full_name": "demo.ecommerce.data",
"data": ["phishing", "ransomware"]
}
]