topic Re: CSV from Google drive as source in Connectivity & Data Prep

CSV from Google drive as source

lschmelter — Thu, 20 Apr 2017 17:17:53 GMT

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

Re: CSV from Google drive as source

marcos-paixao — Mon, 01 May 2017 23:23:39 GMT

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

Re: CSV from Google drive as source

lschmelter — Thu, 04 May 2017 13:35:10 GMT

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.

Re: CSV from Google drive as source

marcos-paixao — Fri, 05 May 2017 10:51:24 GMT

Dear Leszek,

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

Regards,