Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

lschmelter
New Contributor

CSV from Google drive as source

Hello,

I need some help on how to set up a REST-Connection to load a csv file from Google drive.

I managed it to create a client id and a key at the Google Api site.

Now I stumble with the set up of the connection in Qlik Sense desktop.

Is the an example of such a set up?

Thanks.

Leszek

3 Replies
marcos-paixao
New Contributor II

Re: CSV from Google drive as source

Dear Leszek,

you can use apigee (https://apigee.com/console/google-spreadsheets) for test the REST parameters. After test the results, you can use the configuration page for knowing how to use them inside Qlik Sense.

Best Regards,

Marcos A. Paixao

lschmelter
New Contributor

Re: CSV from Google drive as source

Hello Marcos,

thank you. Interesting Link.

Unfortunately this interface seems to work only with Google Spreadsheets and Documents but not with csv files.

Regards,

Leszek.

marcos-paixao
New Contributor II

Re: CSV from Google drive as source

Dear Leszek,

If you save a file inside Google Documents as ".TXT" you may be able to read the CSV content.

Regards,

Community Browser