[ 1 Integration with Devo SOAR ] [ 1.1 Prerequisites: ] [ 1.2 Connect Sharepoint with Devo SOAR ] [ 2 Actions for Sharepoint ] [ 2.1 Download File ] [ 2.1.1 Input Field ] [ 2.1.2 Output ] [ 3 Release Notes ]

Sharepoint empowers teamwork with dynamic and productive team sites for every project team, department, and division. Share files, data, news, and resources. Customize your site to streamline your team's work. Collaborate effortlessly and securely with team members inside and outside your organization, across PCs, Macs, and mobile devices.

Integration with Devo SOAR

Prerequisites:

Ensure that the Azure app you're connecting (by providing the Client ID below) has a Client Secret in Certificates and secrets tab of the Azure app. If not, generate and keep it.
Grant "admin consent" to whatever API permissions you've added to the app. Ensure that at least the following API permission is added for establishing the connection as well as Upload and Download File.

Connect Sharepoint with Devo SOAR

Navigate to Automations > Integrations.
Search for Sharepoint.
Click Details, then the + icon. Enter the required information in the following fields.
Label: Enter a connection name.
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.
Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
Remote Agent: Run this integration using the Devo SOAR Remote Agent.
Client ID: AppId for the registered app in Azure AD.
Client Secret: Key assigned for connection in Azure AD.
TenantId: Tenant ID of your app.
After you've entered all the details, click Connect.

Actions for Sharepoint

Download File

Download file action downloads the specified file by file name supplied as input.

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
File ID column name	Column name from parent table containing parent_folder and file name.
Example: `fol1/fol2/main_file.png`	Required

Output

A JSON object containing multiple rows of result:

has_error: True/False
error: message/null
file_id: local Devo SOAR file-id

``` {json}{ "file_id": "04d717dd33114e57a2e73583ecdcdedc", "has_error": false, "error": null }


## Upload File

Upload file action uploads a new file or overwrites if already exists.

### 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 |
| :----------------------------- | :-------------------------------------------------------------------- | :------- |
| File ID column name            | Column name from parent table containing Devo SOAR file id.            | Required |
| Parent folder path column name | Column name from parent table containing parent folder path in Azure. | Required |

### Output

A JSON object containing multiple rows of result:

- has_error: True/False
- error: message/null
- other keys of response json


``` {json}{
  "parentReference": {
    "driveId": "b!3o5V7bolVUGdq1xFZKId9_Y_kERXXoZMtoUfNtmtlMEivaKUmJ4ASpcHPA4kCZAA",
    "driveType": "documentLibrary",
    "id": "013ZLLN6Z5KPG7ZDI3NFGLZ3TNF5BZD722",
    "path": "/drive/root:/load_test"
  },
  "cTag": "\"c:{A319F30C-18D1-4126-AA37-741BFB898E0D},1\"",
  "lastModifiedDateTime": "2020-12-15T16:56:54Z",
  "error": null,
  "name": "8cbae96752ac44a58f54f63ddcb5a73d",
  "createdDateTime": "2020-12-15T16:56:54Z",
  "webUrl": "https://logichubdevnet.sharepoint.com/Shared%20Documents/load_test/8cbae96752ac44a58f54f63ddcb5a73d",
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('logichubdevnet.sharepoint.com%2Ced558ede-25ba-4155-9dab-5c4564a21df7%2C44903ff6-5e57-4c86-b685-1f36d9ad94c1')/drive/items/$entity",
  "fileSystemInfo": {
    "createdDateTime": "2020-12-15T16:56:54Z",
    "lastModifiedDateTime": "2020-12-15T16:56:54Z"
  },
  "lastModifiedBy": {
    "application": {
      "displayName": "MS Graph test app",
      "id": "9aeecc9f-db28-485b-b21a-f8c4ec112155"
    }
  },
  "has_error": false,
  "eTag": "\"{A319F30C-18D1-4126-AA37-741BFB898E0D},1\"",
  "createdBy": {
    "application": {
      "displayName": "MS Graph test app",
      "id": "9aeecc9f-db28-485b-b21a-f8c4ec112155"
    }
  },
  "@microsoft.graph.downloadUrl": "https://logichubdevnet.sharepoint.com/_layouts/15/download.aspx?UniqueId=a319f30c-18d1-4126-aa37-741bfb898e0d&amp;Translate=false&amp;tempauth=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvbG9naWNodWJkZXZuZXQuc2hhcmVwb2ludC5jb21AODBhMzYxNzMtOWU0Yy00N2FlLWI1YWUtNGQ1ZmQ4ZjRiNjU3IiwiaXNzIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwIiwibmJmIjoiMTYwODA1MTQxNCIsImV4cCI6IjE2MDgwNTUwMTQiLCJlbmRwb2ludHVybCI6IlFyUGduSGR5YTg0QUdvaklRTzhZZXhxY3VtSFJTK05lYUtTTW91ZFJSUzA9IiwiZW5kcG9pbnR1cmxMZW5ndGgiOiIxMjUiLCJpc2xvb3BiYWNrIjoiVHJ1ZSIsImNpZCI6IllqRTRNbVEzT0RrdFpXUTFZaTAwWmpRekxXSmpObUl0TUdZM01XVXdabUV5TlRnNCIsInZlciI6Imhhc2hlZHByb29mdG9rZW4iLCJzaXRlaWQiOiJaV1ExTlRobFpHVXRNalZpWVMwME1UVTFMVGxrWVdJdE5XTTBOVFkwWVRJeFpHWTMiLCJhcHBfZGlzcGxheW5hbWUiOiJNUyBHcmFwaCB0ZXN0IGFwcCIsIm5hbWVpZCI6IjlhZWVjYzlmLWRiMjgtNDg1Yi1iMjFhLWY4YzRlYzExMjE1NUA4MGEzNjE3My05ZTRjLTQ3YWUtYjVhZS00ZDVmZDhmNGI2NTciLCJyb2xlcyI6ImFsbHNpdGVzLnJlYWQgYWxsZmlsZXMud3JpdGUgYWxscHJvZmlsZXMud3JpdGUiLCJ0dCI6IjEiLCJ1c2VQZXJzaXN0ZW50Q29va2llIjpudWxsfQ.Q2FmZ3lXNHVDbnZkcUY3UjZpNGppeEdkNVFJN1JZY1N4c05sUXRpT25EOD0&amp;ApiVersion=2.0",
  "file": {
    "mimeType": "",
    "hashes": {
      "quickXorHash": "9yhFp1gA+DTkpz7X2p4iLcBmDp4="
    }
  },
  "id": "013ZLLN6YM6MM2HUIYEZA2UN3UDP5YTDQN",
  "size": 319
}

Release Notes

v2.0.0 - Updated architecture to support IO via filesystem