topic Re: How to import data using REST connector plugin in Qlik in Connectivity & Data Prep

How to import data using REST connector plugin in Qlik

cosc7070 — Fri, 02 Apr 2021 08:10:15 GMT

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.

Re: How to import data using REST connector plugin in Qlik

stevedark — Tue, 05 Dec 2017 18:42:53 GMT

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

Re: How to import data using REST connector plugin in Qlik

cosc7070 — Wed, 06 Dec 2017 06:30:32 GMT

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.

Re: How to import data using REST connector plugin in Qlik

stevedark — Wed, 06 Dec 2017 09:15:34 GMT

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

Re: How to import data using REST connector plugin in Qlik

cosc7070 — Wed, 06 Dec 2017 14:15:12 GMT

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

Re: How to import data using REST connector plugin in Qlik

stevedark — Wed, 06 Dec 2017 14:31:54 GMT

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