File mover software: move, copy, delete your files with our filemover | Blog | ORDER NOW

Contact Us Now

[contact-form-7 id="1125" title="Contact form 1"]

File Mover Blog

11 Apr
How to use Microsoft Graph API with SharePoint as source and destination
Using Microsoft Graph API with SharePoint
On request we added support for Microsoft Graph as API method in version v2026.4.11.0. So, from this version on we support:
Sharepoint REST API (legacy)
Microsoft Graph API
Limagito FileMover Setup
Setup
Set Site Url and Directory
Select the Auth Type you will be using, check the previous blog articles:
Online Authentication (SPOIDCRL) > deprecated by Microsoft (fully disabled on May 1, 2026)
Classic Authentication (NTLM) > deprecated by Microsoft
Online Authentication using Client Credentials without User Dialog
Online Authentication using OAuth2
OAuth 2.0 authorization code flow
Set “Microsoft Graph API’ as API Method
OAuth2 setup:
Enable ‘Code Challenge’
Enable ‘Include Nonce’
Set ‘Authorization Endpoint URL’
https://login.microsoftonline.com/%realm/oauth2/v2.0/authorize
%realm will be replaced by the Realm value = Directory (tenant) ID. You can also enter the full URL including the Tenant.
Set ‘Token Endpoint URL’
https://login.microsoftonline.com/%realm/oauth2/v2.0/token
%realm will be replaced by the Realm value = Directory (tenant) ID. You can also enter the full URL including the Tenant.
Enter your Client ID and Client Secret (please check the article howto create them)
Azure > App Registrations > Select the App you created > Use ‘Application (client) ID’ as Client ID in Limagito SharePoint OAuth2 setup
Azure > Certificates & Secrets > Client secrets > Use ‘Value’ field as Client Secret in Limagito SharePoint OAuth2 setup
Set ‘Scope’ to: openid offline_access https://graph.microsoft.com/.default
Don’t forget to add “Sites.ReadWrite.All” to the Permissions in your Azure setup.
Permissions Type must be Delegated with “OAuth 2.0 authorization code flow”
Permissions Type must be Application with “Online Authentication using Client Credentials without User Dialog”
FYI: Delegated permissions, also called scopes, allow the application to act on behalf of the signed-in user.
An alternative could be: openid offline_access https://graph.microsoft.com/Sites.ReadWrite.All
Leave Resource empty
Leave Response Mode empty to omit the default response_mode “query” param.
Leave Response Type empty, this way the default value “code” will be used.
The Redirect URI should be http://localhost/ (and not https://localhost/)
Be sure to add the redirect URI in Azure too, combined with the Redirect Port in the example it would be: http://localhost:3017
Check if you selected “Web” as Redirect URI Type in Azure (do not use mobile & desktop or SPA)
RedirectPort, we used 3017
When using %realm in the ‘Authorization or Token Endpoint URL’
Please set ‘Realm’ to your Tenant of Tenant_ID
Azure App Registrations
Register an application > + New registration
Set Name, Single tenant and Web as Redirect URI
You’ll need the Application (Client) ID in the OAuth2 setup of Limagito File Mover. Also Directory (Tenant) ID will be used.
Depending on the ‘Authentication Type’ in Limagito File Mover, you’ll need a Redirect URI.
It is http://localhost:3017 and NOT https://
Summary:
Add a new client secret:
Set Client secret description and expire period:
IMPORTANT: we’ll need the Value as Client Secret in the OAuth2 setup of Limagito File Mover. The Secret ID is NOT needed.
Add API Permissions, two types of permissions:
Application permissions allow the app to access data on its own, without a signed-in user. The app acts as itself using its own identity. This is used with client credentials authentication (client ID + secret or certificate). The app has access to all resources that the permission grants — for example, Sites.ReadWrite.All as an application permission gives access to all SharePoint sites in the tenant.
Delegated permissions allow the app to act on behalf of a signed-in user. The app can only access what the user themselves can access. This is used with the OAuth 2.0 authorization code flow where a user signs in through a browser dialog. For example, Sites.ReadWrite.All as a delegated permission gives the app access only to the SharePoint sites that the signed-in user has permission to use.
In short: application = the app acts as itself (no user), delegated = the app acts as the user (user must sign in once during OAuth2 setup).
Select Microsoft Graph:
First option is it to use Application permissions: we added Sites.ReadWriteAll
Select Microsoft Graph:
Second option is it to use Delegated permissions: again we added Sites.ReadWriteAll
Grant admin consent for the choosen Application permissions:
Confirm
Permissions result:

