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