topic Re: How to do incremental load using Rest Connector? in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60595#M351 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>There is a section in the online manual in incremental loads :</P><P></P><P><A href="https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm" title="https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm">https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm</A></P><P></P><P>And here is a link to a doc containing a couple of dozen other links</P><P></P><P><A href="https://community.qlik.com/docs/DOC-9531">Incremental Load in Qlikview - Sources</A></P><P></P><P>Don't worry QlikView vs. Sense, the load script is the same in both.</P></BODY></HTML> Mon, 26 Feb 2018 19:11:31 GMT Anonymous 2018-02-26T19:11:31Z How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60593#M349 <HTML><HEAD></HEAD><BODY><P>I have generation data (downloadable from this website in the form of excel file <A href="https://transparency.entsoe.eu/generation/r2/actualGenerationPerProductionType/show" title="https://transparency.entsoe.eu/generation/r2/actualGenerationPerProductionType/show"> Data view </A>‌), 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</P><P>Thanks!</P></BODY></HTML> Wed, 21 Feb 2018 05:09:21 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60593#M349 Anonymous 2018-02-21T05:09:21Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60594#M350 <HTML><HEAD></HEAD><BODY><P>Can you share excel data and the expected output format?</P></BODY></HTML> Mon, 26 Feb 2018 18:02:51 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60594#M350 Digvijay_Singh 2018-02-26T18:02:51Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60595#M351 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>There is a section in the online manual in incremental loads :</P><P></P><P><A href="https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm" title="https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm">https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm</A></P><P></P><P>And here is a link to a doc containing a couple of dozen other links</P><P></P><P><A href="https://community.qlik.com/docs/DOC-9531">Incremental Load in Qlikview - Sources</A></P><P></P><P>Don't worry QlikView vs. Sense, the load script is the same in both.</P></BODY></HTML> Mon, 26 Feb 2018 19:11:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60595#M351 Anonymous 2018-02-26T19:11:31Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60596#M352 <HTML><HEAD></HEAD><BODY><P><IMG alt="expected op.PNG" class="jive-image image-1" src="/legacyfs/online/194646_expected op.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 27 Feb 2018 06:33:55 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60596#M352 Anonymous 2018-02-27T06:33:55Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60597#M353 <HTML><HEAD></HEAD><BODY><P>sure will have a look</P></BODY></HTML> Tue, 27 Feb 2018 06:34:27 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60597#M353 Anonymous 2018-02-27T06:34:27Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60598#M354 <HTML><HEAD></HEAD><BODY><P>Also this involves the use of rest api</P><P>Im using the link of REST API: as <A href="https://transparency.entsoe.eu/api" title="https://transparency.entsoe.eu/api">https://transparency.entsoe.eu/api</A> but it is showing error, </P><P>I have received the Security Token as <SPAN style="color: #000000; font-family: Arial, sans-serif; font-size: 16px;">89862325-3929-4bbd-b6d6-00109699d55b</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, sans-serif; font-size: 16px;">How should i proceed?</SPAN></P></BODY></HTML> Tue, 27 Feb 2018 07:16:26 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60598#M354 Anonymous 2018-02-27T07:16:26Z Re: How to do incremental load using Rest Connector? https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60599#M355 <HTML><HEAD></HEAD><BODY><P>Probably best to ask the API supplier who gave you the token.</P><P></P><P>Also best to edit your post above and <SPAN style="font-size: 13.3333px;">delete the token from it</SPAN>, as things like that shouldn't be placed in the public domain.</P></BODY></HTML> Tue, 27 Feb 2018 17:50:46 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-do-incremental-load-using-Rest-Connector/m-p/60599#M355 Anonymous 2018-02-27T17:50:46Z