このページでは、CData Cloud でのOutreach への接続の確立 のガイド、利用可能なリソースに関する情報、および使用可能な接続プロパティのリファレンスについて説明します。

Outreach への接続

接続の確立 は、CData Cloud にデータベースを作成するためのOutreach への認証方法と必要な接続プロパティの設定方法について示します。

CData Cloud サービスからデータにアクセス

利用可能な標準サービスを経由してOutreach からデータにアクセスする方法と、CData Cloud の管理については、CData Cloud ドキュメント で詳しく説明します。

Database タブで対応するアイコンを選択して、Outreach に接続します。必須プロパティはSettings にリストされています。Advanced タブには、通常は必要ない接続プロパティが表示されます。

Outreach への接続

以下のサブセクションでは、3つの一般的な認証フローでのOutreach への認証について詳しく説明します。

• デスクトップ：ユーザーのローカルマシン上でのサーバーへの接続で、テストやプロトタイピングによく使用されます。埋め込みOAuth またはカスタムOAuth で認証されます。
• Web：共有ウェブサイト経由でデータにアクセスします。カスタムOAuth でのみ認証されます。
• ヘッドレスサーバー：他のコンピュータやそのユーザーにサービスを提供する専用コンピュータで、モニタやキーボードなしで動作するように構成されています。埋め込みOAuth またはカスタムOAuth で認証されます。

カスタムOAuth 情報を取得する方法と、埋め込みOAuth 認証情報を持つ認証フローでもカスタム接続を作成したほうがよい場合の説明については、カスタムOAuth アプリケーションの作成 を参照してください。

Outreach で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

アクセストークンの期限が切れたときは、Cloud は自動でアクセストークンをリフレッシュします。

OAuth アクセストークンの自動リフレッシュ：

Cloud がOAuth アクセストークンを自動的にリフレッシュするようにするには、次のように設定します。

1. はじめてデータに接続する際、次の接続プロパティを設定します。
   • InitiateOAuth： REFRESH。
   • OAuthClientId：アプリケーション設定のクライアントId。
   • OAuthClientSecret：アプリケーション設定のクライアントシークレット。
   • OAuthAccessToken：GetOAuthAccessToken によって返されたアクセストークン。
   • OAuthSettingsLocation：Cloud がOAuth 値を保存する場所のパス。これは接続間で維持されます。
2. その後のデータ接続では、以下を設定します。
   • InitiateOAuth
   • OAuthSettingsLocation

OAuth アクセストークンの手動リフレッシュ：

OAuth アクセストークンを手動でリフレッシュするために必要な唯一の値は、OAuth リフレッシュトークンです。

1. ExpiresIn 期間（GetOAuthAccessToken が返す）が経過した後にOAuthAccessToken を手動でリフレッシュするには、RefreshOAuthAccessToken ストアドプロシージャを呼び出します。
2. 次の接続プロパティを設定します。
   • OAuthClientId：アプリケーション設定のクライアントId。
   • OAuthClientSecret：アプリケーション設定のクライアントシークレット。

3. RefreshOAuthAccessToken を呼び出し、OAuthRefreshToken にGetOAuthAccessToken によって返されたOAuth リフレッシュトークンを設定します。
4. 新しいトークンが取得できたら、OAuthAccessToken プロパティにRefreshOAuthAccessToken によって返された値を設定します。これで新規接続が開かれます。

OAuth リフレッシュトークンを保存し、OAuth アクセストークンの有効期限が切れた後に手動でリフレッシュできるようにします。

カスタムOAuth アプリケーションの作成

• AuthScheme をOAuth に設定し、
• OAuthAccessToken を取得して設定し、
• 必要な設定パラメータを設定します。

（OAuthAccessToken およびその他の設定パラメータを取得および設定する方法についての情報は、「Outreach への接続」のデスクトップ認証セクションを参照してください。）

ただし、Web 経由でOutreach に接続する必要がある場合は、カスタムOAuth 接続の作成が必要です。 実際には、カスタムOAuth アプリケーションは、一般的に使用される3つの認証フローをすべてシームレスにサポートするため、これらの認証フロー用にカスタムOAuth アプリケーションを作成（独自のOAuth アプリケーションクレデンシャルを使用）することもできます。 カスタムOAuth アプリケーションは、次のような場合に有用です。

