Establishing a Connection

Create a connection to Oracle Service Cloud by navigating to the Connections page in the Sync App application and selecting the corresponding icon in the Add Connections panel. If the Oracle Service Cloud icon is not available, click the Add More icon to download and install the Oracle Service Cloud connector from the CData site.

Required properties are listed under the Settings tab. The Advanced tab lists connection properties that are not typically required.

Connecting to OracleServiceCloud

You must set the following to authenticate to Oracle Service Cloud:

Url: The Url of the account to connect to.
User: The username of the authenticating account.
Password: The password of the authenticating account.

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Oracle Service Cloud APIs.

Key Features

The Sync App models Oracle Service Cloud entities like documents, folders, and groups as relational views, allowing you to write SQL to query Oracle Service Cloud data.
Stored procedures allow you to execute operations to Oracle Service Cloud
Live connectivity to these objects means any changes to your Oracle Service Cloud account are immediately reflected when using the Sync App.

Views

Views describes the available views.

Tables

Tables describes the available tables.

Stored Procedures

Stored Procedures are function-like interfaces to Oracle Service Cloud. Stored procedures allow you to execute operations to Oracle Service Cloud, including downloading documents and moving envelopes.

Tables

The Sync App models the data in Oracle Service Cloud into a list of tables that can be queried using standard SQL statements.

Generally, querying Oracle Service Cloud tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Oracle Service Cloud Connector for CData Sync Tables


Name	Description
Accounts	The account represents a staff member in Oracle B2C Service.
Answers	The knowledge base information that provides solutions to the common customer support questions.
AnswerVersions	The versioned instance of an answer. Answers are solutions to common customer support questions.
Assets	The product or service associated with an organization's customers.
ContactMarketingRosters	The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service.
Contacts	The customers or end users of Oracle B2C Service site.
Countries	The details about the countries and provinces which are used to maintain accurate address information for the organizations and contacts in Oracle B2C Service.
EventSubscriptions	The event-based subscription management object that allows external applications to discover objects that can be subscribed.
Holidays	The list of holidays in your organization.
Incidents	The question or the request for help submitted by a customer through the Ask a Question page, email, a chat session, site or answer feedback, or from an external source using the API.
Opportunities	The information about a specific sale or a pending deal with a contact or an organization that is tracked and maintained in the Oracle B2C Service knowledge base.
Organizations	The company, business unit of a large company, or government agency that has an organization record in the Oracle B2C Service knowledge base.
PurchasedProducts	The information about a purchased product.
SalesProducts	The items or services sold by an organization.
SalesTerritories	The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment.
ServiceCategories	The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
ServiceDispositions	The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved.
ServiceProducts	The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
StandardContents	The preformed text or HTML content that can be sent to customers when responding to incidents, appended to responses by a business rule, or sent by an agent during a chat session.
Tasks	The information about an action or an activity scheduled to be completed within a specified time.
Variables	A shortcut defined for a larger string that can be inserted in the body of an answer or inserted inline during a chat session.

Accounts

The account represents a staff member in Oracle B2C Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the login,namefirst,namelast,profileId,staffGroupId and newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Accounts (login,namefirst,namelast,profileId,staffGroupId,newpassword) VALUES ('testadministrator','abc','xyz','14','102243','testpw')

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Accounts SET namelast = 'abcd' WHERE id = 1

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Accounts WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
CountryId	Long	False	Id of country. The default country identifier.
CountrylookUpName	String	False	LookUpName of country. The default country identifier.
CreatedTime	Datetime	True	The date and time when the account was created. This attribute is read-only.
DisplayName	String	False	The display name of the account.
DisplayOrder	Int	False	The order in which this staff account is displayed relative to other members of the same group.
EmailNotificationId	Long	False	Id of emailNotification. The format the staff member prefers for email notifications.
EmailNotificationlookUpName	String	False	LookUpName of emailNotification. The format the staff member prefers for email notifications.
Id [KEY]	Long	True	The unique identifier of the account.
Login	String	False	The user name used for authentication.
LookupName	String	True	The name used to look up the account.
ManagerId	Long	False	Id of manager. The manager of the staff member.
ManagerlookUpName	String	False	LookUpName of manager. The manager of the staff member.
NewPassword	String	False	The new password for authentication. It is stored with a one-way encryption in the system. This attribute is write-only.
NotificationPending	Bool	True	Indicates whether any notifications are pending. This attribute does not have a default value and is read-only.
PasswordExpirationTime	Datetime	True	The date and time when the password is set to expire. This attribute is read-only.
ProfileId	Long	False	Id of profile. The profile to which the staff account is assigned.
ProfilelookUpName	String	False	LookUpName of profile. The profile to which the staff account is assigned.
Signature	String	False	The email signature of the account.
StaffGroupId	Long	False	Id of staffGroup. The group to which the staff member is assigned.
StaffGrouplookUpName	String	False	LookUpName of staffGroup. The group to which the staff member is assigned.
UpdatedTime	Datetime	True	The date and time when the account was last updated. This attribute is read-only.
AttributesaccountLocked	Bool	False	Indicates whether the account is temporarily locked. For example, you may lock a staff member's account who has taken a leave of absence. An account automatically gets locked if the staff member has exceeded the number of invalid login attempts or if the password has expired. The default value is false.
AttributescanModifyEmailSignature	Bool	False	Indicates whether the staff member can modify the email signature. The default value is false.
AttributesforcePasswordChange	Bool	False	Indicates whether the staff member must change the password at the next login. The value remains true until the staff member changes the password. The default value is false.
AttributesinfrequentUser	Bool	False	Indicates whether the staff member is considered as an infrequent user seat, as opposed to a full seat. The default value is false.
AttributespasswordNeverExpires	Bool	False	Indicates whether the staff member's account password never expires. This setting overrides system-wide password expiration configurations. The default value is false.
AttributespermanentlyDisabled	Bool	False	Indicates whether the staff member's account is permanently disabled. For example, an account is permanently disabled when a staff member leaves your organization. A disabled account appears in the tree of the Staff Accounts management console if Show Disabled setting is enabled, but you cannot deselect the Permanently Disable check box if you edit the account. You can reuse the login name of a permanently disabled account for a different account. The default value is false.
AttributesstaffAssignmentDisabled	Bool	False	Indicates whether the staff member's account cannot be assigned to incidents, answers, opportunities, and tasks. The default value is false.
AttributesviewsReportsDisabled	Bool	False	Indicates whether the staff member's account cannot be included in the list for filters in reports. The default value is false.
AttributesvirtualAccount	Bool	True	Indicates whether the staff member's account is virtual. The default value is false. This attribute is read-only.
Namefirst	String	False	The first name of the person.
Namelast	String	False	The surname or last name of the person.
NameFuriganafirst	String	False	The first name of the person.
NameFuriganalast	String	False	The surname or last name of the person.
SalesSettingsdefaultCurrencyId	Long	False	Id of defaultCurrency. The default currency ID.
SalesSettingsdefaultCurrencylookUpName	String	False	LookUpName of defaultCurrency. The default currency ID.
SalesSettingsterritoryId	Long	False	Id of territory. The sales territory ID.
SalesSettingsterritorylookUpName	String	False	LookUpName of territory. The sales territory ID.
ServiceSettingsscreenPopPort	Int	False	The port number assigned for screen-pop alerts for the staff account. It is used in Citrix and Terminal Services environments where there are multiple agents logged in to different sessions on the same machine.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
emails	String	The list of email addresses.
phones	String	The list of phone numbers.

Answers

The knowledge base information that provides solutions to the common customer support questions.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the answerTypeId,languageId, and summary newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Answers (answerTypeId,languageId,assignedsiblingId,summary) VALUES ('1','1','12','How do I register my product?')

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Answers SET solution = 'editorContent' WHERE id = '12'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Answers WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
AdminLastAccessTime	Datetime	True	The date and time when the answer was last accessed by an administrator. This attribute is read-only.
AnswerTypeId	Long	False	Id of answerType. The type of storage for answer information.
AnswerTypelookUpName	String	False	LookUpName of answerType. The type of storage for answer information.
AnswerVersionId	Long	True	Id of answerVersion. The versioned instance of the answer. This attribute is read-only.
AnswerVersionlookUpName	String	True	LookUpName of answerVersion. The versioned instance of the answer. This attribute is read-only.
AssignedSiblingId	Long	False	Id of assignedSibling. Another answer with which this answer should be associated.
AssignedSiblinglookUpName	String	False	LookUpName of assignedSibling. Another answer with which this answer should be associated.
CreatedTime	Datetime	True	The date and time when the answer was created. This attribute is read-only.
ExpiresDate	Date	False	The date when the answer expires and is set to review status.
GuidedAssistanceId	Long	True	Id of guidedAssistance. The Guided Assistance guide.
GuidedAssistancelookUpName	String	True	LookUpName of guidedAssistance. The Guided Assistance guide.
Id [KEY]	Long	True	The unique identifier of the answer.
Keywords	String	False	The list of space separated keywords associated with an answer.
LanguageId	Long	False	Id of language. The language used for the answer text.
LanguagelookUpName	String	False	LookUpName of language. The language used for the answer text.
LastAccessTime	Datetime	True	The date and time when the answer was last accessed. This attribute is read-only.
LastNotificationTime	Datetime	True	The date and time when the last notification was generated. This attribute is read-only.
LookupName	String	True	The name used to look up the answer.
Name	String	True	The string version of the answer ID, which is used as the reference number of the answer. This attribute is read-only.
NextNotificationTime	Datetime	False	The date and time when the next earliest notification will be sent.
OriginalReferenceNumber	String	False	The reference number of the incident that was proposed to create this answer. The reference number is common for all the sibling answers.
PositionInListId	Long	False	Id of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.
PositionInListlookUpName	String	False	LookUpName of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.
PublishOnDate	Date	False	The date when the answer will be published and made available to users.
Question	String	False	The question or the description of the answer.
Solution	String	False	The solution or the answer portion of the answer.
SpecialResponse	String	False	The special response of the answer.
Summary	String	False	The title or short summary of the answer.
URL	String	False	The URL which returns the answer, if the answer type is URL.
UpdatedByAccountId	Long	True	Id of updatedByAccount. The staff account who last edited the answer. This attribute is read-only.
UpdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account who last edited the answer. This attribute is read-only.
UpdatedTime	Datetime	True	The date and time when the answer was last updated. This attribute is read-only.
AssignedToaccountId	Long	False	Id of account. The staff account.
AssignedToaccountlookUpName	String	False	LookUpName of account. The staff account.
AssignedTostaffGroupId	Long	False	Id of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
AssignedTostaffGrouplookUpName	String	False	LookUpName of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.
VersionDetaildraftNote	String	False	The draft note for the answer version.
VersionDetaildraftTime	Datetime	False	The date and time when the draft answer version was created.
VersionDetailpublishNote	String	False	The published note for the answer version.
VersionDetailpublishedTime	Datetime	False	The date and time when the draft answer version was published.
VersionDetailstateId	Long	False	Id of state. The state of the version.
VersionDetailstatelookUpName	String	False	LookUpName of state. The state of the version.
VersionDetailunpublishedTime	Datetime	False	The date and time when the answer version was unpublished.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
categories	String	The hierarchical service category.
commonAttachments	String	The file attachments common to all sibling answers.
fileAttachments	String	The list of file attachments.
notes	String	The list of discussion threads.
products	String	The products common to all sibling answers.
relatedAnswers	String	The related answers linked to this answer.
siblingAnswers	String	The sibling answers with which this answer is associated. This attribute is read-only.

AnswerVersions

The versioned instance of an answer. Answers are solutions to common customer support questions.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE AnswerVersions SET keywords = 'test' WHERE id = 133

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM AnswerVersions WHERE id = 133

Columns


Name	Type	ReadOnly	Description
AdminLastAccessTime	Datetime	True	The date and time when the answer version was last accessed by an administrator. This attribute is read-only.
AnswerId	Long	True	Id of answer. The live answer related to this answer version.
AnswerlookUpName	String	True	LookUpName of answer. The live answer related to this answer version.
AnswerTypeId	Long	False	Id of answerType. The type of storage for answer version information.
AnswerTypelookUpName	String	False	LookUpName of answerType. The type of storage for answer version information.
CreatedTime	Datetime	True	The date and time when the answer version was created. This attribute is read-only.
ExpiresDate	Date	False	The date when the answer version expires and is set to review status.
GuidedAssistanceId	Long	True	Id of guidedAssistance. The Guided Assistance guide.
GuidedAssistancelookUpName	String	True	LookUpName of guidedAssistance. The Guided Assistance guide.
Id [KEY]	Long	True	The unique identifier of the answer version.
Keywords	String	False	The list of space separated keywords associated with an answer version.
LanguageId	Long	False	Id of language. The language used for the answer text.
LanguagelookUpName	String	False	LookUpName of language. The language used for the answer text.
LastAccessTime	Datetime	True	The date and time when the answer version was last accessed. This attribute is read-only.
LastNotificationTime	Datetime	True	The date and time when the last notification was generated. This attribute is read-only.
LookupName	String	True	The name used to look up the answer version.
Name	String	True	The string version of the answer ID, which is used as the reference number of the answer version. This attribute is read-only.
NextNotificationTime	Datetime	False	The date and time when the next notification will be sent.
OriginalReferenceNumber	String	False	The reference number of the incident that was proposed to create this answer. The reference number is common for all the sibling answers.
PositionInListId	Long	False	Id of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.
PositionInListlookUpName	String	False	LookUpName of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.
PublishOnDate	Date	False	The date when the answer version will be published and made available to users.
Question	String	False	The question or the description of the answer version.
Solution	String	False	The solution or the answer portion of this version of the answer.
SpecialResponse	String	False	The special response of this version of the answer.
Summary	String	False	The title or short summary of the answer version.
URL	String	False	The URL which returns this version of the answer, if the answer type is URL.
UpdatedByAccountId	Long	True	Id of updatedByAccount. The staff account who last edited the answer version. This attribute is read-only.
UpdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account who last edited the answer version. This attribute is read-only.
UpdatedTime	Datetime	True	The date and time when the answer version was last updated. This attribute is read-only.
AssignedToaccountId	Long	False	Id of account. The staff account.
AssignedToaccountlookUpName	String	False	LookUpName of account. The staff account.
AssignedTostaffGroupId	Long	False	Id of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
AssignedTostaffGrouplookUpName	String	False	LookUpName of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.
VersionDetaildraftNote	String	False	The draft note for the answer version.
VersionDetaildraftTime	Datetime	False	The date and time when the draft answer version was created.
VersionDetailpublishNote	String	False	The published note for the answer version.
VersionDetailpublishedTime	Datetime	False	The date and time when the draft answer version was published.
VersionDetailstateId	Long	False	Id of state. The state of the version.
VersionDetailstatelookUpName	String	False	LookUpName of state. The state of the version.
VersionDetailunpublishedTime	Datetime	False	The date and time when the answer version was unpublished.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
categories	String	The categories common to all sibling answers.
commonAttachments	String	The file attachments common to all sibling answers.
fileAttachments	String	The list of file attachments.
notes	String	The list of discussion threads.
products	String	The products common to all sibling answers.
relatedAnswers	String	The related answers linked to this answer.

Assets

The product or service associated with an organization's customers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the name, productid and serialNumber columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Assets (name,productid,serialNumber) VALUES ('ABC',12,'SN00123')

