External Data (Single / UPSERT)

Manage external data for products. GET retrieves data with filtering. POST performs UPSERT using (dataid, name) as composite key: if record exists → UPDATE with new value, if not → INSERT new record. PUT updates by record ID.

HTTP: GET | POST | PUT /external-data

Query parameters

Name	Type	Required	Description	Example
limit	integer	no	Maximum rows per page (default 100).	50
page	integer	no	1-indexed page when limit is provided.	1
offset	integer	no	Explicit row offset.	0
dataid	string	no	Filter by product ID. Required for POST/PUT.	24
name	string	no	Filter by or specify data name. Required for POST/PUT.	competitor_price
val	string	no	Data value. Required for POST/PUT.	299.90
datum	string	no	Timestamp for the data (defaults to now for POST).	2025-10-16 12:00:00
id	integer	no	ID of specific record to update (PUT only).	123
sort	string	no	Sort column (id, datum, dataid, name).	datum
direction	string	no	Sort direction asc or desc.	desc

Notes

GET lists external data from pricestest.external_data table with pagination.
✅ POST performs UPSERT using (dataid, name) composite key. Record updated if exists, inserted if new. Required: dataid, name, val.
PUT updates by ID. Provide id + fields to update.
External data is accessible in DSL as: dsl.external_data.name = val
Example UPSERT: POST {"dataid":"24","name":"competitor_price","val":"299.90"}
For bulk upserts, use POST /external-data-bulk

Sample request

curl -H "Authorization: ApiKey YOUR_API_KEY" "https://admin.elpricing.com/api/external-data"

Interactive call

HTTP MethodLimitMaximum rows per page (default 100).Page1-indexed page when limit is provided.OffsetExplicit row offset.Product ID (dataid)Filter by product ID. Required for POST/PUT.Data NameFilter by or specify data name. Required for POST/PUT.Data ValueData value. Required for POST/PUT.TimestampTimestamp for the data (defaults to now for POST).Record IDID of specific record to update (PUT only).Sort BySort column (id, datum, dataid, name).DirectionSort direction asc or desc.

Queue workflow

Tasks are persisted to var/api_queue/tasks.json. Process them with:

php go.php cron:list\nphp go.php cron:go

Logs are written to var/api_queue/logs/{task_id}.log.