• 認証ダイアログのブランディングをコントロールしたいとき
• ユーザー認証後にアプリケーションがユーザーをリダイレクトするためのリダイレクトURI をコントロールしたいとき
• ユーザーからのリクエストに対する許可をカスタマイズしたいとき

プロシージャ

OAuthClientId およびOAuthClientSecret を含むカスタムOAuth 接続を行うために必要なOAuth クライアントクレデンシャルを取得するには、[email protected] を介してOutreach に直接連絡してください。

この情報を取得したら、「Outreach への接続」で説明するように、Outreach に接続して認証するための接続変数を設定するために使用します。

概要

このセクションでは、利用可能なAPI オブジェクトを示し、Outreach API へのSQL の実行について詳しく説明します。

主要機能

• Cloud は、Outreach エンティティをリレーショナルビューとしてモデル化し、SQL を記述してOutreach データをクエリできるようにします。
• ストアドプロシージャを使用するとOutreach の操作を実行できます。
• これらのオブジェクトへのライブ接続により、Cloud を使用するとOutreach アカウントへのあらゆる変更が即座に反映されます。

ビュー

ビュー では、利用可能なビューを説明します。ビューは、Accounts、Prospects、Calls などのOutreach エンティティを静的にモデル化するように定義されています。

ストアドプロシージャ

ストアドプロシージャ は、Outreach のファンクションライクなインターフェースです。

ストアドプロシージャを使用すると、オブジェクトのダウンロードやエンベロープの移動など、Outreach の操作を実行できます。

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData Cloud - Outreach ビュー

Get Details of accounts.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• BuyerIntentScore supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• CustomId supports the '=,>=,<=,>,<' operators.
• Domain supports the '=,IN' operators.
• Name supports the '=,IN' operators.
• Nammed supports the '=,IN' operators.
• SharingTeamId supports the '=,IN' operators.
• TouchedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Accounts WHERE Id = 1

SELECT * FROM Accounts WHERE Id IN (1, 2)

SELECT * FROM Accounts WHERE Id >= 1

SELECT * FROM Accounts WHERE Id <= 1

SELECT * FROM Accounts WHERE Id > 1

SELECT * FROM Accounts WHERE Id < 2

SELECT * FROM Accounts WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM accounts WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Accounts WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Accounts WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Accounts WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Accounts WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Accounts WHERE CustomId = 1

SELECT * FROM Accounts WHERE BuyerIntentScore = 1

SELECT * FROM Accounts WHERE SharingTeamId = 1

Columns

A ready-made collection of call dispositions that help categorize your call logs.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• OrderValue supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.

SELECT * FROM CallDispositions WHERE Id = 1

SELECT * FROM CallDispositions WHERE Id IN (1, 2)

SELECT * FROM CallDispositions WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM CallDispositions WHERE Name = 'Answered - Meeting Set'

SELECT * FROM CallDispositions WHERE Name IN ('test', 'ram')

SELECT * FROM CallDispositions WHERE OrderValue = 1

Columns

Get details of ready-made collection of call dispositions that help categorize your call logs.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• OrderValue supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=' operator.

SELECT * FROM CallPurposes WHERE Id = 1

SELECT * FROM CallPurposes WHERE Id IN (1, 2)

SELECT * FROM CallPurposes WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM CallPurposes WHERE Name = 'Answered - Meeting Set'

SELECT * FROM CallPurposes WHERE Name IN ('test', 'ram')

SELECT * FROM CallPurposes WHERE OrderValue = 1

Columns

Get details of an inbound or outbound call made with a prospect.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• From supports the '=,IN' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Outcome supports the '=,IN' operators.
• State supports the '=,IN' operators.
• To supports the '=,IN' operators.
• UserCallType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Calls WHERE Id = 1

SELECT * FROM Calls WHERE Id IN (1, 2)

SELECT * FROM Calls WHERE Id >= 1

SELECT * FROM Calls WHERE Id <= 1

SELECT * FROM Calls WHERE Id > 1

SELECT * FROM Calls WHERE Id < 2

SELECT * FROM Calls WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Calls WHERE UserCallType = 'bridge'

SELECT * FROM Calls WHERE UserCallType IN('bridge', 'test')

Columns

Get details of compliance requests.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN' operators.
• State supports the '=,IN' operators.
• UuId supports the '=,IN' operators.

SELECT * FROM ComplianceRequests WHERE Id = 1

SELECT * FROM ComplianceRequests WHERE Id IN (1, 2)