UPDATE

Update can be executed by specifying the column in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Assets SET contacts = 'US of America' WHERE name = 'United States (US)'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Assets WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
ContactId	Long	False	Id of contact. The contact associated with the asset.
ContactlookUpName	String	False	LookUpName of contact. The contact associated with the asset.
CreatedTime	Datetime	True	The date and time when the asset was created. This attribute is read-only.
Description	String	False	The description of the asset.
Id [KEY]	Long	True	The unique identifier of the asset.
InstalledDate	Date	False	The date when the asset was installed.
LookupName	String	True	The name used to look up the asset.
Name	String	False	The name of the asset used as the lookupName for the asset object.
OrganizationId	Long	False	Id of organization. The organization associated with the asset.
OrganizationlookUpName	String	False	LookUpName of organization. The organization associated with the asset.
ProductId	Long	False	Id of product. The product associated with the asset.
ProductlookUpName	String	False	LookUpName of product. The product associated with the asset.
PurchasedDate	Date	False	The date when the asset was purchased.
RetiredDate	Date	False	The date when the asset was retired.
SerialNumber	String	False	The serial number of the asset.
UpdatedTime	Datetime	True	The date and time when the asset was last updated. This attribute is read-only.
PricecurrencyId	Long	False	Id of currency. The ID of the currency.
PricecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
PriceexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
PriceexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Pricevalue	String	False	The value of the currency.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
sLAInstances	String	The SLA instances associated with the asset.

ContactMarketingRosters

The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the isProofList and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO ContactMarketingRosters (isProofList,name) VALUES ('true','Incident extract limit')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE ContactMarketingRosters SET Comment = 'Incident extract limit' WHERE Name = 'Analytics Lab Attendees'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM ContactMarketingRosters WHERE Name = 'Analytics Lab Attendees'

Columns


Name	Type	ReadOnly	Description
Comment	String	False	The description associated with the contact marketing roster.
CreatedByAccountId	Long	True	Id of createdByAccount. The staff account who created the list.
CreatedByAccountlookUpName	String	True	LookUpName of createdByAccount. The staff account who created the list.
CreatedTime	Datetime	True	The date and time when the contact marketing roster was created. This attribute is read-only.
Id [KEY]	Long	True	The unique identifier of the contact marketing roster.
InterfaceId	Long	True	Id of interface. The interface the list is associated with.
InterfacelookUpName	String	True	LookUpName of interface. The interface the list is associated with.
IsProofList	Bool	False	Indicates whether the contact marketing roster is a proof list.
LookupName	String	True	The name used to look up the contact marketing roster.
Name	String	False	The name of the contact marketing roster.
PurgeData	Bool	False	Indicates whether the contact marketing roster should be cleared periodically. The default value is false.
UpdatedByAccountId	Long	True	Id of updatedByAccount. The staff account who last updated the list.
UpdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account who last updated the list.
UpdatedTime	Datetime	True	The date and time when the contact marketing roster was last updated. This attribute is read-only.
LastCountStatisticslastCount	Int	True	The number of contacts in the contact marketing roster when the count was last calculated.
LastCountStatisticslastCountedTime	Datetime	True	The date and time when the contact marketing roster was last counted.

Contacts

The customers or end users of Oracle B2C Service site.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Contacts (bannertext) VALUES ('Agent: Knowledge')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE Contacts SET login = 'chris.fellows' WHERE namelast = 'Chase'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Contacts WHERE id = '209'

Columns


Name	Type	ReadOnly	Description
ContactTypeId	Long	False	Id of contactType. The ID of the contact type.
ContactTypelookUpName	String	False	LookUpName of contactType. The ID of the contact type.
CreatedTime	Datetime	True	The date and time when the contact was created. This attribute is read-only.
Disabled	Bool	False	Indicates whether the contact is disabled. The default value is false.
ExternalReference	String	True	The external reference key of the contact.
Id [KEY]	Long	True	The unique identifier of the contact.
Login	String	False	The user name used for authentication.
LookupName	String	True	The name used to look up the contact.
NewPassword	String	False	The new password for authentication. It is stored with a one-way encryption in the system. This attribute is write-only.
OrganizationId	Long	False	Id of organization. The organization to which the contact belongs.
OrganizationlookUpName	String	False	LookUpName of organization. The organization to which the contact belongs.
PasswordEmailExpirationTime	Datetime	True	The date and time by when the contact must change the password after a reset has occurred. This attribute is read-only.
PasswordExpirationTime	Datetime	True	The date and time by when the password is set to expire. This attribute is read-only.
SourceId	Long	True	Id of source. The creation source IDs. This attribute is read-only.
SourcelookUpName	String	True	LookUpName of source. The creation source IDs. This attribute is read-only.
SupersededById	Long	True	Id of supersededBy. The superseding contact for the contact. This attribute is read-only.
SupersededBylookUpName	String	True	LookUpName of supersededBy. The superseding contact for the contact. This attribute is read-only.
Title	String	False	The social or professional title of the contact. For example, Mrs., Dr., and so on.
UpdatedTime	Datetime	True	The date and time when the contact was last updated. This attribute is read-only.
Addresscity	String	False	The name of the city.
AddresscountryId	Long	False	Id of country. The ID of the country.
AddresscountrylookUpName	String	False	LookUpName of country. The ID of the country.
AddresspostalCode	String	False	The postal code or the ZIP code.
AddressstateOrProvinceId	Long	False	Id of stateOrProvince. The ID of the state or province.
AddressstateOrProvincelookUpName	String	False	LookUpName of stateOrProvince. The ID of the state or province.
Addressstreet	String	False	The street address.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
CRMModulesmarketing	Bool	False	Indicates whether the marketing module is applicable. The default value is true only if marketing module is enabled.
CRMModulessales	Bool	False	Indicates whether the sales module is applicable. The default value is true only if sales module is enabled.
CRMModulesservice	Bool	False	Indicates whether the service module is applicable. The default value is true only if service module is enabled.
MarketingSettingsemailFormatId	Long	False	Id of emailFormat. The ID of preferred format for sending emails to the contact.
MarketingSettingsemailFormatlookUpName	String	False	LookUpName of emailFormat. The ID of preferred format for sending emails to the contact.
MarketingSettingsmarketingOptIn	Bool	False	Indicates whether the contact has opted in for marketing mailing list. This attribute does not have a default value.
MarketingSettingsmarketingOrganizationName	String	False	The marketing organization name.
MarketingSettingsmarketingOrganizationNameAlt	String	False	The alternate name of the marketing organization.
MarketingSettingssurveyOptIn	Bool	False	Indicates whether the contact has opted in for providing feedback. This attribute does not have a default value.
Namefirst	String	False	The first name of the person.
Namelast	String	False	The surname or last name of the person.
NameFuriganafirst	String	False	The first name of the person.
NameFuriganalast	String	False	The surname or last name of the person.
SalesSettingsacquiredDate	Date	True	The date when the first opportunity associated with the contact was closed. This attribute is read-only.
SalesSettingssalesAccountId	Long	False	Id of salesAccount. The ID of the staff account for the sales representative assigned to the contact.
SalesSettingssalesAccountlookUpName	String	False	LookUpName of salesAccount. The ID of the staff account for the sales representative assigned to the contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
channelUsernames	String	The list of usernames for the contact across different communication channels.
emails	String	The list of email addresses.
fileAttachments	String	The list of file attachments.
notes	String	The list of notes associated with the contact.
openIDAccounts	String	The list of OpenID URLs associated with the contact.
phones	String	The list of phone numbers.
contactLists	String	The contact lists in which the contact is included.
answerNotifications	String	The answer notifications to which the contact is subscribed.
categoryNotifications	String	The category notifications to which the contact is subscribed.
productNotifications	String	The product notifications to which the contact is subscribed.
sLAInstances	String	The SLA instances associated with the contact. This attribute is read-only for versions 1 and 1.1.

Countries

The details about the countries and provinces which are used to maintain accurate address information for the organizations and contacts in Oracle B2C Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the abbreviation,iSOCode and names columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO CountriesNames#TEMP (languageId,labeltext) VALUES ('7','Vietnam')
INSERT INTO Countries(phonecode,abbreviation,iSOCode,names) VALUES ('44','UK','UK','countriesNames#TEMP')

UPDATE

Update can be executed by specifying the column in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Countries SET abbreviation = 'US of America' WHERE name = 'United States (US)'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Countries WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
Abbreviation	String	False	The two or three character abbreviation for the country. For example, USA.
CreatedTime	Datetime	True	The date and time when the country was created. This attribute is read-only.
DisplayOrder	Int	False	The position of the country in the Countries/Provinces tree and drop-down menu.
ISOCode	String	False	The ISO 3166 country code.
Id [KEY]	Long	True	The unique identifier of the country.
LookupName	String	True	The name used to look up the country.
Name	String	True	A list of labels or names used for this country on each unique interface.
PhoneCode	String	False	The international telephone code for the country. This is used by the Click-to-Dial feature.
PhoneMask	String	False	The string having twice the number of characters in the phone number. Two characters are needed to represent every digit or character in the phone number. The first character of the mask describes the target character and the second constrains its type.
PostalMask	String	False	The string having twice the number of characters in the target postal code. Two characters are needed to represent every digit or character in the postal code. The first character of the mask describes the target character and the second constrains its type.
UpdatedTime	Datetime	True	The date and time when the country was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The name of the country in the language of the current interface. This attribute is read-only.
provinces	String	A list of states or provinces associated with this country.

EventSubscriptions

The event-based subscription management object that allows external applications to discover objects that can be subscribed.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the class, endPoint, eventType, integrationUser, name, objectShapeXml and objectVersion columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO EventSubscriptions (class,endPoint,eventTypeId,integrationUserId,objectShapeXml,name,objectVersionId) VALUES ('Contact','https://abc.com','2','1','asdc','queryresults','100200')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE EventSubscriptions SET summary = 'Test Replacement' WHERE lookupName = 'Battery Replacement'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM EventSubscriptions WHERE summary IS NULL

Columns


Name	Type	ReadOnly	Description
Class	String	False	The string which represents the type of object in the ObjectShapeXML.
CreatedTime	Datetime	True	The date and time when the event subscription was created. This attribute is read-only.
EndPoint	String	False	The URL to post the notification event. Note: If an endpoint is registered as a callback, it should contain the fully qualified domain name. For example:
EventTypeId	Long	False	Id of eventType. The types of event such as Create, Update, or Destroy.
EventTypelookUpName	String	False	LookUpName of eventType. The types of event such as Create, Update, or Destroy.
Id [KEY]	Long	True	The unique identifier of the event subscription.
IntegrationUserId	Long	False	Id of integrationUser. The credentials and connection method to use for the event subscription.
IntegrationUserlookUpName	String	False	LookUpName of integrationUser. The credentials and connection method to use for the event subscription.
LookupName	String	True	The name used to look up the event subscription.
Name	String	False	The unique name of the event subscription.
ObjectShapeXml	String	False	The shape of the template object used to send the notification.
ObjectVersionId	Long	False	Id of objectVersion. The Connect version of the object to be sent in the notification.
ObjectVersionlookUpName	String	False	LookUpName of objectVersion. The Connect version of the object to be sent in the notification.
StatusId	Long	False	Id of status. The status of the event subscription.
StatuslookUpName	String	False	LookUpName of status. The status of the event subscription.
UpdatedTime	Datetime	True	The date and time when the event subscription was last updated. This attribute is read-only.

Holidays

The list of holidays in your organization.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the holidayDate and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Holidays (holidayDate,name) VALUES ('2011-01-17','testinsert')

UPDATE

Update can be executed by specifying the id column in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Holidays SET holidayDate = '2012-01-17' WHERE id = '1'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM Holidays WHERE holidayDate = '2012-01-17'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the holiday was created. This attribute is read-only.
DisplayOrder	Int	False	The display position relative to other holidays.
HolidayDate	Date	False	The date the holiday falls on. The maximum allowed value of the date is 12/31/2032.
Id [KEY]	Long	True	The unique identifier of the holiday.
LookupName	String	True	The name used to look up the holiday.
Name	String	False	The name of the holiday.
UpdatedTime	Datetime	True	The date and time when the holiday was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the holiday is available for administration use.

Incidents

