Load Sharepoint data using Sharepoint web URL

[noramiramdnoor]

HI Everyone,

I have a question on the sharepoint loader to QLikview,currently I am using viewID and ListID to load the various sharepoint data and it works perfectly.

Now, I want to automate load the SharePoint data using the normal SharePoint URL web and those URL I will stored in the database table... is that possible to load and concat the data using this Sharepoint URL?

Table A:

ColumnURL:

http://theconnection.com/it/projects/HR/SitePages/Home.aspx

http://theconnection.onsemi.com/it/projects/BA/SitePages/Home.aspx

those sharepoint will have the same template, same attributes.

SharePointDefect:

Load

ID,

Desc

From <SharePointURL>

Any help was really appreciated.

Thanks

Mira