OAuthConsumerKeys

Create, update, delete, and query information on OAuth keys distributed by the application.

テーブル固有の情報

WHERE 句で任意の条件を使用して、OAuth Consumer Keys テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM [OAuth Consumer Keys] WHERE [Consumer Key Name] LIKE '%facebook%' AND [Date Created] > '2017-10-09'

書き込み可能なカラムを指定して、OAuth Consumer Key を作成します。

INSERT INTO [OAuth Consumer Keys] ([Consumer Key Name], [Consumer Key], [Consumer Secret]) VALUES ('New', 'dfvnspidn', '223bbcsubd')

Id を指定して、書き込み可能なOAuth Consumer Key エントリカラムを更新できます。

UPDATE [OAuth Consumer Keys] SET [Consumer Key Name] = 'Updated' WHERE Id = 'Test123'

Id を指定して、OAuth Consumer Key を削除します。

DELETE FROM [OAuth Consumer Keys] WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the OAuth key.
User	String	True	The user name of the user the key has been assigned to.
AssignedUserId	String	False	The Id of the user the key has been assigned to.
ConsumerKeyName	String	False	Name assigned to the key
ConsumerKey	String	False	Key value used in the OAuth 1.0 authentication with SuiteCRM
ConsumerSecret	String	False	Secret used in the OAuth 1.0 authentication with SuiteCRM
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	The record deletion indicator.
Description	String	False	Description for the OAuth key
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.

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


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.