JDBC Driver for SharePoint

Build 21.0.8137


Create, update, query, and delete items in SharePoint Contact lists.


Name Type ReadOnly Description
ID [KEY] String True

The ID of the item. The value of this field is of the format: List|ItemId

List String False

The name of the contacts list.

FirstName String False

The first name of the contact.

Title String False

The last name of the contact.

FullName String False

The full name of the contact.

Email String False

The email of the entry.

Company String False

The company the contact works for.

JobTitle String False

The job title of the contact.

WorkPhone String False

The business phone of the contact.

HomePhone String False

The home phone of the contact.

CellPhone String False

The mobile phone of the contact.

WorkFax String False

The fax number of the contact.

WorkAddress String False

The address of the contact.

WorkCity String False

City for the address of the contact.

WorkState String False

State for the address of the contact.

WorkZip String False

Postal code for the address of the contact.

WorkCountry String False

Country for the address of the contact.

WebPage String False

Web page for the contact.

Comments String False

Notes about the contact.

Author String False

The user that created the item.

Editor String False

The last user that modified the item.

Modified Date False

The date modified.

Created Date False

The date created.


SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CAMLQuery String

The query to be used while listing the list items.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137