Limagito File Mover Software Blog and Filemover News

27 Oct
Google Drive migrate from the OAuth out-of-band (OOB) flow
How to migrate from OAuth out-of-band (OOB) flow
Google Out-Of-Band (OOB) flow Migration Guide
Key compliance dates
February 28, 2022 – new OAuth usage blocked for the OOB flow
September 5, 2022 – a user-facing warning message may be displayed to non-compliant OAuth requests
October 3, 2022 – the OOB flow is deprecated for OAuth clients created before February 28, 2022
Please open your Google Drive Setup in Limagito File Mover because we’ll need to make some adjustments.
– We switched to API v3 but should also work with v2. When using API v3 and x64bit, please use a version starting from v2022.10.27.0
– Please add the following information to the OAuth2 setup:
– Authorization Endpoint URL: https://accounts.google.com/o/oauth2/v2/auth
– Token Endpoint URL: https://www.googleapis.com/oauth2/v4/token
– Client ID
– Client Secret
– Scope: https://www.googleapis.com/auth/drive
– Redirect URI: http://127.0.0.1
– Redirect Port: 3017 (can be any other port that is not in use)
Click GET and your browser will open. Please follow the steps in your browser and after acceptance we will automatically fill in Refresh Token and Access Token. Do not forget to <Save> afterwards.
—
#FileTransfer #OAuth
If you need any info about this ‘migrate from OAuth out-of-band (OOB) flow’ How To, please let us know.
Best regards,
Limagito Team
By Limagito-Team Google OAuth2 oauth, OAuth2, OOB, Out-Of-Band

23 Oct

Need help with subtracting date from a filename

Q: Need help with subtracting date from a filename. My filename is like: 20221023_Pg_01.pdf (YYYYMMDD ) and I need to subtract 1 day and rename it so that it’s 2022-10-22_section_P01.pdf where it’s YYYYMMDD. My other dilemma is what will I do for a case like 20221001_Pg_01.pdf?

A: Yes this is possible using some Pascal Script. We’ve attached some screenshots to get you started.

We are using a Windows Folder a Source

Windows folder as Source

Open the ‘Pascal Script’ option

Limagito File Mover Pascal Script

Enable and set the following ‘On Destinations’ Pascal Script:

Var
  tmpDate: TDateTime;
  tmpDateStr: String;
  tmpPos: Integer;
  tmpLen: Integer;
Const
  ctDateLen = 8;

Function GetDateFromString(const aInput: String): TDateTime;
var
  wYear, wMonth, wDay: Word;
Begin
  wYear := StrToInt(Copy(aInput, 1, 4));
  wMonth := StrToInt(Copy(aInput, 5, 2));
  wDay := StrToInt(Copy(aInput, 7, 2));
  Try
    Result := EncodeDate(wYear, wMonth, wDay);
  Except
    Result := 0;
  End;
End;

Begin
  psExitCode := 0;
  (*
  My filename is like: 20221023_Pg_01.pdf (YYYYMMDD ) and I need to subtract 1 day
  and rename it so that it’s 2022-10-22_section_P01.pdf where it’s YYYYMMDD.
  My other dilemma is what will I do for a case like 20221001_Pg_01.pdf?
  *)
  // ... add your code here
  tmpPos := pos('_', psFileName);
  tmpLen := Length(psFileName);
  // Check
  If (tmpLen > ctDateLen) And (tmpPos = 9) Then
  Begin
    Try
      tmpDateStr := Copy(psFileName, 1, ctDateLen);
      psLogWrite(1, '', 'Date stripped as String: ' + tmpDateStr);
      tmpDate := GetDateFromString(tmpDateStr);
      tmpDate := psIncDay(tmpDate, -1);
      psVSA := FormatDateTime('yyyy-mm-dd', tmpDate);
      psLogWrite(1, '', 'Date Update as String: ' + psVSA);
      // Set ExitCode
      psExitCode := 1;
    Except
      psLogWrite(1, '', 'Exception Error when searching for Date in filename: ' + psFilePath + psFileName);
    End;
  End
  Else
    psLogWrite(1, '', 'Not a valid filename: ' + psFilePath + psFileName);
End.

Pascal Script

The above script will strip the datepart from the filename. We’ll substract one day from this datepart and put the result (in the requested format) in the psVSA var (%VSA).

Please enable and adjust the File Renaming option in you Destination:

Destination File Renaming

File Rename Setup:

RegEx: (.*)_(.)(.*)_(.*)\.(.*)

Replacement: %VSA_section_\2\4.\5

Destination File Renaming option

#Filetransfer #Script

If you need any help with this ‘subtracting date from a filename’ option, please let us know.

Best Regards,

Limagito Team

By Limagito-Team Pascal Script date, subtracting

23 Oct
SharePoint OAuth 2.0 authorization code flow
First you’ll need to register an AD app with your AD Tenant. It will assign you the necessary information you need for the OAuth2 setup.
Some links and screenshots to get you started:
Configure a client application to access a web API
Microsoft identity platform and OAuth 2.0 authorization code flow

Authentication Setup:
Feedback customer: the redirect url should be set for the app, and ID_token must be enabled. Use ‘Web’ as Redirect URI Type.
API Permissions Setup:
Feedback customer: This required the following settings in Azure. Maybe only the delegated permissions under Graph are enough, didn’t play too much.
We added some screenshots of a possible setup in our File Mover:
Please set Auth Type in our SharePoint setup to: ‘OAuth 2.0 Authorization Code Flow’
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 (= Tenant or 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 (= Tenant or 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 > Cerificates & Secrets > Client secrets > Use ‘Value’ field as Client Secret in Limagito SharePoint OAuth2 setup
Set ‘Scope’ to: openid offline_access https://yourSite.sharepoint.com/Sites.ReadWrite.All
Replace the YourSite part with the <Tenant> name you are using.
Don’t forget to add “Sites.ReadWrite.All” to the Permissions in your Azure setup.
Permissions Type must be Delegated.
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://yourSite.sharepoint.com/.default
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)
When using %realm in the ‘Authorization or Token Endpoint URL’
Please set ‘Realm’ to your Tenant of Tenant_ID
After the setup, please click on the <Get> button. If you get a firewall popup, you’ll need to accept this otherwise we will not be able to capture the Tokens.
Follow the steps in the browser and it should fill the Refresh and Access Token afterwards. Do not forget to click <Save>.
Common Setup:
If you want extra debug information during the test, please enable ‘Add Control Information to Log’
> Some information about why we use http://localhost/ as redirect URI:
In the case of a desktop application like our Limagito Remote Tool, you don’t have the capability to receive a redirect on a web server. Our tool will create a temporary background thread for the single purpose of receiving the redirect. Thus the local temporary web browser that interactively gets permission from the account owner is always communicating with your application on the same local machine. There is no communication across the Internet for the redirect, and therefore no HTTPS is needed. In fact, you cannot really use HTTPS because what server certificate would you use? You’d run into all sorts of trust issues with the browser not being happy with some self-signed “localhost” certificate. There’s just no point in opening that can of worms because it’s not even necessary.
#sharepoint #managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘how-to-access-sharepoint-rest-api-using-oauth’ option, please let us know.
Best Regards,
Limagito Team
By Limagito-Team SharePoint oauth, OAuth2, SharePoint