SynchronizeFromSP

This function synchronizes List items data from SharePoint to NAV/BC.

Prerequisites:

Selected List Setup must be released and must have Synchronization Type field set to a value, that allows synchronization from SharePoint ("Replicate SP --> NAV" etc.).
You must set correct RapidStart package in the field Import Config. Package Code in the List Setup. See guideline How to synchronize List data from and to SharePoint.
Please note, that if you set SharePoint Record Conditions in the List Setup, they always apply (even if you use parameter _ManualSharePointTableLink).

Parameters:

"_SharePointListSetupCode" - Specifies the SharePoint list setup used for synchronization. The maximum number of characters is 20.
"_WorkFlowName" - Specifies the workflow name. Leave blank if you synchronize List data only.
"_FullLoad" - Specifies, if NavSherpa synchronizes all List items from SharePoint (from The Oldest Item Date in NavSherpa Setup, if applicable). If set to FALSE, NavSherpa will use the Last SharePoint Sync. Date/Time on SharePoint List Setup Card and download newer items only. Note: If you are using parameters _ModifiedFilterDateTime or _ManualSharePointTableLink, _FullLoad setting has no effect.
"_ModifiedFilterDateTime" - Specifies the date and time for filtering SharePoint List items. NavSherpa will synchronize only items modified after.
"_ManualSharePointTableLink" - Allows to set the SharePoint Record Conditions with code (see code example below).

List Setup Example:

Code Example:

This code synchronizes data from example Employees SharePoint List to NAV/BC. If there is a value set in EmployeeNoFilter variable, NavSherpa will filter the SharePoint data selection according to it.

//Set SharePoint query filters

SyncFromSPDateTime := CREATEDATETIME(081111D,020000T);

EmployeeNoFilter:='RL';

IF NOT TmpSharePointTableLink.ISTEMPORARY THEN

ERROR('TmpSharePoint link variable must be temporary.');

TmpSharePointTableLink.DELETEALL;

IF (EmployeeNoFilter<>'') THEN BEGIN

WITH TmpSharePointTableLink DO BEGIN

INIT;

"Entry No.":=10000;

"SP List Setup Code":=SharePointListSetupCode;

Type:=Type::SPRecordCondition;

"Lookup SP Column Internal Name":='EmployeeNo';

"Lookup SP Column Title":='EmployeeNo';

"Lookup SP Data Type":="Lookup SP Data Type"::Text;

"Source Table ID":=DATABASE::Employee;

"Value/Field Name":=EmployeeNoFilter;

INSERT;

END;

//Call the synchronization

NSPInterface.SynchronizeFromSP('EMPLOYEE_LIST','',TRUE,SyncFromSPDateTime,TmpSharePointTableLink);