Qlik Web Connectors saving historical dataArticle Number: 000020316 | Last Modified: 2019/10/31
This page gives an example of how this could be done.
Although it's possible to cache data with Qlik Web Connectors, this is more useful where you are potentially using identical requests and want to check if you've already got the data before you make a call to the API. For example, when getting a sentiment score for a Tweet there's no point getting it again if you've already got it.
For other scenarios, where say you want to build up Google Analytics data over time, you want to just get the latest data and add it to what you already have and store it to a file.
Qlik Web Connectors doesn't have a function to store data to a file, but you can use QlikView script to save tables to QVDs, which is QlikView's file storage format.
Saving data to QVDs has a number of advantages including:
- being very quick to reload into your apps
- they are compressed
- they can be easily backed up as part of your normal data management processes and
- they can also be reused in other QlikView applications.
Of course you are not restricted to saving data to QVDs as QlikView can save data in other ways as well.
Below is one example of how this can be achieved using QlikView script and is modified from our Twitter demo application.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.