You can translate the question and the replies:

Dynamically constructed HTTP connection to CSV files held in a SharePoint 2013 document library

We have a SharePoint library where an external mechanism will routinely upload CSV files to (Note that the only constant will be that it will be a CSV file of a specific format, and SharePoint won't allow duplicate named files). In our testing we've successfully created an HTTP connection to a static named CSV file - all good. What we need to be able to do is to interrogate the library and list the files that it holds, and iterate through them to ingest them into a virtual data platform. Side note: its probably out of scope for this query to say that we'd like to join all of the files found in this library into one virtual dataset --> we will broach this separately.
17-04-2016 19:06:10 -0400

1 Answer

There are different ways to do this: 1. Using a Network Drive in your Denodo Server: a.In your Denodo Server map a new network drive b.Use your Sharepoint Document folder path (e.g.Z:/ = http://sharepoint_url/Shared Documents) c Use that path (e.g Z:/) in your Denodo Delimited File data source, you can also use a regular expression in the File name Pattern (e.g. (.*)\.txt) will give you access to all the files in that folder with txt as extension 2. Using an input variable in your data source Local Path parameter: a. Use @file_path in your "Local Path" field of your Delimited File data source, Denodo will create a mandatory parameter called file_path that you can use to pass a file path as input parameter b. Use Denodo's Odata Connector available in the Denodo Support Site - Denodo Connects section to obtain all the file names available in a folder and then join the results with the previous view (2.a) using the file_path field. The OData Connector configuration should look like this: 'Service Endpoint *' = 'http://sharepoint_url/_vti_bin/ListData.svc' 'Entity Collection *' = 'SharedDocuments' 'Service Format *' = 'XML-Atom' 'Service Version' = 'V2' Hope this helps!
Denodo Team
18-04-2016 15:45:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here