industry-department-solutions
latest
false
- Overview
- API Resources
Supply Chain & Retail Solutions API guide
Last updated Apr 16, 2026
Product Pricing Daily
Overview
The product_pricing_daily resource represents daily pricing snapshots for products at specific locations. This resource stores time-series pricing data including selling prices, costs, and list prices.
Resource Endpoint
/api/v2/ingest/object/{prefix}PRODUCT_PRICING_DAILY{suffix}
/api/v2/ingest/object/{prefix}PRODUCT_PRICING_DAILY{suffix}
Supported Methods
| Method | Return Type | Description |
|---|---|---|
| POST | Response | Ingest (create/update) daily pricing records via UPSERT operation |
Request Headers
| Header | Required | Description |
|---|---|---|
Authorization | Yes | Your Personal Access Token (PAT) from platform.peak.ai |
Content-Type | Yes | Must be application/json |
Properties
Primary Keys
- location_id (string) - Foreign key reference to locations
- pricing_at (datetime) - Timestamp for the pricing snapshot
- product_id (string) - Foreign key reference to products
Attributes
| Attribute | Data Type | Required | Description |
|---|---|---|---|
location_id | string | Yes | Location identifier (Primary Key, Foreign Key) |
pricing_at | datetime | Yes | Pricing snapshot timestamp (Primary Key) |
product_id | string | Yes | Product identifier (Primary Key, Foreign Key) |
selling_price | float | No | Current selling price |
unit_cost_price | float | No | Cost per unit |
unit_list_price | float | No | List price per unit |
quote_stage | string | No | Pricing stage or lifecycle status |
created_at | datetime | No | Timestamp when the record was created |
updated_at | datetime | No | Timestamp when the record was last updated |
Relationships
Outbound References
None
Inbound References
- product - Foreign key
product_idreferences product - location - Foreign key
location_idreferences location
JSON Representation
{
"solutionName": "QP_OOTB",
"data": [
{
"location_id": "LOC-UK-001",
"pricing_at": "2025-01-28T00:00:00Z",
"product_id": "PROD-001",
"selling_price": 199.99,
"unit_cost_price": 120.00,
"unit_list_price": 249.99,
"quote_stage": "active",
"created_at": "2025-01-28T01:00:00Z",
"updated_at": "2025-01-28T10:00:00Z"
}
],
"operationType": "UPSERT"
}
{
"solutionName": "QP_OOTB",
"data": [
{
"location_id": "LOC-UK-001",
"pricing_at": "2025-01-28T00:00:00Z",
"product_id": "PROD-001",
"selling_price": 199.99,
"unit_cost_price": 120.00,
"unit_list_price": 249.99,
"quote_stage": "active",
"created_at": "2025-01-28T01:00:00Z",
"updated_at": "2025-01-28T10:00:00Z"
}
],
"operationType": "UPSERT"
}
Example Request
curl -X POST \
'https://service.peak.ai/ingestion-api/api/v2/ingest/object/QP_PRODUCT_PRICING_DAILY_OOTB' \
-H 'Authorization: YOUR_API_KEY' \
-H 'Content-Type: application/json' \
-d '{
"solutionName": "QP_OOTB",
"data": [
{
"location_id": "LOC-UK-001",
"pricing_at": "2025-01-28T00:00:00Z",
"product_id": "PROD-001",
"selling_price": 199.99,
"unit_cost_price": 120.00,
"unit_list_price": 249.99,
"quote_stage": "active",
"created_at": "2025-01-28T01:00:00Z",
"updated_at": "2025-01-28T10:00:00Z"
}
],
"operationType": "UPSERT"
}'
curl -X POST \
'https://service.peak.ai/ingestion-api/api/v2/ingest/object/QP_PRODUCT_PRICING_DAILY_OOTB' \
-H 'Authorization: YOUR_API_KEY' \
-H 'Content-Type: application/json' \
-d '{
"solutionName": "QP_OOTB",
"data": [
{
"location_id": "LOC-UK-001",
"pricing_at": "2025-01-28T00:00:00Z",
"product_id": "PROD-001",
"selling_price": 199.99,
"unit_cost_price": 120.00,
"unit_list_price": 249.99,
"quote_stage": "active",
"created_at": "2025-01-28T01:00:00Z",
"updated_at": "2025-01-28T10:00:00Z"
}
],
"operationType": "UPSERT"
}'
Important Notes
- Foreign Key Dependencies: Requires valid
product_idandlocation_idto exist in their respective tables - Time-Series Data: Captures daily pricing snapshots for trend analysis
- Multi-Price Tracking: Stores selling price, cost, and list price for margin analysis
- Location-Specific: Prices can vary by location
- Custom Attributes: Additional custom attributes can be added using the
/PRODUCT_PRICING_DAILY/add-attributeendpoint - Data Validation: All attributes are validated according to their defined data types