|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(DataFlex) SharePoint -- Get Files in Documents FolderSee more SharePoint ExamplesGets the list of files that exist in the /Documents folder.
Use ChilkatAx-win32.pkg Procedure Test Handle hoHttp Variant vSbJson Handle hoSbJson Boolean iSuccess Handle hoJson Integer iNumFiles Handle hoLastMod Variant vDt Handle hoDt Boolean iBLocal Integer i String sFilename String sFileRelativeUri Integer iFileSize String sSLastModified String sTemp1 Integer iTemp1 Integer iTemp2 Integer iTemp3 Integer iTemp4 Integer iTemp5 // This requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. // ------------------------------------------------------------------------- // The following comments apply to SharePoint Windows classic authentication. // ------------------------------------------------------------------------- // For example, imagine our SharePoint endpoint is https://xyzoffice.mycompany.com/ // The SHAREPOINT_NTLM_DOMAIN would be "mycompany.com" // The SHAREPOINT_HTTPS_DOMAIN would be "xyzoffice.mycompany.com" // Also, the SHAREPOINT_USERNAME would be just the name, not a full email address. // for example, "chilkat" instead of "chilkat@mycompany.com" Get Create (RefClass(cComChilkatHttp)) To hoHttp If (Not(IsComObjectCreated(hoHttp))) Begin Send CreateComObject of hoHttp End // If SharePoint Windows classic authentication is used, then set the // Login, Password, LoginDomain, and NtlmAuth properties. Set ComLogin Of hoHttp To "SHAREPOINT_USERNAME" Set ComPassword Of hoHttp To "SHAREPOINT_PASSWORD" Set ComLoginDomain Of hoHttp To "SHAREPOINT_NTLM_DOMAIN" Set ComNtlmAuth Of hoHttp To True // ------------------------------------------------------------------------- // The more common case is to use SharePoint Online authentication (via the SPOIDCRL cookie). // If so, do not set Login, Password, LoginDomain, and NtlmAuth, and instead // establish the cookie as shown at SharePoint Online Authentication // ------------------------------------------------------------------------- // Indicate that we want a JSON reply Set ComAccept Of hoHttp To "application/json;odata=verbose" Set ComAcceptCharset Of hoHttp To "utf-8" // If your Sharepoint site is within a site collection, then use "https://SHAREPOINT_HTTPS_DOMAIN/sites/teamA/_api/web/GetFolderByServerRelativeUrl('/sites/teamA/Documents')/Files" where "teamA" is the name of the site. Get Create (RefClass(cComChilkatStringBuilder)) To hoSbJson If (Not(IsComObjectCreated(hoSbJson))) Begin Send CreateComObject of hoSbJson End Get pvComObject of hoSbJson to vSbJson Get ComQuickGetSb Of hoHttp "https://SHAREPOINT_HTTPS_DOMAIN/_api/web/GetFolderByServerRelativeUrl('/Documents')/Files" vSbJson To iSuccess If (iSuccess <> True) Begin Get ComLastErrorText Of hoHttp To sTemp1 Showln sTemp1 Procedure_Return End Get Create (RefClass(cComChilkatJsonObject)) To hoJson If (Not(IsComObjectCreated(hoJson))) Begin Send CreateComObject of hoJson End Get pvComObject of hoSbJson to vSbJson Get ComLoadSb Of hoJson vSbJson To iSuccess // Iterate over the results and get each file's name, size, and last-modified date/time. Get ComSizeOfArray Of hoJson "d.results" To iNumFiles Showln "Number of Files in the SharePoint /Documents folder = " iNumFiles Get Create (RefClass(cComCkDateTime)) To hoLastMod If (Not(IsComObjectCreated(hoLastMod))) Begin Send CreateComObject of hoLastMod End Move True To iBLocal Move 0 To i While (i < iNumFiles) Set ComI Of hoJson To i Get ComStringOf Of hoJson "d.results[i].Name" To sFilename Get ComStringOf Of hoJson "d.results[i].ServerRelativeUrl" To sFileRelativeUri Get ComIntOf Of hoJson "d.results[i].Length" To iFileSize Get ComStringOf Of hoJson "d.results[i].TimeLastModified" To sSLastModified Showln (i + 1) ": " sFilename Showln " Relative URI: " sFileRelativeUri Showln " Size in Bytes: " iFileSize // Show the last-modified date/time in the local timezone. Get ComSetFromTimestamp Of hoLastMod sSLastModified To iSuccess Get ComGetDtObj Of hoLastMod iBLocal To vDt If (IsComObject(vDt)) Begin Get Create (RefClass(cComChilkatDtObj)) To hoDt Set pvComObject Of hoDt To vDt End Get ComDay Of hoDt To iTemp1 Get ComMonth Of hoDt To iTemp2 Get ComYear Of hoDt To iTemp3 Get ComHour Of hoDt To iTemp4 Get ComMinute Of hoDt To iTemp5 Showln " Last-Modified: " iTemp1 "/" iTemp2 "/" iTemp3 " " iTemp4 ":" iTemp5 Send Destroy of hoDt Move (i + 1) To i Loop // The output of this program when I tested it: // Number of Files in the SharePoint /Documents folder = 13 // 1: VCAC_DISA_brief_8_13_16.pdf // Relative URI: /Documents/VCAC_DISA_brief_8_13_16.pdf // Size in Bytes: 5571942 // Last-Modified: 14/8/2016 21:32 // 2: Test Procedure Self-Registration Kiosk.docx // Relative URI: /Documents/Test Procedure Self-Registration Kiosk.docx // Size in Bytes: 26568 // Last-Modified: 16/1/2017 10:46 // 3: VCAC_Architecture_Brief_8_29_15.pptx // Relative URI: /Documents/VCAC_Architecture_Brief_8_29_15.pptx // Size in Bytes: 28756136 // Last-Modified: 17/3/2016 15:32 // 4: D42_Device_70_IP.xlsx // Relative URI: /Documents/D42_Device_70_IP.xlsx // Size in Bytes: 17060 // Last-Modified: 14/3/2016 21:22 // 5: Domain Name created for Exchange.docx // Relative URI: /Documents/Domain Name created for Exchange.docx // Size in Bytes: 80651 // Last-Modified: 16/1/2017 11:8 // 6: VCAC_Architecture_Brief_8_29_15.pdf // Relative URI: /Documents/VCAC_Architecture_Brief_8_29_15.pdf // Size in Bytes: 5814495 // Last-Modified: 17/3/2016 15:30 // 7: D42_Device_70_IP223.xlsx // Relative URI: /Documents/D42_Device_70_IP223.xlsx // Size in Bytes: 17109 // Last-Modified: 16/1/2017 12:1 // 8: image_VCAC.png // Relative URI: /Documents/image_VCAC.png // Size in Bytes: 4825795 // Last-Modified: 21/3/2016 14:13 // 9: FRC_Summit_brief.pdf // Relative URI: /Documents/FRC_Summit_brief.pdf // Size in Bytes: 2202216 // Last-Modified: 14/8/2016 21:31 // 10: VCAC_RA_Design.docx // Relative URI: /Documents/VCAC_RA_Design.docx // Size in Bytes: 32278 // Last-Modified: 15/1/2017 22:44 // 11: VCAC_PEO_EIS_Brief_3_23_16.pdf // Relative URI: /Documents/VCAC_PEO_EIS_Brief_3_23_16.pdf // Size in Bytes: 7239114 // Last-Modified: 22/3/2016 17:50 // 12: VCAC-document.docx // Relative URI: /Documents/VCAC-document.docx // Size in Bytes: 21082 // Last-Modified: 15/1/2017 22:44 // 13: Engineering_Drawing (sample).jpg // Relative URI: /Documents/Engineering_Drawing (sample).jpg // Size in Bytes: 97638 // Last-Modified: 22/3/2016 17:51 End_Procedure |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.