Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SharePoint Integration

Hi Folks,
Firstly I Love your project and have been using Talend for some time now..
Anyway, I have become very active in a very exciting MS product maned SharePoint (it is now officially MS's fastest growing product). The product is a "monster" of an application. There are many aspects where I believe Talend's architecture would fit very well.
Has anyone brought this up before? Although I am fairly new with SharePoint, I would be willing to work with someone here to help. If there is interest please let me know.
Thank You,
Gus
Labels (3)
13 Replies
Anonymous
Not applicable
Author

Shong, I've been a follower of you and picked a lot from you. Thank you !
Here are the details for anyone who wants to download files from any SharePoint library folder. This job should work out of box, all you need to do is to set your own context values.
Note that following SOAP msg is critical (to understand how the msg is set up, read http://sharepointmagazine.net/articles/writing-caml-queries-for-retrieving-list-items-from-a-sharepo...:
"<?xml version='1.0' encoding='utf-8'?>
<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>
<soapenv:Body>
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>
<listName>Collaboration Documents</listName>
<query>
<Query>
<Where><Neq><FieldRef Name='FSObjType' /><Value Type='Lookup'>1</Value></Neq></Where>
</Query>
</query>
<viewFields>
<ViewFields>
<FieldRef Name='Title' />
<FieldRef Name='EncodedAbsUrl' />
</ViewFields>
</viewFields>

<queryOptions>
<QueryOptions>
<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls>
<Folder>" + context.SP_site_noTrailingSlash + "/" + context.SP_folder_noLeadingSlash + "</Folder>
</QueryOptions>
</queryOptions>
</GetListItems>
</soapenv:Body>
</soapenv:Envelope>"
"SP_site_noTrailingSlash" is the SharPoint Site such as " http://some.any.com/sites/site", and "SP_folder_noLeadingSlash" is library folder such as "Shared%20Documents/Some%20and%20more%20description". (Note that when you set up folder value in windows batch file, you must use %%20 instead of %20.)
Have fun !
_AnonymousUser
Specialist III
Specialist III

Getting the following error while fetching a sharepoint file. Was wondering if anyone had a similar issue and the way it was resolved.
Exception in component tFileFetch_1
java.lang.Exception: Method failed: HTTP/1.1 404 NOT FOUND
sukumar_c
Contributor
Contributor

Hi,
Can any know hoe to place the xls file in share point library .
Erika_Mihara
Contributor
Contributor

Hello,

 

I'm trying to download a file from sharepoint using the tfilefetch component and it's showing the message

 

org.apache.commons.httpclient.HttpMethodBase processResponseHeaders

WARNING: Cookie rejected: "$Version=0; esctx=xxxxxxxxx--xxxxxxxxxxxxxxxxxx-xxxxxxxxx; $Path=/; $Domain=.login.microsoftonline.com". Illegal domain attribute ".login.microsoftonline.com". Domain of origin: "login.microsoftonline.com"

how should I proceed?