PdcSharepoint.FileListViaRelativePath

Declaration

FileListViaRelativePath(intDirectoryType As Integer, intPID as Integer, strSubDirectory as String) As SharepointFileInfoList

Description

This function will return a list of files that are in a specific directory. The relative path to this directory is determine by the DirectoryType and Pid, but using the SubDirectory parameter you can go even deeper.

• The parameter intDirectoryType indicates a number which provides context regarding the entity. This number corresponds to an entity type, for example Companies or Calculations. See DirectoryTypes for more information.
• The parameter intPID is the unique _pid value that each record in the database has. This pid is used to determine which folder needs to be searched for within Sharepoint.
• The parameter strSubDirectory is for any subdirectory within the main directory. For example if the directory structure is like this: 'Companies\00211 - AHREND [68]\invoices\October', you can fill in the strSubDirectory parameter with 'invoices\October' to search within the oktober subdirectory.

If successful, the result will contain a SharepointFileInfoList from which all the files can be accessed. This list includes files and directories, via the property IsDirectory you can determine what the file is.
If unsuccessful, the result is nothing

Code example

Dim sp As PDCEXT.PdcSharepoint = PDC.App.Sharepoint("scriptUploadLocation")
Dim spFileInfoList As PDCEXT.SharepointFileInfoList = sp.FileListViaRelativePath(2, 68, "invoices")
If Not IsNothing(spFileInfoList) Then
    For i As Integer = 0 To spFileInfoList.Count - 1
        Dim spFileInfo As PDCEXT.SharepointFileInfo = spFileInfoList.Items(i)
        MsgBox(spFileInfo.FileName)
    Next
End If

Availability

Available since 2024R4