Small and medium business | Business Central, N...

Sharepoint Connector (Create meta data in sharepoint) and Sync Job from BC to Sharepoint

(5) Share

Report

Posted on by MU-02050924-0

codeunit 9100 "SharePoint Client"
{
    Access = Public;
    var
        SharePointClientImpl: Codeunit "SharePoint Client Impl.";

In the SharePoint Connector for Business Central, is there a way to programmatically create SharePoint metadata columns (i.e., add custom columns to a document library) directly from AL code? Currently, the built-in codeunit only supports creating folders and uploading files, but not adding or managing metadata fields. Is there any supported approach or workaround to create and sync metadata columns between SharePoint and BC?

any other way?

What is the recommended approach to set up a bidirectional sync job where:

Data from BC is pushed to SharePoint (e.g., document metadata or structured data), and
Updates or files from SharePoint can be pulled back into BC automatically or on a schedule?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/application/system-application/codeunit/system.integration.sharepoint.sharepoint-client

https://blog.daniyalkhalid.com/2024/03/sync-data-business-central-and-sharepoint.html

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central Blog Series: Integrate Business Central with SharePoint | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
MU-02050924-0 16 on at

Like (1)

Report

Hi Guys,

Let me rephrase my question. I want to create metadata in sharepoint. Means, I want to create custom columns to a document library, directly from AL code. PFA Attached - I want to create REF column through BC code.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Sorry, I haven't tested this in detail, but from what I understand it's possible.

You can do it through the graph api below.

https://learn.microsoft.com/en-us/graph/api/filestoragecontainer-post-columns?view=graph-rest-beta&viewFallbackFrom=graph-rest-1.0&tabs=http

I recommend testing it through Postman first.

Thanks

ZHU

Was this reply helpful? Yes No
MU-02050924-0 16 on at

Like (0)

Report

Hi Yun Zhu,

I've tried implementing the solution, but unfortunately, I haven't been able to achieve the desired result. I was wondering if you could kindly take a look whenever you have a moment—your guidance would be incredibly helpful and greatly appreciated by myself and many in the Business Central AL developer community.

One of my connections also shared the following Microsoft API documentation, which might be useful in this context:

Working with folders and files with REST

Thanks in advance for your time and support!

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Adding MetaData to SharePoint Documents with the SharePoint Connector

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Sorry I haven't used the built-in code because of some limitations.
Some of my tests are done directly using Http methods, I think you can try it.

Dynamics 365 Business Central Blog Series: Integrate Business Central with SharePoint

https://yzhums.com/63735/

Thanks.

ZHU

Was this reply helpful? Yes No