SELECT * FROM ComplianceRequests WHERE State = 'test'

SELECT * FROM ComplianceRequests WHERE uuid = '12345'

SELECT * FROM ComplianceRequests WHERE uuid IN (1, 2)

Columns

Get details of content categories.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM ContentCategories WHERE Id = 1

SELECT * FROM ContentCategories WHERE Id IN (1, 2)

SELECT * FROM ContentCategories WHERE Id >= 1

SELECT * FROM ContentCategories WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt > '2022-02-25 01:02:02.0'

Columns

Get details of a record that maps content to a content category.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM ContentCategoryMemberships WHERE Id = 1

SELECT * FROM ContentCategoryMemberships WHERE Id IN (1, 2)

SELECT * FROM ContentCategoryMemberships WHERE Id >= 1

SELECT * FROM ContentCategoryMemberships WHERE Id < 2

SELECT * FROM ContentCategoryMemberships WHERE Id <= 2

SELECT * FROM ContentCategoryMemberships WHERE Id >= 1 AND Id <= 10

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt > '2022-02-25 01:02:02.0'

Columns

A record that maps content to a content category.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM ContentCategoryOwnerships WHERE Id = 1

SELECT * FROM ContentCategoryOwnerships WHERE Id IN (1, 2)

SELECT * FROM ContentCategoryOwnerships WHERE Id >= 1

SELECT * FROM ContentCategoryOwnerships WHERE Id < 2

SELECT * FROM ContentCategoryOwnerships WHERE Id <= 2

SELECT * FROM ContentCategoryOwnerships WHERE Id >= 1 AND Id <= 10

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt > '2022-02-25 01:02:02.0'

Columns

An Outreach-suggested role or job duty played by a user in their organization.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.

SELECT * FROM Duties WHERE Id = 1

SELECT * FROM Duties WHERE Id IN (1, 2)

SELECT * FROM Duties WHERE Id >= 1

SELECT * FROM Duties WHERE Id <= 4

SELECT * FROM Duties WHERE Id > 1

SELECT * FROM Duties WHERE Id < 4

Columns

Get details of prospect email addresses.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• EmailType supports the '=,IN' operators.
• Status supports the '=,IN' operators.
• OrderValue supports the '=,>=,<=,>,<' operators.
• StatusChangedAt supports the '=,>=,<=,>,<' operators.
• UnsubscribedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM EmailAddress WHERE Id = 1

SELECT * FROM EmailAddress WHERE Id IN (1, 2)

SELECT * FROM EmailAddress WHERE Id >= 1

SELECT * FROM EmailAddress WHERE Id <= 1

SELECT * FROM EmailAddress WHERE Id > 1

SELECT * FROM EmailAddress WHERE Id < 2

SELECT * FROM EmailAddress WHERE StatusChangedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE StatusChangedAt >= '2022-01-25 01:02:02.0 ' AND StatusChangedAt <= '2022-02-27 01:02:02.0'

SELECT * FROM EmailAddress WHERE StatusChangedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE StatusChangedAt = '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE StatusChangedAt < '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE StatusChangedAt > '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE UnsubscribedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM EmailAddress WHERE Email = '[email protected]'

Columns

Get details of application events, capturing details around the initiator, recipient.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• EventAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Events WHERE Id = 1

SELECT * FROM Events WHERE Id IN (1, 2)

SELECT * FROM Events WHERE Id >= 1

SELECT * FROM Events WHERE Id <= 1

SELECT * FROM Events WHERE Id > 1

SELECT * FROM Events WHERE Id < 2

SELECT * FROM Events WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE EventAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE Name IN ('task_updated', 'task_owner_changed')

Columns

Get details of a record favorited by a particular user.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• TargetType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Favorites WHERE Id = 1

SELECT * FROM Favorites WHERE Id IN (1, 2)

SELECT * FROM Favorites WHERE Id >= 1

SELECT * FROM Favorites WHERE Id <= 1

SELECT * FROM Favorites WHERE Id > 1

SELECT * FROM Favorites WHERE Id < 2

SELECT * FROM Favorites WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Favorites WHERE TargetType = 'Prospect'

Columns

Alternative email name for a mailbox.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM MailAliases WHERE Id = 1

SELECT * FROM MailAliases WHERE Id IN (1, 2)

SELECT * FROM MailAliases WHERE Id >= 1

