Sharepoint

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.

Connecting with Sharepoint

To connect to Sharepoint following details are required:

  • Label: 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.
  • 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.

Actions with Sharepoint

Download File

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

Inputs to this Action:

  • Connection: Choose a connection that you have created.
  • File ID column name: Column name from parent table containing parent_folder and file name Example: fol1/fol2/main_file.png

Output of Action:
correlated rows of result json containing following items:

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

Inputs to this Action:

  • Connection: Choose a connection that you have created.
  • File ID column name: Column name from parent table containing LogicHub file id
  • Parent folder path column name: Column name from parent table containing parent folder path in Azure

Output of Action:
correlated rows of result json containing following items:

  • 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
}

Did this page help you?