How to do incremental load using Rest Connector? - Qlik Community

Anonymous · ‎2018-02-21

I have generation data (downloadable from this website in the form of excel file Data view ‌), Now i need to display this data in a dynamic way, i.e. hourly basis. Can any one explain to me the broad level process that i should follow and add some useful sources to read/refer to

Thanks!

Digvijay_Singh · ‎2018-02-26

Can you share excel data and the expected output format?

Anonymous · ‎2018-02-26

Having a had a quick at the url you posted it looks like it comes at hourly or sometimes 15 minutes granularity so it looks like a suitable data source for a classic incremental load.

There is a section in the online manual in incremental loads :

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-increme...

And here is a link to a doc containing a couple of dozen other links

Incremental Load in Qlikview - Sources

Don't worry QlikView vs. Sense, the load script is the same in both.

Anonymous · ‎2018-02-27

Anonymous · ‎2018-02-27

sure will have a look

Anonymous · ‎2018-02-27

Also this involves the use of rest api

Im using the link of REST API: as https://transparency.entsoe.eu/api but it is showing error,

I have received the Security Token as 89862325-3929-4bbd-b6d6-00109699d55b

How should i proceed?

Anonymous · ‎2018-02-27

Probably best to ask the API supplier who gave you the token.

Also best to edit your post above and delete the token from it, as things like that shouldn't be placed in the public domain.