SELECT * FROM MailAliases WHERE Id <= 1

SELECT * FROM MailAliases WHERE Id > 1

SELECT * FROM MailAliases WHERE Id < 2

SELECT * FROM MailAliases WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

Columns

Get details of email mailboxes.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• UserId supports the '=,IN,>=,<=,>,<' operator.

SELECT * FROM Mailbox WHERE Id = 1

SELECT * FROM Mailbox WHERE Id IN (1, 2)

SELECT * FROM Mailbox WHERE Id >= 1

SELECT * FROM Mailbox WHERE Id <= 1

SELECT * FROM Mailbox WHERE Id > 1

SELECT * FROM Mailbox WHERE Id < 2

SELECT * FROM Mailbox WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Mailbox WHERE UserId = 1

Columns

Get details of mailings.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• BouncedAt supports the '=,>=,<=,>,<' operators.
• ClickedAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DeliveredAt supports the '=,>=,<=,>,<' operators.
• MailingType supports the '=,IN' operators.
• MessageId supports the '=,IN' operators.
• NotifyThreadScheduledAt supports the '=,>=,<=,>,<' operators.
• NotifyThreadStatus supports the '=' operator.
• OpenedAt supports the '=,>=,<=,>,<' operators.
• RetryAt supports the '=,>=,<=,>,<' operators.
• RepliedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• ScheduledAt supports the '=,>=,<=,>,<' operators.
• State supports the '=,IN' operator.
• StateChangedAt supports the '=,>=,<=,>,<' operators.
• UnsubscribedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Mailings WHERE Id = 1

SELECT * FROM Mailings WHERE Id IN (1, 2)

SELECT * FROM Mailings WHERE Id >= 1

SELECT * FROM Mailings WHERE Id <= 1

SELECT * FROM Mailings WHERE Id > 1

SELECT * FROM Mailings WHERE Id < 2

SELECT * FROM Mailings WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Mailings WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

Columns

Get details of opportunity for a sale or pending deal.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• ExternalCreatedAt supports the '=,>=,<=,>,<' operators.
• MapLink supports the '=,IN' operators.
• MapStatus supports the '=,IN' operators.
• Name supports the '=,IN' operators.
• Probability supports the '=,IN,>=,<=,>,<' operators.
• SharingTeamId supports the '=,IN' operators.
• TouchedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Opportunities WHERE Id = 1

SELECT * FROM Opportunities WHERE Id IN (1, 2)

SELECT * FROM Opportunities WHERE Id >= 1

SELECT * FROM Opportunities WHERE Id <= 1

SELECT * FROM Opportunities WHERE Id > 1

SELECT * FROM Opportunities WHERE Id < 2

SELECT * FROM Opportunities WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

Columns

Get details of prospect roles and associated with an opportunity.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Role supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM OpportunityProspectRoles WHERE Id = 1

SELECT * FROM OpportunityProspectRoles WHERE Id IN (1, 2)

SELECT * FROM OpportunityProspectRoles WHERE Id >= 1

SELECT * FROM OpportunityProspectRoles WHERE Id <= 1

SELECT * FROM OpportunityProspectRoles WHERE Id > 1

SELECT * FROM OpportunityProspectRoles WHERE Id < 2

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

Columns

The stage an opportunity is in.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• OrderValue supports the '=' operator.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM OpportunityStages WHERE Id = 1

SELECT * FROM OpportunityStages WHERE Id IN (1, 2)

SELECT * FROM OpportunityStages WHERE Id >= 1

SELECT * FROM OpportunityStages WHERE Id <= 1

SELECT * FROM OpportunityStages WHERE Id > 1

SELECT * FROM OpportunityStages WHERE Id < 2

SELECT * FROM OpportunityStages WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityStages WHERE Name = 'Prospecting'

SELECT * FROM OpportunityStages WHERE OrderValue = 0

Columns

A descriptor of a person used for categorizing prospects.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Personas WHERE Id = 1

SELECT * FROM Personas WHERE Id IN (1, 2)

SELECT * FROM Personas WHERE Id >= 1

SELECT * FROM Personas WHERE Id <= 1

SELECT * FROM Personas WHERE Id > 1

SELECT * FROM Personas WHERE Id < 2

SELECT * FROM Personas WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Personas WHERE Name = 'Prospecting'

SELECT * FROM Personas WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

Columns

