Document toolboxDocument toolbox

Case Management

[ 1 Connect Case Management with Devo SOAR ] [ 2 Actions for Case Management ] [ 2.1 Search Issues ] [ 2.1.1 Input Field ] [ 2.1.2 Output ] [ 2.2 Delete Case ] [ 2.2.1 Input Field ] [ 2.2.2 Output ] [ 2.3 Update Case ] [ 2.3.1 Input Field ] [ 2.3.2 Output ] [ 2.4 Append Comment ] [ 2.4.1 Input Field ] [ 2.4.2 Output ] [ 2.5 Add Manual Task ] [ 2.5.1 Inputs to this Action ] [ 2.5.2 Output ] [ 2.6 Get Tasks ] [ 2.6.1 Input Field ] [ 2.6.2 Output ] [ 2.7 Update Task ] [ 2.7.1 Input Field ] [ 2.7.2 Output ] [ 2.8 Get/Download Case Attachment by Attachment ID ] [ 2.8.1 Input Field ] [ 2.8.2 Output ] [ 2.9 Get Case Attachment ] [ 2.9.1 Input Field ] [ 2.9.2 Output ] [ 2.10 Get Task Attachment ] [ 2.10.1 Input Field ] [ 2.10.2 Output ] [ 2.11 Add Attachment ] [ 2.11.1 Input Field ] [ 2.11.2 Output ] [ 2.12 Delete Attachment ] [ 2.12.1 Input Field ] [ 2.12.2 Output ] [ 2.13 Add Automated Task ] [ 2.13.1 Input Field ] [ 2.13.2 Output ] [ 2.14 Link Cases ] [ 2.14.1 Input Field ] [ 2.14.2 Output ] [ 3 Release Notes ]

An Integration to manage Devo SOAR Cases. It can create new cases, get all cases, get a specific case's details and update or delete a case.

Connect Case Management with Devo SOAR

  1. Navigate to Automations > Integrations.

  2. Search for Case Management.

  3. Click Details, then the + icon. Enter the required information in the following fields.

  4. Label: Enter a connection name.

  5. Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.

  6. Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).

  7. Remote Agent: Run this integration using the Devo SOAR Remote Agent.

  8. URL (Optional): URL of your Devo SOAR instance. Example: https://xyz.logichub.com (Default to connect to the local Devo SOAR server using https://nginx:8443).

  9. API Token: API Token for accessing Case Management. To create API Token, see details.

  10. After you've entered all the details, click Connect.

Actions for Case Management

Search Issues

Search for Issues

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Filter Query

Jinja-templated for search text. Leave empty to get all issues. For advanced query see help.

Required

Explode Results

Explode each result in a separate row. (default: No).

Required

Get All Fields

Get all custom and system fields. (default: No). The default will get only some fields such as assignee and reporter attached to the issue.

Required

Fetch Case Details

Get case details as well (default: No).

Required

Fetch Case History

Get history of the case as well. Applicable only when Fetch case details is "Yes". (default: No).

Required

Fetch Comments In History

Get comments in history of the case as well. Applicable only when Fetch case history is "Yes" (default: No).

Required

Exclude Comments

Jinja-templated string representing a regex such that all comments matching with the regex would be excluded from the result. Applicable only when Fetch case details is "Yes".

 

Example {{regex_column}}

Required

 

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: List of cases

