Extract Artifacts from Excel File

LAST UPDATED: AUG 07, 2024

Extracts artifacts from an excel file with File ID. Artifacts include IP, Domain, URL, File Hash, Email Address etc. The first row of the Excel file will be consider as a header row.

Implementation	System
Command Category	Cyber Utility
Tags	`Artifact` `Condition`

Inputs

Parameter Name	Required/Optional	Description	Sample Data
File Id	Required	Id of the file to get artifact	925
File Source	Required	Source of the file	Incident Attachment File

Output

Return Data

The returned result of this command. If some required parameters are not defined, this returned data could be empty. The returned result can be passed down directly to a subsequent command in playbooks.

SAMPLE DATA

JSON

Successful

Context Data

The response data from the utility command.

SAMPLE DATA

JSON

{
    "ip": [
        "1.1.1.1"
    ],
    "url": [
        "https://www.d3security.com",
        "https://www.google.com/"
    ],
    "domain": [
        "www.d3security.com",
        "www.google.com"
    ],
    "md5": [
        "e6fd84aeddfeb04a45698535edb9adf6"
    ],
    "sha256": [
        "b88124f01bd245056920867df287d1ac8b5ffead5fde8492ccffbcb53b84d70a"
    ],
    "sha1": [
        "b48b238c0d36a1ab1506d72b3258af622f75db49"
    ],
    "emailaddress": [
        "test@mail.com"
    ]
}

Remote Command API

The D3 command API allows you to send requests to D3 SOAR to execute this utility command via REST API.

Request

POST

CODE

https:/{base_url}/{api_namespace}/api/Command/ExtractArtifactsFromExcel

Headers

Please refer to the page Webhook Configuration Guide - Authentication Method: API Keys for more details.

Request Body

JSON

{
  "Username": <Username here>,
  "Site": <Site here>,
  "CommandParams": {
    "File Id": <File Id here>,
    "File Source": <File Source here>,
  }
}

Body Parameters

Parameter Name	Type	Required/Optional	Description
Username	`string`	Required	The username of your D3 SOAR account.
Site	`string`	Required	The D3 SOAR site to run the remote command.
File Id	`integer`	Required	Id of the file to get artifact
File Source	`string`	Required	Source of the file

Sample Request

SAMPLE DATA

JSON

{
  "Username": "Admin",
  "Site": "Security Operations",
  "CommandParams": {
    "File Id": 925,
    "File Source": "Incident Attachment File"
  }
}

Response

Response Fields

Field Name	Type	Description
error	`string`	The error message if the API request has failed.
returnData	`string`	The return data from the API request.
contextData	`JSON Object`	The context data from the API request.

Sample Response

JSON

{
    "error": "",
    "returnData": "Successful",
    "contextData": {
      "ip": [
          "1.1.1.1"
      ],
      "url": [
          "https://www.d3security.com",
          "https://www.google.com/"
      ],
      "domain": [
          "www.d3security.com",
          "www.google.com"
      ],
      "md5": [
          "e6fd84aeddfeb04a45698535edb9adf6"
      ],
      "sha256": [
          "b88124f01bd245056920867df287d1ac8b5ffead5fde8492ccffbcb53b84d70a"
      ],
      "sha1": [
          "b48b238c0d36a1ab1506d72b3258af622f75db49"
      ],
      "emailaddress": [
          "test@mail.com"
      ]
    }
}