topic Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets in Integration, Extension & APIs

Embedded Labels problem using Web Connector - Google Drive Spreadsheets

caio_caminoski — Fri, 13 Oct 2017 08:26:54 GMT

Hello Community,

I have been facing an issue. I am loading data from an online spreadsheet I have, however I can not get Qlik Sense to identify the labels.

I am using the QlikWebConnectors 2.2.0 which is generating a URL qvx like the following:

LOAD

Column1,

Column2,

...

FROM

[http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetWorksheet&worksheetKey=xxxxxxxxxx&skipRows=6&appID=]

(qvx);

As you can see there is a skipRows parameter equal to 6 in the URL as my data do not start from the first row in the sheet. I tried using the wizard from qlikview and qlik sense and in neither i could embed the labels.

I cannot do the alias manually as the user could be able to insert a new column and mess up all the names.

Any ideas?

Thanks in advance,

Caio

Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets

caio_caminoski — Wed, 25 Oct 2017 09:52:59 GMT

Is it true that the only way to embed labels is if they are in the first row of the online sheet?

Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets

Anonymous — Thu, 26 Oct 2017 08:53:14 GMT

Instead of adding skipRows in the URL itself, can you skip the rows by writing for loop in your script.

Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets

tannyj17 — Wed, 21 Aug 2019 12:56:10 GMT

Hello,

I had a similar problem, and fixed it by putting the column headers in the first row. I am not sure if there is any functionality to fix this problem via the qlikview web connectors.