The question or the request for help submitted by a customer through the Ask a Question page, email, a chat session, site or answer feedback, or from an external source using the API.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the primaryContact columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Incidents (primaryContactId) VALUES ('12')

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Incidents SET languageId = '1' WHERE id = 1

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Incidents WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
AssetId	Long	False	Id of asset. The ID of the associated asset.
AssetlookUpName	String	False	LookUpName of asset. The ID of the associated asset.
CategoryId	Long	False	Id of category. The service category.
CategorylookUpName	String	False	LookUpName of category. The service category.
ChannelId	Long	False	Id of channel. The channel used in the creation of the most recent thread.
ChannellookUpName	String	False	LookUpName of channel. The channel used in the creation of the most recent thread.
ChatQueueId	Long	False	Id of chatQueue. The chat queue to which the incident is assigned. This attribute is read-only.
ChatQueuelookUpName	String	False	LookUpName of chatQueue. The chat queue to which the incident is assigned. This attribute is read-only.
ClosedTime	Datetime	True	The date and time when the incident was closed. This attribute is read-only.
CreatedByAccountId	Long	True	Id of createdByAccount. The staff member who created the incident.
CreatedByAccountlookUpName	String	True	LookUpName of createdByAccount. The staff member who created the incident.
CreatedTime	Datetime	True	The date and time when the incident was created. This attribute is read-only.
DispositionId	Long	False	Id of disposition. The service disposition.
DispositionlookUpName	String	False	LookUpName of disposition. The service disposition.
Id [KEY]	Long	True	The unique identifier of the incident.
InitialResponseDueTime	Datetime	True	The due date that is required to conform to the SLA. If SLAs have not been implemented, this would apply to the default response requirements. This attribute is read-only.
InitialSolutionTime	Datetime	True	The date and time when a response was sent to the customer for a status change other than 'unresolved'. This attribute is read-only.
InterfaceId	Long	False	Id of interface. The ID of the associated interface.
InterfacelookUpName	String	False	LookUpName of interface. The ID of the associated interface.
LanguageId	Long	False	Id of language. The ID of the associated language.
LanguagelookUpName	String	False	LookUpName of language. The ID of the associated language.
LastResponseTime	Datetime	True	The date and time when the last response was sent to the contact. This attribute is read-only.
LastSurveyScore	Int	True	The score of the last survey of the incident. This attribute is read-only.
LookupName	String	True	The name used to look up the incident.
MailboxId	Long	False	Id of mailbox. The ID of the mailbox from which incident was created.
MailboxlookUpName	String	False	LookUpName of mailbox. The ID of the mailbox from which incident was created.
MailingId	Long	True	Id of mailing. The ID of the associated marketing outbound email. This attribute is read-only.
MailinglookUpName	String	True	LookUpName of mailing. The ID of the associated marketing outbound email. This attribute is read-only.
OrganizationId	Long	False	Id of organization. The ID of the associated organization.
OrganizationlookUpName	String	False	LookUpName of organization. The ID of the associated organization.
PrimaryContactId	Long	False	Id of primaryContact. The primary contact.
PrimaryContactlookUpName	String	False	LookUpName of primaryContact. The primary contact.
ProductId	Long	False	Id of product. The service product.
ProductlookUpName	String	False	LookUpName of product. The service product.
QueueId	Long	False	Id of queue. The queue to which the incident is assigned.
QueuelookUpName	String	False	LookUpName of queue. The queue to which the incident is assigned.
ReferenceNumber	String	True	The reference number generated when the incident was created. It is also referred as the incident name.
ResolutionInterval	Int	True	The number of minutes taken to resolve the incident past the SLA's resolution requirement. This attribute is read-only.
ResponseEmailAddressTypeId	Long	False	Id of responseEmailAddressType. The type of address that is used for incident responses, such as Primary or Alt1 .
ResponseEmailAddressTypelookUpName	String	False	LookUpName of responseEmailAddressType. The type of address that is used for incident responses, such as Primary or Alt1 .
ResponseInterval	Int	True	The number of minutes taken to respond to the incident past the SLA's response requirement. This attribute is read-only.
SeverityId	Long	False	Id of severity. The assigned severity level.
SeveritylookUpName	String	False	LookUpName of severity. The assigned severity level.
SmartSenseCustomer	Int	True	The emotive index calculated from the contact-generated threads. This attribute is read-only.
SmartSenseStaff	Int	True	The emotive index calculated from the staff-generated threads. This attribute is read-only.
SourceId	Long	True	Id of source. The creation source IDs. This attribute is read-only.
SourcelookUpName	String	True	LookUpName of source. The creation source IDs. This attribute is read-only.
Subject	String	False	The short description of the incident.
UpdatedTime	Datetime	True	The date and time when the incident was last updated. This attribute is read-only.
AssignedToaccountId	Long	False	Id of account. The staff account.
AssignedToaccountlookUpName	String	False	LookUpName of account. The staff account.
AssignedTostaffGroupId	Long	False	Id of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
AssignedTostaffGrouplookUpName	String	False	LookUpName of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
SLAInstanceactiveDate	Date	True	The date when the instance became active.
SLAInstanceexpireDate	Date	True	The date when the instance is scheduled to expire. This attribute is read-only.
SLAInstanceid	Long	True	The unique identifier of the SLAInstance.
SLAInstancenameOfSLAId	Long	False	Id of nameOfSLA. The SLA from which the instance was created.
SLAInstancenameOfSLAlookUpName	String	False	LookUpName of nameOfSLA. The SLA from which the instance was created.
SLAInstanceremainingFromCSR	Int	True	The remaining number of CSR incidents. This attribute is read-only.
SLAInstanceremainingFromChat	Int	True	The remaining number of chat incidents. This attribute is read-only.
SLAInstanceremainingFromEmail	Int	True	The remaining number of email incidents. This attribute is read-only.
SLAInstanceremainingFromWeb	Int	True	The remaining number of web self-service incidents. This attribute is read-only.
SLAInstanceremainingTotal	Int	True	The total number of remaining incidents. This attribute is read-only.
SLAInstancesLASet	Int	True	The SLA set from which the instance was created. This attribute is read-only.
SLAInstancestateOfSLAId	Long	True	Id of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.
SLAInstancestateOfSLAlookUpName	String	True	LookUpName of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
billedMinutes	String	The list of time-billed entries that are used for tracking work on the incident.
fileAttachments	String	The list of file attachments.
milestoneInstances	String	The list of milestone instances associated with the incident. This attribute is read-only.
otherContacts	String	The list of secondary contacts.
threads	String	The list of customer and staff discussion threads or notes. New entries can be added to the list and existing threads updated. It is not possible to remove discussion threads retroactively.

Opportunities

The information about a specific sale or a pending deal with a contact or an organization that is tracked and maintained in the Oracle B2C Service knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Opportunities (recalltime) VALUES ('2012-01-17')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE Opportunities SET summary = 'Test Replacement' WHERE lookupName = 'Battery Replacement'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM Opportunities WHERE summary IS NULL

Columns


Name	Type	ReadOnly	Description
AssignedToAccountId	Long	False	Id of assignedToAccount. The sales representative assigned to the account.
AssignedToAccountlookUpName	String	False	LookUpName of assignedToAccount. The sales representative assigned to the account.
CampaignId	Long	True	Id of campaign. The campaign that created the opportunity, where applicable. This value and the survey are mutually exclusive; one or both must be null. This attribute is read-only.
CampaignlookUpName	String	True	LookUpName of campaign. The campaign that created the opportunity, where applicable. This value and the survey are mutually exclusive; one or both must be null. This attribute is read-only.
ClosedTime	Datetime	False	The date and time when the opportunity was closed.
CreatedTime	Datetime	True	The date and time when the opportunity was created. This attribute is read-only.
ForecastCloseDate	Date	False	The date when the opportunity is estimated to close.
Id [KEY]	Long	True	The unique identifier of the opportunity.
InitialContactDate	Date	False	The date when the sales representative made the initial contact with the organization.
InterfaceId	Long	False	Id of interface. The interface with which the opportunity is associated.
InterfacelookUpName	String	False	LookUpName of interface. The interface with which the opportunity is associated.
LeadRejectDateTime	Datetime	False	The date and time when the lead was rejected.
LeadRejectDescription	String	False	The summary or description provided when the lead was rejected.
LeadRejectReasonId	Long	False	Id of leadRejectReason. The reason the lead was rejected.
LeadRejectReasonlookUpName	String	False	LookUpName of leadRejectReason. The reason the lead was rejected.
LookupName	String	True	The name used to look up the opportunity.
LostTime	Datetime	False	The date and time when the opportunity was lost.
ManagerCommit	Bool	False	The committed status of the manager-forecasted value. The default value is false.
Name	String	False	The name of the opportunity.
OrganizationId	Long	False	Id of organization. The associated organization.
OrganizationlookUpName	String	False	LookUpName of organization. The associated organization.
RecallTime	Datetime	False	The date and time when the opportunity was recalled.
SalesRepresentativeCommit	Bool	False	Indicates whether the sales representative-forecasted value is committed. The default value is false.
SourceId	Long	True	Id of source. The creation source IDs. This attribute is read-only.
SourcelookUpName	String	True	LookUpName of source. The creation source IDs. This attribute is read-only.
Summary	String	False	The brief summary of the opportunity.
SurveyId	Long	True	Id of survey. The survey that created the opportunity, where applicable. This value and the campaign are mutually exclusive; one or both must be null. This attribute is read-only.
SurveylookUpName	String	True	LookUpName of survey. The survey that created the opportunity, where applicable. This value and the campaign are mutually exclusive; one or both must be null. This attribute is read-only.
TerritoryId	Long	False	Id of territory. The associated sales territory.
TerritorylookUpName	String	False	LookUpName of territory. The associated sales territory.
UpdatedTime	Datetime	True	The date and time when the opportunity was last updated. This attribute is read-only.
WinLossDescription	String	False	The description of how the opportunity was won or lost.
WinLossReasonId	Long	False	Id of winLossReason. The reason for winning or losing.
WinLossReasonlookUpName	String	False	LookUpName of winLossReason. The reason for winning or losing.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
ClosedValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ClosedValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ClosedValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ClosedValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ClosedValuevalue	String	False	The value of the currency.
CostOfSalecurrencyId	Long	False	Id of currency. The ID of the currency.
CostOfSalecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
CostOfSaleexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
CostOfSaleexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
CostOfSalevalue	String	False	The value of the currency.
ManagerValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ManagerValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ManagerValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ManagerValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ManagerValuevalue	String	False	The value of the currency.
PrimaryContactcontactId	Long	False	Id of contact. The ID of the contact.
PrimaryContactcontactlookUpName	String	False	LookUpName of contact. The ID of the contact.
PrimaryContactcontactRoleId	Long	False	Id of contactRole. The role of the contact in the opportunity process.
PrimaryContactcontactRolelookUpName	String	False	LookUpName of contactRole. The role of the contact in the opportunity process.
ReturnValuecurrencyId	Long	False	Id of currency. The ID of the currency.
ReturnValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
ReturnValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ReturnValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ReturnValuevalue	String	False	The value of the currency.
SalesRepresentativeValuecurrencyId	Long	False	Id of currency. The ID of the currency.
SalesRepresentativeValuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
SalesRepresentativeValueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesRepresentativeValueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesRepresentativeValuevalue	String	False	The value of the currency.
StageWithStrategystageId	Long	False	Id of stage. The current stage.
StageWithStrategystagelookUpName	String	False	LookUpName of stage. The current stage.
StageWithStrategystrategyId	Long	True	Id of strategy. The associated strategy. This attribute is read-only.
StageWithStrategystrategylookUpName	String	True	LookUpName of strategy. The associated strategy. This attribute is read-only.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
fileAttachments	String	The list of file attachments.
notes	String	The list of associated notes.
otherContacts	String	The other non-primary associated contacts.
quotes	String	The list of sales quotes.

Organizations

The company, business unit of a large company, or government agency that has an organization record in the Oracle B2C Service knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Organizations (name) VALUES ('Incident records')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE Organizations SET  login = '001o0000005xSbZAAU' WHERE parentlookUpName IS NULL

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Organizations WHERE id = '9'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the organization was created. This attribute is read-only.
ExternalReference	String	True	The external reference key of the organization.
Id [KEY]	Long	True	The unique identifier of the organization.
IndustryId	Long	False	Id of industry. The industry with which the organization is associated.
IndustrylookUpName	String	False	LookUpName of industry. The industry with which the organization is associated.
Login	String	False	The user name used for authentication.
LookupName	String	True	The name used to look up the organization.
Name	String	False	The business name of the organization.
NameFurigana	String	False	The Furigana reading aid for the Name field. This field is used in the workspaces of the Agent Console and is only available if the site has at least one Japanese interface.
NewPassword	String	False	The write-only field used to set the authentication password. It is stored in a non-plaintext form in the system.
NumberOfEmployees	Int	False	The number of employees in the organization.
ParentId	Long	False	Id of parent. The parent organization.
ParentlookUpName	String	False	LookUpName of parent. The parent organization.
SourceId	Long	True	Id of source. The creation source IDs. This attribute is read-only.
SourcelookUpName	String	True	LookUpName of source. The creation source IDs. This attribute is read-only.
SupersededById	Long	True	Id of supersededBy. The superseding organization for the organization. This attribute is read-only.
SupersededBylookUpName	String	True	LookUpName of supersededBy. The superseding organization for the organization. This attribute is read-only.
UpdatedTime	Datetime	True	The date and time when the organization was last updated. This attribute is read-only.
BannerimportanceFlagId	Long	False	Id of importanceFlag. The importance of the banner.
BannerimportanceFlaglookUpName	String	False	LookUpName of importanceFlag. The importance of the banner.
Bannertext	String	False	The description of a flag.
BannerupdatedByAccountId	Long	True	Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedByAccountlookUpName	String	True	LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.
BannerupdatedTime	Datetime	True	The date and time when the banner was last updated. This attribute is read-only.
CRMModulesmarketing	Bool	False	Indicates whether the marketing module is applicable. The default value is true only if marketing module is enabled.
CRMModulessales	Bool	False	Indicates whether the sales module is applicable. The default value is true only if sales module is enabled.
CRMModulesservice	Bool	False	Indicates whether the service module is applicable. The default value is true only if service module is enabled.
SalesSettingsacquiredDate	Date	True	The date when the first opportunity associated with the organization was closed. This attribute is read-only.
SalesSettingssalesAccountId	Long	False	Id of salesAccount. The sales representative assigned to the account.
SalesSettingssalesAccountlookUpName	String	False	LookUpName of salesAccount. The sales representative assigned to the account.
SalesSettingstotalRevenuecurrencyId	Long	False	Id of currency. The ID of the currency.
SalesSettingstotalRevenuecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
SalesSettingstotalRevenueexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesSettingstotalRevenueexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
SalesSettingstotalRevenuevalue	String	False	The value of the currency.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
addresses	String	The list of associated addresses.
fileAttachments	String	The list of file attachments.
notes	String	The list of associated notes.
sLAInstances	String	The Service Level Agreement (SLA) instances associated with the organization. This attribute is read-only for versions 1 and 1.1.

PurchasedProducts

The information about a purchased product.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the comment column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO PurchasedProducts (comment) VALUES ('Incident extract limit')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE PurchasedProducts SET comment = 'Test Replacement' WHERE contactId = '2'

DELETE

Following is an example of how to Delete a record in this table.

DELETE FROM PurchasedProducts WHERE summary id = '10'

Columns


Name	Type	ReadOnly	Description
CampaignId	Long	False	Id of campaign. The campaign associated with the purchased product.
CampaignlookUpName	String	False	LookUpName of campaign. The campaign associated with the purchased product.
Comment	String	False	The comments or notes associated with the line item.
ContactId	Long	False	Id of contact. The contact associated with the purchased product.
ContactlookUpName	String	False	LookUpName of contact. The contact associated with the purchased product.
CreatedTime	Datetime	True	The date and time when the purchased product was created. This attribute is read-only.
FinalizedByAccountId	Long	False	Id of finalizedByAccount. The account associated with the purchased product.
FinalizedByAccountlookUpName	String	False	LookUpName of finalizedByAccount. The account associated with the purchased product.
Id [KEY]	Long	True	The unique identifier of the purchased product.
LicenseEndTime	Datetime	False	The end date of the license.
LicenseStartTime	Datetime	False	The start date of the license.
LookupName	String	True	The name used to look up the purchased product.
MailingId	Long	False	Id of mailing. The associated mailing.
MailinglookUpName	String	False	LookUpName of mailing. The associated mailing.
OpportunityId	Long	False	Id of opportunity. The opportunity associated with the purchased product.
OpportunitylookUpName	String	False	LookUpName of opportunity. The opportunity associated with the purchased product.
OrganizationId	Long	False	Id of organization. The organization associated with the purchased product.
OrganizationlookUpName	String	False	LookUpName of organization. The organization associated with the purchased product.
PurchaseTime	Datetime	False	The date and time of the purchase.
SalesProductId	Long	False	Id of salesProduct. The sales product associated with the purchased product.
SalesProductlookUpName	String	False	LookUpName of salesProduct. The sales product associated with the purchased product.
SerialNumber	String	False	The serial number of the purchased product.
UpdatedTime	Datetime	True	The date and time when the purchased product was last updated. This attribute is read-only.
PricecurrencyId	Long	False	Id of currency. The ID of the currency.
PricecurrencylookUpName	String	False	LookUpName of currency. The ID of the currency.
PriceexchangeRateId	Long	False	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
PriceexchangeRatelookUpName	String	False	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Pricevalue	String	False	The value of the currency.

SalesProducts

