EAPM
Create, update, delete, and query the EAPM (External API Module) entries in SuiteCRM
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、EAPM テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM EAPM WHERE Application LIKE 'Suite%'
Insert
書き込み可能なカラムを指定して、EAPM エントリを作成します。
INSERT INTO EAPM ([App User Name], Application) VALUES ('Saved app', 'Test Application')
Update
Id を指定して、書き込み可能なEAPM カラムを更新できます。
UPDATE EAPM SET Connected = True WHERE Id = 'Test123'
Delete
Id を指定して、EAPM エントリを削除します。
DELETE FROM EAPM WHERE Id = '10003'
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | String | False |
Unique identifier for the external API. |
APIData | String | False |
Any API data that the external API may wish to store on a per-user basis. |
AppPassword | String | False |
The password of the external API. |
AppUserName | String | False |
The name of the external API. |
Application | String | False |
The application name of the external API. |
AssignedUserId | String | False |
The Id of the user assigned to the record. |
Connected | Bool | False |
Whether the external API has been validated. |
ConsumerKey | String | False |
The consumer key for the external API. |
ConsumerSecret | String | False |
The consumer secret for the external API. |
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 |
The full text of the note. |
ModifiedById | String | True |
The Id of the user who last modified the record. |
ModifiedByName | String | True |
The user name of the user who last modified the record. |
OAuthToken | String | False |
The OAuth access token for the external API. |
PleaseNote | String | True |
The note for the external API. |
SuiteCRMUser | String | True |
The name of the user assigned to the record. |
URL | String | False |
The URL of the external API. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |