Account

The Account schema defines the structure and API endpoints for managing account records in SiteMesh. It includes fields for account identification, contact details, address, geolocation, currency, and timestamps.

Schema Columns

Column ID	Type	Key	Filter	Description
AccountID	TEXT	Yes	EQUALS	Unique identifier
AccountName	TEXT	No	LIKE	Name of the account
AccountWebsite	TEXT	No	LIKE	Website URL
AccountPhone	TEXT	No	LIKE	Phone number
AccountEmail	TEXT	No	LIKE	Email address
AccountStreet1	TEXT	No	LIKE	Address line 1
AccountStreet2	TEXT	No	LIKE	Address line 2
AccountCity	TEXT	No	LIKE	City
AccountState	TEXT	No	LIKE	State/Province
AccountCountry	TEXT	No	LIKE	Country
AccountPostCode	TEXT	No	LIKE	Postal/ZIP code
AccountLatitude	DOUBLE	No	-	Latitude (geo)
AccountLongitude	DOUBLE	No	-	Longitude (geo)
AccountCurrency	TEXT	No	EQUALS	Currency code (e.g., USD)
AccountActivity	TIMESTAMP	No	-	Last activity timestamp
AccountCreated	TIMESTAMP	No	-	Creation timestamp
AccountUpdated	TIMESTAMP	No	-	Last update timestamp
AccountDeleted	TIMESTAMP	No	EQUALS	Deletion timestamp

Sorting

• Default sort: AccountName (ascending)

API Endpoints

All endpoints require a valid authentication token. Some actions are restricted to users with the [admin] role.

• account/count (POST): Count accounts matching filter parameters.
  Permissions: [admin] (all accounts), non-admin (only their accounts).
  Body: JSON with filter parameters.
  Returns: Count as a string.
• account/list (POST): List accounts matching filter parameters.
  Permissions: [admin] only.
  Body: JSON with filter parameters.
  Returns: JSON array of account objects.
• account/get (POST): Get a single account by AccountID.
  Permissions: [admin] (any account), non-admin (their own account).
  Body: { "AccountID": "<id>" }
  Returns: JSON object or "null" if not found.
• account/save (POST): Create or update an account.
  Permissions: [admin] (all fields), non-admin (their own account, cannot edit AccountCurrency or AccountDeleted).
  Body: JSON with account fields.
  Returns: JSON object for the saved account.

Notes

• All endpoints return "Unauthorized" (401) if the token is missing or expired.
• Non-admin users have restricted access and cannot modify certain fields.
• Filtering supports EQUALS and LIKE as specified in the schema columns.

Example Requests

POST /account/count
Headers: { Authorization: Bearer <token> }
Body: { "AccountName": "Acme Corp" }
            

POST /account/get
Headers: { Authorization: Bearer <token> }
Body: { "AccountID": "12345" }