Skip to content
background-image background-image

Microsoft Sharepoint O365 Create Folder

[ | version 3.3]

Connector

The connector is permitted for use of the platform background agent.

Connector processing type: Row by row!

This connector allows to create new folders on Microsoft Sharepoint O365 through Graph API. More information in documentation.

Required Microsoft Graph API Application permissions

  • Files.ReadWrite.All
  • Sites.ReadWrite.All

Site and Drive

One of configuration options are Site and Drive.

Site can be just company sharepoint intelstudios.sharepoint.com but it can also contain sub sites. In web URL it can be behind sites path e.g. https://intelstudios.sharepoint.com/sites/DEV... which shows sub site name DEV. In this case Site configuration attribute will be specified as intelstudios.sharepoint.com/DEV of DEV if DEV sub site is needed.

Site have data unit/s named drive which is another part of URL behind site or sub site. Typical example is Documents but is a little tricky because in URL it is displayed as Shared%20Documents, e.g. intelstudios.sharepoint.com/sites/DEV/Shared%20Documents. Other drives have usually same name as in URL.

But when site or drive is specified incorrectly connector will print available names to error message which can help to configure it.

Example

Just for example how you can make input for this connector by JS Mapper connector as step before. In Directory attribute is path to folder where new folder is created.

return
[
    {
        "Directory":'/folder/subfolder', 
        "Name": 'testFolder'
    }
]

Configuration

Azure Auhtentication configuration

Prerequisites

To successfully use this configuration, you must have defined Application registration on your Tenant ID Instance on https://portal.azure.com:

  1. Open Microsoft Azure portal.
  2. Go to Manage Azure Active Directory for your Tenant ID.
  3. Click on App registrations on the left side menu.
  4. Click on New registration:
    1. Fill Name
    2. Set Supported account types to Accounts in this organizational directory only (Single tenant)
    3. Click on Register button
  5. When App registration already exists click on existing app registration in list
  6. Click on Authentication on the left side menu:
    1. Check ID tokens (used for implicit and hybrid flows) property.
  7. Click on API permissions on the left side menu:
    1. Click on Add a permission
    2. Select Microsoft Graph tile from Microsoft APIs on the right side menu:
      1. Select Application permissions.
      2. Check corresponding API permissions.
      3. Click on Add permissions button.
    3. When its needed click on Grant admin consent button over assigned permissions list.
  8. Use filled properties from App registration application into configuration:
    1. Click on Certificates & secrets on the left side menu:
      1. Add new client secret value.
      2. Take this new created Value and insert it into Client Secret configuration property.
    2. From the Overview left side menu:
      1. Take Application (client) ID and insert value into Azure Client Application ID configuration property.
      2. Take Directory (tenant) ID and insert value into Tenant ID configuration property.

Azure Active Directory Instance

URL of AAD Instance that the authentication is provided.

https://login.windows.net/

Tenant ID

Tenant identifier that the data should be returned for. Is visible on azure portal https://portal.azure.com in application Overview in App registrations.

61e057ea-2890-4d8e-95af-f35789a661f0

Azure Client Application ID

The unique identifier for Azure Client Application. Is visible on azure portal https://portal.azure.com in application Overview in App registrations. The application must have defined API permissions for specific operations.

e0bd7921-1a85-4ed9-8bbe-77b9ebdbaa4f

Resource ID

ID of the resource to get the data.

https://graph.microsoft.com

Api Version

API Version.

Default: v1.0

Authentication Mode

Supported authentication modes

  • Username and password
  • Client secret

Username

Client user name

Password

Client password

Mailbox

Define Subscription Bind Mailbox which is used for emails processing.

Client Secret

Client secret

Sharepoint Site configuration

Site

Name of site or sub site.

Example

  • https://intelstudios.sharepoint.com
  • https://intelstudios.sharepoint.com/SubSiteName

Drive

Name of custom drive, empty will use root drive. Typical can be Documents. To find your specific DriveId use Microsoft Graph explorer

Example

  • b!dbzcQi3Vp0ap4vuJ7Pxo0U2JU6-0n2RBvWyDxr9XDLo8O0zSh0XESLUh8xzuXIcw
  • b!dbzcQi3Vp0ap4vuJ7Pxo0U2JU6-0n2RBvWyDxr9XDLqjKHPd7fh4S5eC-x9wESjl

Input & Output Schema

Input

Sharepoint O365 create folder input (ver. 1.0.1)

Column Data type Allow null Description
Directory string Yes Parent path for creating folder
Name string No Folder name
Example input data
Directory: string Name: string
/folder/subfolder testFolder

Output

Sharepoint O365 create folder output (ver. 1.0.0)

Column Data type Allow null Description
Id string No Id of created folder
Path string Yes Path to created folder
WebUrl string Yes Web URL of created folder
Example output data
Id: string Path: string WebUrl: string
01J62SXPGEVVQIB3KIEBEYOBXOAWWJMHAP /drives/b!dbzcQi3Vp0ap4vuJ7Pxo0U2JU6-0n2RBvWyDxr9XDLo8O0zSh0XESLUh8xzuXIcw/root:/testFolder https://intelstudios.sharepoint.com/Germany/testFolder

Release notes

3.5.0

  • Added new description and icon.

3.4.4

  • Fixed shared nuget package versions.

3.4.3

  • Fixed right processing of nullable properties.