- name
- simpleerp
- description
- >-
SimpleERP API
Use HTTP against the SimpleERP backend. Read domain examples only from the linked reference files; this file stays a navigator and global rules.
Agent execution policy
- If completing the user request requires running commands/scripts (including
curlcommands or PowerShellInvoke-WebRequest/Invoke-RestMethod), run them automatically. Do not ask the user to run/execute anything. GET /api/healthmay run without an API key. All other HTTP calls need a resolvedx-api-keyper Credentials below; if no key is available after that resolution, ask once for the key before issuing authenticated requests (then continue running commands automatically).
Environment
- Base URL:
http://localhost:3000. Resource paths are under/api(example:http://localhost:3000/api/products). If the user names another host, use it instead of localhost. - Clients: Prefer
curlon Unix-like shells; on Windows,curl.exeorInvoke-WebRequest/Invoke-RestMethodin PowerShell.
Credentials
- Header:
x-api-keyon every request exceptGET /api/health. - Resolution order: (1) API key the user provided in this conversation, if any; (2) environment variable
SIMPLEERP_API_KEY; (3) if still missing, ask once for the key, then proceed. - Do not invent keys, search arbitrary files for secrets, or read unrelated workspace paths to find credentials.
- Production: Admin routes need
admin_access. Most resources map to explicitPERMISSION_IDchecks; a few route modules usepermissions.<name> || {}in code, and where that map has no entry yet,requirePermissionreceives a falsy id and does not enforce a named permission (API key still required). See references/ENDPOINTS.md (Notes).
Minimal GET example
curl "http://localhost:3000/api/health"Invoke-WebRequest -Method GET -Uri "http://localhost:3000/api/health"Template
curl "http://localhost:3000/api/<resource>?<query_params>"Domain reference map
| Need | Open |
|---|---|
| All paths, methods, auth notes | references/ENDPOINTS.md |
| Sys-par, currencies, warehouses, partners, customers, suppliers | references/master-data-endpoints.md |
| Products, price lists, related master data | references/products-and-pricing.md |
| Inventory, deliveries, transfers, adjustments | references/inventory-and-deliveries.md |
| Sale/purchase orders, invoices, payments | references/documents-sales-purchasing.md |
| Returns, credit memos, debit notes | references/returns-and-memos.md |
| Users, API keys, permissions | references/admin-and-permissions.md |
| Chained flows (customer → sale order, etc.) | references/workflows.md |
| Report route copy-paste curls | references/reports.md |
List query allowlists (buildFilters), workspace paths | references/query-filters.md |
Dynamic list query filters
Most list endpoints build WHERE from a fixed allowlist of query parameters (bind variables; unknown params ignored). See references/query-filters.md for how buildFilters works and workspace-root-relative paths to simpleerp-api source files.
- Common:
limit,offseton list endpoints; many supportstatusor foreign-key ids. - Examples
- /sys-par — codePrefix, limit, offset - /currencies — status, limit, offset - /tax — status, limit, offset - /partners — status, limit, offset - /products — status, sku, limit, offset - /customers, /suppliers, /brands, /categories, /price-lists, /areas, /warehouses — status, limit, offset - /credit-terms — status, limit, offset - /uom — status, prodId, limit, offset - /warehouse-zones — warehouseId, status, limit, offset - /bank-accounts — status, currencyCode, warehouseId, limit, offset - /exchange-rates — source, limit, offset - /memberships — status, limit, offset - /inventory — warehouseId, prodId, limit, offset - /deliveries — orderId (SALE_ORDER only), warehouseId, status, limit, offset - /sale-orders — status, customerId, limit, offset - /purchase-orders — status, supplierId, limit, offset - /cust-returns — status, customerId, saleOrderId, limit, offset - /cust-credit-memos, /cust-debit-notes — status, customerId, limit, offset - /supp-returns, /supp-credit-memos, /supp-debit-notes — status, supplierId, limit, offset - /transfers — status, fromWhId, toWhId, limit, offset - /inventory-adjustments — status, warehouseId, limit, offset - /permissions — functionId, limit, offset - /user-permissions — userId, permissionId, limit, offset - /api-key-permissions — apiKeyId, permissionId, limit, offset
Prefer explicit filters and small limit values.
Report endpoints workflow
Use when the user needs a report and must pick accounts, products, warehouses, partners, customers, or suppliers.
- Discover (optional) —
GET /api/reports. UseincludeData=truefor quick aggregates. Example:GET /api/reports?includeData=true&topN=10 - Resolve IDs — Helper lists:
/api/reports/helpers/warehouses,.../customers,.../products,.../partners,.../suppliers,.../accounts(for GL). If the user gives names or SKU, search helpers first, then call the report. - CSV multi-select —
productIds=1,2,3,warehouseIds=10,11,customerIds=5,9,supplierIds=7,accountIds=100,101. Dedupe IDs; uselimit/offsetwhere supported. - Call the report — Date window:
fromDate=YYYY-MM-DD,toDate=YYYY-MM-DD. Full path table: references/ENDPOINTS.md (Reports). Copy-paste curls: references/reports.md.
GET /api/reports returns categories, accessibility metadata, and optional aggregate data; it normalizes singular/CSV filter aliases and may return warnings for bad filters or permissions.
Safety, pagination, and troubleshooting
- Start with small
limit(e.g. 20–50); narrow withstatus,customerId,supplierId,warehouseId,prodId, and other allowlisted query params from Dynamic list query filters where available. - Use
GETfor reads;POSTto create;PUT/PATCHto update;DELETEonly when requested and safe. Prefer deactivating viastatusover deleting master data or financial documents. - 400: often missing required fields (e.g.
priceListIdon customers, order dates). 409: duplicates or constraints (e.g. SKU, partner).