SSIS Components for Oracle Service Cloud

Build 24.0.9060

OpportunitiesFileAttachments

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

Table-Specific Information

SELECT

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

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

Columns

Name Type Description
OpportunitiesId Long The unique identifier of the opportunity.
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060