SPList Component

Properties Methods Events Configuration Settings Errors

Manages the list items and attachments of the list items relating to a specific SharePoint List.

Syntax

nsoftware.InSP.Splist

Remarks

The SPList component allows you to manage SharePoint Lists. While it can also be used to manage SharePoint Libraries, the SPDocuments component is specifically designed for usage with individual SharePoint Documents.

To get started, first set the URL, User, and Password properties to point the component 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 component.

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 component 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 component 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 component 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 component 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.