Module - Cloud Files Management (Microsoft OneDrive and SharePoint)

Sample Code:

const info = await irpa_365online.fileManagement.getRemoteFileInformation('https://sap.sharepoint.com/:x:/r/sites/321365/My%20Path/08_Product_Development/myFile.xlsx?d=w30ff232031bc40...dc7c1c2be50&csf=1&web=1&e=MmD8gw');

Note:

This activity is useful to get driveId and fileId from a source url. driveId and fileId are used by many activities in Microsoft 365 Online SDK.

Sample Code:

const info = await irpa_365online.fileManagement.getRemoteFolderInformation('https://compagny.sharepoint.com/:f:/r/sites/1234/Shared%20Documents/Customers');

Note:

This activity is useful to get driveId and folderId from a source url. driveId and folderId are used by many activities in Microsoft 365 Online SDK.

Note:

OneNote files are considered as folders in Microsoft file system.

Sample Code:

// get root files from local drive const list = await irpa_365online.fileManagement.getFilesFromRemoteFolder('');

Sample Code:

// get root files from remote drive const list = await irpa_365online.fileManagement.getFilesFromRemoteFolder('myDriveId');

Sample Code:

// get children of test/myFolder folder from local drive const list = await irpa_365online.fileManagement.getFilesFromRemoteFolder(undefined, 'test/myFolder');

Sample Code:

await irpa_365online.fileManagement.downloadFile(undefined, 'download.xlsx', 'C:\\myFolder\\download.xlsx');

Sample Code:

await irpa_365online.fileManagement.createFile(undefined, 'myFolder', 'myWorkbook.xlsx', irpa_365online.enums.fileTypes.workbook);

Sample Code:

await irpa_365online.fileManagement.copyOrMoveFile({driveId: undefined, pathOrFileId: "file.txt"}, {path: "folder", driveId: undefined}, true, true);

Sample Code:

await irpa_365online.fileManagement.uploadFile(undefined, 'myFolder', 'C:\\myFolder\\upload.xlsx');

Sample Code:

// delete a file located on a remote drive designated by its id and its file id await irpa_365online.fileManagement.deleteFile('myDriveId', 'myfileId');

Sample Code:

// file located on the local onedrive, accessed by the file id await irpa_365online.fileManagement.deleteFile(undefined, 'myfileId');

Sample Code:

// file located on the local onedrive, accessed by the file path await irpa_365online.fileManagement.deleteFile(undefined, 'test/myfile.txt');

Sample Code:

// delete a folder located on a remote drive designated by its id await irpa_365online.fileManagement.deleteFolder('myDriveId', 'myFiles');

Sample Code:

// delete a folder and its content, located on a remote drive designated by its id await irpa_365online.fileManagement.deleteFolder('myDriveId', 'myFiles', true);

Sample Code:

// delete a folder located on the local onedrive await irpa_365online.fileManagement.deleteFolder(undefined, 'myFiles');

Sample Code:

// Give read/write access to user1@company.com on a remote file described by its path. The user will receive a mail with the given message. await irpa_365online.fileManagement.shareContent('someDriveId', 'myFiles/someFile.xlsx', ['user1@company.com'], enums.accessTypes.readWrite, 'This file has been shared with you');

Sample Code:

// Give read only access to user1@company.com on a remote folder described by its path. The user will not receive a mail. await irpa_365online.fileManagement.shareContent('someDriveId', 'myFiles/subFolder', ['user1@company.com'], enums.accessTypes.readOnly);

Sample Code:

// Remove access to user1@company.com on a local file described by its path. The user will not receive a mail. await irpa_365online.fileManagement.shareContent(undefined, 'myFiles/someFile.xlsx', ['user1@company.com'], enums.accessTypes.noAccess);

Note:

For a given user, if the Share Content activity is applied on a folder, the accessType is given recursively, except if the user has already no access to the folder and a noAccess is required.

Note:

If a permission on a file or a folder has been previously given to a user through a share link, that permission will be overriden only if the share link is used only by that user.