Codeunit 9101 SharePoint Client Impl.
src/System Application/App/SharePoint/src/SharePointClientImpl.Codeunit.al967 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Integration.Sharepoint;using System.Utilities;codeunit 9101 "SharePoint Client Impl."{ Access = Internal; InherentEntitlements = X; InherentPermissions = X; var SharePointUriBuilder: Codeunit "SharePoint Uri Builder"; SharePointRequestHelper: Codeunit "SharePoint Request Helper"; SharePointOperationResponse: Codeunit "SharePoint Operation Response"; Authorization: Interface "SharePoint Authorization"; ReadResponseFailedErr: Label 'Could not read response.'; IncorrectResponseErr: Label 'Incorrect response.'; IncorrectResponseLogErr: Label 'Incorrect request digest response: %1.', Comment = '%1 = the response text', Locked = true; SharePointCategoryLbl: Label 'AL SharePoint', Locked = true; procedure Initialize(BaseUrl: Text; Auth: Interface "SharePoint Authorization") begin SharePointUriBuilder.Initialize(BaseUrl, 'Web'); SharePointUriBuilder.ResetPath(); Authorization := Auth; end; procedure Initialize(BaseUrl: Text; Namespace: Text; Auth: Interface "SharePoint Authorization") begin SharePointUriBuilder.Initialize(BaseUrl, Namespace); SharePointUriBuilder.ResetPath(); Authorization := Auth; end; procedure GetDiagnostics(): Interface "HTTP Diagnostics" begin exit(SharePointOperationResponse.GetDiagnostics()); end; local procedure GetRequestDigest(BaseUrl: Text): Text var NewSharePointOperationResponse: Codeunit "SharePoint Operation Response"; NewSharePointUriBuilder: Codeunit "SharePoint Uri Builder"; Context: JsonToken; Result: Text; begin NewSharePointUriBuilder.Initialize(BaseUrl, 'contextinfo'); SharePointRequestHelper.SetAuthorization(Authorization); NewSharePointOperationResponse := SharePointRequestHelper.Post(NewSharePointUriBuilder); if NewSharePointOperationResponse.GetResultAsText(Result) then begin Context.ReadFrom(Result); if not Context.AsObject().Get('d', Context) then begin Session.LogMessage('00001SPC', StrSubstNo(IncorrectResponseLogErr, Result), Verbosity::Normal, DataClassification::CustomerContent, TelemetryScope::ExtensionPublisher, 'Category', SharePointCategoryLbl); Error(IncorrectResponseErr); end; if not Context.AsObject().Get('GetContextWebInformation', Context) then begin Session.LogMessage('00002SPC', StrSubstNo(IncorrectResponseLogErr, Result), Verbosity::Normal, DataClassification::CustomerContent, TelemetryScope::ExtensionPublisher, 'Category', SharePointCategoryLbl); Error(IncorrectResponseErr); end; if not Context.AsObject().Get('FormDigestValue', Context) then begin Session.LogMessage('00003SPC', StrSubstNo(IncorrectResponseLogErr, Result), Verbosity::Normal, DataClassification::CustomerContent, TelemetryScope::ExtensionPublisher, 'Category', SharePointCategoryLbl); Error(IncorrectResponseErr); end; exit(Context.AsValue().AsText()); end else Error(ReadResponseFailedErr); end; #region Lists procedure GetLists(var SharePointList: Record "SharePoint List"): Boolean var SharePointListParser: Codeunit "SharePoint List"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListParser.Parse(Result, SharePointList); exit(true); end; procedure GetListItems(ListTitle: Text; var SharePointListItem: Record "SharePoint List Item"): Boolean var SharePointListItemParser: Codeunit "SharePoint List Item"; Result: Text; begin //GET https://{site_url}/_api/web/lists/GetByTitle('Test')/items SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetObject('items'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemParser.Parse(Result, SharePointListItem); exit(true); end; procedure GetListItems(ListId: Guid; var SharePointListItem: Record "SharePoint List Item"): Boolean var SharePointListItemParser: Codeunit "SharePoint List Item"; Result: Text; begin //GET https://{site_url}/_api/web/lists(guid'{list_guid}')/items SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetObject('items'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemParser.Parse(Result, SharePointListItem); exit(true); end; procedure GetListItemAttachments(ListTitle: Text; ListItemId: Integer; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; Result: Text; begin //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item+id})/AttachmentFiles/ SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.Parse(Result, SharePointListItemAtch); exit(true); end; procedure GetListItemAttachments(ListId: Guid; ListItemId: Integer; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; Result: Text; begin //GET https://{site_url}/_api/web/lists(guid'{list_guid}')/items({item+id})/AttachmentFiles/ SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.Parse(Result, SharePointListItemAtch); exit(true); end; procedure DownloadListItemAttachmentContent(ListTitle: Text; ListItemId: Integer; FileName: Text): Boolean var FileInStream: InStream; begin //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetMethod('AttachmentFiles', FileName); SharePointUriBuilder.SetObject('$value'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); DownloadFromStream(FileInStream, '', '', '', FileName); exit(true); end; procedure DownloadListItemAttachmentContent(ListId: Guid; ListItemId: Integer; FileName: Text): Boolean var FileInStream: InStream; begin //GET https://{site_url}/_api/web/lists(guid'{list_guid}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetMethod('AttachmentFiles', FileName); SharePointUriBuilder.SetObject('$value'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); DownloadFromStream(FileInStream, '', '', '', FileName); exit(true); end; procedure DownloadListItemAttachmentContent(OdataId: Text): Boolean var FileInStream: InStream; FileName: Text; begin //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(OdataId); SharePointUriBuilder.SetObject('$value'); FileName := SharePointUriBuilder.GetMethodParameter('AttachmentFiles'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); DownloadFromStream(FileInStream, '', '', '', FileName); exit(true); end; procedure CreateListItemAttachment(ListTitle: Text; ListItemId: Integer; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; FileName: Text; FileInStream: InStream; Result: Text; begin if not UploadIntoStream('', '', '', FileName, FileInStream) then exit; //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointUriBuilder.SetMethod('add', 'FileName', '''' + FileName + ''''); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.ParseSingleReturnValue(Result, SharePointListItemAtch); exit(true); end; procedure CreateListItemAttachment(ListId: Guid; ListItemId: Integer; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; FileName: Text; FileInStream: InStream; Result: Text; begin if not UploadIntoStream('', '', '', FileName, FileInStream) then exit; //GET https://{site_url}/_api/web/lists(guid'{list_guid}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointUriBuilder.SetMethod('add', 'FileName', '''' + FileName + ''''); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.ParseSingleReturnValue(Result, SharePointListItemAtch); exit(true); end; procedure CreateListItemAttachment(ListTitle: Text; ListItemId: Integer; FileName: Text; var FileInStream: InStream; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; Result: Text; begin //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointUriBuilder.SetMethod('add', 'FileName', '''' + FileName + ''''); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.ParseSingleReturnValue(Result, SharePointListItemAtch); exit(true); end; procedure CreateListItemAttachment(ListId: Guid; ListItemId: Integer; FileName: Text; var FileInStream: InStream; var SharePointListItemAtch: Record "SharePoint List Item Atch"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemAtchParser: Codeunit "SharePoint List Item Atch."; Result: Text; begin //GET https://{site_url}/_api/web/lists(guid'{list_guid}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetMethod('Items', ListItemId); SharePointUriBuilder.SetObject('AttachmentFiles'); SharePointUriBuilder.SetMethod('add', 'FileName', '''' + FileName + ''''); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemAtchParser.ParseSingleReturnValue(Result, SharePointListItemAtch); exit(true); end; procedure CreateList(ListTitle: Text; ListDescription: Text; var SharePointList: Record "SharePoint List"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListParser: Codeunit "SharePoint List"; Request, Metadata : JsonObject; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); Metadata.Add('type', 'SP.List'); Request.Add('__metadata', Metadata); Request.Add('AllowContentTypes', true); Request.Add('BaseTemplate', 100); Request.Add('ContentTypesEnabled', true); Request.Add('Description', ListDescription); Request.Add('Title', ListTitle); SharePointHttpContent.FromJson(Request); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListParser.ParseSingleReturnValue(Result, SharePointList); exit(true); end; procedure CreateListItem(ListTitle: Text; ListItemEntityTypeFullName: Text; ListItemTitle: Text; var SharePointListItem: Record "SharePoint List Item"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemParser: Codeunit "SharePoint List Item"; Request, Metadata : JsonObject; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetObject('items'); Metadata.Add('type', ListItemEntityTypeFullName); Request.Add('__metadata', Metadata); Request.Add('Title', ListItemTitle); SharePointHttpContent.FromJson(Request); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemParser.ParseSingleReturnValue(Result, SharePointListItem); exit(true); end; procedure CreateListItem(ListId: Guid; ListItemEntityTypeFullName: Text; ListItemTitle: Text; var SharePointListItem: Record "SharePoint List Item"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointListItemParser: Codeunit "SharePoint List Item"; Request, Metadata : JsonObject; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetObject('items'); Metadata.Add('type', ListItemEntityTypeFullName); Request.Add('__metadata', Metadata); Request.Add('Title', ListItemTitle); SharePointHttpContent.FromJson(Request); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointListItemParser.ParseSingleReturnValue(Result, SharePointListItem); exit(true); end; #endregion #region Folders procedure GetSubFoldersByServerRelativeUrl(ServerRelativeUrl: Text; var SharePointFolder: Record "SharePoint Folder"): Boolean var SharePointFolderParser: Codeunit "SharePoint Folder"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('Folders'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFolderParser.Parse(Result, SharePointFolder); exit(true); end; internal procedure GetSubFoldersByServerRelativePath(ServerRelativePath: Text; var SharePointFolder: Record "SharePoint Folder"): Boolean var SharePointFolderParser: Codeunit "SharePoint Folder"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFolderByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointUriBuilder.SetObject('Folders'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFolderParser.Parse(Result, SharePointFolder); exit(true); end; procedure GetFolderFilesByServerRelativeUrl(ServerRelativeUrl: Text; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('Files'); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.Parse(Result, SharePointFile); exit(true); end; internal procedure GetFolderFilesByServerRelativePath(ServerRelativePath: Text; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFolderByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointUriBuilder.SetObject('Files'); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.Parse(Result, SharePointFile); exit(true); end; procedure GetFileByServerRelativeUrl(ServerRelativeUrl: Text; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFileByServerRelativeUrl', ServerRelativeUrl); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.ParseSingle(Result, SharePointFile); exit(true); end; procedure DownloadFileContent(OdataId: Text; var FileInStream: InStream): Boolean begin //GET https://{site_url}/_api/web/GetFileByServerRelativeUrl('/Folder Name/{file_name}')/$value SharePointUriBuilder.ResetPath(OdataId); SharePointUriBuilder.SetObject('$value'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); exit(true); end; procedure DownloadFileContent(OdataId: Text; FileName: Text): Boolean var FileInStream: InStream; begin if not DownloadFileContent(OdataId, FileInStream) then exit(false); DownloadFromStream(FileInStream, '', '', '', FileName); exit(true); end; procedure DownloadFileContent(OdataId: Text; var TempBlob: Codeunit "Temp Blob"): Boolean var FileInStream: InStream; FileOutStream: OutStream; begin if not DownloadFileContent(OdataId, FileInStream) then exit(false); TempBlob.CreateOutStream(FileOutStream); CopyStream(FileOutStream, FileInStream); exit(true); end; procedure DownloadFileContentByServerRelativeUrl(ServerRelativeUrl: Text; var FileInStream: InStream): Boolean begin //GET https://{site_url}/_api/web/GetFileByServerRelativeUrl('/Folder Name/{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFileByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('$value'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); exit(true); end; procedure DownloadFileContentByServerRelativeUrl(ServerRelativeUrl: Text; FileName: Text): Boolean var FileInStream: InStream; begin if not DownloadFileContentByServerRelativeUrl(ServerRelativeUrl, FileInStream) then exit(false); DownloadFromStream(FileInStream, '', '', '', FileName); exit(true); end; procedure DownloadFileContentByServerRelativeUrl(ServerRelativeUrl: Text; var TempBlob: Codeunit "Temp Blob"): Boolean var FileInStream: InStream; FileOutStream: OutStream; begin if not DownloadFileContentByServerRelativeUrl(ServerRelativeUrl, FileInStream) then exit(false); TempBlob.CreateOutStream(FileOutStream); CopyStream(FileOutStream, FileInStream); exit(true); end; internal procedure DownloadFileContentByServerRelativePath(ServerRelativePath: Text; var FileInStream: InStream): Boolean begin // GET https://{site_url}/_api/web/GetFileByServerRelativePath(decodedurl='/Folder/File#1%.pdf')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFileByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointUriBuilder.SetObject('$value'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsStream(FileInStream); exit(true); end; procedure DeleteFile(OdataId: Text): Boolean begin //DELETE https://{site_url}/_api/web/GetFileByServerRelativeUrl('/Folder Name/{file_name}') SharePointUriBuilder.ResetPath(OdataId); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; procedure DeleteFileByServerRelativeUrl(ServerRelativeUrl: Text): Boolean begin //DELETE https://{site_url}/_api/web/GetFileByServerRelativeUrl('/Folder Name/{file_name}') SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFileByServerRelativeUrl', ServerRelativeUrl); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; internal procedure DeleteFileByServerRelativePath(ServerRelativePath: Text): Boolean begin // DELETE https://{site_url}/_api/web/GetFileByServerRelativePath(decodedurl='/Folder/File#1%.pdf') SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFileByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; procedure GetDocumentLibraryRootFolder(OdataID: Text; var SharePointFolder: Record "SharePoint Folder"): Boolean var SharePointFolderParser: Codeunit "SharePoint Folder"; Result: Text; begin SharePointUriBuilder.ResetPath(OdataID); SharePointUriBuilder.SetObject('rootfolder'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFolderParser.ParseSingle(Result, SharePointFolder); exit(true); end; procedure CreateFolder(ServerRelativeUrl: Text; var SharePointFolder: Record "SharePoint Folder"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointFolderParser: Codeunit "SharePoint Folder"; Request, Metadata : JsonObject; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('folders'); Metadata.Add('type', 'SP.Folder'); Request.Add('__metadata', Metadata); Request.Add('ServerRelativeUrl', ServerRelativeUrl); SharePointHttpContent.FromJson(Request); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFolderParser.ParseSingleReturnValue(Result, SharePointFolder); exit(true); end; internal procedure CreateFolderByServerRelativePath(ServerRelativePath: Text; var SharePointFolder: Record "SharePoint Folder"): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; SharePointFolderParser: Codeunit "SharePoint Folder"; EmptyRequest: JsonObject; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('Folders'); SharePointUriBuilder.SetMethodWithNamedTextParameter('AddUsingPath', 'decodedurl', ServerRelativePath); SharePointHttpContent.FromJson(EmptyRequest); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFolderParser.ParseSingleReturnValue(Result, SharePointFolder); exit(true); end; procedure FolderExistsByServerRelativeUrl(ServerRelativeUrl: Text): Boolean var Result: Text; FolderExists: Boolean; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('Exists'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); ParseFolderExistsByServerRelativeUrlResult(Result, FolderExists); exit(FolderExists); end; internal procedure FolderExistsByServerRelativePath(ServerRelativePath: Text): Boolean var Result: Text; FolderExists: Boolean; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFolderByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointUriBuilder.SetObject('Exists'); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Get(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); ParseFolderExistsByServerRelativeUrlResult(Result, FolderExists); exit(FolderExists); end; procedure DeleteFolder(OdataId: Text): Boolean begin //DELETE https://{site_url}/_api/web/GetFolderByServerRelativeUrl('{folder_name}') SharePointUriBuilder.ResetPath(OdataId); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; procedure DeleteFolderByServerRelativeUrl(ServerRelativeUrl: Text): Boolean begin //DELETE https://{site_url}/_api/web/GetFolderByServerRelativeUrl('{folder_name}') SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; internal procedure DeleteFolderByServerRelativePath(ServerRelativePath: Text): Boolean begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFolderByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Delete(SharePointUriBuilder); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); exit(true); end; procedure AddFileToFolder(ServerRelativeUrl: Text; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; SharePointHttpContent: Codeunit "SharePoint Http Content"; FileName: Text; FileInStream: InStream; Result: Text; begin if not UploadIntoStream('', '', '', FileName, FileInStream) then exit; //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('Files'); SharePointUriBuilder.SetMethod('add', 'url', '''' + FileName + ''''); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.ParseSingleReturnValue(Result, SharePointFile); exit(true); end; procedure AddFileToFolder(ServerRelativeUrl: Text; FileName: Text; var FileInStream: InStream; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; SharePointHttpContent: Codeunit "SharePoint Http Content"; Result: Text; begin //GET https://{site_url}/_api/web/lists/getbytitle('{list_title}')/items({item_id})/AttachmentFiles('{file_name}')/$value SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('GetFolderByServerRelativeUrl', ServerRelativeUrl); SharePointUriBuilder.SetObject('Files'); SharePointUriBuilder.SetMethod('add', 'url', '''' + FileName + ''''); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.ParseSingleReturnValue(Result, SharePointFile); exit(true); end; internal procedure AddFileToFolderByServerRelativePath(ServerRelativePath: Text; FileName: Text; var FileInStream: InStream; var SharePointFile: Record "SharePoint File" temporary; ListAllFields: Boolean): Boolean var SharePointFileParser: Codeunit "SharePoint File"; SharePointHttpContent: Codeunit "SharePoint Http Content"; Result: Text; begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethodWithNamedTextParameter('GetFolderByServerRelativePath', 'decodedurl', ServerRelativePath); SharePointUriBuilder.SetObject('Files'); SharePointUriBuilder.SetMethodWithNamedTextAndBooleanParameters('AddUsingPath', 'decodedurl', FileName, 'overwrite', false); if ListAllFields then SharePointUriBuilder.AddQueryParameter('$expand', 'ListItemAllFields'); SharePointHttpContent.FromFileInStream(FileInStream); SharePointRequestHelper.SetAuthorization(Authorization); SharePointOperationResponse := SharePointRequestHelper.Post(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Result); SharePointFileParser.ParseSingleReturnValue(Result, SharePointFile); exit(true); end; procedure UpdateListItemMetaDataField(ListTitle: Text; ItemId: Integer; ListItemEntityTypeFullName: Text; FieldName: Text; FieldValue: Text): Boolean begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetObject('lists'); SharePointUriBuilder.SetMethod('GetByTitle', ListTitle); SharePointUriBuilder.SetMethod('items', ItemId); exit(UpdateListItemMetaDataField(ListItemEntityTypeFullName, FieldName, FieldValue)); end; procedure UpdateListItemMetaDataField(ListId: Guid; ItemId: Integer; ListItemEntityTypeFullName: Text; FieldName: Text; FieldValue: Text): Boolean begin SharePointUriBuilder.ResetPath(); SharePointUriBuilder.SetMethod('Lists', ListId); SharePointUriBuilder.SetMethod('items', ItemId); exit(UpdateListItemMetaDataField(ListItemEntityTypeFullName, FieldName, FieldValue)); end; local procedure UpdateListItemMetaDataField(ListItemEntityTypeFullName: Text; FieldName: Text; FieldValue: Text): Boolean var SharePointHttpContent: Codeunit "SharePoint Http Content"; Metadata, Payload : JsonObject; Txt: Text; begin Metadata.Add('type', ListItemEntityTypeFullName); Payload.Add('__metadata', Metadata); Payload.Add(FieldName, FieldValue); SharePointHttpContent.FromJson(Payload); SharePointHttpContent.GetContent().ReadAs(Txt); SharePointHttpContent.SetRequestDigest(GetRequestDigest(SharePointUriBuilder.GetSiteUrl())); SharePointHttpContent.SetXHttpMethod('MERGE'); SharePointHttpContent.SetIfMatch('*'); SharePointOperationResponse := SharePointRequestHelper.Patch(SharePointUriBuilder, SharePointHttpContent); if not SharePointOperationResponse.GetDiagnostics().IsSuccessStatusCode() then exit(false); SharePointOperationResponse.GetResultAsText(Txt); exit(true); end; local procedure ParseFolderExistsByServerRelativeUrlResult(Payload: Text; var FolderExists: Boolean) var JObject: JsonObject; JToken: JsonToken; begin if not JObject.ReadFrom(Payload) then exit; if not JObject.Get('value', JToken) then exit; if not JToken.IsValue() then exit; FolderExists := JToken.AsValue().AsBoolean(); end; #endregion}