Get details of prospect phone numbers.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• Number supports the '=,IN' operators.
• Order supports the '=,>=,<=,>,<' operator.
• PhoneType supports the '=' operator.
• Status supports the '=' operator.
• StatusChangedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM PhoneNumbers WHERE Id = 1

SELECT * FROM PhoneNumbers WHERE Id IN (1, 2)

SELECT * FROM PhoneNumbers WHERE Id >= 1

SELECT * FROM PhoneNumbers WHERE Id <= 1

SELECT * FROM PhoneNumbers WHERE Id > 1

SELECT * FROM PhoneNumbers WHERE Id < 2

SELECT * FROM PhoneNumbers WHERE StatusChangedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt >= '2022-01-25 01:02:02.0 ' AND StatusChangedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt = '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt < '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt > '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE Number = '+919876543210'

SELECT * FROM PhoneNumbers WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE PhoneType = 'work'

Columns

Controls what you can see and do within Outreach.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• SpecialId supports the '=,IN' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Profiles WHERE Id = 1

SELECT * FROM Profiles WHERE Id IN (1, 2)

SELECT * FROM Profiles WHERE Id >= 1

SELECT * FROM Profiles WHERE Id <= 1

SELECT * FROM Profiles WHERE Id > 1

SELECT * FROM Profiles WHERE Id < 2

SELECT * FROM Profiles WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Profiles WHERE Name = 'Admin'

SELECT * FROM Profiles WHERE Name IN ('Admin', 'Default')

SELECT * FROM Profiles WHERE SpecialId IN ('Admin', 'Default')

Columns

Get Details of Prospects.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Emails supports the '=,IN' operators.
• EngagedAt supports the '=,>=,<=,>,<' operators.
• EngagedScore supports the '=,>=,<=,>,<' operators.
• ExternalSource supports the '=,IN' operators.
• FirstName supports the '=,IN' operators.
• GithubUsername supports the '=,IN' operators.
• LastName supports the '=,IN' operators.
• LinkedInId supports the '=,IN' operators.
• LinkedInSlug supports the '=,IN' operators.
• SharingTeamId supports the '=,IN' operators.
• StackOverflowId supports the '=,IN' operators.
• TimeZone supports the '=,IN' operators.
• Title supports the '=,IN' operators.
• TouchedAt supports the '=,>=,<=,>,<' operators.
• TwitterUsername supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Prospects WHERE Id = 1

SELECT * FROM Prospects WHERE Id IN (1, 2)

SELECT * FROM Prospects WHERE Id >= 1

SELECT * FROM Prospects WHERE Id <= 1

SELECT * FROM Prospects WHERE Id > 1

SELECT * FROM Prospects WHERE Id < 2

SELECT * FROM Prospects WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE EngagedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE Emails = '[email protected]'

SELECT * FROM Prospects WHERE FirstName = 'test'

SELECT * FROM Prospects WHERE LastName = 'test'

Columns

Record for a recipient for some communication, such as email.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.

SELECT * FROM Recipients WHERE Id = 1

SELECT * FROM Recipients WHERE Id IN (1, 2)

SELECT * FROM Recipients WHERE Id >= 1

SELECT * FROM Recipients WHERE Id <= 1

SELECT * FROM Recipients WHERE Id > 1

SELECT * FROM Recipients WHERE Id < 2

Columns

Get details of where you fall within your organizations structure.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Roles WHERE Id = 1

SELECT * FROM Roles WHERE Id IN (1, 2)

SELECT * FROM Roles WHERE Id >= 1

SELECT * FROM Roles WHERE Id <= 1

SELECT * FROM Roles WHERE Id > 1

SELECT * FROM Roles WHERE Id < 2

SELECT * FROM Roles WHERE Name = 'test'

Columns

A reusable set of behaviors to be applied to sequences.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• AutoResumeOotoProspects supports the '=' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• IncludeUnsubscribeLinks supports the '=' operator.
• Name supports the '=,IN' operators.
• PermitDuplicateProspects supports the '=,IN' operators.
• SequenceExclusivity supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Rulesets WHERE Id = 1

SELECT * FROM Rulesets WHERE Id IN (1, 2)

SELECT * FROM Rulesets WHERE Id >= 1

SELECT * FROM Rulesets WHERE Id <= 1

SELECT * FROM Rulesets WHERE Id > 1

SELECT * FROM Rulesets WHERE Id < 2

