Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alexpanjhc
Valued Contributor

Share point question

Hi

I searched a few discussion but I am still not able to get how it works.

Where do you put the connection string on the script?

I was reading one post from Ian Crosland

he said :

FROM [http://vm-sharepoint/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={625801CC-11E6-40E9-9C25-AD198E2BAF21}] (XmlSimple, Table is [xml/Schema/ElementType/AttributeType]);

Access the list via your browser and select the View you want to find the GUID.

2. Select "Modify this View" and copy the URL.

3 You will get a URL like this,

http://vm-sharepoint/_layouts/listedit.aspx?List=%7B625801CC%2D11E6%2D40E9%2D9C25%2DAD198E2BAF21%7D

I am not familiar with sharepoint's architecture, is the part below universal? when I tried to use this in the script, but how to i use  (XmlSimple, Table is [xml/Schema/ElementType/AttributeType]); in my script?

http://vm-sharepoint/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={

where do you see the step 2: Modify this View?

TIA

Tags (1)
1 Solution

Accepted Solutions
alexpanjhc
Valued Contributor

Re: Share point question

OK I finally get it connected.

here are the steps:

go to the sharepoint page that you want to grab the information from.

I used Firefox so that i can see the view page source, there i found my GUID after the first List=

I then construct the url close to the above.  I am still not sure how the dll is placed in the sharepoint infrastructure.

but it seems that you can just use it after the directory.

Try the URL out in your browser, you will see the codes if they are valid, if not you either do not have access or you did something wrong.

open Qlikview scriptor, and click the web file, put the url in the internet file. then choose xml, you are good to go.

4 Replies
alexpanjhc
Valued Contributor

Re: Share point question

OK I finally get it connected.

here are the steps:

go to the sharepoint page that you want to grab the information from.

I used Firefox so that i can see the view page source, there i found my GUID after the first List=

I then construct the url close to the above.  I am still not sure how the dll is placed in the sharepoint infrastructure.

but it seems that you can just use it after the directory.

Try the URL out in your browser, you will see the codes if they are valid, if not you either do not have access or you did something wrong.

open Qlikview scriptor, and click the web file, put the url in the internet file. then choose xml, you are good to go.

Not applicable

Re: Share point question

Hello - what QV  version do you use??

Works fine for me in QV9 but fails with with QV11 ><,

Syntax error, missing/misplaced FROM:AttributeType... anyone having the same??

error.jpg

alexpanjhc
Valued Contributor

Re: Share point question

Hi

I do not think it has anything to do with your sharepoint, it is the ';' you are missing before the attribute type?

Not applicable

Re: Share point question

I see the same error. Were you able to get it resolved. If so, how?

Syntax error, missing/misplaced FROM: Attribute Type:

Community Browser