SSIS Components for Oracle Service Cloud

Build 24.0.9060

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

SELECT * FROM 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060