The items or services sold by an organization.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the acceptCount,respondCount and names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO SalesProductsNames#TEMP (languageId,labeltext) VALUES ('1','Smartly Maestro')
INSERT INTO SalesProducts (acceptCount,respondCount,names) VALUES ('0','0',salesProductsNames#TEMP)

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE SalesProducts SET partNumber='SV100D' WHERE folderlookupName = 'Smartly Maestro'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM SalesProducts WHERE folderLookupName = 'Spaces B2B'

Columns


Name	Type	ReadOnly	Description
AcceptCount	Int	False	The number of times an offer for the sales product was accepted through offer advisor.
CreatedTime	Datetime	True	The date and time when the sales product was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the sales product within the folder list in the product catalog.
ExcludeFromOfferAdvisor	Bool	False	Indicates whether the product is excluded from the offer advisor. This attribute does not have a default value.
Id [KEY]	Long	True	The unique identifier of the sales product.
LookupName	String	True	The name used to look up the sales product.
Name	String	True	The name of the product in the language of the current interface. This attribute is read-only.
PartNumber	String	False	The text string which identifies the product. For example, stock keeping unit (SKU) or model number.
RespondCount	Int	False	The number of times the product was offered through the offer advisor.
ServiceProductId	Long	False	Id of serviceProduct. The service product.
ServiceProductlookUpName	String	False	LookUpName of serviceProduct. The service product.
UpdatedTime	Datetime	True	The date and time when the sales product was last updated. This attribute is read-only.
Attributesdisabled	Bool	False	Indicates whether the product is temporarily disabled and will not be displayed. The default value is false.
AttributeshasSerialNumber	Bool	False	Indicates whether the product has a serial number. The default value is false.
AttributesisSalesProduct	Bool	False	Indicates whether the product is a sales product. The default value is true.
AttributesisServiceProduct	Bool	False	Indicates whether the product is a service product. The default value is false.
Folderid	Long	False	ID value
FolderlookupName	String	False	Name used to lookup this object

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the sales product is visible.
descriptions	String	The list of descriptions, one for each supported language.
names	String	The list of names, one for each supported language.
schedules	String	The list of associated price schedules.

SalesTerritories

The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO SalesTerritoriesNames#TEMP (languageId,labeltext) VALUES ('1','Community Ideas')
INSERT INTO SalesTerritories (names) VALUES ('salesTerritoriesNames#TEMP')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE SalesTerritories SET displayorder = '2' WHERE name = 'United States'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM SalesTerritories WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
Comment	String	False	The comments or notes associated with the sales territory.
CreatedTime	Datetime	True	The date and time when the sales territory was created. This attribute is read-only.
Disabled	Bool	False	Indicates whether a sales territory is disabled. The default value is false.
DisplayOrder	Int	False	The display position of the sales territory relative to other members of the same group.
Id [KEY]	Long	True	The unique identifier of the sales territory.
LookupName	String	True	The name used to look up the sales territory.
Name	String	True	The name of the sales territory in the language of the current interface. This attribute is read-only.
ParentId	Long	False	Id of parent. The parent sales territory in the hierarchy.
ParentlookUpName	String	False	LookUpName of parent. The parent sales territory in the hierarchy.
UpdatedTime	Datetime	True	The date and time when the sales territory was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the category is available for administration use.
names	String	The list of names, one for each supported language.

ServiceCategories

The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO ServiceCategoriesNames#TEMP (languageId,labeltext) VALUES ('1','Community Ideas')
INSERT INTO serviceCategories(names) VALUES ('ServiceCategoriesNames#TEMP')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE ServiceCategories SET displayOrder = '1' WHERE ParentlookUpName = 'Ordering'

DELETE

Delete can be executed by specifying id in the WHERE Clause.

DELETE FROM ServiceCategories WHERE id = '83'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the service category was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the service category relative to other categories with the same parent.
Id [KEY]	Long	True	The unique identifier of the service category.
LookupName	String	True	The name used to look up the service category.
Name	String	True	The name of the service category in the language of the current interface. This attribute is read-only.
ParentId	Long	False	Id of parent. The parent category in the hierarchy.
ParentlookUpName	String	False	LookUpName of parent. The parent category in the hierarchy.
UpdatedTime	Datetime	True	The date and time when the service category was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the category is available for administration use.
descriptions	String	The list of descriptions, one for each supported language.
endUserVisibleInterfaces	String	The list of interfaces on which the category is available for end user use.
names	String	The list of names, one for each supported language.
productLinks	String	The category to product linking.

ServiceDispositions

The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO ServiceDispositionsNames#TEMP (serviceDispositionsId,labeltext) VALUES ('16','Agent: Knowledge')
INSERT INTO ServiceDispositions (names) VALUES ('serviceDispositionsNames#TEMP')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE ServiceDispositions SET displayOrder = '1' WHERE lookupName = 'Product: Misuse'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM ServiceDispositions WHERE lookupName = 'abc'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the service disposition was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the service disposition relative to other dispositions with the same parent.
Id [KEY]	Long	True	The unique identifier of the service disposition.
LookupName	String	True	The name used to look up the service disposition.
Name	String	True	The name of the service disposition in the language of the current interface. This attribute is read-only.
ParentId	Long	False	Id of parent. The parent disposition in the hierarchy.
ParentlookUpName	String	False	LookUpName of parent. The parent disposition in the hierarchy.
UpdatedTime	Datetime	True	The date and time when the service disposition was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the disposition is available for administration use.
descriptions	String	The list of descriptions, one for each supported language.
names	String	The list of names, one for each supported language.
productLinks	String	The disposition to product linking.

ServiceProducts

The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO ServiceProductsNames#TEMP (languageId,labeltext) VALUES ('1','Community Ideas')
INSERT INTO ServiceProducts(names) VALUES ('serviceProductsNames#TEMP')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE ServiceProducts SET displayOrder = '4' WHERE parentlookUpName IS NULL

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM ServiceProducts WHERE id = '4'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the service product was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the service product relative to other products with the same parent.
Id [KEY]	Long	True	The unique identifier of the service product.
LookupName	String	True	The name used to look up the service product.
Name	String	True	The name of the service product in the language of the current interface.
ParentId	Long	False	Id of parent. The parent product in the hierarchy.
ParentlookUpName	String	False	LookUpName of parent. The parent product in the hierarchy.
UpdatedTime	Datetime	True	The date and time when the service product was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the category is available for administration use.
categoryLinks	String	The product to category linking.
descriptions	String	The list of descriptions, one for each supported language.
dispositionLinks	String	The product to disposition linking.
endUserVisibleInterfaces	String	The list of interfaces on which the category is available for end user use.
names	String	The list of names, one for each supported language.

StandardContents

The preformed text or HTML content that can be sent to customers when responding to incidents, appended to responses by a business rule, or sent by an agent during a chat session.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the contentValues,name and usage in WHERE Clause. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO standardContents (name,usagechattext) VALUES ('Battery Replacement','false')

UPDATE

Update can be executed by specifying the id column in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE StandardContents SET folderid = '100146' WHERE id = '4'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM StandardContents WHERE id = '3'

Columns


Name	Type	ReadOnly	Description
Comment	String	False	The comments associated with the standard content object.
CreatedTime	Datetime	True	The date and time when the standard content was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the standard content relative to other standard content objects with the same parent.
HotKey	String	False	The assigned shortcut key for inserting the standard content.
Id [KEY]	Long	True	The unique identifier of the standard content object.
LookupName	String	True	The name used to look up the standard content object.
Name	String	False	The name of the standard content object.
UpdatedTime	Datetime	True	The date and time when the standard content was last updated. This attribute is read-only.
AttributesdisplayRightToLeft	Bool	False	Indicates whether the content presentation is from right to left. The default value is false.
Folderid	Long	False	ID value
FolderlookupName	String	False	Name used to lookup this object
UsagechatText	Bool	False	Indicates whether the content is used in a chat session. The default value is false.
UsagechatURL	Bool	False	Indicates whether the content is used in the URL of a chat session. The default value is false.
UsageincidentText	Bool	False	Indicates whether the content is used in an incident. The default value is false.
UsageruleText	Bool	False	Indicates whether the content is used in a rule. The default value is false.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the category is available for administration use.
contentValues	String	The list of the preformed content with entries for each content type.

Tasks

The information about an action or an activity scheduled to be completed within a specified time.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Tasks (name) VALUES ('Organize PO for Initech')

UPDATE

Update can be executed. The columns that are not read-only can be Updated.

UPDATE Tasks SET percentComplete = '60' WHERE name = 'Organize PO for Initech'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Tasks WHERE id = '7'

Columns


Name	Type	ReadOnly	Description
AssignedToAccountId	Long	False	Id of assignedToAccount. The assigned staff account.
AssignedToAccountlookUpName	String	False	LookUpName of assignedToAccount. The assigned staff account.
CompletedTime	Datetime	False	The date and time when the task was completed.
ContactId	Long	False	Id of contact. The associated contact.
ContactlookUpName	String	False	LookUpName of contact. The associated contact.
CreatedTime	Datetime	True	The date and time when the task was created. This attribute is read-only.
DueTime	Datetime	False	The date and time when the task is due.
Id [KEY]	Long	True	The unique identifier of the task.
LookupName	String	True	The name used to look up the task.
Name	String	False	The name used to describe the task.
OrganizationId	Long	False	Id of organization. The associated organization.
OrganizationlookUpName	String	False	LookUpName of organization. The associated organization.
PercentComplete	Int	False	The percentage of work completed.
PlannedCompletionTime	Datetime	False	The date and time when the task is planned for completion.
PriorityId	Long	False	Id of priority. The relative priority.
PrioritylookUpName	String	False	LookUpName of priority. The relative priority.
StartTime	Datetime	False	The date and time when the task started.
TaskTemplateId	Long	False	Id of taskTemplate. The template for the business process.
TaskTemplatelookUpName	String	False	LookUpName of taskTemplate. The template for the business process.
TaskTypeId	Long	False	Id of taskType. The identifier of the task type, such as incident task. This works in conjunction with the inherit options to determine which associated object to inherit the data from.
TaskTypelookUpName	String	False	LookUpName of taskType. The identifier of the task type, such as incident task. This works in conjunction with the inherit options to determine which associated object to inherit the data from.
UpdatedTime	Datetime	True	The date and time when the task was last updated. This attribute is read-only.
InheritinheritContact	Bool	False	Indicates whether the task inherits contact value from the associated object. The default value is false.
InheritinheritOrganization	Bool	False	Indicates whether the task inherits organization value from the associated object. The default value is false.
InheritinheritStaffAssignment	Bool	False	Indicates whether the task inherits account value from the associated object. The default value is false.
MarketingSettingscampaignId	Long	False	Id of campaign. The associated campaign.
MarketingSettingscampaignlookUpName	String	False	LookUpName of campaign. The associated campaign.
MarketingSettingsdocumentId	Long	False	Id of document. The associated marketing document.
MarketingSettingsdocumentlookUpName	String	False	LookUpName of document. The associated marketing document.
MarketingSettingsmailingId	Long	False	Id of mailing. The associated mailing.
MarketingSettingsmailinglookUpName	String	False	LookUpName of mailing. The associated mailing.
MarketingSettingssurveyId	Long	False	Id of survey. The associated survey.
MarketingSettingssurveylookUpName	String	False	LookUpName of survey. The associated survey.
SalesSettingsopportunityId	Long	False	Id of opportunity. The associated opportunity.
SalesSettingsopportunitylookUpName	String	False	LookUpName of opportunity. The associated opportunity.
ServiceSettingsanswerId	Long	False	Id of answer. The associated answer.
ServiceSettingsanswerlookUpName	String	False	LookUpName of answer. The associated answer.
ServiceSettingsincidentId	Long	False	Id of incident. The associated incident.
ServiceSettingsincidentlookUpName	String	False	LookUpName of incident. The associated incident.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
fileAttachments	String	The list of file attachments.
notes	String	The list of discussion threads.

Variables

A shortcut defined for a larger string that can be inserted in the body of an answer or inserted inline during a chat session.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

INSERT

Insert can be executed by specifying the name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Variables (name) VALUES ('Exampleinsertname')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE Variables SET folderlookupName = 'variables' WHERE name = 'Exampleinsertname'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM variables WHERE id = '3'

Columns


Name	Type	ReadOnly	Description
CreatedTime	Datetime	True	The date and time when the variable was created. This attribute is read-only.
DisplayOrder	Int	False	The position of the variable in the variable list.
Id [KEY]	Long	True	The unique identifier of the variable.
LookupName	String	True	The name used to look up the variable.
Name	String	False	The name of the variable.
SearchIndexable	Bool	False	Indicates whether the text is indexed for searching the customer portal. The default value is false.
UpdatedTime	Datetime	True	The date and time when the variable was last updated. This attribute is read-only.
Folderid	Long	False	ID value
FolderlookupName	String	False	Name used to lookup this object

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
interfaceValues	String	The list of values, one for each supported interface.

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Oracle Service Cloud Connector for CData Sync Views


Name	Description
AccountsEmails	The email address and its associated information.
AccountsPhones	The details related to the phone number.
AnalyticsReports	The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components.
AnalyticsReportsFilters	The filters used for running an analytics report.
AnalyticsReportsNames	The language-specific strings used for localization of fields.
AnswersCategories	The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswersCommonAttachments	The file attachment shared by sibling answers.
AnswersCommonAttachmentsNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
AnswersFileAttachments	The file attachment shared by answers.
AnswersNotes	The note text associated with the objects such as contacts and organizations.
AnswersProducts	The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswersRelatedAnswers	The knowledge base information that provides solutions to the common customer support questions.
AnswersSiblingAnswers	The knowledge base information that provides solutions to the common customer support questions.
AnswerVersionsCategories	The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswerVersionsCommonAttachments	The file attachment shared by sibling answers.
AnswerVersionsCommonAttachmentsNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
AnswerVersionsFileAttachments	The file attachment shared by answers.
AnswerVersionsNotes	The note text associated with the objects such as contacts and organizations.
AnswerVersionsProducts	The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswerVersionsRelatedAnswers	The link to related answers.
AssetsSLAInstances	The instance of a Service Level Agreement (SLA).
AssetStatuses	The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service.
AssetStatusesNames	The language-specific strings used for localization of fields.
Campaigns	The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service.
ChannelTypes	The social channels tracked in contact records when storing social account user names and associating social monitor incidents to contacts.
ChannelTypesNames	The language-specific strings used for localization of fields.
Chats	The real-time, two-way dialog between a customer and one or more chat agents.
Configurations	The information about the configuration settings within Oracle B2C Service.
ContactsChannelUsernames	The user name of the channel.
ContactsEmails	The email address and its associated information.
ContactsFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
ContactsNotes	The note text associated with the objects such as contacts and organizations.
ContactsOpenIDAccounts	The OpenID related information for the contact.
ContactsPhones	The details related to the phone number.
CountriesNames	The language-specific strings used for localization of fields.
CountriesProvinces	The information about the provinces in the Countries/Provinces customizable menu.
CountriesProvincesNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
HolidaysAdminVisibleInterfaces	The named ID that can be included in a list.
IncidentsBilledMinutes	The work time applied to incidents through the Time Billed feature.
IncidentsFileAttachments	The file attachment that includes fields specific to incidents.
IncidentsMilestoneInstances	The milestone instances associated with incidents.
IncidentsThreads	The incident discussion thread entry.
Mailboxes	The mailbox used for collecting email inquiries sent by customers, responses to mailings, and bounced messages.
MarketingMailboxes	The mailbox used to send and receive emails and process bounced messages.
MessageBases	The editable text string that allows international language support and customization of headings, labels, buttons, and other text in the administration interface and customer portal. It also applies to email messages and notifications.
NamedIDs	An ID which has an associated name string. These IDs can be set by either value or name.
OpportunitiesFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
OpportunitiesNotes	The note text associated with the objects such as contacts and organizations.
OpportunitiesOtherContacts	The secondary contact associated with the opportunity.
OpportunitiesQuotes	The sales quote associated with an opportunity.
OpportunitiesQuotesFileAttachments	The file that is attached or associated with another object.
OpportunitiesQuotesLineItems	The product line item in a quote.
OpportunityStatuses	The information about the default and custom opportunity statuses and their corresponding types.
OpportunityStatusesNames	The language-specific strings used for localization of fields.
OrganizationsAddresses	The physical address of the organization.
OrganizationsFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
OrganizationsNotes	The note text associated with the objects such as contacts and organizations.
SalesProductsAdminVisibleInterfaces	The named ID that can be included in a list.
SalesProductsDescriptions	The language-specific string used for localization.
SalesProductsNames	The language-specific strings used for localization of fields.
SalesProductsSchedules	The price schedule for a sales product.
SalesTerritoriesAdminVisibleInterfaces	The named ID that can be included in a list.
SalesTerritoriesNames	The language-specific strings used for localization of fields.
ServiceCategoriesAdminVisibleInterfaces	The named ID that can be included in a list.
ServiceCategoriesDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceCategoriesEndUserVisibleInterfaces	The named ID that can be included in a list.
ServiceCategoriesNames	The language-specific strings used for localization of fields.
ServiceCategoriesProductLinks	The product linking for a category or a disposition.
ServiceDispositionsAdminVisibleInterfaces	The named ID that can be included in a list.
serviceDispositionsDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceDispositionsNames	The language-specific strings used for localization of fields.
ServiceDispositionsProductLinks	The product linking for a category or a disposition.
ServiceMailboxes	The email box dedicated to collect email inquiries sent by customers.
ServiceProductsAdminVisibleInterfaces	The named ID that can be included in a list.
ServiceProductsCategoryLinks	The category linking for a product.
ServiceProductsDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceProductsDispositionLinks	The disposition linking for a product.
ServiceProductsEndUserVisibleInterfaces	The named ID that can be included in a list.
ServiceProductsNames	The language-specific strings used for localization of fields.
SiteInterfaces	The console, windows, and pages used by staff members and customers to access the application and interact with a single knowledge base.
StandardContentsAdminVisibleInterfaces	The named ID that can be included in a list.
StandardContentsContentValues	The standard content value with a data type and a formatted data value.
TasksFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
TasksNotes	The note text associated with the objects such as contacts and organizations.
VariablesInterfaceValues	The interface-specific value of a variable.

AccountsEmails

The email address and its associated information.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AccountsEmails WHERE accountsId = 12
SELECT * FROM AccountsEmails WHERE accountsId > 15
SELECT * FROM AccountsEmails WHERE address LIKE '%test'
SELECT * FROM AccountsEmails WHERE accountsId IN (12,23,123)
SELECT * FROM AccountsEmails WHERE certificate IS NOT NULL

Columns


Name	Type	Description
AccountsId	Long	Id of Accounts.
Address	String	The string value of the email address.
AddressTypeId	Long	Id of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
AddressTypelookUpName	String	LookUpName of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
Certificate	String	The associated public email certificate used to encrypt outgoing emails.
Invalid	Bool	Indicates whether the email address is disabled.

AccountsPhones

The details related to the phone number.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AccountsPhones WHERE accountsId = 12
SELECT * FROM AccountsPhones WHERE accountsId > 15
SELECT * FROM AccountsPhones WHERE number LIKE '%test'
SELECT * FROM AccountsPhones WHERE accountsId IN (12,23,123)
SELECT * FROM AccountsPhones WHERE number IS NOT NULL

Columns


Name	Type	Description
AccountsId	Long	Id of Accounts.
Number	String	The free-form phone number including non-numeric characters. For example, 1 (406) 522-4200.
PhoneTypeId	Long	Id of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
PhoneTypelookUpName	String	LookUpName of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
RawNumber	String	The automatically populated numeric string derived by excluding the non-numeric characters from the value of the Number attribute. For example, if the Number attribute has a value of 1 (406) 522-4200, this field is populated as 14065224200. This attribute is read-only.

AnalyticsReports

The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the analytics report was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the analytics report definition.
LookupName	String	The name used to look up the analytics report definition.
Name	String	The name of the report in the language of the current interface. This attribute is read-only.
UpdatedTime	Datetime	The date and time when the analytics report was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
columns	String	The columns defined in the report.
filters	String	The filters defined on the report.
names	String	The list of language-specific display names.

AnalyticsReportsFilters

The filters used for running an analytics report.

Table-Specific Information

SELECT

The Sync App will use the Oracle Service Cloud API to process WHERE clause conditions built with the following operators. AnalyticsReportsid is a required column.

analyticsReportsid supports "="

SELECT * FROM AnalyticsReportsFilters WHERE analyticsReportsid = 12

Columns


Name	Type	Description
AnalyticsReportsId	Long	Id of analytics report
Name	String	Name of filter
Values	String	Values of filter

AnalyticsReportsNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnalyticsReportsNames WHERE languageId = 12
SELECT * FROM AnalyticsReportsNames WHERE languageId > 15
SELECT * FROM AnalyticsReportsNames WHERE labeltext LIKE '%test'
SELECT * FROM AnalyticsReportsNames WHERE languageId IN (12,23,123)
SELECT * FROM AnalyticsReportsNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
AnalyticsReportsId	Long	Id of AnalyticsReports.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

AnswersCategories

The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswersCategories WHERE CategoriesId =12
SELECT * FROM AnswersCategories WHERE CategoriesId >15
SELECT * FROM AnswersCategories WHERE CategoriesLookUpName LIKE '%test'
SELECT * FROM AnswersCategories WHERE CategoriesId IN (12,23,123)
SELECT * FROM AnswersCategories WHERE CategoriesLookUpName IS NOT NULL

Columns


Name	Type	Description
CategoriesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
CategoriesLookUpName	String	The name used to look up the object.
AnswersId	Long	The unique identifier of the object. This is the key for the list entry.
AnswersLookUpName	String	The name used to look up the object.

AnswersCommonAttachments

The file attachment shared by sibling answers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswersId	Long	Id of Answers.
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 answer. 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.
Disabled	Bool	Indicates whether the file attachment is hidden when the associated answer is viewed. If the Private flag is not set, this flag hides the file attachment. This attribute does not have a default value.
FileName	String	The name of the file when saving it to the disk.
FormData	String
Id [KEY]	Long	The unique identifier of the file attachment.
Private	Bool	Indicates whether the file attachment is hidden from the end users. This attribute does not have a default value.
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 was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of language specific display names.

AnswersCommonAttachmentsNames

The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswersCommonAttachmentsNames WHERE answersId = 12
SELECT * FROM AnswersCommonAttachmentsNames WHERE answersId > 15
SELECT * FROM AnswersCommonAttachmentsNames WHERE labelText LIKE '%test'
SELECT * FROM AnswersCommonAttachmentsNames WHERE answersId IN (12,23,123)
SELECT * FROM AnswersCommonAttachmentsNames WHERE labelText IS NOT NULL

Columns


Name	Type	Description
AnswersId	Long	Id of Answers.
CommonAttachmentsId	Long	Id of CommonAttachments.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

AnswersFileAttachments

The file attachment shared by answers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswersId	Long	Id of Answers.
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 answer. 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.
Disabled	Bool	Indicates whether the file attachment should be hidden when the associated answer is viewed. If the Private flag is not set, this flag hides the file attachment. This attribute does not have a default value.
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.
Indexed	Bool	Indicates whether the file attachment's contents are included in the keyword indexing of the answer. This attribute does not have a default value.
Name	String	The short display name of the file attachment.
Private	Bool	Indicates whether the file attachment is hidden from the end users. The default value is false.
Size	Int	The size of the file in bytes. This attribute is read-only.
URL	String	The URL to access the file.
UpdatedTime	Datetime	The date and time when the file was last updated. This attribute is read-only.

AnswersNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswersId	Long	Id of Answers.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

AnswersProducts

The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswersProducts WHERE answersId = 12
SELECT * FROM AnswersProducts WHERE answersId > 15
SELECT * FROM AnswersProducts WHERE answerslookUpName LIKE '%test'
SELECT * FROM AnswersProducts WHERE answersId IN (12,23,123)
SELECT * FROM AnswersProducts WHERE answerslookUpName IS NOT NULL

Columns


Name	Type	Description
ProductsId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
ProductsLookUpName	String	The name used to look up the object.
AnswersId	Long	The unique identifier of the object. This is the key for the list entry.
AnswersLookUpName	String	The name used to look up the object.

AnswersRelatedAnswers

The knowledge base information that provides solutions to the common customer support questions.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswersRelatedAnswers WHERE manualstrength = 12
SELECT * FROM AnswersRelatedAnswers WHERE manualstrength > 15
SELECT * FROM AnswersRelatedAnswers WHERE toanswerlookUpName LIKE '%test'
SELECT * FROM AnswersRelatedAnswers WHERE manualstrength IN (12,23,123)
SELECT * FROM AnswersRelatedAnswers WHERE toanswerlookUpName IS NOT NULL

Columns


Name	Type	Description
AnswersId	Long	Id of Answers.
LearnedStrength	Int	The relative relatedness of the linked answers.
ManualStrength	Int	The static strength of the link.
SimilarityStrength	Int	The strength of the link calculated by the link-clustering algorithms based on the content similarity of the answers.
ToAnswerId	Long	Id of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.
ToAnswerlookUpName	String	LookUpName of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.

AnswersSiblingAnswers

The knowledge base information that provides solutions to the common customer support questions.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswersSiblingAnswers WHERE SiblingAnswersId = 12
SELECT * FROM AnswersSiblingAnswers WHERE SiblingAnswersId > 15
SELECT * FROM AnswersSiblingAnswers WHERE SiblingAnswersLookUpName LIKE '%test'
SELECT * FROM AnswersSiblingAnswers WHERE SiblingAnswersId IN (12,23,123)
SELECT * FROM AnswersSiblingAnswers WHERE SiblingAnswersLookUpName IS NOT NULL

Columns


Name	Type	Description
SiblingAnswersId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
SiblingAnswersLookUpName	String	The name used to look up the object.
AnswersId	Long	The unique identifier of the object. This is the key for the list entry.
AnswersLookUpName	String	The name used to look up the object.

AnswerVersionsCategories

The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CategoriesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
CategoriesLookUpName	String	The name used to look up the object.
AnswerVersionsId	Long	The unique identifier of the object. This is the key for the list entry.
AnswerVersionsLookUpName	String	The name used to look up the object.

AnswerVersionsCommonAttachments

The file attachment shared by sibling answers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswerVersionsId	Long	Id of AnswerVersions.
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 answer. 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.
Disabled	Bool	Indicates whether the file attachment is hidden when the associated answer is viewed. If the Private flag is not set, this flag hides the file attachment. This attribute does not have a default value.
FileName	String	The name of the file when saving it to the disk.
FormData	String	The form data.
Id [KEY]	Long	The unique identifier of the file attachment.
Private	Bool	Indicates whether the file attachment is hidden from the end users. This attribute does not have a default value.
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 was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of language specific display names.

AnswerVersionsCommonAttachmentsNames

The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswerVersionsCommonAttachmentsNames WHERE answerVersionsId = 12
SELECT * FROM AnswerVersionsCommonAttachmentsNames WHERE answerVersionsId > 15
SELECT * FROM AnswerVersionsCommonAttachmentsNames WHERE labelText LIKE '%test'
SELECT * FROM AnswerVersionsCommonAttachmentsNames WHERE answerVersionsId IN (12,23,123)
SELECT * FROM AnswerVersionsCommonAttachmentsNames WHERE labelText IS NOT NULL

Columns


Name	Type	Description
AnswerVersionsId	Long	The Id of AnswerVersions.
CommonAttachmentsId	Long	The Id of CommonAttachments.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

AnswerVersionsFileAttachments

The file attachment shared by answers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswerVersionsId	Long	The Id of Answer Version.
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 answer. 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.
Disabled	Bool	Indicates whether the file attachment should be hidden when the associated answer is viewed. If the Private flag is not set, this flag hides the file attachment. This attribute does not have a default value.
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.
Indexed	Bool	Indicates whether the file attachment's contents are included in the keyword indexing of the answer. This attribute does not have a default value.
Name	String	The short display name of the file attachment.
Private	Bool	Indicates whether the file attachment is hidden from the end users. The default value is false.
Size	Int	The size of the file in bytes. This attribute is read-only.
URL	String	The URL to access the file.
UpdatedTime	Datetime	The date and time when the file was last updated. This attribute is read-only.

AnswerVersionsNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AnswerVersionsId	Long	Id of the answer version.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

AnswerVersionsProducts

The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswerVersionsProducts WHERE productsid = 12
SELECT * FROM AnswerVersionsProducts WHERE productsid > 15
SELECT * FROM AnswerVersionsProducts WHERE productslookUpName LIKE '%test'
SELECT * FROM AnswerVersionsProducts WHERE productsid IN (12,23,123)
SELECT * FROM AnswerVersionsProducts WHERE productslookUpName IS NOT NULL

Columns


Name	Type	Description
ProductsId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
ProductsLookUpName	String	The name used to look up the object.
AnswerVersionsId	Long	The unique identifier of the object. This is the key for the list entry.
AnswerVersionsLookUpName	String	The name used to look up the object.

AnswerVersionsRelatedAnswers

The link to related answers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength = 12
SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength > 15
SELECT * FROM AnswerVersionsRelatedAnswers WHERE toanswerlookUpName LIKE '%test'
SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength IN (12,23,123)
SELECT * FROM AnswerVersionsRelatedAnswers WHERE toanswerlookUpName IS NOT NULL

Columns


Name	Type	Description
AnswerVersionsId	Long	The unique identifier of the answer version.
LearnedStrength	Int	The relative relatedness of the linked answers.
ManualStrength	Int	The static strength of the link.
SimilarityStrength	Int	The strength of the link calculated by the link-clustering algorithms based on the content similarity of the answers.
ToAnswerId	Long	Id of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.
ToAnswerlookUpName	String	LookUpName of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.

AssetsSLAInstances

The instance of a Service Level Agreement (SLA).

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
AssetsId	Long	The unique identifier of the asset.
ActiveDate	Date	The date when the instance became active.
ExpireDate	Date	The date when the instance is scheduled to expire.
Id [KEY]	Long	The unique identifier of the SLAInstance.
NameOfSLAId	Long	Id of nameOfSLA. The SLA from which the instance was created.
NameOfSLAlookUpName	String	LookUpName of nameOfSLA. The SLA from which the instance was created.
RemainingFromCSR	Int	The number of remaining CSR incidents.
RemainingFromChat	Int	The number of remaining chat incidents.
RemainingFromEmail	Int	The number of remaining email incidents.
RemainingFromWeb	Int	The number of remaining web self-service incidents.
RemainingTotal	Int	The total number of remaining incidents.
SLASet	Int	The SLA set from which the instance was created.
StateOfSLAId	Long	Id of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.
StateOfSLAlookUpName	String	LookUpName of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.

AssetStatuses

The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the asset status was created. This attribute is read-only.
DisplayOrder	Int	The display position relative to other asset statuses.
Id [KEY]	Long	The unique identifier of the asset status.
LookupName	String	The name used to look up the asset status.
Name	String	The name of the asset status in the language of the current interface.
StatusTypeId	Long	Id of statusType. The type associated with the status.
StatusTypelookUpName	String	LookUpName of statusType. The type associated with the status.
UpdatedTime	Datetime	The date and time when the asset status was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of names, one for each supported language.

AssetStatusesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM AssetStatusesNames WHERE assetStatusesId = 12
SELECT * FROM AssetStatusesNames WHERE assetStatusesId > 15
SELECT * FROM AssetStatusesNames WHERE labeltext LIKE '%test'
SELECT * FROM AssetStatusesNames WHERE assetStatusesId IN (12,23,123)
SELECT * FROM AssetStatusesNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
AssetStatusesId	Long	The unique identifier of the asset statuses version.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

Campaigns

The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
ActualLeads	Int	The number of actual leads generated from the campaign.
ActualOpportunities	Int	The number of actual opportunities generated from the campaign.
AssignedToAccountId	Long	Id of assignedToAccount. The staff member assigned to the campaign.
AssignedToAccountlookUpName	String	LookUpName of assignedToAccount. The staff member assigned to the campaign.
CampaignEndTime	Datetime	The date and time when the campaign ends.
CampaignStartTime	Datetime	The date and time when the campaign begins.
CreatedByAccountId	Long	Id of createdByAccount. The ID number of the staff member who created the campaign.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The ID number of the staff member who created the campaign.
CreatedTime	Datetime	The date and time when the campaign was created. This attribute is read-only.
ExpectedLeads	Int	The number of expected leads generated from the campaign.
ExpectedOpportunities	Int	The number of expected opportunities generated from the campaign.
FlowId	Long	Id of flow. The ID of the flow that the campaign is associated with.
FlowlookUpName	String	LookUpName of flow. The ID of the flow that the campaign is associated with.
Id [KEY]	Long	The unique identifier of the campaign.
InterfaceId	Long	Id of interface. The ID of the interface that the campaign is associated with.
InterfacelookUpName	String	LookUpName of interface. The ID of the interface that the campaign is associated with.
IsSingleExecute	Bool	Indicates whether the contacts are allowed to flow through the recurring campaign only one time. This attribute does not have a default value.
LookupName	String	The name used to look up the campaign.
Name	String	The name of the campaign.
ObjectivesSummary	String	The summary of the objectives specified for the campaign.
UpdatedByAccountId	Long	Id of updatedByAccount. The ID of the staff member who last updated the campaign.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The ID of the staff member who last updated the campaign.
UpdatedTime	Datetime	The date and time when the campaign was last updated. This attribute is read-only.
ActualCostcurrencyId	Long	Id of currency. The ID of the currency.
ActualCostcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
ActualCostexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualCostexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualCostvalue	String	The value of the currency.
ActualSalescurrencyId	Long	Id of currency. The ID of the currency.
ActualSalescurrencylookUpName	String	LookUpName of currency. The ID of the currency.
ActualSalesexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualSalesexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualSalesvalue	String	The value of the currency.
BudgetcurrencyId	Long	Id of currency. The ID of the currency.
BudgetcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
BudgetexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
BudgetexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Budgetvalue	String	The value of the currency.
ExpectedCostcurrencyId	Long	Id of currency. The ID of the currency.
ExpectedCostcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
ExpectedCostexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedCostexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedCostvalue	String	The value of the currency.
ExpectedSalescurrencyId	Long	Id of currency. The ID of the currency.
ExpectedSalescurrencylookUpName	String	LookUpName of currency. The ID of the currency.
ExpectedSalesexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedSalesexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedSalesvalue	String	The value of the currency.
Folderid	Long	ID value
FolderlookupName	String	Name used to lookup this object

ChannelTypes

The social channels tracked in contact records when storing social account user names and associating social monitor incidents to contacts.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ChannelTypes WHERE Id = 12
SELECT * FROM ChannelTypes WHERE Id > 15
SELECT * FROM ChannelTypes WHERE lookUpName LIKE '%test'
SELECT * FROM ChannelTypes WHERE Id IN (12,23,123)
SELECT * FROM ChannelTypes WHERE lookUpName IS NOT NULL

Columns


Name	Type	Description
ContactVisibility	Bool	Indicates whether the channel is available in the ChannelUsername collection. This attribute does not have a default value and is read-only.
CreatedTime	Datetime	The date and time when the channel type was created. This attribute is read-only.
DisplayOrder	Int	The position of the channel type in the list of channels.
Id [KEY]	Long	The unique identifier of the channel type.
LookupName	String	The name used to look up the channel type.
Name	String	The name of the channel type in the language of the current interface. This attribute is read-only.
UpdatedTime	Datetime	The date and time when the channel type was last updated. This attribute is read-only.
AttributescontactVisibility	Bool	Indicates whether the channel is visible to contacts. This attribute does not have a default value.
Attributesincoming	Bool	Indicates whether it is an incoming channel. This attribute does not have a default value.
Attributesmonitoring	Bool	Indicates whether it is a monitoring channel. This attribute does not have a default value.
Attributesoutgoing	Bool	Indicates whether it is an outgoing channel. This attribute does not have a default value.
Attributessubscription	Bool	Indicates whether it is a subscription channel. This attribute does not have a default value.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of names, one for each supported language.

ChannelTypesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ChannelTypesNames WHERE channelTypesId = 12
SELECT * FROM ChannelTypesNames WHERE channelTypesId > 15
SELECT * FROM ChannelTypesNames WHERE labeltext LIKE '%test'
SELECT * FROM ChannelTypesNames WHERE channelTypesId IN (12,23,123)
SELECT * FROM ChannelTypesNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ChannelTypesId	Long	The unique identifier of the channel type.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

Chats

The real-time, two-way dialog between a customer and one or more chat agents.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the chat was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the chat.
LookupName	String	The name used to look up the chat.
Question	String	The question that is used as the lookupName for the chat object.
UpdatedTime	Datetime	The date and time when the chat was last updated. This attribute is read-only.

Configurations

The information about the configuration settings within Oracle B2C Service.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the configuration was created. This attribute is read-only.
DataTypeId	Long	Id of dataType. The type of data that the configuration represents.
DataTypelookUpName	String	LookUpName of dataType. The type of data that the configuration represents.
Id [KEY]	Long	The unique identifier of the configuration.
LookupName	String	The name used to look up the configuration.
Name	String	The name of the configuration.
UpdatedTime	Datetime	The date and time when the configuration was last updated. This attribute is read-only.
Value	String	The string value of the configuration. The value is either a site value or the value associated with the interface. The configuration values are stored and fetched from a file cache.

ContactsChannelUsernames

The user name of the channel.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ContactsChannelUsernames WHERE contactsId = 12
SELECT * FROM ContactsChannelUsernames WHERE contactsId > 15
SELECT * FROM ContactsChannelUsernames WHERE usernumber LIKE '%test'
SELECT * FROM ContactsChannelUsernames WHERE contactsId IN (12,23,123)
SELECT * FROM ContactsChannelUsernames WHERE usernumber IS NOT NULL

Columns


Name	Type	Description
ContactsId	Long	The unique identifier of the contact.
ChannelTypeId	Long	Id of channelType. The associated communication channel. This is the key for the list entry.
ChannelTypelookUpName	String	LookUpName of channelType. The associated communication channel. This is the key for the list entry.
UserNumber	String	The user number ID for this communication channel. It is a string with a value between 0 and 9.
Username	String	The user name for this communication channel.

ContactsEmails

The email address and its associated information.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ContactsEmails WHERE contactsId = 12
SELECT * FROM ContactsEmails WHERE contactsId > 15
SELECT * FROM ContactsEmails WHERE certificate LIKE '%test'
SELECT * FROM ContactsEmails WHERE contactsId IN (12,23,123)
SELECT * FROM ContactsEmails WHERE certificate IS NOT NULL

Columns


Name	Type	Description
ContactsId	Long	The unique identifier of the contact.
Address	String	The string value of the email address.
AddressTypeId	Long	Id of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
AddressTypelookUpName	String	LookUpName of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
Certificate	String	The associated public email certificate used to encrypt outgoing emails.
Invalid	Bool	Indicates whether the email address is disabled.

ContactsFileAttachments

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

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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.

ContactsNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
ContactsId	Long	The unique identifier of the contact.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

ContactsOpenIDAccounts

The OpenID related information for the contact.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
ContactsId	Long	The unique identifier of the contact.
Id [KEY]	Long	The unique identifier for the list entry.
URL	String	The unique authentication URL for the OpenIDAccount item.

ContactsPhones

The details related to the phone number.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ContactsPhones WHERE phonetypeId = 12
SELECT * FROM ContactsPhones WHERE phonetypeId > 15
SELECT * FROM ContactsPhones WHERE rawnumber LIKE '%test'
SELECT * FROM ContactsPhones WHERE phonetypeId IN (12,23,123)
SELECT * FROM ContactsPhones WHERE rawnumber IS NOT NULL

Columns


Name	Type	Description
ContactsId	Long	The unique identifier of the contact.
Number	String	The free-form phone number including non-numeric characters. For example, 1 (406) 522-4200.
PhoneTypeId	Long	Id of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
PhoneTypelookUpName	String	LookUpName of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
RawNumber	String	The automatically populated numeric string derived by excluding the non-numeric characters from the value of the Number attribute. For example, if the Number attribute has a value of 1 (406) 522-4200, this field is populated as 14065224200. This attribute is read-only.

CountriesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM CountriesNames WHERE languageId = 12
SELECT * FROM CountriesNames WHERE languageId > 15
SELECT * FROM CountriesNames WHERE labeltext LIKE '%test'
SELECT * FROM CountriesNames WHERE languageId IN (12,23,123)
SELECT * FROM CountriesNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
CountriesId	Long	The unique identifier of the country.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

CountriesProvinces

The information about the provinces in the Countries/Provinces customizable menu.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CountriesId	Long	The unique identifier of the country.
DisplayOrder	Int	The display position relative to other provinces associated with the same country.
Id [KEY]	Long	The unique identifier of the province.
Name	String	The name of the province in the language of the current interface. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of names or labels for the province for each available language.

CountriesProvincesNames

The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM CountriesProvinces WHERE languageId =12
SELECT * FROM CountriesProvinces WHERE languageId >15
SELECT * FROM CountriesProvinces WHERE labelText LIKE '%test'
SELECT * FROM CountriesProvinces WHERE languageId IN (12,23,123)
SELECT * FROM CountriesProvinces WHERE labelText IS NOT NULL

Columns


Name	Type	Description
CountriesId	Long	The unique identifier of the country.
ProvincesId	Long	The unique identifier of the province.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

HolidaysAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12;
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15;
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesLookUpName LIKE '%test';
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123);
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesLookUpName IS NOT NULL;

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
HolidaysId	Long	The unique identifier of the object. This is the key for the list entry.
HolidaysLookUpName	String	The name used to look up the object.

