https://community.qlik.com/t5/Member-Articles/Using-Qlik-Lineage-API-s-with-your-On-Premise-Environment-s/ta-p/2527726 <H2><STRONG>Starting Point</STRONG></H2> <P>Before you get to excited, the Qlik Lineage API's do <STRONG>NOT </STRONG>work against your Qlik Sense Enterprise on Windows environments. But I used that title because that is how I searched when a customer said "I really like tracking the lineage for my SasS applications, but I also need it for the Qlik Sense Applications I still have on-premise."&nbsp;</P> <P>Don't get discouraged just yet, as I'm going to show you a way forward that will let you capture the lineage you want using a product Qlik provides that you might not be aware of ... <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikLineageConnectors/qlik-lineageconnectors.htm" target="_blank" rel="noopener">Qlik Lineage Connectors</A>.&nbsp;</P> <P>In a nutshell, the Qlik Lineage Connectors collects all the lineage information for your on-premise environments and publishes the needed METADATA for them to the Cloud, where you can use the API's. No data is moved to the cloud, and you do not need to reload anything in the cloud to make it work.&nbsp;</P> <H2><STRONG>Installation &amp; Configuration</STRONG></H2> <P>Note: You will need at least a bare bones Qlik SaaS tenant to serve as the catalog for your lineage data.&nbsp;Follow the instruction for the <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikLineageConnectors/qlik-lineageconnectors-install.htm" target="_blank" rel="noopener">Qlik Lineage Connectors application</A>, as the point of this post is to help you after that so you can configure and get the Qlik Lineage API's working on all of that precious on-premise lineage metadata.&nbsp;</P> <P>The metadata can only be published to a Managed space within your Qlik SaaS Tenant. In the following screen shot you will notice I conveniently named that space "<FONT color="#339966"><STRONG>OnPremise</STRONG></FONT>" so there would be no doubt in my old mind what the space was when I see it a few weeks from now.&nbsp;<span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_0-1755615744828.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182970iBC6ED4DF31A0950D/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_0-1755615744828.png" alt="Dalton_Ruer_0-1755615744828.png" /></span></P> <P>The following screen shot shows what that space looked like before configuring and running the Qlik Lineage Connectors in my environment:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_1-1755615824474.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182971iF002972212E25D3A/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_1-1755615824474.png" alt="Dalton_Ruer_1-1755615824474.png" /></span></P> <H2><STRONG>Executing Qlik Linage Connectors On-Premise</STRONG></H2> <P>You can run/test the process by going to the Scheduler tab and simply pressing the run/play icon. As you will see in the image below I configured my environment to be limited to a single stream that had 22 applications in it.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_2-1755615883419.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182972i9CF409895E2B62F4/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_2-1755615883419.png" alt="Dalton_Ruer_2-1755615883419.png" /></span></P> <P>&nbsp;</P> <P>As the process was going I began seeing "<FONT color="#339966"><STRONG>items</STRONG></FONT>" appear in my "<STRONG><FONT color="#339966">OnPremise</FONT></STRONG>" space.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_3-1755615953104.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182973iB4BE261CE34F6A93/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_3-1755615953104.png" alt="Dalton_Ruer_3-1755615953104.png" /></span></P> <H2><STRONG>Output</STRONG></H2> <P>I used the word&nbsp;"<FONT color="#339966"><STRONG>items</STRONG></FONT>" because they are a type of object called an "External link." You can click on the link and it acts just like other hyperlinks and would launch the application in your QSEoW environment. However, it also has the advantage which is driving this post ... the ability to see the Lineage Metadata for those on-premise applications. Simply right click on the "<STRONG><FONT color="#339966">external link</FONT></STRONG>" and choose either "<FONT color="#339966"><STRONG>Lineage</STRONG></FONT>" or "<FONT color="#339966"><STRONG>Impact analysis</STRONG></FONT>", just like you would any of your SaaS applications.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_4-1755615996352.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182975iE29BD2630024C0E0/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_4-1755615996352.png" alt="Dalton_Ruer_4-1755615996352.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;Yeah! We are in business:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_5-1755615996353.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182976i2AA03DFB00FBBCD2/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_5-1755615996353.png" alt="Dalton_Ruer_5-1755615996353.png" /></span></P> <H2><STRONG>API Calls</STRONG></H2> <P>If you checkout the <A href="https://qlik.dev/apis/rest/lineage-graphs/" target="_blank" rel="noopener">Lineage APIs</A>&nbsp;you will notice a pretty simple format.&nbsp;</P> <P><STRONG>https://{Qlik&nbsp;Tenant}/api/v1/lineage-graphs/nodes/<FONT color="#008000">{QRI_ID}</FONT>&nbsp;</STRONG></P> <P>If you look at the online documentation or examples people have shared they all involve "applications." Which shows you that the QRI_ID involves a pattern of <STRONG>"<FONT color="#008000">qri:app:sense://{Application Id}</FONT>"</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_6-1755615996354.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182974i60CA2E65889BAFF7/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_6-1755615996354.png" alt="Dalton_Ruer_6-1755615996354.png" /></span></P> <P>Alas, these "<FONT color="#339966"><STRONG>external links</STRONG></FONT>" are not "applications" they are simply pointers to the on-premise applications along with the lineage metadata. So, that format won't work for us. However, we can easily get that QRI_ID value using the <A href="https://qlik.dev/apis/rest/items/" target="_blank" rel="noopener">Qlik "items" API call</A>.&nbsp;</P> <H2><STRONG>Items API</STRONG></H2> <P>In the documentation you will notice that one of the parameters that can be utilized for the "items" API call is something called "<FONT color="#339966"><STRONG>resourceType</STRONG></FONT>." That parameter allows you to filter the API to exactly what you are looking for which we need to do in this case. The "<STRONG><FONT color="#339966">resourceType</FONT></STRONG>" value we want is "<FONT color="#339966"><STRONG>genericlink</STRONG></FONT>."&nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_7-1755615996358.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182978i0CB5B4611A8B005B/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_7-1755615996358.png" alt="Dalton_Ruer_7-1755615996358.png" /></span></P> <P>&nbsp;</P> <P>Notice that in my screenshot (from Postman) that in addition to passing "<FONT color="#339966"><STRONG>genericlink</STRONG></FONT>" for the "<FONT color="#339966"><STRONG>resourceType</STRONG></FONT>" parameter, I have also configured another parameter called "<FONT color="#339966"><STRONG>spaceId</STRONG></FONT>" that then limits the list to the "<FONT color="#339966"><STRONG>genericlink</STRONG></FONT>"(s) found in my "<STRONG><FONT color="#339966">OnPremise</FONT></STRONG>" Managed Space.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_8-1755615996365.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182979i97E5E69E6BC47A1D/image-size/large?v=v2&amp;px=999" role="button" title="Dalton_Ruer_8-1755615996365.png" alt="Dalton_Ruer_8-1755615996365.png" /></span></P> <P>&nbsp;</P> <P>If you look at the blue highligted area in the screenshot above it output exactly what we are looking for in the form of the "<FONT color="#339966"><STRONG>secureQri</STRONG></FONT>" value. Woohoo! We can programmatically iterate through the output from calling the items API and pass the QRI_ID values to the lineage API.</P> <H2><STRONG>Lineage API</STRONG></H2> <P>Two important parameters for the <A href="https://qlik.dev/apis/rest/lineage-graphs/#get-api-v1-lineage-graphs-nodes-id" target="_blank" rel="noopener">Lineage API</A> are called "<FONT color="#339966"><STRONG>level</STRONG></FONT>" and "<FONT color="#339966"><STRONG>up</STRONG></FONT>." The "<FONT color="#339966"><STRONG>level</STRONG></FONT>" parameter lets you define what aspects of the lineage information you want. While the "<FONT color="#339966"><STRONG>up</STRONG></FONT>" parameter lets you declare how many values to return.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_9-1755615996366.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182977i6AF71B01F0895B37/image-size/medium?v=v2&amp;px=400" role="button" title="Dalton_Ruer_9-1755615996366.png" alt="Dalton_Ruer_9-1755615996366.png" /></span></P> <P>In my call, notice that I have indicated that I wish to get all values, and I want the resources.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Dalton_Ruer_10-1755615996369.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182980i63DD7F508C266332/image-size/large?v=v2&amp;px=999" role="button" title="Dalton_Ruer_10-1755615996369.png" alt="Dalton_Ruer_10-1755615996369.png" /></span></P> <P>You simply change the "<STRONG><FONT color="#339966">level</FONT></STRONG>" parameter if you wish to obtain Table names or Field names and the information about them. Or set it to all and it will return all of the metadata you could dream of.&nbsp;</P> <P>&nbsp;</P> Tue, 19 Aug 2025 15:24:06 GMT Dalton_Ruer 2025-08-19T15:24:06Z https://community.qlik.com/t5/Member-Articles/Using-Qlik-Lineage-API-s-with-your-On-Premise-Environment-s/ta-p/2527726 <P>Stop dreaming, and start doing. In this post I will share how you can use the Qlik Lineage API's for SaaS applications on your Qlik Sense Enterprise for Windows applications.&nbsp;</P> Tue, 19 Aug 2025 15:24:06 GMT https://community.qlik.com/t5/Member-Articles/Using-Qlik-Lineage-API-s-with-your-On-Premise-Environment-s/ta-p/2527726 Dalton_Ruer 2025-08-19T15:24:06Z