Limagito File Mover Software Blog and Filemover News

23 Oct
How to access SharePoint Rest API using OAuth
Version v2023 is needed and available here.
Update: A newer and preferred OAuth2 setup is explained in the following blog article: link
This Authorization method using OAuth2 was tested by a customer of us (Eddy, we really appreciate this). It is based on the following article.
As mentioned in the article, 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
Feedback customer:
This required the following settings in Azure. Maybe only the delegated permissions under Graph are enough, didn’t play too much.
Also the the redirect url should be set for the app, and ID_token must be enabled.
Limagito File Mover Setup:
In this case the Auth Type in our SharePoint setup should be set to: ‘OAuth 2.0 Authorization Code Flow’
OAuth2 Setup:
Disable ‘Code Challenge’
Seems to work also when enabled (tested by customer)
Enable ‘Include Nonce’
Set ‘Authorization Endpoint URL’
https://login.microsoftonline.com/%realm/oauth2/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.windows.net/%realm/oauth2/token?api-version=1.0
%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)
Set ‘Scope’ to: openid
If you don’t receive a Refresh Token, change it to: openid offline_access
Customer used: https://<Tenant>.sharepoint.com/.default
Set ‘Resource’ to: https://graph.microsoft.com/
Customer used: https://<Tenant>.sharepoint.com
Set Response Mode to: form_post
Set Response Type to: id_token+code
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>.
OAuth2 setup used by customer (info about the .default Scope: here):
OAuth2 setup we received from our SharePoint source code provider:
Common Setup:
If you want extra debug information during the test, please enable ‘Add Control Information to Log’
#Filetransfer #SharePoint
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 OAuth2 SharePoint azure, oauth, OAuth2, SharePoint
01 Oct
I have a task that needs to grab sets of files
Q: I have a task that needs to grab sets of files. Pdf files that have “A01” and “A06” OR files that have “A01” and A08” in their filename. Could this be accomplished?
A: So you would like us to check if pdf file A08 is available and if so then grab pdf files with A01 and A08 in their filename. If pdf file A08 is not available check the same but then using A06 in the filename. Meaning a set of files and grabbing the first and last page pdf file. Yes, this is possible.
As Source we will use a windows folder. This folder will contain the pdf files.
In the ‘File Filter’ we are going to use the ‘File Name Include’ filter option. Add the parameter %VSA to this filter. This %VSA (Var String A) will get its value from a script that we will add in the next step.
In the ‘Advanced’ tab of the ‘File Filter Setup’ we need to enable ‘Allow parameters in File Name Filter’.
Next, please open the ‘Pascal Script’ option:
Enable and add the following ‘On Rule Begin’ script:
Begin psExitCode:= 0; // ... add your code here psLogWrite(1, '', 'Source Path: ' + psSourcePath); If psCountFiles(psSourcePath, '*A08*.pdf', False) >= 1 Then Begin psLogWrite(1, '', 'Found A08'); psVSA := '*A01*.pdf;*A08*.pdf'; psExitCode:= 1; End Else Begin If psCountFiles(psSourcePath, '*A06*.pdf', False) >= 1 Then Begin psLogWrite(1, '', 'Found A06'); psVSA := '*A01*.pdf;*A06*.pdf'; psExitCode:= 1; End; End; End.
As Destination we used a Windows folder:
First test with 6 pdf files in the Source, A01 to A06
RunTime log result, only pdf file A01 and A06 are copied:
Second test with 6 pdf files in the Source, A01 to A08
RunTime log result, only pdf file A01 and A08 are copied:
If you need any help with this ‘grab sets of files’ request, please let us know.
Best Regards,
Limagito Team
#filetransfer #filemanagement
By Limagito-Team Pascal Script sets of files
05 Sep
AWS connection failed with code 403
AWS connection failed with code 403
In case you are getting error messages like:
GetBucketLocation AWSS3, SB Bucket XYZ-XYZ-XYZ Exists Exception: HTTP request failed with code 403 (Forbidden). Error code: AccessDenied
or
<Error>
    <Code>PermanentRedirect</Code>
    <Message>The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.</Message>
    <Endpoint>XYZ-XYZ-XYZ.s3-eu-west-1.amazonaws.com</Endpoint>
    <Bucket>XYZ-XYZ-XYZa</Bucket>
    <RequestId>…</RequestId>
    <HostId>…</HostId>
</Error>
, Code: 301
This could mean that you are trying to connect to a wrong endpoint. In this case please adjust in andpoint in the AWS S3 setup:
We prefer as API Vendor: Vendor 2 – CK. So please first check if this Vendor is selected.
If you want the maximum of log information, please enable ‘Add Control Information to Log’.
If you need any help with this ‘AWS connection failed with code 403’ , please let us know.
Best Regards,
Limagito Team
#filetransfer #filemanagement
By Limagito-Team AWS S3 403, aws