Qlik Web Connectors - Clearing Cached Data

Bjorn_Wedbratt — Fri, 28 May 2021 17:36:48 GMT

Some connectors cache data locally, this has the benefit of:

Vastly improved load time after initial download of data.
Reduced number of calls to API (which often have throttle and usage limits)

Clearing the cache in the UI

?If you wish to delete the data cached for a connector manually

Open Qlik Web Connectors in your browser (http://localhost:5555/web)
Select the connector and go to the 'Settings' tab for the connector
Click the 'Clear Cached Data' button as highlighted below.

Clearing the cache using load script

If you wish to clear the cache in your load script you may do so with the following script:

1
2
3
4
5
6
7
8 ClearCache:
LOAD [Qlik Web Connectors_ClearCache_Result], [Qlik Web Connectors_ClearCache_SearchPattern], [Qlik Web Connectors_ClearCache_NoItemsDeleted] FROM [http://localhost:5555/data?connectorID=CONNECTOR_NAME&clearcache=true] (txt, utf8, embedded labels, delimiter is '\t', msq);

You just need to replace CONNECTOR_NAME with the the right value, this will be the value present in the same place in the url for the other load statements you use for this connector.

So for example for the Twitter Connector you could place this as the first statement in your load script, perhaps running it conditionally based on the number of days since your last reload.

1
2
3
4
5
6
7
8 ClearCache:
LOAD [Qlik Web Connectors_ClearCache_Result], [Qlik Web Connectors_ClearCache_SearchPattern], [Qlik Web Connectors_ClearCache_NoItemsDeleted] FROM [http://localhost:5555/data?connectorID=TwitterConnector&clearcache=true] (txt, utf8, embedded labels, delimiter is '\t', msq);

Advanced Arguments

Pattern Matching

Some connectors support an additional paramter: &clearcache_searchPattern=

Here you can pass in a string with * wildcards to further specify which cached items are to be deleted. Currently only the Facebook for Pages Connector and Facebook Insights Connector supports this - typically you would use 'clearcache_searchPattern=[pagename_or_id]'. So for example to clear all the cached items for the QlikView Facebook page simply use.

1
2
3
4
5
6
7
8 ClearCache:
LOAD [Qlik Web Connectors_ClearCache_Result], [Qlik Web Connectors_ClearCache_SearchPattern], [Qlik Web Connectors_ClearCache_NoItemsDeleted] FROM [http://localhost:5555/data?connectorID=FacebookFanPagesConnector&clearcache=true&clearcache_searchPattern=qlikview_*] (txt, utf8, embedded labels, delimiter is '\t', msq);

Only Deleting Items Older Than X Hours

You can use the parameter:

&clearcache_ageInHours=X

Where X is an integer greater than or equal to zero. If this is specified, then only items older than this will be deleted.

Changing the Cache Directory

By default the Qlik Web Connectors cache will be contained in a sub-directory under QlikWebConnectors.exe. For example if Qlik Web Connectors is running in the folder:
- F:\Qlik Web Connectors\

the cache for each connector will be located at:
- F:\Qlik Web Connectors\App_Data\[User]\[CONNECTOR_NAME]_Cache

where [User] is the GUID for the user logged in when setting up the connector (Default GUID for Admin is DEFAULT0-000-000-000-00000000000)

As an example, results from the sentiment analyzer will be cached at:
- F:\Qlik Web Connectors\App_Data\DEFAULT0-000-000-000-00000000000\SentimentAnalyser_Cache

You can change the directory where the cache is installed by editing deploy.config and change the FileBasedCacheProvider setting:

<Cache provider="FileBasedCacheProvider" config="{app_root}/App_Data/{user_id}/{connector_id}_Cache/"></Cache>?

Compressing the Cache Folder

A large number of files can accumulate in the cache directory and for this reason we would recommend configuring Windows to compress it. To do this right click on your App_Data folder and select properties:

The click the 'Advanced' button:

Then check the 'Compress' option:

You should then confirm the following:

You should then see the folder highlighted in blue illustrating that it is compressed.

article Qlik Web Connectors - Clearing Cached Data in Official Support Articles