Tray
Overview
Overview of V4MOS.AI Tray API
The V4MOS.AI Tray API brings together customer, order, and catalog data from Tray Commerce stores connected to your organization. Endpoints share the /v1/tray prefix and use the same authentication, pagination, and metadata envelope as every other V4MOS.AI integration.
Available Endpoints
- getCustomers
/v1/tray/customersRetrieve Tray customer commerce, engagement, and lifecycle metrics - getOrders
/v1/tray/ordersRetrieve Tray orders with payment, shipping, and status data - getProducts
/v1/tray/productsRetrieve products sold in Tray orders with SKU, commission, and category information
Authentication
All endpoints require the x-client-id and x-client-secret headers, plus the organizationId query parameter. See Authentication.
Common Parameters
organizationId(required) – Organization that owns the Tray integrationintegrationId– Integration IDintegrationName– Integration namepage– Page number (default: 1)limit– Records per page (default: 500, max: 5000)orderBy– Field used for orderingorderDirection–ASCorDESCcreatedStart/createdEnd– Filter by entity creation datelastModifiedStart/lastModifiedEnd– Filter by last update timestamp
Resource-Specific Filters
Customers (/v1/tray/customers)
idregistrationDateStart/registrationDateEndcreatedStart/createdEndlastModifiedStart/lastModifiedEnd
Orders (/v1/tray/orders)
idcustomerIdorderStatus,status,deliveredStatus,paymentMethodTypepaymentDateStart/paymentDateEndcreatedStart/createdEndlastModifiedStart/lastModifiedEndpartnerId
Products (/v1/tray/products)
orderIdnameproductIdcategoryintegrationId
Tray Data Model Highlights
Customers
- Contact and marketing:
email,newsletter,last_sending_newsletter - Commerce insights:
total_orders,count_orders,credit_limit,discount,blocked,reseller - Lifecycle timestamps:
created,registration_date,last_purchase,last_visit,last_modification,modified,inserted_at
Orders
- Payment and totals:
partial_total,taxes,discount,total,payment_method,payment_method_rate,installment,payment_date,coupon - Shipping:
shipment,shipment_value,shipment_date,delivery_date,shipment_integrator,delivery_time,is_traceable - Status:
status,order_status,order_status_type,delivered,delivered_status,shipping_cancelled,has_payment,has_shipment,has_invoice - Operational metadata:
partner_id,point_sale,session_id,app_id,store_segment,integration_id
Products (Order Items)
- Identification:
product_id,sold_product_id,order_id,name,brand,model - Pricing:
price,cost_price,original_price,commission - Inventory context:
quantity,category,product_image,url - Relationships:
integration_id,organization_id,organization_id,document_id
Responses
All responses follow the standard format:
{
"data": [...],
"meta": {
"page": 1,
"limit": 500,
"hasNextPage": true,
"hasPreviousPage": false
}
}