IncidentsBilledMinutes

The work time applied to incidents through the Time Billed feature.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
IncidentsId	Long	The unique identifier of the incident.
AccountId	Long	Id of account. The staff member who billed the time. This is part of the key for the list entry.
AccountlookUpName	String	LookUpName of account. The staff member who billed the time. This is part of the key for the list entry.
BillTime	Datetime	The date and time when the work was performed. This is part of the key for the list entry.
BillableTaskId	Long	Id of billableTask. The associated billable task.
BillableTasklookUpName	String	LookUpName of billableTask. The associated billable task.
Comment	String	The comments associated with the timeBilled record.
Id [KEY]	Long	The unique identifier of the timeBilled record.
Minutes	Int	The number of minutes billed.

IncidentsFileAttachments

The file attachment that includes fields specific to incidents.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
IncidentsId	Long	The unique identifier of the incident.
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 incident. 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.
Private	Bool	Indicates whether the file attachment is hidden from the end users. This attribute does not have a default value.
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 was last updated. This attribute is read-only.

IncidentsMilestoneInstances

The milestone instances associated with incidents.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId = 12
SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId > 15
SELECT * FROM IncidentsMilestoneInstances WHERE milestonelookUpName LIKE '%test'
SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId IN (12,23,123)
SELECT * FROM IncidentsMilestoneInstances WHERE milestonelookUpName IS NOT NULL

