Sharepoint

Version: 2.0.0

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 LogicHub

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.
2942

Connect Sharepoint with LogicHub

  1. Navigate to Automations > Integrations.
  2. Search for Sharepoint.
  3. 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 LogicHub 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.
  4. 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 NameDescriptionRequired
File ID column nameColumn 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 LogicHub file-id
{
  "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 NameDescriptionRequired
File ID column nameColumn name from parent table containing LogicHub file id.Required
Parent folder path column nameColumn 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
{
  "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&Translate=false&tempauth=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvbG9naWNodWJkZXZuZXQuc2hhcmVwb2ludC5jb21AODBhMzYxNzMtOWU0Yy00N2FlLWI1YWUtNGQ1ZmQ4ZjRiNjU3IiwiaXNzIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwIiwibmJmIjoiMTYwODA1MTQxNCIsImV4cCI6IjE2MDgwNTUwMTQiLCJlbmRwb2ludHVybCI6IlFyUGduSGR5YTg0QUdvaklRTzhZZXhxY3VtSFJTK05lYUtTTW91ZFJSUzA9IiwiZW5kcG9pbnR1cmxMZW5ndGgiOiIxMjUiLCJpc2xvb3BiYWNrIjoiVHJ1ZSIsImNpZCI6IllqRTRNbVEzT0RrdFpXUTFZaTAwWmpRekxXSmpObUl0TUdZM01XVXdabUV5TlRnNCIsInZlciI6Imhhc2hlZHByb29mdG9rZW4iLCJzaXRlaWQiOiJaV1ExTlRobFpHVXRNalZpWVMwME1UVTFMVGxrWVdJdE5XTTBOVFkwWVRJeFpHWTMiLCJhcHBfZGlzcGxheW5hbWUiOiJNUyBHcmFwaCB0ZXN0IGFwcCIsIm5hbWVpZCI6IjlhZWVjYzlmLWRiMjgtNDg1Yi1iMjFhLWY4YzRlYzExMjE1NUA4MGEzNjE3My05ZTRjLTQ3YWUtYjVhZS00ZDVmZDhmNGI2NTciLCJyb2xlcyI6ImFsbHNpdGVzLnJlYWQgYWxsZmlsZXMud3JpdGUgYWxscHJvZmlsZXMud3JpdGUiLCJ0dCI6IjEiLCJ1c2VQZXJzaXN0ZW50Q29va2llIjpudWxsfQ.Q2FmZ3lXNHVDbnZkcUY3UjZpNGppeEdkNVFJN1JZY1N4c05sUXRpT25EOD0&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

© 2017-2021 LogicHub®. All Rights Reserved.