JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ContactsFileAttachments

The file attachment that includes additional fields used for attachments to various classes.

Table-Specific Information

SELECT

The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.

SELECT * FROM ContactsFileAttachments WHERE id = 12
SELECT * FROM ContactsFileAttachments WHERE id > 15
SELECT * FROM ContactsFileAttachments WHERE filename LIKE '%test'
SELECT * FROM ContactsFileAttachments WHERE id IN (12,23,123)
SELECT * FROM ContactsFileAttachments WHERE filename IS NOT NULL

Columns

Name Type Description
ContactsId Long The unique identifier of the contact.
ContentType String The MIME content type of the file. For example, text/plain, audio/mp3, image/jpg, and so on.
CreatedTime Datetime The date and time when the file was associated with the object. This attribute is read-only.
Data String The Base64 encoded data contained in the file. The maximum supported length is defined by the maximum number of bytes allowed by this field.
Description String The description for the contents of the file attachment.
FileName String The name of the file when saving it to the disk.
FormData String The HTML form which is used to upload file attachments.
Id [KEY] Long The unique identifier of the file attachment.
Name String The short display name of the file attachment.
Size Int The size of the file in bytes. This attribute is read-only.
URL String The URL to access this file.
UpdatedTime Datetime The date and time when the file attachment was last updated. This attribute is read-only.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462