Getting Google web connector working on cloud

[sachconsultancy]

Dear All

I managed to load Google sheets using Google web connector provided by Qlik in the Qlik Sense desktop version. Also, I managed to get the connector working as a service in my server so I can access it via an IP address instead of localhost.

When I try to refresh the app in the cloud it gives the following error message?

"This statement only works with lib:// paths in this script mode"

What I want to know is whether the Qlik Sense cloud support to refresh apps using the Google web connector? If so how can I give the path in lib:// format as Qlik Sense cloud wants?

[bwisealiahmad]

Hi,

Did you change the script mode for it to work in Qlik Sense Enterprise?

Could you share a screenshot of the connector string?

Best,

Ali A

[sachconsultancy]

Hi Ali, Thanks for the response. I am talking about the Qlik Sense Business Cloud. I can get the connector working in the desktop. I don't use Qlik Sense enterprise.  Please see below for the connection string that runs perfectly in Desktop but when I try to refresh this on Qlik Sense Cloud it gives the following error.

The following error occurred:

This statement only works with lib:// paths in this script mode

Case_Log:

LOAD

    [Date/UFN],

    [File Received by Reception],

    [Contact Log]

FROM [http://vmdhtt76:5555/data?connectorID=GoogleDriveConnector&table=GetWorksheet&worksheetKey=10GbE_ifi...)

WHERE Len([Date/UFN])>0

[balabhaskarqlik]

Check the data connector, modify it.

[pragna666]

Hi, did this work for you?

I am also trying to use Qlik Google Connector for Qlik Cloud. I created a connection with 'Web File' and got an error "Access Denied" (please see attached).

If the above connection is made successful, then the script will work with no issues with library. First part of my script is as below :

let vQwcConnectionName = 'lib://Google_Sheet';

GoogleDriveConnector_GetWorksheet:
LOAD .............