SELECT * FROM Rulesets WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Rulesets WHERE AutoResumeOotoProspects = 'false'

SELECT * FROM Rulesets WHERE PermitDuplicateProspects = 'disallow'

SELECT * FROM Rulesets WHERE SequenceExclusivity = 'none'

Columns

Get details of sequences.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• ClickCount supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DeliverCount supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• EnabledAt supports the '=,>=,<=,>,<' operators.
• LastUsedAt supports the '=,>=,<=,>,<' operators.
• LockedAt supports the '=,>=,<=,>,<' operators.
• OpenCount supports the '=,>=,<=,>,<' operators.
• ReplyCount supports the '=,>=,<=,>,<' operators.
• ThrottleCapacity supports the '=,>=,<=,>,<' operators.
• ThrottleMaxAddsPerDay supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• ShareType supports the '=' operator.

SELECT * FROM Sequences WHERE Id = 1

SELECT * FROM Sequences WHERE Id IN (1, 2)

SELECT * FROM Sequences WHERE Id >= 1

SELECT * FROM Sequences WHERE Id <= 1

SELECT * FROM Sequences WHERE Id > 1

SELECT * FROM Sequences WHERE Id < 2

SELECT * FROM Sequences WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Sequences WHERE DeliverCount = 0

SELECT * FROM Sequences WHERE Name = 'test'

SELECT * FROM Sequences WHERE ThrottleMaxAddsPerDay = 1

SELECT * FROM Sequences WHERE ShareType = 'private'

Columns

Get details of sequence states.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• ClickCount supports the '=,IN,>=,<=,>,<' operators.
• CallCompletedAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DeliverCount supports the '=,IN,>=,<=,>,<' operators.
• OpenCount supports the '=,IN,>=,<=,>,<' operators.
• PauseReason supports the '=,IN' operators.
• RepliedAt supports the '=,>=,<=,>,<' operators.
• ReplyCount supports the '=,IN,>=,<=,>,<' operators.
• State supports the '=' operator.
• StateChangedAt supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM SequenceStates WHERE Id = 1

SELECT * FROM SequenceStates WHERE Id IN (1, 2)

SELECT * FROM SequenceStates WHERE Id >= 1

SELECT * FROM SequenceStates WHERE Id <= 1

SELECT * FROM SequenceStates WHERE Id > 1

SELECT * FROM SequenceStates WHERE Id < 2

SELECT * FROM SequenceStates WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceStates WHERE DeliverCount = 0

SELECT * FROM SequenceStates WHERE Name = 'test'

Columns

Get details of sequence steps.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• OrderValue supports the '=,IN,>=,<=,>,<' operators.
• StepType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM SequenceSteps WHERE Id = 1

SELECT * FROM SequenceSteps WHERE Id IN (1, 2)

SELECT * FROM SequenceSteps WHERE Id >= 1

SELECT * FROM SequenceSteps WHERE Id <= 1

SELECT * FROM SequenceSteps WHERE Id > 1

SELECT * FROM SequenceSteps WHERE Id < 2

SELECT * FROM SequenceSteps WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM SequenceSteps WHERE StepType = 'task'

SELECT * FROM Stages WHERE OrderValue > 3 AND OrderValue < 7

Columns

An object used to track which templates are in use by which sequence steps.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.

SELECT * FROM SequenceTemplates WHERE Id = 1

SELECT * FROM SequenceTemplates WHERE Id IN (1, 2)

SELECT * FROM SequenceTemplates WHERE Id >= 1

SELECT * FROM SequenceTemplates WHERE Id <= 1

SELECT * FROM SequenceTemplates WHERE Id > 1

SELECT * FROM SequenceTemplates WHERE Id < 2

Columns

Piece of an email to be reused in multiple messages.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• ShareType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Snippets WHERE Id = 1

SELECT * FROM Snippets WHERE Id IN (1, 2)

SELECT * FROM Snippets WHERE Id >= 1

SELECT * FROM Snippets WHERE Id <= 1

SELECT * FROM Snippets WHERE Id > 1

SELECT * FROM Snippets WHERE Id < 2

SELECT * FROM Snippets WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt >= '2022-01-25 01:02:02.0' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE ShareType = 'private'

SELECT * FROM Snippets WHERE Name = 'test'

SELECT * FROM Snippets WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE UpdatedAt < '2022-02-25 01:02:02.0'

Columns