If you need any help about this ‘microsoft Graph API with SharePoint’ option, please let us know.
Best Regards,
Limagito Team
# sharepoint #managedfiletransfer #filetransfer #filemanagement #limagito
By Limagito-Team SharePoint graph, SharePoint
06 Apr
How to use day of the week folders based on the filename
Using day of the week folders
Q: I would like to sort my files based on the filename. The first 8 char contain the date that has to be used. The format is YYYYMMDD (Year = 4 char, Month = 2 char and Day 2 = char).
A: This is possible using our Pascal Script option. We’ve attached some screenshots to get you started.
We used a Windows folder as Source:
File Filter Setup:
Open our Pascal Script option:
Enable and add the following ‘On Destination’ script:
The script will strip the date part from the filename and will check the day of the week
Corresponding day of the week will go into the %VSA (Var String A) parameter which will be used in the Destination setup
Var tmpStr: String; tmpDate: TDateTime; tmpDays: array[1..7] of string; Const ctDateFormat = 'YYYYMMDD'; ctDateFormatLen = 8; ctDateSeparator = #0; Begin tmpDays[1] := 'Monday'; tmpDays[2] := 'Tuesday'; tmpDays[3] := 'Wednesday'; tmpDays[4] := 'Thursday'; tmpDays[5] := 'Friday'; tmpDays[6] := 'Saturday'; tmpDays[7] := 'Sunday'; // Default Result = Skip File psExitCode:= 0; psVSA := ''; // ... add your code here tmpStr := Copy(psFileName, 1, ctDateFormatLen); If StrToIntDef(tmpStr, -1) <> -1 Then Begin Try tmpDate := psStrToDate(tmpStr, ctDateFormat, ctDateSeparator); psVSA := tmpDays[DayOfTheWeek(tmpDate)]; // Successful Result psExitCode := 1; // Debug psLogWrite(1, '', psFileName + ' will go into subfolder: ' + psVSA); Except psLogWrite(1, '', psFileName + ' conversion exception of date part, file will be skipped'); End; End Else Begin psLogWrite(1, '', psFileName + ' does not start with a valid date, file will be skipped'); End; End.
Destination Setup:
Important, adjust the default ‘Create Subdir option’, add %VSA (%VSA contains the day of the week):
RunTime Log Result:
If you need any help about this ‘day of the week folders’ option, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement #limagito
By Limagito-Team How-to Pascal Script day, days of the week
01 Apr
How to use Limagito to do SQL Server Express backup
Q: Not sure if you can help or suggest with SQL Server Express Backup. We are looking to have Limagito to do SQL Express backup with more frequently. We have SQL Server Express and looking into option if Limagito has agent to directly Backup the database. Or what is your suggestion if we want to use Limagito?
A: We use it here with a script on SQL Express. Our tool triggers this script using our schedular.
Script attached.: link
Download and rename backupsqlexpress.txt > backupsqlexpress.bat
You’ll need to set up the following parameters:
REM Database Configuration
SET SERVER=.\SQLEXPRESS
SET DATABASE=YourDatabase
SET USERNAME=YourUserName
SET PASSWORD=YourPasswordREM Paths and Files
SET BACKUP_PATH=C:\Test\In_Script\Backup
SET LOG_PATH=C:\Test\In_Script\Log
– During our test the script was put under C:\Test\In_Script\BackupSQLExpress.bat
– The backup itself are placed under C:\Test\In_Script\Backup
– Logging of the Database backup was put under C:\Test\In_Script\Log
Add CMD as Source
Setup Schedule
We used every day at 5AM:
Function, not that it really matters because in this case we are using our CMD option as Source
Optional:
> You can add Rule Events “On Succes” or “On Error” to get notified about the daily backup
> You could add a simple “PScript” Destination like:
If you need any help about this ‘add a no file edited trigger’, please let us know.
Best Regards,
Limagito Team
#sql #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Database How-to

1 2 3 4 … 169 →

SEARCH

ARCHIVES

Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.

Please don’t hesitate to contact us if you have any questions about our product and services.

DISCOVER OUR SITE

How to use Microsoft Graph API with SharePoint as source and destination

April 11, 2026 no responses

How to use day of the week folders based on the filename

April 6, 2026 no responses

How to use Limagito to do SQL Server Express backup

April 1, 2026 no responses

© 2007-2026 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan