Sync Google Drive files to Microsoft OneDrive

Use case

Using this sample, you can sync files in a given Google Drive folder to a given Microsoft OneDrive folder.

Prerequisites

• Google account
• Microsoft OneDrive account

Setting up Google Drive account

1. Visit Google API Console, click Create Project, and follow the wizard to create a new project.
2. Go to Credentials -> OAuth consent screen, enter a product name to be shown to users, and click Save.
3. On the Credentials tab, click Create credentials and select OAuth client ID.
4. Select an application type, enter a name for the application, and specify a redirect URI (enter https://developers.google.com/oauthplayground if you want to use OAuth 2.0 playground to receive the authorization code and obtain the access token and refresh token).
5. Click Create. Your client ID and client secret appear.
6. In a separate browser window or tab, visit OAuth 2.0 playground, select the required Google Drive scopes, and then click Authorize APIs.
7. When you receive your authorization code, click Exchange authorization code for tokens to obtain the refresh token and access token.
8. You could get the gDriveFolderId from the folder URL.

Setting up Microsoft OneDrive account

1. Before you run the following steps, create an account in OneDrive. Next, sign into Azure Portal - App Registrations. You can use your personal or work or school account to register.

2. In the App registrations page, click New registration and enter a meaningful name in the name field.

3. In the Supported account types section, select Accounts in any organizational directory under personal Microsoft accounts (e.g., Skype, Xbox, Outlook.com). Click Register to create the application.

4. Copy the Application (client) ID (<CLIENT_ID>). This is the unique identifier for your app.

5. In the application's list of pages (under the Manage tab in left hand side menu), select Authentication. Under Platform configurations, click Add a platform.

6. Under Configure platforms, click Web located under Web applications.

7. Under the Redirect URIs text box, register the https://login.microsoftonline.com/common/oauth2/nativeclient url. Under Implicit grant, select Access tokens. Click Configure.

8. Under Certificates & Secrets, create a new client secret (<CLIENT_SECRET>). This requires providing a description and a period of expiry. Next, click Add.

9. Next, you need to obtain an access token and a refresh token to invoke the Microsoft Graph API. First, in a new browser, enter the below URL by replacing the <CLIENT_ID> with the application ID. Here you can use Files.ReadWrite or Files.ReadWrite.All according to your preference. Files.ReadWrite will allow you to access to only your files and Files.ReadWrite.All will allow you to access all files you can access.

   https://login.microsoftonline.com/common/oauth2/v2.0/authorize?response_type=code&client_id=<CLIENT_ID>&redirect_uri=https://login.microsoftonline.com/common/oauth2/nativeclient&scope=Files.ReadWrite offline_access
   

10. This will prompt you to enter the username and password for signing into the Azure Portal App.

11. Once the username and password pair is successfully entered, this will give a URL as follows on the browser address bar.

    https://login.microsoftonline.com/common/oauth2/nativeclient?code=xxxxxxxxxxxxxxxxxxxxxxxxxxx

12. Copy the code parameter (xxxxxxxxxxxxxxxxxxxxxxxxxxx in the above example) and in a new terminal, enter the following cURL command by replacing the <CODE> with the code received from the above step. The <CLIENT_ID> and <CLIENT_SECRET> parameters are the same as above.

    curl -X POST --header "Content-Type: application/x-www-form-urlencoded" --header "Host:login.microsoftonline.com" -d "client_id=<CLIENT_ID>&client_secret=<CLIENT_SECRET>&grant_type=authorization_code&redirect_uri=https://login.microsoftonline.com/common/oauth2/nativeclient&code=<CODE>&scope=Files.ReadWrite offline_access" https://login.microsoftonline.com/common/oauth2/v2.0/token
    

    The above cURL command will provide the refresh token.

13. You could provide the oneDrivePath from root. If folder is a child of root, path should be given as /CHILD_NAME

Note : If you want to sync new files and latest updates of existing OneDrive files, you need to give filesOverridable as true and if you only wants to sync new files, you need to give filesOverridable as false;

Config.toml

[<ORG_NAME>.gdrive_files_to_microsoft_onedrive_files]
gDriveClientId = ""
gDriveClientSecret = ""
gDriveRefreshToken = ""
gDriveFolderId = ""
oneDriveClientId = ""
oneDriveClientSecret = ""
oneDriveRefreshURL = ""
oneDriveRefreshToken = ""
oneDrivePath = ""
filesOverridable = 

Testing

1. Run the Ballerina project created by the integration sample by executing bal run from the root.

2 .Now you can check the OneDrive folder to verify whether file is added.