SSIS Components for Oracle Service Cloud

Build 24.0.9060

ContactsOpenIDAccounts

The OpenID related information for the contact.

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

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