Columns


Name	Type	Description
IncidentsId	Long	The unique identifier of the incident.
MilestoneId	Long	Id of milestone. The ID of the associated milestone.
MilestonelookUpName	String	LookUpName of milestone. The ID of the associated milestone.
ResolutionDueTime	Datetime	The date and time when the associated resolution milestone is due.

IncidentsThreads

The incident discussion thread entry.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
IncidentsId	Long	The unique identifier of the incident.
AccountId	Long	Id of account. The associated staff account. This attribute is read-only.
AccountlookUpName	String	LookUpName of account. The associated staff account. This attribute is read-only.
ChannelId	Long	Id of channel. The associated communication channel.
ChannellookUpName	String	LookUpName of channel. The associated communication channel.
ContactId	Long	Id of contact. The associated contact.
ContactlookUpName	String	LookUpName of contact. The associated contact.
ContentTypeId	Long	Id of contentType. The MIME content type of the file. For example, text/plain, audio/mp3, image/jpg, and so on.
ContentTypelookUpName	String	LookUpName of contentType. 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 thread was created. This attribute is read-only.
DisplayOrder	Int	The relative display order for the threads with the same created time. This attribute is read-only.
EntryTypeId	Long	Id of entryType. The entry type.
EntryTypelookUpName	String	LookUpName of entryType. The entry type.
Id [KEY]	Long	The unique identifier of the thread. It cannot be used for delete operations.
MailHeader	String	The mail header information for a contact submitting the thread by email.
Text	String	The entry text in the thread.

Mailboxes

The mailbox used for collecting email inquiries sent by customers, responses to mailings, and bounced messages.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the mailbox was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the mailbox.
InterfaceId	Long	Id of interface. The interface that the mailbox is associated with.
InterfacelookUpName	String	LookUpName of interface. The interface that the mailbox is associated with.
IsDefault	Bool	Indicates whether the mailbox is the default mailbox for the interface. This attribute does not have a default value.
LookupName	String	The name used to look up the mailbox.
Name	String	The name of the mailbox.
TypeId	Long	Id of type. The module the mailbox is associated with.
TypelookUpName	String	LookUpName of type. The module the mailbox is associated with.
UpdatedTime	Datetime	The date and time when the mailbox was last updated. This attribute is read-only.
IncomingEmailSettingsforceReplyBetweenLines	Bool	Indicates whether the Force Reply Between the Lines feature is enabled for outgoing emails from the mailbox. This attribute does not have a default value.
IncomingEmailSettingsforwardRejectMessageAddress	String	The address to which rejected messages are sent.
IncomingEmailSettingsisEnabled	Bool	Indicates whether incoming email option is enabled. This attribute does not have a default value.
OutgoingEmailSettingsdisplayName	String	The display name used in the outgoing emails from the mailbox.
OutgoingEmailSettingsfriendlyFromAddress	String	The from address used to brand outgoing emails as friendly.
OutgoingEmailSettingsfromAddress	String	The from address on the outgoing email.
OutgoingEmailSettingsisEnabled	Bool	Indicates whether outgoing email is enabled. This attribute does not have a default value.
OutgoingEmailSettingsreplyToAddress	String	The reply-to-address on the outgoing email.

MarketingMailboxes