The point in the process used for categorizing prospects.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• Order supports the '=,IN,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Stages WHERE Id = 1

SELECT * FROM Stages WHERE Id IN (1, 2)

SELECT * FROM Stages WHERE Id >= 1

SELECT * FROM Stages WHERE Id <= 1

SELECT * FROM Stages WHERE Id > 1

SELECT * FROM Stages WHERE Id < 2

SELECT * FROM Stages WHERE Name IN ('Interested', 'Replied')

SELECT * FROM Stages WHERE OrderValue > 3 AND OrderValue < 7

SELECT * FROM Stages WHERE OrderValue IN (3, 5, 7)

Columns

Descriptor of importance used for categorizing tasks.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• Weight supports the '=,>=,<=,>,<' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM TaskPriorities WHERE Id = 1

SELECT * FROM TaskPriorities WHERE Id IN (1, 2)

SELECT * FROM TaskPriorities WHERE Id >= 1

SELECT * FROM TaskPriorities WHERE Id <= 1

SELECT * FROM TaskPriorities WHERE Id > 1

SELECT * FROM TaskPriorities WHERE Id < 2

SELECT * FROM TaskPriorities WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE Name = 'test'

SELECT * FROM TaskPriorities WHERE Weight > 10

SELECT * FROM TaskPriorities WHERE Weight = 10

SELECT * FROM TaskPriorities WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM TaskPriorities WHERE UpdatedAt < '2022-02-25 01:02:02.0'

Columns

An item that requires action to complete.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• AutoskipAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DueAt supports the '=,>=,<=,>,<' operators.
• ScheduledAt supports the '=,>=,<=,>,<' operators.
• State supports the '=,IN' operators.
• StateChangedAt supports the '=,>=,<=,>,<' operators.
• TaskType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Tasks WHERE Id = 1

SELECT * FROM Tasks WHERE Id IN (1, 2)

SELECT * FROM Tasks WHERE Id >= 1

SELECT * FROM Tasks WHERE Id <= 1

SELECT * FROM Tasks WHERE Id > 1

SELECT * FROM Tasks WHERE Id < 2

SELECT * FROM Tasks WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE AutoskipAt = '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE DueAt = '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE ScheduledAt = '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE StateChangedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Tasks WHERE TaskType = 'follow_up'

SELECT * FROM Tasks WHERE State = 'incomplete'

Columns

Get details of a group of users.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Teams WHERE Id = 1

SELECT * FROM Teams WHERE Id IN (1, 2)

SELECT * FROM Teams WHERE Id >= 1

SELECT * FROM Teams WHERE Id <= 1

SELECT * FROM Teams WHERE Id > 1

SELECT * FROM Teams WHERE Id < 2

SELECT * FROM Teams WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Teams WHERE Name = 'test'

Columns

Get details of reusable templates for building emails.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• ArchivedAt supports the '=,>=,<=,>,<' operators.
• ClickCount supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DeliverCount supports the '=,IN,>=,<=,>,<' operators.
• LastUsedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• OpenCount supports the '=,IN,>=,<=,>,<' operators.
• ReplyCount supports the '=,IN,>=,<=,>,<' operators.
• ShareType supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.

SELECT * FROM Templates WHERE Id = 1

SELECT * FROM Templates WHERE Id IN (1, 2)

SELECT * FROM Templates WHERE Id >= 1

SELECT * FROM Templates WHERE Id <= 1

SELECT * FROM Templates WHERE Id > 1

SELECT * FROM Templates WHERE Id < 2

SELECT * FROM Templates WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Templates WHERE Name = 'test'

SELECT * FROM Templates WHERE ShareType = 'read_only'

Columns

Get deatils of The individual that uses the application.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CurrentSignInAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• FirstName supports the '=,IN' operators.
• LastName supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• UserName supports the '=,IN' operators.

SELECT * FROM Users WHERE Id = 1

SELECT * FROM Users WHERE Id IN (1, 2)

SELECT * FROM Users WHERE Id >= 1

SELECT * FROM Users WHERE Id <= 1

SELECT * FROM Users WHERE Id > 1

SELECT * FROM Users WHERE Id < 2

SELECT * FROM Users WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE CurrentSignInAt = '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Users WHERE Email = '[email protected]'

SELECT * FROM Users WHERE FirstName = 'test'

SELECT * FROM Users WHERE LastName = 'test'

