Alaska Software Inc. - SharePoint
Username: Password:
AuthorTopic: SharePoint
Jonathan LeemingSharePoint
on Fri, 27 Sep 2019 12:25:11 -0600
Hi,

I have a need to be able to retrieve and possible save various documents 
to a SharePoint Server from within my Xbase 2.0 app.  Thus far I have 
successfully connected & logged into the SP Server and can recursively 
traverse all the folders and report on folder & file names found.  Most 
of these files are ASPX files although there is one folder /_catalogs/wp 
that contains a bunch of files with DWP or webpart extensions.  There 
are also a number of JavaScript (js) files in some folders.

Nowhere do I see and documents, spreadsheets or PDF files.

I am using ChilKat's SharePoint ActiveX library 
(https://www.chilkatsoft.com) to connect a work with SharePoint.

Following Chilkat's example to "Download SharePoint Lists and JSON 
Iterate" I retrieved 18 lists (attached SP_Lists44355.txt) and in 
processing them based upon Chilkat's "Retrieve a Particular SharePoint 
List as JSON" where I looped through the guid's from the SPLists the 
retrieval process produced the results in the attached SP_Content.txt file.

I don't know if the above is of any use to me as I am suck as what to do 
with this.  In reading about SharePoint I'm thinking that there is some 
sort of document library but I have no idea how to access this. I came 
across the following 
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest 
and after reading though it am no further ahead.

Does anyone have any experience / insight regarded SharePoint who might 
be able to point me in a more productive direction as currently I'm stuck!

Thanks... Jonathan

jonathan.leeming@familycentre.org
Edmonton, Alberta, Canada

SP_Lists44355.txt
SP_Content.txt
Andreas Gehrs-Pahl
Re: SharePoint
on Fri, 27 Sep 2019 18:37:06 -0400
Jonathan,

Take a look at: https://www.example-code.com/foxpro/sharepoint.asp
for some help with this. Specifically, the following topics:
https://www.example-code.com/foxpro/sharepoint_get_files_in_documents_folder.asp
and https://www.example-code.com/foxpro/sharepoint_download_file.asp should 
help.

If the FoxPro Syntax isn't quite clear enough, check one of the other 
language examples, listed above.

And f you need help with implementing this, let me know, and we can work 
something out.

Hope this helps,

Andreas

Andreas Gehrs-Pahl
Absolute Software, LLC

phone: (989) 723-9927
email: Andreas@AbsoluteSoftwareLLC.com
web:   http://www.AbsoluteSoftwareLLC.com
[F]:   https://www.facebook.com/AbsoluteSoftwareLLC