How would you create a new field on the Event object, create a connected app, and update a city field on the Account object? Also explain inbound vs outbound calls, when to use @HttpPost, what Omni-Channel is, and what External Routing is.
Translate the data modification portion into PostgreSQL and briefly connect the SQL model to the Salesforce concepts.
account_id, account_name, city.account_id ascending.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique Event identifier |
| account_id | INT | Account associated with the Event |
| event_type | VARCHAR(30) | Event operation type |
| event_city | VARCHAR(80) | City supplied by the Event |
| event_at | TIMESTAMPTZ | Event creation timestamp |
| integration_reference | VARCHAR(100) | External integration reference added by the solution |
| Column | Type | Description |
|---|---|---|
| connected_app_idPK | INT | Connected app identifier |
| app_name | VARCHAR(100) | Registered application name |
| callback_url | VARCHAR(255) | OAuth callback URL |
| status | VARCHAR(20) | Application registration status |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique Account identifier |
| account_name | VARCHAR(100) | Account name |
| city | VARCHAR(80) | Current Account city |