Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cosc7070
Contributor II
Contributor II

How to import data using REST connector plugin in Qlik

Hi All,

I have installed 64 bit Qlik REST connector Plugin in my PC and am trying to import data from any one URL  link for example

URL: Demographics of India - Wikipedia  through REST connector, I am unable to fetch data. I am facing below issue in Qlik.

Can you please provide the solution??

How to use Rest Connector In Qlikview?? Please provide solution asap.

Thanks in Advance.

5 Replies
stevedark
Luminary Alumni
Luminary Alumni

Hi there,

You don't need the REST connector for that data source, rather just put the URL in after clicking the Web Files button.  You will then find you can explore the various tables in the source.

You will end up with a script like this, to pull the :

LOAD Rank,

    [State/UT],

    Population[48],

    [Percent (%)],

    Male,

    Female,

    [Sex Ratio],

    Rural[49],

    Urban[49],

    "Area[50] (km2)",

    [Density (per km2)]

FROM

[https://en.wikipedia.org/wiki/Demographics_of_India]

(html, codepage is 1252, embedded labels, table is [Population distribution by states/union territories (2011)]);

The first table on the page needs a bit more tweaking, as it has two header rows, but it's not too much of a faff.  Other tables are all straight forward.

If you want to use the REST connector for a different data source this post by catalystmichael‌ is a good one:

https://adventuresinqlik.com/2017/11/12/spotify-rest-qlik/

Cheers,

Steve

cosc7070
Contributor II
Contributor II
Author

Thanks a lot Steve Dark.

I am unable to open below link. please share any alternative link.

ttps://adventuresinqlik.com/2017/11/12/spotify-rest-qlik/    

I want to fetch XML data from SharePoint list to Qlik. In this case I guess We need "Rest Connector plugin"

Without REST connector How can I fetch XML data from SharePoint list?

Is it possible without REST connector?? Please share your valuable ideas.

Thanks in advance.

stevedark
Luminary Alumni
Luminary Alumni

Hi,

That link works fine here - suggest you re-try.

With SharePoint a lot depends on the version of SharePoint and how it is configured.  Some versions allow you to refer to items in SharePoint as folder shares.

This article looks like it could be useful regarding the SharePoint REST API:

Get to know the SharePoint REST service | Microsoft Docs

This would require the REST connector, and some kind of authentication as Michael refers to in his post.

I would highly recommend the use of PostMan as well for exploring APIs (https://www.getpostman.com/)

Steve

cosc7070
Contributor II
Contributor II
Author

thanks a lot Steve..

You have any sample application? or Any step by step process screen shots. Please share it you have.

Requirement: SharePoint list XML using REST connector plugin.

hanks & Regards,

Subbu

stevedark
Luminary Alumni
Luminary Alumni

Hi - I've not had a requirement to do this recently so don't have any sample code I can share, sorry.