SPList Bean
Properties Methods Events Configuration Settings Errors
Manages the list items and attachments of the list items relating to a specific SharePoint List.
Syntax
InSP.Splist
Remarks
The SPList bean allows you to manage SharePoint Lists. While it can also be used to manage SharePoint Libraries, the SPDocuments bean is specifically designed for usage with individual SharePoint Documents.
To get started, first set the URL, User, and Password properties to point the bean to your Site, and then set List to the Id of a specific SharePoint List to manage. To retrieve Ids for all of the Lists on your Site, use the SPSite bean.
When ListItems is called, the Item event will fire for each item in the specified list and Items will be populated. Specific fields of an item can be retrieved using the GetItemField method. Use ListAttachments to list the attachments of a specific item, which will be provided in the Attachment event.
Use the AddItems, DeleteItems, and UpdateItems methods to add, delete, and update items of a specific List. AddAttachment and DeleteAttachment can be used to add and delete attachments from a specific item in a List.
About SharePoint Online Services
When using Microsoft SharePoint Online you must set AuthScheme to authSPOnline (7).
Property List
The following is the full list of the properties of the bean with short descriptions. Click on the links for further details.
AuthScheme | The authentication scheme to be used while authenticating with the server. |
Firewall | A set of properties related to firewall access. |
Idle | The current status of the component. |
ItemMarker | The marker of the last item from the previous listing. |
Items | The collection of list items to use while altering or listing the items of a list. |
List | The Id or Title of the selected list. |
LocalFile | The path to a local file for downloading. |
Password | The password to use for authentication. |
Proxy | A set of properties related to proxy access. |
Query | The query to be used while listing the list items. |
SSLAcceptServerCert | Instructs the component to unconditionally accept the server certificate that matches the supplied certificate. |
SSLCert | The certificate to be used during SSL negotiation. |
SSLServerCert | The server certificate for the last established connection. |
Timeout | A timeout for the component. |
URL | The base URL for the site. |
User | The user account to use for authentication. |
Method List
The following is the full list of the methods of the bean with short descriptions. Click on the links for further details.
addAttachment | Adds an attachment to a specific item of a list. |
addItems | Adds items to the List . |
config | Sets or retrieves a configuration setting . |
deleteAttachment | Deletes an attachment from an item in the list. |
deleteItems | Deletes items from the List . |
doEvents | Processes events from the internal message queue. |
getAttachment | Retrieves an attachment from the list specified by List . |
getItemField | Retrieves the value of a field of an item. |
getXAttribute | Retrieve the value at the specified XPath in the SOAP response. |
interrupt | Interrupt the current method. |
listAttachments | Lists the attachments related to a specific list item. |
listItems | Lists the items in the specified SharePoint list. |
reset | Resets request-related properties. |
sendCustomRequest | Sends a custom request to the server. |
setDownloadStream | Sets the stream to which the downloaded data from the server will be written. |
setUploadStream | Sets the stream to be uploaded to the server. |
updateItems | Updates List items. |
Event List
The following is the full list of the events fired by the bean with short descriptions. Click on the links for further details.
Attachment | Fired for each attachment. |
Error | Information about errors during data delivery. |
Item | Fires for each item in the list. |
SSLServerAuthentication | Fired after the server presents its certificate to the client. |
SSLStatus | Shows the progress of the secure connection. |
Configuration Settings
The following is a list of configuration settings for the bean with short descriptions. Click on the links for further details.
AllowLocalFile | Whether AddAttachment uploads the file specified by LocalFile. |
ContinueOnError | Indicates whether to continue updating items or not on an error. |
EscapeXML | Indicates whether to XML escape the data. |
ExpandRecurrence | Indicates whether to expand recurring events when querying a Calendar list. |
IncludedFields | The fields to request when calling ListItems. |
IncludeFieldsWithViewId | Indicates whether to use the IncludedFields setting when using the ViewId setting. |
PagingId | Used to check for paged results from SharePoint. |
QueryOptions | The full QueryOptions xml element to submit to SharePoint. |
RawEntry | Returns the raw entry for the listing inside the Item event. |
RowLimit | Limits the rows returned by ListItems. |
SiteURL | The complete URL for a service. |
Scope | Sets the scope for the View used by the ListItems method. |
SOAPRequest | The contents of the request sent to the server. |
SOAPResponse | The response from the last request. |
Subfolder | The subfolder of the specified list. |
UseRawTagNames | Whether to use the raw XML tag names. |
ViewId | The GUID of a view to use when listing items. |
FormBasedCookies | Holds the security cookies for Form-Based Authentication. |
SPOnlineSecurityCookies | Holds the security cookies for SharePoint Online. |
SPOnlineSSO | Whether to use Single Sign On (SSO) with Active Directory Federation Services (ADFS). |
SPOnlineSTS | The URL of the online STS. |
SPOnlineADFSAuthScheme | The HTTP authentication scheme used when working with SSO. |
SSODomain | Specifies the federation domain configured in Office 365. |
ParseCustomResponse | Whether to automatically parse the response from the SendCustomRequest() method. |
XPath | Provides a way to point to a specific element in the returned XML response. |
XText | The text of the current element. |
XElement | The name of the current element. |
XNamespace | The namespace of the current element. |
XParent | The parent of the current element. |
XPrefix | The prefix of the current element. |
XSubTree | A snapshot of the current element in the document. |
XAttributesCount | The number of attributes of the current element. |
XAttributesName[x] | The name of the selected attribute. |
XAttributesValue[x] | The attribute value. |
XAttributesNamespace[x] | The attribute namespace. |
XAttributesPrefix[x] | The attribute prefix. |
XChildrenCount | The number of child elements of the current element. |
XChildrenName[x] | The name of the child element. |
XChildrenXText[x] | The inner text of the child element. |
XChildrenNamespace[x] | The namespace of the child element. |
XChildrenPrefix[x] | The prefix of the child element. |
AcceptEncoding | Used to tell the server which types of content encodings the client supports. |
AllowHTTPCompression | This property enables HTTP compression for receiving data. |
AllowIdenticalRedirectURL | Allow redirects to the same URL. |
Append | Whether to append data to LocalFile. |
Authorization | The Authorization string to be sent to the server. |
BytesTransferred | Contains the number of bytes transferred in the response data. |
EncodeURL | If set to true the URL will be encoded by the component. |
FollowRedirects | Determines what happens when the server issues a redirect. |
GetOn302Redirect | If set to true the component will perform a GET on the new location. |
HTTPVersion | The version of HTTP used by the component. |
IfModifiedSince | A date determining the maximum age of the desired document. |
KeepAlive | Determines whether the HTTP connection is closed after completion of the request. |
MaxRedirectAttempts | Limits the number of redirects that are followed in a request. |
OtherHeaders | Other headers as determined by the user (optional). |
ProxyAuthorization | The authorization string to be sent to the proxy server. |
ProxyAuthScheme | The authorization scheme to be used for the proxy. |
ProxyPassword | A password if authentication is to be used for the proxy. |
ProxyPort | Port for the proxy server (default 80). |
ProxyServer | Name or IP address of a proxy server (optional). |
ProxyUser | A user name if authentication is to be used for the proxy. |
TransferredDataLimit | The maximum number of incoming bytes to be stored by the component. |
TransferredHeaders | The full set of headers as received from the server. |
UseChunkedEncoding | Enables or Disables HTTP chunked encoding for transfers. |
ChunkSize | Specifies the chunk size in bytes when using chunked encoding. |
UserAgent | Information about the user agent (browser). |
KerberosSPN | The Service Principal Name for the Kerberos Domain Controller. |
ConnectionTimeout | Sets a separate timeout value for establishing a connection. |
FirewallAutoDetect | Tells the component whether or not to automatically detect and use firewall system settings, if available. |
FirewallHost | Name or IP address of firewall (optional). |
FirewallPassword | Password to be used if authentication is to be used when connecting through the firewall. |
FirewallPort | The TCP port for the FirewallHost;. |
FirewallType | Determines the type of firewall to connect through. |
FirewallUser | A user name if authentication is to be used connecting through a firewall. |
KeepAliveTime | The inactivity time in milliseconds before a TCP keep-alive packet is sent. |
KeepAliveInterval | The retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received. |
Linger | When set to True, connections are terminated gracefully. |
LingerTime | Time in seconds to have the connection linger. |
LocalHost | The name of the local host through which connections are initiated or accepted. |
LocalPort | The TCP port in the local host where the component binds. |
MaxLineLength | The maximum amount of data to accumulate when no EOL is found. |
MaxTransferRate | The transfer rate limit in bytes per second. |
RecordLength | The length of received data records. |
TCPKeepAlive | Determines whether or not the keep alive socket option is enabled. |
UseIPv6 | Whether to use IPv6. |
TcpNoDelay | Whether or not to delay when sending packets. |
ReuseSSLSession | Determines if the SSL session is reused. |
SSLCipherStrength | The minimum cipher strength used for bulk encryption. |
SSLEnabledProtocols | Used to enable/disable the supported security protocols. |
SSLProvider | The name of the security provider to use. |
SSLSecurityFlags | Flags that control certificate verification. |
OpenSSLCADir | The path to a directory containing CA certificates. |
OpenSSLCAFile | Name of the file containing the list of CA's trusted by your application. |
OpenSSLCipherList | A string that controls the ciphers to be used by SSL. |
OpenSSLPrngSeedData | The data to seed the pseudo random number generator (PRNG). |
AbsoluteTimeout | Determines whether timeouts are inactivity timeouts or absolute timeouts. |
FirewallData | Used to send extra data to the firewall. |
InBufferSize | The size in bytes of the incoming queue of the socket. |
OutBufferSize | The size in bytes of the outgoing queue of the socket. |
CodePage | The system code page used for Unicode to Multibyte translations. |