Contacts
Create, update, delete, and query Contacts items.
テーブル固有の情報
Update およびDelete
本製品 では、アイテムの更新および削除にはItemChangeKey が必要です。ただし、ItemChangeKey が不明な場合には、本製品 は自動的にExchange サーバーからこれを取得することができます。 これはクエリ実行にかかる時間を増加させることに注意してください。
Columns
| Name | Type | ReadOnly | Description |
| ItemId [KEY] | String | True |
Contains the unique identifier of an item in the Exchange store. This property is read-only. |
| MimeContent | String | True |
Contains the native Multipurpose Internet Mail Extensions (MIME) stream of an object that is represented in Base64 binary format. |
| ItemChangeKey | String | True |
Contains the unique change key of an item in the Exchange store. This property is read-only. |
| ParentFolderId | String | False |
Represents the unique identifier of the parent folder that contains the item or folder. This property is read-only. |
| ParentFolderChangeKey | String | True |
Represents the unique change key of the parent folder that contains the item or folder. This property is read-only. |
| ItemClass | String | False |
Represents the message class of an item. |
| Subject | String | False |
Represents the subject for Exchange store items and response objects. The subject is limited to 255 characters. |
| Sensitivity | String | True |
Indicates the sensitivity level of an item. |
| Body | String | False |
Represents the actual body content of a message. |
| DateTimeReceived | Datetime | True |
Represents the date and time that an item in a mailbox was received. |
| Size | Integer | True |
Represents the size in bytes of an item. This property is read-only. |
| Categories | String | False |
Represents a collection of strings that identify to which categories an item in the mailbox belongs. |
| Importance | String | False |
Describes the importance of an item. |
| IsSubmitted | Boolean | True |
Indicates whether an item has been submitted to the Outbox default folder. |
| InReplyTo | String | True |
Represents the identifier of the item to which this item is a reply. |
| IsDraft | Boolean | True |
Represents whether an item has not yet been sent. |
| IsFromMe | Boolean | True |
Indicates whether a user sent an item to himself or herself. |
| IsResend | Boolean | True |
Indicates whether the item had previously been sent. |
| IsUnmodified | Boolean | True |
Indicates whether the item has been modified. |
| InternetMessageHeaders | String | True |
Represents the collection of all Internet message headers that are contained within an item in a mailbox. |
| DateTimeSent | Datetime | True |
Represents the date and time that an item in a mailbox was sent. |
| DateTimeCreated | Datetime | True |
Represents the date and time that a given item in the mailbox was created. |
| ReminderDueBy | Datetime | False |
Represents the date and time when the event occurs. |
| ReminderIsSet | Boolean | False |
Indicates whether a reminder has been set for an item in the Exchange store. |
| ReminderMinutesBeforeStart | Integer | False |
Represents the number of minutes before an event occurs when a reminder is displayed. |
| DisplayCc | String | True |
Represents the display string that is used for the contents of the Cc box. This is the concatenated string of all Cc recipient display names. |
| DisplayTo | String | True |
Represents the display string that is used for the contents of the To box. This is the concatenated string of all To recipient display names. |
| HasAttachments | Boolean | True |
Represents a property that is set to true if an item has at least one visible attachment. This property is read-only. |
| Culture | String | False |
Represents the culture for a given item in a mailbox. |
| EffectiveRights_CreateAssociated | Boolean | True |
Indicates whether a client can create an associated contents table. |
| EffectiveRights_CreateContents | Boolean | True |
Indicates whether a client can create a contents table. |
| EffectiveRights_CreateHierarchy | Boolean | True |
Indicates whether a client can create a hierarchy table. |
| EffectiveRights_Delete | Boolean | True |
Indicates whether a client can delete a folder or item. |
| EffectiveRights_Modify | Boolean | True |
Indicates whether a client can modify a folder or item. |
| EffectiveRights_Read | Boolean | True |
Indicates whether a client can read a folder or item. |
| EffectiveRights_ViewPrivateItems | Boolean | True |
Indicates whether a private item can be viewed. |
| LastModifiedName | String | True |
Contains the display name of the last user to modify an item. |
| LastModifiedTime | Datetime | True |
Indicates when an item was last modified. This element is read-only. |
| IsAssociated | Boolean | False |
Indicates whether the item is associated with a folder. |
| WebClientReadFormQueryString | String | True |
Represents a URL to concatenate to the Microsoft Office Outlook Web App endpoint to read an item in Outlook Web App. |
| WebClientEditFormQueryString | String | True |
Represents a URL to concatenate to the Outlook Web App endpoint to edit an item in Outlook Web App. |
| ConversationId | String | True |
Identifies a specific conversation in the Exchange store. |
| UniqueBody | String | True |
Represents an HTML fragment or plain-text which represents the unique body of this conversation. |
| UniqueBodyType | String | True |
Describes how the unique item body is stored in the item (HTML or TEXT). |
| FileAs | String | False |
Represents how a contact or distribution list is filed in the Contacts folder. |
| FileAsMapping | String | False |
Defines how to construct what is displayed for a contact. |
| DisplayName | String | False |
Defines the display name of a folder, contact, distribution list, delegate user, location, or rule. |
| GivenName | String | False |
Contains the given name of a contact. |
| Initials | String | False |
Represents the initials of a contact. |
| MiddleName | String | False |
Represents the middle name of a contact. |
| Nickname | String | False |
Represents the nickname of a contact. |
| CompleteName_Title | String | True |
Represents the title of a contact. |
| CompleteName_FirstName | String | True |
Represents the first name of a contact. |
| CompleteName_MiddleName | String | True |
Represents the middle name of a contact. |
| CompleteName_LastName | String | True |
Represents the last name of a contact. |
| CompleteName_Suffix | String | True |
Represents the suffix of a contact. |
| CompleteName_Initials | String | True |
Represents the initials of a contact. |
| CompleteName_FullName | String | True |
Represents the full name of a contact. |
| CompleteName_Nickname | String | True |
Represents the nickname of a contact. |
| CompleteName_YomiFirstName | String | True |
Represents the name used in Japan for the searchable or phonetic spelling of a Japanese first name. |
| CompleteName_YomiLastName | String | True |
Represents the name used in Japan for the searchable or phonetic spelling of a Japanese first name. |
| CompanyName | String | False |
Represents the company name that is associated with a contact. |
| EmailAddress1 | String | False |
Represents a single email address for a contact. |
| EmailAddress2 | String | False |
Represents a single email address for a contact. |
| EmailAddress3 | String | False |
Represents a single email address for a contact. |
| BusinessAddress_Street | String | False |
Represents the Business street address for a contact item. |
| BusinessAddress_City | String | False |
Represents the Business city name for a contact item. |
| BusinessAddress_State | String | False |
Represents the Business state of residence for a contact item. |
| BusinessAddress_Country | String | False |
Represents the Business country or region for a contact item. |
| BusinessAddress_PostalCode | String | False |
Represents the Business postal code for a contact item. |
| HomeAddress_Street | String | False |
Represents the Home street address for a contact item. |
| HomeAddress_City | String | False |
Represents the Home city name for a contact item. |
| HomeAddress_State | String | False |
Represents the Home state of residence for a contact item. |
| HomeAddress_Country | String | False |
Represents the Home country or region for a contact item. |
| HomeAddress_PostalCode | String | False |
Represents the Home postal code for a contact item. |
| OtherAddress_Street | String | False |
Represents the Other street address for a contact item. |
| OtherAddress_City | String | False |
Represents the Other city name for a contact item. |
| OtherAddress_State | String | False |
Represents the Other state of residence for a contact item. |
| OtherAddress_Country | String | False |
Represents the Other country or region for a contact item. |
| OtherAddress_PostalCode | String | False |
Represents the Other postal code for a contact item. |
| AssistantPhone | String | False |
Represents the AssistantPhone number for a contact item. |
| BusinessFax | String | False |
Represents the BusinessFax number for a contact item. |
| BusinessPhone | String | False |
Represents the BusinessPhone number for a contact item. |
| BusinessPhone2 | String | False |
Represents the BusinessPhone2 number for a contact item. |
| Callback | String | False |
Represents the Callback number for a contact item. |
| CarPhone | String | False |
Represents the CarPhone number for a contact item. |
| CompanyMainPhone | String | False |
Represents the CompanyMainPhone number for a contact item. |
| HomeFax | String | False |
Represents the HomeFax number for a contact item. |
| HomePhone | String | False |
Represents the HomePhone number for a contact item. |
| HomePhone2 | String | False |
Represents the HomePhone2 number for a contact item. |
| Isdn | String | False |
Represents the Isdn number for a contact item. |
| MobilePhone | String | False |
Represents the MobilePhone number for a contact item. |
| OtherFax | String | False |
Represents the OtherFax number for a contact item. |
| OtherTelephone | String | False |
Represents the OtherTelephone number for a contact item. |
| Pager | String | False |
Represents the Pager number for a contact item. |
| PrimaryPhone | String | False |
Represents the PrimaryPhone number for a contact item. |
| RadioPhone | String | False |
Represents the RadioPhone number for a contact item. |
| Telex | String | False |
Represents the Telex number for a contact item. |
| TtyTddPhone | String | False |
Represents the TtyTddPhone number for a contact item. |
| AssistantName | String | False |
Represents an assistant to a contact. |
| Birthday | Datetime | False |
Represents the birth date of a contact. |
| BusinessHomePage | String | False |
Represents the Home page (Web address) for the contact. |
| Children_1 | String | False |
Contains the name of the child of a contact. |
| Children_2 | String | False |
Contains the name of the child of a contact. |
| Children_3 | String | False |
Contains the name of the child of a contact. |
| Companies_1 | String | False |
Represents the name of a company associated with a contact. |
| Companies_2 | String | False |
Represents the name of a company associated with a contact. |
| Companies_3 | String | False |
Represents the name of a company associated with a contact. |
| ContactSource | String | False |
Describes whether the contact is located in the Exchange store or Active Directory Domain Services. |
| Department | String | False |
Represents the department of a contact. |
| Generation | String | False |
Represents a generational abbreviation that follows the full name of a contact. |
| ImAddress1 | String | False |
Represents an instant messaging (IM) address for a contact. |
| ImAddress2 | String | False |
Represents an instant messaging (IM) address for a contact. |
| ImAddress3 | String | False |
Represents an instant messaging (IM) address for a contact. |
| JobTitle | String | False |
Represents the job title of a contact. |
| Manager | String | False |
Represents the manager of a contact. |
| Mileage | String | False |
Represents the mileage for a contact item. |
| OfficeLocation | String | False |
Represents the office location of a contact. |
| PostalAddressIndex | String | False |
Represents the display type for the physical address of a contact. |
| Profession | String | False |
Represents the profession of a contact. |
| SpouseName | String | False |
Represents the name of the spouse or partner of the contact. |
| Surname | String | False |
Represents the surname of a contact. |
| WeddingAnniversary | Datetime | False |
Contains the wedding anniversary of a contact. |
| HasPicture | Boolean | False |
Indicates whether the contact item has a file attachment that represents the picture of a contact. |
| PhoneticFullName | String | False |
Contains the full name of a contact, including the first and last name, spelled phonetically. |
| PhoneticFirstName | String | False |
Contains the first name of a contact, spelled phonetically. |
| PhoneticLastName | String | False |
Contains the last name of a contact, spelled phonetically. |
| Alias | String | False |
Contains the email alias of a contact. |
| Notes | String | False |
Contains supplementary contact information. |
| Photo | String | False |
Contains a value that encodes the photo of a contact. |
| UserSMIMECertificate | String | False |
Contains a value that encodes the SMIME certificate of a contact. |
| MSExchangeCertificate | String | False |
Contains a value that encodes the Microsoft Exchange certificate of a contact. |
| DirectoryId | String | False |
Contains the directory Id of a contact. |
| ManagerMailbox | String | False |
Contains SMTP information that identifies the mailbox of the manager of a contact. |
| DirectReports | String | False |
Contains SMTP information that identifies the direct reports of a contact. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ImpersonationUser | String |
The Identifier of the user to impersonate. |
| ImpersonationType | String |
The type of Identifier used for the impersonation user (PrincipalName, SID, PrimarySmtpAddress, SmtpAddress). |
| SharedMailboxEmail | String |
The email of a shared mailbox. Use this to retrieve the contacts of a shared mailbox. |