``` {json}{ "result":[ { "id":"lhub-3422", "issueType":"Default", "issueTypeId":"lhcasetype-1", "reporter":"indrajeet", "assignee":"Unassigned", "status":"ToDo", "priority":"High", "title":"testIJ", "taskOrder":[ "lhub-3423" ], "descriptionRaw":"", "createdAt":1614757210516, "modifiedAt":1614757226935, "fields":[

], "statusType":"Open", "case_details":{ "id":"lhub-3422", "issueType":"Default", "issueTypeId":"lhcasetype-1", "reporterUserName":"indrajeet", "assigneeUserName":"Unassigned", "status":"ToDo", "priority":"High", "title":"testIJ", "descriptionRaw":"", "comments":[ ], "tasks":[ { "id":"lhub-3423", "issueType":"Manual Task", "issueTypeId":"lhcasetype-2", "reporterUserName":"indrajeet", "assigneeUserName":"Unassigned", "status":"InProgress", "priority":"High", "title":"Task1", "parent":"lhub-3422", "descriptionRaw":"", "dateCreated":1614757219399, "dateModified":1614757252356, "hasAccess":true } ], "attachments":[ ], "fields":[ { "caseId":"lhub-3422", "fieldId":"field-379", "fieldName":"000_CusField0429_Text", "displayName":"000_CusField0429_Text", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-444", "fieldName":"321", "displayName":"2123", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-563", "fieldName":"e32e32e", "displayName":"23e23e32", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-277", "fieldName":"Abir_Test", "displayName":"Abir_TEST", "fieldType":"Select", "descriptor":{ "options":[ "1" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-506", "fieldName":"ANewDate", "displayName":"ANewDate", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-507", "fieldName":"ANewDT", "displayName":"ANewDT", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-498", "fieldName":"ANewSelectField", "displayName":"ANewSelectField", "fieldType":"Select", "descriptor":{ "options":[ "Abc", "Def", "XYZ" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-489", "fieldName":"AUrlField", "displayName":"AUrlField", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-571", "fieldName":"B", "displayName":"B", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-311", "fieldName":"issue_id_clone", "displayName":"Case/Task Id_clone", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-426", "fieldName":"cloneField", "displayName":"cloneField", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-574", "fieldName":"d", "displayName":"d", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-171", "fieldName":"Date", "displayName":"Date", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-430", "fieldName":"dateField", "displayName":"dateField", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-511", "fieldName":"dateTypeField", "displayName":"dateTypeField_displayName", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-578", "fieldName":"dd", "displayName":"dd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-446", "fieldName":"dedwed", "displayName":"dedewdwedwed", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-449", "fieldName":"delete3f", "displayName":"delete3fd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-447", "fieldName":"deleteq", "displayName":"deleteqw", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-570", "fieldName":"Demo", "displayName":"Demo", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-448", "fieldName":"disableq", "displayName":"disableqw", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-588", "fieldName":"DS", "displayName":"DS", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-575", "fieldName":"dds", "displayName":"dsds", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-577", "fieldName":"e", "displayName":"e", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-435", "fieldName":"epicID", "displayName":"epicID", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-376", "fieldName":"exit_code", "displayName":"exit_code", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-223", "fieldName":"lh_filehash", "displayName":"Extracted File Hashes", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-221", "fieldName":"lh_ipaddress", "displayName":"Extracted IP Addresses", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-222", "fieldName":"lh_url", "displayName":"Extracted URLs", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-326", "fieldName":"qqqqq", "displayName":"fffff", "fieldType":"MultiSelect", "descriptor":{ "options":[ "ggg", "af" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-212", "fieldName":"field_1230_3", "displayName":"field_1230_3", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-509", "fieldName":"Field_Name_1301", "displayName":"Field_Name_1301", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-508", "fieldName":"Field_test_1101", "displayName":"Field_test_1101", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-514", "fieldName":"Field_test_2301", "displayName":"Field_test_2301", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-452", "fieldName":"Field_test_2501", "displayName":"Field_test_2501_edit", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-453", "fieldName":"Field_test_2502", "displayName":"Field_test_2502", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-549", "fieldName":"Field_test_date", "displayName":"Field_test_date", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-550", "fieldName":"Field_test_text", "displayName":"Field_test_text", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-177", "fieldName":"FOR_CT3_1", "displayName":"FOR_CT3_1", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-628", "fieldName":"HE", "displayName":"HE", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-377", "fieldName":"host_id", "displayName":"host_id", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-170", "fieldName":"IP", "displayName":"IP_edit", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-421", "fieldName":"ipColumn", "displayName":"ipColumn", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-440", "fieldName":"jiraID", "displayName":"jiraID", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-502", "fieldName":"latency1", "displayName":"latency1", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-503", "fieldName":"latency2", "displayName":"latency2", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-504", "fieldName":"latency3", "displayName":"latency3", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-400", "fieldName":"LHUB14332", "displayName":"LHUB14332", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-309", "fieldName":"Location", "displayName":"Location", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-405", "fieldName":"m57NewFieldNAMEOne", "displayName":"m57NewDispalyOne", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-418", "fieldName":"multiSelectColumn", "displayName":"multiSelectColumn", "fieldType":"MultiSelect", "descriptor":{ "options":[ "1", "2", "3", "amar test", "amar test 2", "amar test new", "amar test new 2", "amar test new 3" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-419", "fieldName":"multiValuedColumn", "displayName":"multiValuedColumn", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-301", "fieldName":"TestCall", "displayName":"NertworkCall", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-438", "fieldName":"numberColumn_CustomField", "displayName":"numberColumn_displayName", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-496", "fieldName":"pg_1", "displayName":"pg_1", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-451", "fieldName":"playdelF", "displayName":"playdelFa", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-450", "fieldName":"playdisF", "displayName":"playdisFd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-318", "fieldName":"QA_Date", "displayName":"QA_Date_edited", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-319", "fieldName":"QA_mulVal", "displayName":"QA_mulVal", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-314", "fieldName":"QA_num", "displayName":"QA_num", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-640", "fieldName":"qa_num", "displayName":"qa_num", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-315", "fieldName":"QA_textarea", "displayName":"QA_textarea", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-317", "fieldName":"QA_url", "displayName":"QA_url", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-316", "fieldName":"QA_user", "displayName":"QA_user", "fieldType":"User", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-630", "fieldName":"rbac_field", "displayName":"rbac_field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-633", "fieldName":"rbac_field_dateTime", "displayName":"rbac_field_dateTime", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-634", "fieldName":"rbac_field_ipAddress", "displayName":"rbac_field_ipAddress", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-636", "fieldName":"rbac_field_multiSelect", "displayName":"rbac_field_multiSelect", "fieldType":"MultiSelect", "descriptor":{ "options":[ "rbac_field_multiSelect 1", "rbac_field_multiSelect 2" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-637", "fieldName":"rbac_field_multiValued", "displayName":"rbac_field_multiValued", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-632", "fieldName":"rbac_field_number", "displayName":"rbac_field_number", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-635", "fieldName":"rbac_field_select", "displayName":"rbac_field_select", "fieldType":"Select", "descriptor":{ "options":[ "rbac_field_select 1", "rbac_field_select 2" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-631", "fieldName":"rbac_field_textArea", "displayName":"rbac_field_textArea", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-638", "fieldName":"rbac_field_url", "displayName":"rbac_field_url", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-639", "fieldName":"rbac_field_user", "displayName":"rbac_field_user", "fieldType":"User", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-576", "fieldName":"s", "displayName":"s", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-573", "fieldName":"Sa", "displayName":"Sa", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-579", "fieldName":"Sample", "displayName":"Sample", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-420", "fieldName":"selectColumn", "displayName":"selectColumn", "fieldType":"Select", "descriptor":{ "options":[ "1", "2", "3" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-587", "fieldName":"SF", "displayName":"SF", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-627", "fieldName":"SS", "displayName":"SS", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-581", "fieldName":"T", "displayName":"T", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-300", "fieldName":"Test_IJ", "displayName":"Test Field", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-307", "fieldName":"Test_IP_address", "displayName":"Test IP address", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-399", "fieldName":"test_email", "displayName":"test_email", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-641", "fieldName":"Test_Field", "displayName":"Test_Field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-572", "fieldName":"TestField123", "displayName":"TestField123", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-586", "fieldName":"testField_2801", "displayName":"testField_2801", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-487", "fieldName":"TextAreaField", "displayName":"TextAreaField", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-371", "fieldName":"lhub_ts", "displayName":"timestamp", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-580", "fieldName":"TTT", "displayName":"TTT", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-274", "fieldName":"vabs_field", "displayName":"vaibhav_field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-372", "fieldName":"lh_watchers", "displayName":"watchers", "fieldType":"MultiSelect", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-583", "fieldName":"WW", "displayName":"WWE", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-582", "fieldName":"zxcv", "displayName":"zxcv", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false } ], "dateCreated":1614757210516, "dateModified":1614757226935, "linkedCases":[ ], "viewLayout":"{\"layout\":[{\"defaultActiveTab\":\"Summary\",\"i\":\"lh-case-details-layout-section-1\",\"isResizable\":false,\"sectionName\":\"Section 1\",\"x\":0,\"y\":3,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Summary\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Tasks\",\"i\":\"lh-case-details-layout-section-2\",\"isResizable\":false,\"sectionName\":\"Section 2\",\"x\":0,\"y\":0,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Tasks\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Attachments\",\"i\":\"lh-case-details-layout-section-3\",\"isResizable\":false,\"sectionName\":\"Section 3\",\"x\":0,\"y\":1,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Attachments\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Linked Cases\",\"i\":\"lh-case-details-layout-section-4\",\"isResizable\":false,\"sectionName\":\"Section 4\",\"x\":0,\"y\":2,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Linked Cases\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"Suggested Cases\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Comments\",\"i\":\"lh-case-details-layout-section-5\",\"sectionName\":\"Section 5\",\"isResizable\":false,\"x\":0,\"y\":4,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Comments\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"Commands\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"History\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Extracted Fields\",\"i\":\"lh-case-details-layout-section-6\",\"isResizable\":false,\"sectionName\":\"Section 6\",\"x\":1,\"y\":0,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Extracted Fields\",\"isDefaultTab\":true,\"fields\":[{\"fieldName\":\"lh_ipaddress\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted IP Addresses\"},{\"fieldName\":\"lh_url\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted URLs\"},{\"fieldName\":\"lh_filehash\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted File Hashes\"}]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Additional Fields\",\"i\":\"lh-case-details-layout-section-7\",\"isResizable\":false,\"sectionName\":\"Section 7\",\"x\":1,\"y\":1,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Additional Fields\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]}],\"systemFields\":[{\"fieldName\":\"reporter\",\"fieldType\":\"User\",\"isReadOnly\":false},{\"fieldName\":\"assignee\",\"fieldType\":\"User\",\"isReadOnly\":false},{\"fieldName\":\"title\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"description\",\"fieldType\":\"TextArea\",\"isReadOnly\":false},{\"fieldName\":\"priority\",\"fieldType\":\"Select\",\"isReadOnly\":false},{\"fieldName\":\"issue_id\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"lh_watchers\",\"fieldType\":\"MultiSelect\",\"isReadOnly\":false},{\"fieldName\":\"status\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"created_at\",\"fieldType\":\"Date\",\"isReadOnly\":false},{\"fieldName\":\"modified_at\",\"fieldType\":\"Date\",\"isReadOnly\":false}]}", "history":[ { "id":11845, "cmEntityId":3422, "cmEntityType":"case", "modifiedAt":1614757227067, "userName":"indrajeet", "fieldName":"task", "modification":"Added", "before":null, "before_raw":null, "after":{ "value":"lhub-3423" }, "after_raw":{ "value":"lhub-3423" } } ], "isWatching":false, "caseStatusWorkflow":{ "id":"statusworkflow-3", "name":"Old Default Case Workflow", "description":"This is the old default workflow created by system.", "createdAt":1593169387512, "modifiedAt":1593169387512, "stateTransitions":{ "transitions":[ { "name":"ToDo", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"Open" }, { "name":"InProgress", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"In Progress" }, { "name":"Done", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"Closed" } ] }, "isSystem":true, "caseTypes":[ ] } } }

], "error":null, "has_error":false }

## Create Case Creates a case with parameters provided. ### Input Field Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection. | Input Name | Description | Required | | : -------- | : -------- | : -------- | | Case Type | Jinja2 template for type of case to be created. Example: Default. | Required | | Case Title Template | Jinja2 template for case title. Example: This is {{case_title_column_name}}. | Optional | | Case Description Template | Markdown template for case description (Blockquotes and HTML tags are not supported). Example: **Reporter**: {{reporter_column_name}}. **Severity**: {{score_column_name}}. | Optional | | Case Reporter | Column name from parent table containing Reporter of the Case. | Optional | | Case Assignee | Column name from parent table containing Assignee for the Case. | Optional | | Case Priority | Column name from parent table containing Priority for the Case. | Required | | Case Custom Fields Template | Jinja2 template for case custom fields. Input is expected in valid json-array as given in example. Example: [{"field-name1":{{column1}}, "field-name2": {{column2}}]. - You can enter the following JSON syntax for **linking alerts to a case**: {"lh_linked_alerts":["{{alert_Id}}", "alert-84147474"]} where, `lh_linked_alerts` is the field ID which is multivalued type. You can either use the alert ID or the Jinja template. To know more, see [how to view alerts in a case](doc:create-cases-to-track-work-in-logichub#linked-alerts-to-case) | Optional | ### Output A JSON object containing multiple rows of result: - has_error: True/False - error: message/null - result: Case details ![](https://files.readme.io/0f8448e-Create_Case.png "Create Case.png") ## Get Case Details Retrieves all cases. ### Input Field Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection. | Input Name | Description | Required | | :----------------------------- | :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------- | | Case Id | Column name from parent table containing Case ID of the Case | Required | | Fields To Return | Jinja2 template for getting some specific fields only. Enter comma-separated list of field names, not display names. Leave empty to get all fields. Use only after Devo SOAR version M81 | Optional | | Include Case History | Get history of the case as well. (Default is No) | Optional | | Include History For Fields | Jinja2 template for getting history of some specific fields only. Enter comma-separated list of field names, not display names. Applicable only when Include Case History is "Yes". Leave empty to get entire history. Use only after Devo SOAR version M81 | Optional | | Include Comments In History | Get comments in history of the case as well. Applicable only when Include Case history is "Yes" (Default is No) | Optional | | Exclude Comments Regex | Jinja templated string representing a regex such that all comments matching with the regex would be excluded from the result. Applicable only when Include Case Details or Include Case Comments is "Yes". If your Devo SOAR version is less than M81, then applicable only when 'Include Case Details' is "Yes". Example {{regex_column}} | Optional | | Include Content In Attachments | Get Contents in Attachments. (Default is No) | Optional | ### Output A JSON object containing multiple rows of result: - has_error: True/False - error: message/null - result: Case details ``` {json}{ "id":"lhub-3422", "issueType":"Default", "issueTypeId":"lhcasetype-1", "reporterUserName":"indrajeet", "assigneeUserName":"Unassigned", "status":"ToDo", "priority":"High", "title":"testIJ", "descriptionRaw":"", "comments":[ ], "tasks":[ { "id":"lhub-3423", "issueType":"Manual Task", "issueTypeId":"lhcasetype-2", "reporterUserName":"indrajeet", "assigneeUserName":"Unassigned", "status":"InProgress", "priority":"High", "title":"Task1", "parent":"lhub-3422", "descriptionRaw":"", "dateCreated":1614757219399, "dateModified":1614757252356, "hasAccess":true } ], "attachments":[ ], "fields":[ { "caseId":"lhub-3422", "fieldId":"field-379", "fieldName":"000_CusField0429_Text", "displayName":"000_CusField0429_Text", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-444", "fieldName":"321", "displayName":"2123", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-563", "fieldName":"e32e32e", "displayName":"23e23e32", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-277", "fieldName":"Abir_Test", "displayName":"Abir_TEST", "fieldType":"Select", "descriptor":{ "options":[ "1" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-506", "fieldName":"ANewDate", "displayName":"ANewDate", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-507", "fieldName":"ANewDT", "displayName":"ANewDT", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-498", "fieldName":"ANewSelectField", "displayName":"ANewSelectField", "fieldType":"Select", "descriptor":{ "options":[ "Abc", "Def", "XYZ" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-489", "fieldName":"AUrlField", "displayName":"AUrlField", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-571", "fieldName":"B", "displayName":"B", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-311", "fieldName":"issue_id_clone", "displayName":"Case/Task Id_clone", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-426", "fieldName":"cloneField", "displayName":"cloneField", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-574", "fieldName":"d", "displayName":"d", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-171", "fieldName":"Date", "displayName":"Date", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-430", "fieldName":"dateField", "displayName":"dateField", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-511", "fieldName":"dateTypeField", "displayName":"dateTypeField_displayName", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-578", "fieldName":"dd", "displayName":"dd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-446", "fieldName":"dedwed", "displayName":"dedewdwedwed", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-449", "fieldName":"delete3f", "displayName":"delete3fd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-447", "fieldName":"deleteq", "displayName":"deleteqw", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-570", "fieldName":"Demo", "displayName":"Demo", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-448", "fieldName":"disableq", "displayName":"disableqw", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-588", "fieldName":"DS", "displayName":"DS", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-575", "fieldName":"dds", "displayName":"dsds", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-577", "fieldName":"e", "displayName":"e", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-435", "fieldName":"epicID", "displayName":"epicID", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-376", "fieldName":"exit_code", "displayName":"exit_code", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-223", "fieldName":"lh_filehash", "displayName":"Extracted File Hashes", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-221", "fieldName":"lh_ipaddress", "displayName":"Extracted IP Addresses", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-222", "fieldName":"lh_url", "displayName":"Extracted URLs", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-326", "fieldName":"qqqqq", "displayName":"fffff", "fieldType":"MultiSelect", "descriptor":{ "options":[ "ggg", "af" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-212", "fieldName":"field_1230_3", "displayName":"field_1230_3", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-509", "fieldName":"Field_Name_1301", "displayName":"Field_Name_1301", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-508", "fieldName":"Field_test_1101", "displayName":"Field_test_1101", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-514", "fieldName":"Field_test_2301", "displayName":"Field_test_2301", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-452", "fieldName":"Field_test_2501", "displayName":"Field_test_2501_edit", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-453", "fieldName":"Field_test_2502", "displayName":"Field_test_2502", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-549", "fieldName":"Field_test_date", "displayName":"Field_test_date", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-550", "fieldName":"Field_test_text", "displayName":"Field_test_text", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-177", "fieldName":"FOR_CT3_1", "displayName":"FOR_CT3_1", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-628", "fieldName":"HE", "displayName":"HE", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-377", "fieldName":"host_id", "displayName":"host_id", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-170", "fieldName":"IP", "displayName":"IP_edit", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-421", "fieldName":"ipColumn", "displayName":"ipColumn", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-440", "fieldName":"jiraID", "displayName":"jiraID", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-502", "fieldName":"latency1", "displayName":"latency1", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-503", "fieldName":"latency2", "displayName":"latency2", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-504", "fieldName":"latency3", "displayName":"latency3", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-400", "fieldName":"LHUB14332", "displayName":"LHUB14332", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-309", "fieldName":"Location", "displayName":"Location", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-405", "fieldName":"m57NewFieldNAMEOne", "displayName":"m57NewDispalyOne", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-418", "fieldName":"multiSelectColumn", "displayName":"multiSelectColumn", "fieldType":"MultiSelect", "descriptor":{ "options":[ "1", "2", "3", "amar test", "amar test 2", "amar test new", "amar test new 2", "amar test new 3" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-419", "fieldName":"multiValuedColumn", "displayName":"multiValuedColumn", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-301", "fieldName":"TestCall", "displayName":"NertworkCall", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-438", "fieldName":"numberColumn_CustomField", "displayName":"numberColumn_displayName", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-496", "fieldName":"pg_1", "displayName":"pg_1", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-451", "fieldName":"playdelF", "displayName":"playdelFa", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-450", "fieldName":"playdisF", "displayName":"playdisFd", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-318", "fieldName":"QA_Date", "displayName":"QA_Date_edited", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-319", "fieldName":"QA_mulVal", "displayName":"QA_mulVal", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-314", "fieldName":"QA_num", "displayName":"QA_num", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-640", "fieldName":"qa_num", "displayName":"qa_num", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-315", "fieldName":"QA_textarea", "displayName":"QA_textarea", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-317", "fieldName":"QA_url", "displayName":"QA_url", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-316", "fieldName":"QA_user", "displayName":"QA_user", "fieldType":"User", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-630", "fieldName":"rbac_field", "displayName":"rbac_field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-633", "fieldName":"rbac_field_dateTime", "displayName":"rbac_field_dateTime", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-634", "fieldName":"rbac_field_ipAddress", "displayName":"rbac_field_ipAddress", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-636", "fieldName":"rbac_field_multiSelect", "displayName":"rbac_field_multiSelect", "fieldType":"MultiSelect", "descriptor":{ "options":[ "rbac_field_multiSelect 1", "rbac_field_multiSelect 2" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-637", "fieldName":"rbac_field_multiValued", "displayName":"rbac_field_multiValued", "fieldType":"MultiValued", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-632", "fieldName":"rbac_field_number", "displayName":"rbac_field_number", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-635", "fieldName":"rbac_field_select", "displayName":"rbac_field_select", "fieldType":"Select", "descriptor":{ "options":[ "rbac_field_select 1", "rbac_field_select 2" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-631", "fieldName":"rbac_field_textArea", "displayName":"rbac_field_textArea", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-638", "fieldName":"rbac_field_url", "displayName":"rbac_field_url", "fieldType":"URL", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-639", "fieldName":"rbac_field_user", "displayName":"rbac_field_user", "fieldType":"User", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-576", "fieldName":"s", "displayName":"s", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-573", "fieldName":"Sa", "displayName":"Sa", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-579", "fieldName":"Sample", "displayName":"Sample", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-420", "fieldName":"selectColumn", "displayName":"selectColumn", "fieldType":"Select", "descriptor":{ "options":[ "1", "2", "3" ] }, "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-587", "fieldName":"SF", "displayName":"SF", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-627", "fieldName":"SS", "displayName":"SS", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-581", "fieldName":"T", "displayName":"T", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-300", "fieldName":"Test_IJ", "displayName":"Test Field", "fieldType":"Number", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-307", "fieldName":"Test_IP_address", "displayName":"Test IP address", "fieldType":"IP", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-399", "fieldName":"test_email", "displayName":"test_email", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-641", "fieldName":"Test_Field", "displayName":"Test_Field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-572", "fieldName":"TestField123", "displayName":"TestField123", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-586", "fieldName":"testField_2801", "displayName":"testField_2801", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-487", "fieldName":"TextAreaField", "displayName":"TextAreaField", "fieldType":"TextArea", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-371", "fieldName":"lhub_ts", "displayName":"timestamp", "fieldType":"Date", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-580", "fieldName":"TTT", "displayName":"TTT", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-274", "fieldName":"vabs_field", "displayName":"vaibhav_field", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-372", "fieldName":"lh_watchers", "displayName":"watchers", "fieldType":"MultiSelect", "descriptor":"Default", "isHidden":false, "isSystemField":true, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-583", "fieldName":"WW", "displayName":"WWE", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false }, { "caseId":"lhub-3422", "fieldId":"field-582", "fieldName":"zxcv", "displayName":"zxcv", "fieldType":"Text", "descriptor":"Default", "isHidden":false, "isSystemField":false, "value":null, "excludedValues":[ ], "isReadOnly":false } ], "dateCreated":1614757210516, "dateModified":1614757226935, "linkedCases":[ ], "viewLayout":"{\"layout\":[{\"defaultActiveTab\":\"Summary\",\"i\":\"lh-case-details-layout-section-1\",\"isResizable\":false,\"sectionName\":\"Section 1\",\"x\":0,\"y\":3,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Summary\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Tasks\",\"i\":\"lh-case-details-layout-section-2\",\"isResizable\":false,\"sectionName\":\"Section 2\",\"x\":0,\"y\":0,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Tasks\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Attachments\",\"i\":\"lh-case-details-layout-section-3\",\"isResizable\":false,\"sectionName\":\"Section 3\",\"x\":0,\"y\":1,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Attachments\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Linked Cases\",\"i\":\"lh-case-details-layout-section-4\",\"isResizable\":false,\"sectionName\":\"Section 4\",\"x\":0,\"y\":2,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Linked Cases\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"Suggested Cases\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Comments\",\"i\":\"lh-case-details-layout-section-5\",\"sectionName\":\"Section 5\",\"isResizable\":false,\"x\":0,\"y\":4,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Comments\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"Commands\",\"isDefaultTab\":true,\"fields\":[]},{\"tabName\":\"History\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Extracted Fields\",\"i\":\"lh-case-details-layout-section-6\",\"isResizable\":false,\"sectionName\":\"Section 6\",\"x\":1,\"y\":0,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Extracted Fields\",\"isDefaultTab\":true,\"fields\":[{\"fieldName\":\"lh_ipaddress\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted IP Addresses\"},{\"fieldName\":\"lh_url\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted URLs\"},{\"fieldName\":\"lh_filehash\",\"fieldType\":\"MultiValued\",\"isReadOnly\":true,\"displayName\":\"Extracted File Hashes\"}]}],\"allowSectionDelete\":false,\"fields\":[]},{\"defaultActiveTab\":\"Additional Fields\",\"i\":\"lh-case-details-layout-section-7\",\"isResizable\":false,\"sectionName\":\"Section 7\",\"x\":1,\"y\":1,\"w\":1,\"h\":1,\"tabs\":[{\"tabName\":\"Additional Fields\",\"isDefaultTab\":true,\"fields\":[]}],\"allowSectionDelete\":false,\"fields\":[]}],\"systemFields\":[{\"fieldName\":\"reporter\",\"fieldType\":\"User\",\"isReadOnly\":false},{\"fieldName\":\"assignee\",\"fieldType\":\"User\",\"isReadOnly\":false},{\"fieldName\":\"title\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"description\",\"fieldType\":\"TextArea\",\"isReadOnly\":false},{\"fieldName\":\"priority\",\"fieldType\":\"Select\",\"isReadOnly\":false},{\"fieldName\":\"issue_id\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"lh_watchers\",\"fieldType\":\"MultiSelect\",\"isReadOnly\":false},{\"fieldName\":\"status\",\"fieldType\":\"Text\",\"isReadOnly\":false},{\"fieldName\":\"created_at\",\"fieldType\":\"Date\",\"isReadOnly\":false},{\"fieldName\":\"modified_at\",\"fieldType\":\"Date\",\"isReadOnly\":false}]}", "isWatching":false, "caseStatusWorkflow":{ "id":"statusworkflow-3", "name":"Old Default Case Workflow", "description":"This is the old default workflow created by system.", "createdAt":1593169387512, "modifiedAt":1593169387512, "stateTransitions":{ "transitions":[ { "name":"ToDo", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"Open" }, { "name":"InProgress", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"In Progress" }, { "name":"Done", "from":[ "__TransitionFromAll__" ], "to":[ "__TransitionToAll__" ], "statusType":"Closed" } ] }, "isSystem":true, "caseTypes":[ ] }, "statusType":"Open", "error":null, "has_error":false }

Delete Case

Deletes a Case associated with a case ID.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Success/Failure Message

Update Case

Updates Reporter, Assignee, Status, Priority, Title and/or Description of a case.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Updated Case Reporter

Jinja-templated text containing the Reporter to be updated for the Case.

Optional

Updated Case Assignee

Jinja-templated text containing the Assignee to be updated for the Case.

Optional

Updated Case Status

Jinja-templated text containing the Status to be updated for the Case.

Optional

Updated Case Priority

Jinja-templated text containing the Priority to be updated for the Case.

Optional

Updated Case Title Template

Jinja2 template for case title.

 

Example: This is {{case_title_column_name}}.

Optional

 

Updated Case Description Template

Markdown template for case description (Blockquotes and HTML tags are not supported).

 

Example: Reporter: {{reporter_column_name}}.

 

 

Severity: {{score_column_name}}.

Optional

 

Updated Case Custom Fields Template

Jinja2 template for case custom fields. Input is expected in valid json-array as given in example.

 

Example: [{"id":"field-id", "value":{{column1}}}, {"id":"field-id", "value":"{{column2}}"}].

Optional

 

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Case details

Append Comment

Appends comment to a Case.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Reporter Username

Column name from parent table containing Devo SOAR username. Default will be the user whose account has been used at the connection level.

Optional

Comment Template

Jinja2 template for comment.

 

Example: This is {{comment_column_name}}.

Required

 

Escape HTML

Select option to escape HTML. (Default is 'True')

Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Case id and comment ID

Add Manual Task

Adds Manual task to a Case.

Inputs to this Action

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case Id

Column name from parent table containing Case ID of the Case.

Required

Task Title Template

Jinja2 template for task title. Example: This is {{title_column_name}}.

 

Task Reporter

Column name from parent table containing task reporter username.

 

Task Assignee

Column name from parent table containing task assignee username.

Optional

Task Priority

Column name from parent table containing task priority.

Optional

Task Status

Column name from parent table containing the status of the task.

Optional

Task Summary Template

Markdown template for task summary (Blockquotes and HTML tags are not supported).

 

Example: Reporter: {{reporter_column_name}}. Severity:{{score_column_name}}. | Optional |

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Task details

Get Tasks

Get all tasks of a case.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Task details

Update Task

Updates Assignee, Status, Priority, Title, and/or Summary of a task.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Task ID

Column name from parent table containing Task ID of the task.

 

Task Title Template

Jinja2 template for task title. Example: This is {{title_column_name}}.

Optional

Task Assignee

Column name from parent table containing task assignee username.

Optional

Task Priority

Column name from parent table containing task priority.

Optional

Task Status

Column name from parent table containing the status of the task.

Optional

Task Summary Template

Markdown template for task summary (Blockquotes and HTML tags are not supported).

 

Example: Reporter: {{reporter_column_name}}. Severity:
{{score_column_name}} . | Optional |

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Task details

Get/Download Case Attachment by Attachment ID

Download an attachment for a case identified by attachment ID.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Attachment ID

Column name from parent table containing Attachment ID of Attachment.

Required

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: File ID

Get Case Attachment

Get attachments of a case.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case Id

Column name from parent table containing Case ID of the Case.

Required

Split Results

Split attachments in separate rows. (Default 'Yes').

Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Attachment ID

Get Task Attachment

Get attachments of a task.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Task ID

Column name from parent table containing Task ID of the Case.

Required

Split Results

Split attachments in separate rows. (Default 'Yes').

Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Attachment ID

Add Attachment

Add an attachment to a case (optionally to a specific task of a case).

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

File Name

Column name from parent table containing Name of the file to be added as an Attachment.

Required

File ID

Column name from parent table containing file-id of the file to be added as an Attachment.

Required

Task ID

Column name from parent table containing Task ID of the Case. If the value corresponding to column-name is empty, task-id will be ignored and attachment will be added to the case. Ignored, by default.

Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Attachment ID

Delete Attachment

Delete an attachment from case/task using Attachment ID.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Attachment ID

Jinja-templated text containing the Attachment ID of the attachment. Example: {{attachment_id}}.

 

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Attachment deleted successfully

{json}{ "result": "Attachment deleted successfully", "has_error": false }

Add Automated Task

Adds Automated task to a Case.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Command Template

Jinja2 template for Command of the task.

 

Example: Either mention command name directly or as {{commandNameColumn}}.

 

 

To know more about commands, see Create Commands for Cases.

Required

 

Task Title Template

Jinja2 template for task title.

 

Example: This is {{title_column_name}}. Default is Command Name.

Optional

 

Task Reporter Template

Jinja2 template for task reporter username.

 

Example: Either mention reporter name directly or as {{reporterColumnName}}

Required

 

Task Description Template

Jinja2 template for task description.

 

Example: This is {{description_column_name}}. Default is Command Description.

Optional

 

Task Parameters Template

Jinja-templated JSON for parameters of the task. Example '{\"case_field_name1\": \"param_name1\", \"case_field_name2\": \"param_name2\"}'.

Optional

Trigger Type

Select trigger type of task. There are two options:

 

1) Automatic: The task is executed immediately when the conditions of the task list and case type are met.

 

 

2) On click: When the conditions of the task list and case type are met, the owner or assignee can click a button to run the task.

 

 

By default, Automatic is selected.

 

 

For more information on Trigger Type, see Add Tasks to a Case.

Required

 

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Task details

Link Cases

Get attachments of a task.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name

Description

Required

Input Name

Description

Required

Case ID

Column name from parent table containing Case ID of the Case.

Required

Case IDs to link

Column name from parent table containing Case IDs in comma separated manner.

 

Example: case_id1,case_id2,case_id3.

Required

 

Output

A JSON object containing multiple rows of result:

  • has_error: True/False

  • error: message/null

  • result: Success/Failure Message

Release Notes

  • v3.3.0 - Added Escape HTML optional field to Append Comment

  • v3.2.5 - Error handling fix if error is coming from backend.

  • v3.2.1 - Updated input description.

  • v3.1.2 - Added support for mTLS-enabled instances.

  • v3.0.0 - Updated architecture to support IO via filesystem

  • v2.3.21 - Reporter, Assignee, Priority and Status are not necessary to update the ticket in Update Case action.

  • v2.3.18 - Made Reporter, Assignee, Priority, and status fields as jinja template in Update Case action.

  • v2.3.16 - Bug resolved to handle escape characters in Update Case and added option to get content of attachment in Search Case aaction.

  • v2.3.12 - Made reporter username in Append Comment action as optional.

  • v2.3.10 - Optimized the action Link Case to not bring the attachment content into the service memory.

  • v2.3.8 - Changed the priority of Create Case action to required.

  • v2.3.7 - Bug resolved for JsonDecode.

  • v2.3.2 - Added option to download attachment in get case.