The mailbox used to send and receive emails and process bounced messages.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the marketing mailbox was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the marketing mailbox.
InterfaceId	Long	Id of interface. The interface that the mailbox is associated with.
InterfacelookUpName	String	LookUpName of interface. The interface that the mailbox is associated with.
IsDefault	Bool	Indicates whether the mailbox is the default mailbox for the interface. This attribute does not have a default value.
LookupName	String	The name used to look up the marketing mailbox.
Name	String	The name of the marketing mailbox.
TypeId	Long	Id of type. The module the mailbox is associated with.
TypelookUpName	String	LookUpName of type. The module the mailbox is associated with.
UpdatedTime	Datetime	The date and time when the marketing mailbox was last updated. This attribute is read-only.
IncomingEmailSettingsforceReplyBetweenLines	Bool	Indicates whether the Force Reply Between the Lines feature is enabled for outgoing emails from the mailbox. This attribute does not have a default value.
IncomingEmailSettingsforwardRejectMessageAddress	String	The address to which rejected messages are sent.
IncomingEmailSettingsisEnabled	Bool	Indicates whether incoming email option is enabled. This attribute does not have a default value.
OutgoingEmailSettingsdisplayName	String	The display name used in the outgoing emails from the mailbox.
OutgoingEmailSettingsfriendlyFromAddress	String	The from address used to brand outgoing emails as friendly.
OutgoingEmailSettingsfromAddress	String	The from address on the outgoing email.
OutgoingEmailSettingsisEnabled	Bool	Indicates whether outgoing email is enabled. This attribute does not have a default value.
OutgoingEmailSettingsreplyToAddress	String	The reply-to-address on the outgoing email.

MessageBases

The editable text string that allows international language support and customization of headings, labels, buttons, and other text in the administration interface and customer portal. It also applies to email messages and notifications.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the message base was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the message base.
LookupName	String	The name used to look up the message base.
Name	String	The name of the message base.
UpdatedTime	Datetime	The date and time when the message base was last updated. This attribute is read-only.
UsageId	Long	Id of usage. The type of data the message base represents.
UsagelookUpName	String	LookUpName of usage. The type of data the message base represents.
Value	String	The string value of the message base.

NamedIDs

An ID which has an associated name string. These IDs can be set by either value or name.

Table-Specific Information

SELECT

The Sync App will use the Oracle Service Cloud API to process WHERE clause conditions built with = operator. Tablename and Columnname are required columns.

If you want to access the namedIds of columns inside a child table, then give the column value in the form of the tree substructure, after the parent table name, separated by "/". Use the same case for the columnname as mentioned in the Tables or Views.

For example: If you want to retrieve the addressType namedId for accountsEmails table. The tablename will be 'accounts' and the columnname will be 'emails/addressType'.

SELECT * FROM NamedIDs tablename = 'accounts' AND columnname = 'profiles'
SELECT * FROM NamedIDs tablename = 'accounts' AND columnname = 'emails/addressType'

Columns


Name	Type	Description
TableName	String	Table Name
ColumnName	String	Column Name
Id	Long	Id of namedId
LookUpName	String	LookUpName of NamedId

OpportunitiesFileAttachments

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

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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.

OpportunitiesNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OpportunitiesId	Long	The unique identifier of the opportunity.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

OpportunitiesOtherContacts

The secondary contact associated with the opportunity.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM OpportunitiesOtherContacts WHERE contactId = 12
SELECT * FROM OpportunitiesOtherContacts WHERE contactId > 15
SELECT * FROM OpportunitiesOtherContacts WHERE contactlookUpName LIKE '%test'
SELECT * FROM OpportunitiesOtherContacts WHERE contactId IN (12,23,123)
SELECT * FROM OpportunitiesOtherContacts WHERE contactlookUpName IS NOT NULL

Columns


Name	Type	Description
OpportunitiesId	Long	The unique identifier of the opportunity.
ContactId	Long	Id of contact. The ID of the contact. This is the key for the list entry.
ContactlookUpName	String	LookUpName of contact. The ID of the contact. This is the key for the list entry.
ContactRoleId	Long	Id of contactRole. The role of the contact in the opportunity process.
ContactRolelookUpName	String	LookUpName of contactRole. The role of the contact in the opportunity process.

OpportunitiesQuotes

The sales quote associated with an opportunity.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OpportunitiesId	Long	The unique identifier of the opportunity.
Comment	String	The comment text for the quote.
CreatedTime	Datetime	The date and time when the quote was created.
DiscountPercent	Int	The discount percentage for the quote.
Forecasted	Bool	Indicates whether the quote has been forecasted. The default value is false.
Id [KEY]	Long	The unique identifier of the quote. This is the key for the list entry.
Name	String	The descriptive name of the quote.
OfferEndTime	Datetime	The date and time when the quoted offer ends.
OfferStartTime	Datetime	The date and time when the quoted offer starts.
PriceScheduleId	Long	Id of priceSchedule. The effective price schedule.
PriceSchedulelookUpName	String	LookUpName of priceSchedule. The effective price schedule.
SentTime	Datetime	The date and time when the quote was sent.
SentTo	String	The email addresses of the contact to whom the quote was sent. This attribute is read-only.
StatusId	Long	Id of status. The current status.
StatuslookUpName	String	LookUpName of status. The current status.
TemplateId	Long	Id of template. The template used to generate the quote.
TemplatelookUpName	String	LookUpName of template. The template used to generate the quote.
UpdatedTime	Datetime	The date and time when the quote was last updated. This attribute is read-only.
AdjustedTotalcurrencyId	Long	Id of currency. The ID of the currency.
AdjustedTotalcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
AdjustedTotalexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalvalue	String	The value of the currency.
TotalcurrencyId	Long	Id of currency. The ID of the currency.
TotalcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
TotalexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
TotalexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Totalvalue	String	The value of the currency.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
fileAttachments	String	The list of file attachments for the quote.
lineItems	String	The list of individual product line items that make up the quote.

OpportunitiesQuotesFileAttachments

The file that is attached or associated with another object.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OpportunitiesId	Long	The unique identifier of the opportunity.
QuotesId	Long
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.
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.
Size	Int	The size of the file in bytes. This attribute is read-only.
URL	String	The URL to access the file.
UpdatedTime	Datetime	The date and time when the file was last updated. This attribute is read-only.

OpportunitiesQuotesLineItems

The product line item in a quote.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OpportunitiesId	Long	The unique identifier of the opportunity.
QuotesId	Long	The unique identifier of the quote.
AdjustedDescription	String	The edited product description in the product line item.
AdjustedName	String	The edited product name in the product line item.
AdjustedPartNumber	String	The edited product part number in the product line item.
Comment	String	The comments associated with a product line item in the quote.
DiscountPercent	Int	The discount applied to the adjusted price of the product line item.
DisplayOrder	Int	The position of the line item in the quote.
Id [KEY]	Long	The unique identifier of the product line item in the quote. This is the key for the list entry.
OriginalDescription	String	The original product description. This attribute is read-only.
OriginalName	String	The original product name. This attribute is read-only.
OriginalPartNumber	String	The original product part number. This attribute is read-only.
ProductId	Long	Id of product. The ID of the sales product.
ProductlookUpName	String	LookUpName of product. The ID of the sales product.
Quantity	Int	The product quantity in the line item.
AdjustedPricecurrencyId	Long	Id of currency. The ID of the currency.
AdjustedPricecurrencylookUpName	String	LookUpName of currency. The ID of the currency.
AdjustedPriceexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedPriceexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedPricevalue	String	The value of the currency.
AdjustedTotalcurrencyId	Long	Id of currency. The ID of the currency.
AdjustedTotalcurrencylookUpName	String	LookUpName of currency. The ID of the currency.
AdjustedTotalexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
AdjustedTotalvalue	String	The value of the currency.
OriginalPricecurrencyId	Long	Id of currency. The ID of the currency.
OriginalPricecurrencylookUpName	String	LookUpName of currency. The ID of the currency.
OriginalPriceexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
OriginalPriceexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
OriginalPricevalue	String	The value of the currency.

OpportunityStatuses

The information about the default and custom opportunity statuses and their corresponding types.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the opportunity status was created. This attribute is read-only.
DisplayOrder	Int	The position of the opportunity status in the folder list.
Id [KEY]	Long	The unique identifier of the opportunity status.
LookupName	String	The name used to look up the opportunity status.
Name	String	The name of the opportunity status in the language of the current interface.
StatusTypeId	Long	Id of statusType. The current status and associated status type.
StatusTypelookUpName	String	LookUpName of statusType. The current status and associated status type.
UpdatedTime	Datetime	The date and time when the opportunity status was last updated. This attribute is read-only.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
names	String	The list of names, one for each supported language.

OpportunityStatusesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM OpportunityStatusesNames WHERE languageId = 12
SELECT * FROM OpportunityStatusesNames WHERE languageId > 15
SELECT * FROM OpportunityStatusesNames WHERE labeltext LIKE '%test'
SELECT * FROM OpportunityStatusesNames WHERE languageId IN (12,23,123)
SELECT * FROM OpportunityStatusesNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
OpportunityStatusesId	Long	The unique identifier of the opportunity.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

OrganizationsAddresses

The physical address of the organization.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM OrganizationsAddresses WHERE addresstypeId = 12
SELECT * FROM OrganizationsAddresses WHERE addresstypeId > 15
SELECT * FROM OrganizationsAddresses WHERE city LIKE '%test'
SELECT * FROM OrganizationsAddresses WHERE addresstypeId IN (12,23,123)
SELECT * FROM OrganizationsAddresses WHERE city IS NOT NULL

Columns


Name	Type	Description
OrganizationsId	Long	The unique identifier of the organization.
AddressTypeId	Long	Id of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry.
AddressTypelookUpName	String	LookUpName of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry.
City	String	The name of the city.
CountryId	Long	Id of country. The ID of the country.
CountrylookUpName	String	LookUpName of country. The ID of the country.
PostalCode	String	The postal code or ZIP code.
StateOrProvinceId	Long	Id of stateOrProvince. The ID of the state or province.
StateOrProvincelookUpName	String	LookUpName of stateOrProvince. The ID of the state or province.
Street	String	The street address.

OrganizationsFileAttachments

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

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OrganizationsId	Long	The unique identifier of the organization.
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.

OrganizationsNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
OrganizationsId	Long	The unique identifier of the organization.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

SalesProductsAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM SalesProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM SalesProductsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM SalesProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM SalesProductsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
SalesProductsId	Long	The unique identifier of the object. This is the key for the list entry.
SalesProductsLookUpName	String	The name used to look up the object.

SalesProductsDescriptions

The language-specific string used for localization.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesProductsDescriptions WHERE languageId = 12
SELECT * FROM SalesProductsDescriptions WHERE languageId > 15
SELECT * FROM SalesProductsDescriptions WHERE labeltext LIKE '%test'
SELECT * FROM SalesProductsDescriptions WHERE languageId IN (12,23,123)
SELECT * FROM SalesProductsDescriptions WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
SalesProductsId	Long	The unique identifier of the sales product.
LabelText	String	The label text.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

SalesProductsNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesProductsNames WHERE languageId = 12
SELECT * FROM SalesProductsNames WHERE languageId > 15
SELECT * FROM SalesProductsNames WHERE labeltext LIKE '%test'
SELECT * FROM SalesProductsNames WHERE languageId IN (12,23,123)
SELECT * FROM SalesProductsNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
SalesProductsId	Long	The unique identifier of the sales product.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

SalesProductsSchedules

The price schedule for a sales product.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesProductsSchedules WHERE scheduleId = 12
SELECT * FROM SalesProductsSchedules WHERE scheduleId > 15
SELECT * FROM SalesProductsSchedules WHERE comment LIKE '%test'
SELECT * FROM SalesProductsSchedules WHERE scheduleId IN (12,23,123)
SELECT * FROM SalesProductsSchedules WHERE comment IS NOT NULL

Columns


Name	Type	Description
SalesProductsId	Long	The unique identifier of the sales product.
Comment	String	The comments or notes associated with the sales product schedule.
ScheduleId	Long	Id of schedule. The ID of the schedule. This is part of the key for the list entry.
SchedulelookUpName	String	LookUpName of schedule. The ID of the schedule. This is part of the key for the list entry.
ScheduleEndDate	Date	The date when the schedule ends.
ScheduleStartDate	Date	The date when the schedule starts. This is part of the key for the list entry.
PricecurrencyId	Long	Id of currency. The ID of the currency.
PricecurrencylookUpName	String	LookUpName of currency. The ID of the currency.
PriceexchangeRateId	Long	Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
PriceexchangeRatelookUpName	String	LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Pricevalue	String	The value of the currency.

SalesTerritoriesAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesTerritoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM SalesTerritoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM SalesTerritoriesAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM SalesTerritoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM SalesTerritoriesAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
SalesTerritoriesId	Long	The unique identifier of the object. This is the key for the list entry.
SalesTerritoriesLookUpName	String	The name used to look up the object.

SalesTerritoriesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM SalesTerritoriesNames WHERE languageId = 12;
SELECT * FROM SalesTerritoriesNames WHERE languageId > 15;
SELECT * FROM SalesTerritoriesNames WHERE labeltext LIKE '%test';
SELECT * FROM SalesTerritoriesNames WHERE languageId IN (12,23,123);
SELECT * FROM SalesTerritoriesNames WHERE labeltext IS NOT NULL;

Columns


Name	Type	Description
SalesTerritoriesId	Long	The unique identifier of the sales territory.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceCategoriesAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceCategoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM ServiceCategoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM ServiceCategoriesAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM ServiceCategoriesAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM ServiceCategoriesAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
ServiceCategoriesId	Long	The unique identifier of the object. This is the key for the list entry.
ServiceCategoriesLookUpName	String	The name used to look up the object.

ServiceCategoriesDescriptions

The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
ServiceCategoriesId	Long	Id of ServiceCategories.
LabelText	String	The label text.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceCategoriesEndUserVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceCategoriesEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId = 12
SELECT * FROM ServiceCategoriesEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId > 15
SELECT * FROM ServiceCategoriesEndUserVisibleInterfaces WHERE EndUserVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM ServiceCategoriesEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId IN (12,23,123)
SELECT * FROM ServiceCategoriesEndUserVisibleInterfaces WHERE EndUserVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
EndUserVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
EndUserVisibleInterfacesLookUpName	String	The name used to look up the object.
ServiceCategoriesId	Long	The unique identifier of the object. This is the key for the list entry.
ServiceCategoriesLookUpName	String	The name used to look up the object.

ServiceCategoriesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceCategoriesNames WHERE languageId = 12
SELECT * FROM ServiceCategoriesNames WHERE languageId > 15
SELECT * FROM ServiceCategoriesNames WHERE labeltext LIKE '%test'
SELECT * FROM ServiceCategoriesNames WHERE languageId IN (12,23,123)
SELECT * FROM ServiceCategoriesNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ServiceCategoriesId	Long	The unique identifier of the service category.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceCategoriesProductLinks

The product linking for a category or a disposition.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductId = 12
SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductId > 15
SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductlookUpName LIKE '%test'
SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductId IN (12,23,123)
SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductlookUpName IS NOT NULL

Columns


Name	Type	Description
ServiceCategoriesId	Long	Id of ServiceCategories.
ServiceProductId	Long	Id of serviceProduct. The ID of the service product. This is the key for the list entry.
ServiceProductlookUpName	String	LookUpName of serviceProduct. The ID of the service product. This is the key for the list entry.

ServiceDispositionsAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceDispositionsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM ServiceDispositionsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM ServiceDispositionsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM ServiceDispositionsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM ServiceDispositionsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
ServiceDispositionsId	Long	The unique identifier of the object. This is the key for the list entry.
ServiceDispositionsLookUpName	String	The name used to look up the object.

