Data Grid
Embed a full CRUD data table on any admin page. Reads from and writes to any MAPI entity. Multiple grids on the same page are fully isolated.
Try it with your AI assistant
Once WebsitePublisher is connected to your AI assistant, paste one of these into the chat. Replace the parts in [brackets] with your own details.
@WebsitePublisher add an editable table of my [customers] to my admin page so I can add, edit and delete rowsWith WebsitePublisher, add an editable table of my [customers] to my admin page so I can add, edit and delete rowsWith WebsitePublisher, add an editable table of my [customers] to my admin page so I can add, edit and delete rowsEndpoints (11)
Create or update a data grid configuration for a MAPI entity. Columns auto-discovered from entity schema when not specified. Use different grid_id slugs for multiple grids on the same page.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | Unique slug for this grid on the page (e.g. "products", "orders"). Use different slugs for multiple grids on the same page. |
entity_name |
string | ✓ Yes | MAPI entity name (plural form, e.g. "products", "customers"). |
columns |
array | No | Column definitions. Omit to auto-discover from entity schema. Each item: {key, label, type?, sortable?, searchable?, editable?, required?} |
options |
object | No | Grid options: per_page (default 25), searchable, create_enabled, update_enabled, delete_enabled, delete_confirm, title, empty_message. |
Get the embeddable HTML+JS snippet for a configured grid. Paste this into a PAPI page. Requires Admin Auth to be configured.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | The grid_id to generate a snippet for. |
List all configured data grids for a project.
No input parameters required.
Remove a data grid configuration.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes |
List records from a MAPI entity. Called from browser with wsa_ token.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
page |
integer | No | |
per_page |
integer | No | |
search |
string | No | |
sort_by |
string | No | |
sort_dir |
string | No |
Create a new record in a MAPI entity.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
data |
object | ✓ Yes |
Create multiple records in a single call. Max 100 records per batch. Returns created count and any failures with reasons.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
records |
array | ✓ Yes | Array of data objects. Each object follows the same format as grid-create data. |
Update multiple records in a single call. Max 100 records per batch. Partial updates supported — only send fields that need changing.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
records |
array | ✓ Yes | Array of {record_id: int, data: object} items. Data follows the same format as grid-update. |
Delete multiple records in a single call. Max 100 record IDs per batch.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
record_ids |
array | ✓ Yes | Array of integer record IDs to delete. |
Update an existing record in a MAPI entity.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
record_id |
integer | ✓ Yes | |
data |
object | ✓ Yes |
Delete a record from a MAPI entity.
| Field | Type | Required | Description |
|---|---|---|---|
grid_id |
string | ✓ Yes | |
record_id |
integer | ✓ Yes |
MCP Tool Names
When using this integration through an AI assistant (Claude, ChatGPT, Cursor, etc.), the endpoints are available as MCP tools:
| Endpoint | MCP Tool Name |
|---|---|
| configure | data_grid_configure |
| get_snippet | data_grid_get_snippet |
| list_grids | data_grid_list_grids |
| remove_grid | data_grid_remove_grid |
| grid-list | data_grid_grid_list |
| grid-create | data_grid_grid_create |
| grid-batch-create | data_grid_grid_batch_create |
| grid-batch-update | data_grid_grid_batch_update |
| grid-batch-delete | data_grid_grid_batch_delete |
| grid-update | data_grid_grid_update |
| grid-delete | data_grid_grid_delete |
Website