Get a datasource from Google Drive

Last modified by Aurelie Bertrand on 2020/07/31 11:30


Preparation

Prerequisite

For the first method:

  • A service account to store documents and a file. Refer to p12
  • Follow the instruction of the tutoriel “google_drive_config_en.pdf” to get data settings.

For the second method:

  • No requisite

Principles

There are two ways to share a document from Google Drive :

  1. First : You can retrieve the document by sharing it with the service account created
  2. Second method : by creating a public link of the file in Google Drive and adding the link in the DigDash document server as an URL.

First method

Service account

Get the  service account ID (as email address)

gdrive.png

Share file to the service account

Connect to the Google Drive account and share the document to the service account previously mentioned.
https://lh3.googleusercontent.com/H-PCkjFPEWFVUpqrEqowKjjaZhtKwSaa12EVqZ88np5gJH_Dd80cigHNrKne3DL0cjlh0sKzOr6F9b4ezjyVrNNlAK5N4xisY29wOa9nuKJqdbs_EGjE2RFPVL6VpYf2xH-M4qGlulw

https://lh3.googleusercontent.com/W-SVIi9EDQegM97n5nnDeaFrLPpal_OdaOM2yQEm1n4SKQWPfoL3c4ZRVFgVXSe7ZkNPtdN0ijBAI9tfsnUvd9vlUW94qFf4EagcY80Qd8Y2jaUs34XSKiye7ljGe0xO1Ix0xo6ENwY

Second method

Creating a public link of the Google Drive’s file

From the google File : File > Publish on the web
https://lh4.googleusercontent.com/iuxZv7Gst87N3JSp3lQ1bVyIuL099LEIkoYnKBnO7gcaS7RPAhJP6K264ZPikNDTOC1RiLEyFOR9xcXaAZkzMzkdmc927vn-u5ZjoPF4FJhlbQbOMymaRhKglcR4WPhhvDOm8sccHNc

publish after every update

Choose a format > check “publish automatically after every update” to send the updates > start the publication > Copy the generated link
https://lh5.googleusercontent.com/ppNFHE6ypKoHRV0uGXsiwuwsV-DtmoUKdwxWeWHILiTzKVxlNG3BVe66izj-19liiVNZn0Rm1H2Fs3duFWlAHj8L4OgugHeZdeHNaJYeu7QJbNpAOZThDBVc4n6So_x7M0mi-Nm0lLE

https://lh3.googleusercontent.com/J0Q3T5alWuJSwpkmN6enKVyr8mPDq2dkk4nsKBIC295uP_l2bVyLckKqEhkKfXQJJRn4vmYzDWAe7sbAtRJKvw8sdzY-i0k7rJY-zsgFL1t4LisjVJvAclVoJj4WERbvZJNCNCr6LLE

Add the document in DigDas

Select the document server and add a file from the URL previously copied > Give a name to the file.
https://lh4.googleusercontent.com/TqqMPBkI62qCP_hoer6w9-rGG0RZYyrTue54cU68QhM4DTz1hxDxhhcZAlFzup90Pu1BaO_UE32H0xFrlTW7GSfJlKL3X-w8tfsbUvztSTDpE2SkuFeYzk4EZF6LUdQpzLyoqRWf6rM