Accessing InfoPath data held in Sharepoint

[darrylgould]

Hello

Is it possible to query / access data held in a SharePoint library from
outside of SharePoint?

At present we have an InfoPath form which submits to a SharePoint
library. Is it possible to query the contents of all the forms without
going into SharePoint?

I ask the question because we would ideally like to have all the data
on the forms transferred to a SQL table.

Thanks
Darryl

 

[S.Y.M. Wong-A-Ton]

You can use the WebClient class in .NET to retrieve a form from a library as
a binary stream. From there you can do whatever you like with the stream.

Another option is to directly connect to the SharePoint database containing
the forms in SQL Server. Note: This is *not recommended* by Microsoft. You'd
have to do some investigation which database and/or tables you'd need to
access to retrieve the forms, but after you have that it's the same thing as
with the WebClient class, retrieve the BLOB for the form and then use it to
you likings.

 

[darrylgould]

Many thanks

You can use the WebClient class in .NET to retrieve a form from a library as
a binary stream. From there you can do whatever you like with the stream.

Another option is to directly connect to the SharePoint database containing
the forms in SQL Server. Note: This is *not recommended* by Microsoft. You'd
have to do some investigation which database and/or tables you'd need to
access to retrieve the forms, but after you have that it's the same thing as
with the WebClient class, retrieve the BLOB for the form and then use it to
you likings.