Columns

Get details of the individual that uses the application.

Select

The Cloud will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• UsersId supports the '=,IN,>=,<=,>,<' operators.
• CurrentSignInAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• FirstName supports the '=,IN' operators.
• LastName supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• UserName supports the '=,IN' operators.
• Locked supports the '=' operators.

SELECT * FROM UsersDuties WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CurrentSignInAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE Email = '[email protected]'

SELECT * FROM UsersDuties WHERE FirstName = 'test'

SELECT * FROM UsersDuties WHERE LasttName = 'test'

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

ストアドプロシージャはファンクションライクなインターフェースで、Outreach の単純なSELECT 処理にとどまらずCloud の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOutreach から関連するレスポンスデータを返します。

CData Cloud - Outreach ストアドプロシージャ

Creates or Finds profile with provided Specialid

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE CustomDuties Name = test

Input

Result Set Columns

Finishes an active sequence state.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE Finish Id = 6

Input

Result Set Columns

Marks the task as complete.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE MarkComplete Id = 6

Input

Result Set Columns

Pauses an active sequence state

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE Pause Id = 6

Input

Result Set Columns

Resumes a paused sequence state

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE Resume Id = 6

Input

Result Set Columns

Advances the sequence state associated with the task to the next step in the sequence

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskAdvance Id = 1

Input

Result Set Columns

Schedules the mailing associated with the task for delivery, if possible.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskDeliver Id = 1

Input

Result Set Columns

Reassigns the owner of a task

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskReassignOwner Id = 1, OwnerId = 1

Input

Result Set Columns

Reschedules a task by setting a new task due time

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskReschedule Id = 1, DueAt = 2022-01-25

Input

Result Set Columns

Snooze the task.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskSnooze Id = 1

Input

Result Set Columns

Creates or finds profile with provided Specialid.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TaskUpdateNotes Id = 1, Note = test

Input

Result Set Columns

Test if sending emails works from this mailbox.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TestSend Id = 1

Input

Result Set Columns

Test if syncing emails works from this mailbox.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE TestSync Id = 1

Input

Result Set Columns

Updates opportunity association of a task.

Stored Procedure Specific Information

Outreach allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. For example:

EXECUTE UpdateOpportunityAssociation Id = 1, OpportunityAssociation = test

Input

Result Set Columns

このセクションで説明されているシステムテーブルをクエリして、スキーマ情報、データソース機能に関する情報、およびバッチ操作の統計にアクセスできます。

スキーマテーブル

以下のテーブルは、Outreach のデータベースメタデータを返します。

• sys_catalogs：利用可能なデータベースをリスト。
• sys_schemas：利用可能なスキーマをリスト。
• sys_tables：利用可能なテーブルおよびビューをリスト。
• sys_tablecolumns：利用可能なテーブルおよびビューのカラムについて説明。
• sys_procedures：利用可能なストアドプロシージャについて説明。
• sys_procedureparameters：ストアドプロシージャパラメータについて説明。
• sys_keycolumns：主キーおよび外部キーについて説明。
• sys_indexes：利用可能なインデックスについて説明。

データソーステーブル

以下のテーブルは、データソースへの接続方法およびクエリ方法についての情報を返します。

• sys_connection_props：利用可能な接続プロパティについての情報を返す。
• sys_sqlinfo：Cloud がデータソースにオフロードできるSELECT クエリについて説明。

クエリ情報テーブル

次のテーブルは、データ変更クエリのクエリ統計を返します。

• sys_identity：バッチ処理または単一の更新に関する情報を返す。

利用可能なデータベースをリストします。

次のクエリは、接続文字列で決定されるすべてのデータベースを取得します。

SELECT * FROM sys_catalogs

Columns

利用可能なスキーマをリストします。

次のクエリは、すべての利用可能なスキーマを取得します。

          SELECT * FROM sys_schemas
          

Columns

利用可能なテーブルをリストします。

次のクエリは、利用可能なテーブルおよびビューを取得します。

          SELECT * FROM sys_tables
          

Columns

利用可能なテーブルおよびビューのカラムについて説明します。

次のクエリは、SampleTable_1 テーブルのカラムとデータ型を返します。

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='SampleTable_1' 

Columns

利用可能なストアドプロシージャをリストします。

次のクエリは、利用可能なストアドプロシージャを取得します。

          SELECT * FROM sys_procedures
          

Columns