serviceDispositionsDescriptions

The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceDispositionsDescriptions WHERE languageId = 12
SELECT * FROM ServiceDispositionsDescriptions WHERE languageId > 15
SELECT * FROM ServiceDispositionsDescriptions WHERE labeltext LIKE '%test'
SELECT * FROM ServiceDispositionsDescriptions WHERE languageId IN (12,23,123)
SELECT * FROM ServiceDispositionsDescriptions WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ServiceDispositionsId	Long	Id of ServiceDispositions.
LabelText	String	The label text.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceDispositionsNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceDispositionsNames WHERE languageId = 12
SELECT * FROM ServiceDispositionsNames WHERE languageId > 15
SELECT * FROM ServiceDispositionsNames WHERE labeltext LIKE '%test'
SELECT * FROM ServiceDispositionsNames WHERE languageId IN (12,23,123)
SELECT * FROM ServiceDispositionsNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ServiceDispositionsId	Long	Id of ServiceDispositions.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceDispositionsProductLinks

The product linking for a category or a disposition.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceDispositionsProductLinks WHERE serviceproductId = 12
SELECT * FROM ServiceDispositionsProductLinks WHERE serviceproductId > 15
SELECT * FROM ServiceDispositionsProductLinks WHERE serviceproductlookUpName LIKE '%test'
SELECT * FROM ServiceDispositionsProductLinks WHERE serviceproductId IN (12,23,123)
SELECT * FROM ServiceDispositionsProductLinks WHERE serviceproductlookUpName IS NOT NULL

Columns


Name	Type	Description
ServiceDispositionsId	Long	Id of ServiceDispositions.
ServiceProductId	Long	Id of serviceProduct. The ID of the service product. This is the key for the list entry.
ServiceProductlookUpName	String	LookUpName of serviceProduct. The ID of the service product. This is the key for the list entry.

ServiceMailboxes

The email box dedicated to collect email inquiries sent by customers.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the service mailbox was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the service mailbox.
InterfaceId	Long	Id of interface. The interface that the mailbox is associated with.
InterfacelookUpName	String	LookUpName of interface. The interface that the mailbox is associated with.
IsDefault	Bool	Indicates whether the mailbox is the default mailbox for the interface. This attribute does not have a default value.
LookupName	String	The name used to look up the service mailbox.
Name	String	The name of the service mailbox in the language of the current interface.
TypeId	Long	Id of type. The module the mailbox is associated with.
TypelookUpName	String	LookUpName of type. The module the mailbox is associated with.
UpdatedTime	Datetime	The date and time when the service mailbox was last updated. This attribute is read-only.
IncomingEmailSettingsforceReplyBetweenLines	Bool	Indicates whether the Force Reply Between the Lines feature is enabled for outgoing emails from the mailbox. This attribute does not have a default value.
IncomingEmailSettingsforwardRejectMessageAddress	String	The address to which rejected messages are sent.
IncomingEmailSettingsisEnabled	Bool	Indicates whether incoming email option is enabled. This attribute does not have a default value.
OutgoingEmailSettingsdisplayName	String	The display name used in the outgoing emails from the mailbox.
OutgoingEmailSettingsfriendlyFromAddress	String	The from address used to brand outgoing emails as friendly.
OutgoingEmailSettingsfromAddress	String	The from address on the outgoing email.
OutgoingEmailSettingsisEnabled	Bool	Indicates whether outgoing email is enabled. This attribute does not have a default value.
OutgoingEmailSettingsreplyToAddress	String	The reply-to-address on the outgoing email.

ServiceProductsAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM ServiceProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM ServiceProductsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM ServiceProductsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM ServiceProductsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	Long	The unique identifier of the object. This is the key for the list entry.
ServiceProductsLookUpName	String	The name used to look up the object.

ServiceProductsCategoryLinks

The category linking for a product.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategoryId = 12
SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategoryId > 15
SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategorylookUpName LIKE '%test'
SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategoryId IN (12,23,123)
SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategorylookUpName IS NOT NULL

Columns


Name	Type	Description
ServiceProductsId	Long	Id of serviceProducts.
ServiceCategoryId	Long	Id of serviceCategory. The ID of the service category. This is the key for the list entry.
ServiceCategorylookUpName	String	LookUpName of serviceCategory. The ID of the service category. This is the key for the list entry.

ServiceProductsDescriptions

The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsDescriptions WHERE languageId = 12
SELECT * FROM ServiceProductsDescriptions WHERE languageId > 15
SELECT * FROM ServiceProductsDescriptions WHERE labeltext LIKE '%test'
SELECT * FROM ServiceProductsDescriptions WHERE languageId IN (12,23,123)
SELECT * FROM ServiceProductsDescriptions WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ServiceProductsId	Long	Id of ServiceProducts.
LabelText	String	The label text.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

ServiceProductsDispositionLinks

The disposition linking for a product.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionId = 12
SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionId > 15
SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionlookUpName LIKE '%test'
SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionId IN (12,23,123)
SELECT * FROM ServiceProductsDispositionLinks WHERE servicedispositionlookUpName IS NOT NULL

Columns


Name	Type	Description
ServiceProductsId	Long	Id of ServiceProducts.
ServiceDispositionId	Long	Id of serviceDisposition. The ID of the service disposition. This is the key for the list entry.
ServiceDispositionlookUpName	String	LookUpName of serviceDisposition. The ID of the service disposition. This is the key for the list entry.

ServiceProductsEndUserVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId =12
SELECT * FROM ServiceProductsEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId >15
SELECT * FROM ServiceProductsEndUserVisibleInterfaces WHERE EndUserVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM ServiceProductsEndUserVisibleInterfaces WHERE EndUserVisibleInterfacesId IN (12,23,123)
SELECT * FROM ServiceProductsEndUserVisibleInterfaces WHERE EndUserVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
EndUserVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
EndUserVisibleInterfacesLookUpName	String	The name used to look up the object.
ServiceProductsId	Long	The unique identifier of the object. This is the key for the list entry.
ServiceProductsLookUpName	String	The name used to look up the object.

ServiceProductsNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM ServiceProductsNames WHERE languageId = 12
SELECT * FROM ServiceProductsNames WHERE languageId > 15
SELECT * FROM ServiceProductsNames WHERE labeltext LIKE '%test'
SELECT * FROM ServiceProductsNames WHERE languageId IN (12,23,123)
SELECT * FROM ServiceProductsNames WHERE labeltext IS NOT NULL

Columns


Name	Type	Description
ServiceProductsId	Long	Name of ServiceProducts.
LabelText	String	The language-specific label text. The value cannot be null or empty.
LanguageId	Long	Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName	String	LookUpName of language. The ID of the language. This is the key for the list entry.

SiteInterfaces

The console, windows, and pages used by staff members and customers to access the application and interact with a single knowledge base.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
CreatedTime	Datetime	The date and time when the site interface was created. This attribute is read-only.
DisplayName	String	The display name of the site interface.
Id [KEY]	Long	The unique identifier of the site interface.
LanguageId	Long	Id of language. The language associated with the interface.
LanguagelookUpName	String	LookUpName of language. The language associated with the interface.
LookupName	String	The name used to look up the site interface.
Name	String	The name of the site interface.
UpdatedTime	Datetime	The date and time when the site interface was last updated. This attribute is read-only.

StandardContentsAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM StandardContentsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12
SELECT * FROM StandardContentsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15
SELECT * FROM StandardContentsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName LIKE '%test'
SELECT * FROM StandardContentsAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12,23,123)
SELECT * FROM StandardContentsAdminVisibleInterfaces WHERE AdminVisibleInterfaceslookUpName IS NOT NULL

Columns


Name	Type	Description
AdminVisibleInterfacesId [KEY]	Long	The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName	String	The name used to look up the object.
StandardContentsId	Long	The unique identifier of the object. This is the key for the list entry.
StandardContentsLookUpName	String	The name used to look up the object.

StandardContentsContentValues

The standard content value with a data type and a formatted data value.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM StandardContentsContentValues WHERE contenttypeId = 12
SELECT * FROM StandardContentsContentValues WHERE contenttypeId > 15
SELECT * FROM StandardContentsContentValues WHERE contenttypelookUpName LIKE '%test'
SELECT * FROM StandardContentsContentValues WHERE contenttypeId IN (12,23,123)
SELECT * FROM StandardContentsContentValues WHERE contenttypelookUpName IS NOT NULL

Columns


Name	Type	Description
StandardContentsId	Long	Id of StandardContents.
ContentTypeId	Long	Id of contentType. The content type of the data.
ContentTypelookUpName	String	LookUpName of contentType. The content type of the data.
Value	String	The formatted data for the associated content type.

TasksFileAttachments

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

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

Columns


Name	Type	Description
TasksId	Long	Id of Tasks.
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.

TasksNotes

The note text associated with the objects such as contacts and organizations.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

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

DELETE

Delete can be executed by specifying the tasksId in the WHERE Clause. For example:

DELETE FROM TasksNotes WHERE tasksId = '1'

Columns


Name	Type	Description
TasksId	Long	Id of Tasks.
ChannelId	Long	Id of channel. The channel through which the note was created.
ChannellookUpName	String	LookUpName of channel. The channel through which the note was created.
CreatedByAccountId	Long	Id of createdByAccount. The staff member account that created the note.
CreatedByAccountlookUpName	String	LookUpName of createdByAccount. The staff member account that created the note.
CreatedTime	Datetime	The date and time when the note was created. This attribute is read-only.
Id [KEY]	Long	The unique identifier of the note.
Text	String	The text content in the note.
UpdatedByAccountId	Long	Id of updatedByAccount. The staff member account that updated the note.
UpdatedByAccountlookUpName	String	LookUpName of updatedByAccount. The staff member account that updated the note.
UpdatedTime	Datetime	The date and time when the note was last updated. This attribute is read-only.

VariablesInterfaceValues

The interface-specific value of a variable.

Table-Specific Information

SELECT

The Sync App 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 Sync App.

SELECT * FROM VariablesInterfaceValues WHERE interfaceId = 12
SELECT * FROM VariablesInterfaceValues WHERE interfaceId > 15
SELECT * FROM VariablesInterfaceValues WHERE interfacelookUpName LIKE '%test'
SELECT * FROM VariablesInterfaceValues WHERE interfaceId IN (12,23,123)
SELECT * FROM VariablesInterfaceValues WHERE interfacelookUpName IS NOT NULL

Columns


Name	Type	Description
VariablesId	Long	Id of Variables.
InterfaceId	Long	Id of interface. The interface of the site.
InterfacelookUpName	String	LookUpName of interface. The interface of the site.
Value	String	The description of the interface.

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

Property	Description
URL	The Url of the account to connect to.
User	The Oracle Service Cloud user account used to authenticate.
Password	The password used to authenticate the user.

SSL

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

Firewall

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

Proxy

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Logging

Property	Description
LogModules	Core modules to be included in the log file.

Schema

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Miscellaneous

Property	Description
AnalyticsReportResultsIds	A comma-separated list of IDs to include in the AnalyticsReportResults views.
IncludeAnalyticsReportResults	Whether or not the AnalyticsReportResults views are included.
IncludeCustomFields	A boolean indicating if you would like to include custom fields in the column listing.
IncludeCustomObjects	Whether or not to include the Custom Objects.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

Property	Description
URL	The Url of the account to connect to.
User	The Oracle Service Cloud user account used to authenticate.
Password	The password used to authenticate the user.

URL

The Url of the account to connect to.

Remarks

The Oracle Service Cloud URL.

User

The Oracle Service Cloud user account used to authenticate.

Remarks

Together with Password, this field is used to authenticate against the Oracle Service Cloud server.

Password

The password used to authenticate the user.

Remarks

The User and Password are together used to authenticate with the server.

SSL

This section provides a complete list of the SSL properties you can configure in the connection string for this provider.

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:


Description	Example
A full PEM Certificate (example shortened for brevity)	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate	C:\cert.cer
The public key (example shortened for brevity)	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated)	ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated)	34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

Firewall

This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

FirewallType

The protocol used by a proxy-based firewall.

Remarks

This property specifies the protocol that the Sync App will use to tunnel traffic through the FirewallServer proxy. Note that by default, the Sync App connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.


Type	Default Port	Description
TUNNEL	80	When this is set, the Sync App opens a connection to Oracle Service Cloud and traffic flows back and forth through the proxy.
SOCKS4	1080	When this is set, the Sync App sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5	1080	When this is set, the Sync App sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

The name or IP address of a proxy-based firewall.

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the Sync App uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

FirewallPort

The TCP port for a proxy-based firewall.

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

FirewallUser

The user name to use to authenticate with a proxy-based firewall.

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.

FirewallPassword

A password used to authenticate to a proxy-based firewall.

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

Proxy

This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

ProxyAutoDetect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

The hostname or IP address of a proxy to route HTTP traffic through.

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The Sync App can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the Sync App uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

ProxyPort

The TCP port the ProxyServer proxy is running on.

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

ProxyAuthScheme

The authentication type to use to authenticate to the ProxyServer proxy.

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the Sync App will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

BASIC: The Sync App performs HTTP BASIC authentication.
DIGEST: The Sync App performs HTTP DIGEST authentication.
NEGOTIATE: The Sync App retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
PROPRIETARY: The Sync App does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

A user name to be used to authenticate to the ProxyServer proxy.

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain
domain\user

ProxyPassword

A password to be used to authenticate to the ProxyServer proxy.

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the Sync App uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

ProxySSLType

The SSL type to use when connecting to the ProxyServer proxy.

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:


AUTO	Default setting. If the URL is an HTTPS URL, the Sync App will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the Sync App uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

Property	Description
LogModules	Core modules to be included in the log file.

LogModules

Core modules to be included in the log file.

Remarks

Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.

See the Logging page for an overview.

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

Remarks

The path to a directory which contains the schema files for the Sync App (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\OracleServiceCloud Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

Property	Description
AnalyticsReportResultsIds	A comma-separated list of IDs to include in the AnalyticsReportResults views.
IncludeAnalyticsReportResults	Whether or not the AnalyticsReportResults views are included.
IncludeCustomFields	A boolean indicating if you would like to include custom fields in the column listing.
IncludeCustomObjects	Whether or not to include the Custom Objects.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

AnalyticsReportResultsIds

A comma-separated list of IDs to include in the AnalyticsReportResults views.

Remarks

A comma-separated list of IDs to include in the AnalyticsReportResults views.

IncludeAnalyticsReportResults

Whether or not the AnalyticsReportResults views are included.

Remarks

Whether or not the AnalyticsReportResults views are included.

IncludeCustomFields

A boolean indicating if you would like to include custom fields in the column listing.

Remarks

Setting this to true will cause custom fields to be included in the column listing, but may cause poor performance when listing metadata.

IncludeCustomObjects

Whether or not to include the Custom Objects.

Remarks

Whether or not to include the Custom Objects.

MaxRows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

These hidden properties are used only in specific use cases.

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Integration and Formatting


DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT	Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the Sync App throws an exception.

UserDefinedViews

A filepath pointing to the JSON configuration file containing your custom views.

Remarks

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The Sync App automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the Sync App.

This User Defined View configuration file is formatted as follows:

Each root element defines the name of a view.
Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM Accounts WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"