Data API Resources
The Data API provides deep access to the data powering any website - exposing the majority of its data models. A lot of them are very low level - essentially exposing raw database tables as XML Resources and allowing you CRUD operations on them. Please keep in mind:
- Some of these formats are optimised for specific use cases - and are not necessarily perfectly normalised.
- Some of these formats are not ideal, but are widely used - meaning we are stuck with supporting them.
- Some resources require precise formatting of specific fields. For example a field may be new line delimited or stored as JSON. It is important to retain this formatting as it may be required by the software in that particular area.
A lot of the resources have plural names - e.g. Enquiries
or UserCustomGroups
. When being output by the API in a ResultSet
, the node will be singular - e.g. Enquiry
or UserCustomerGroup
. This should also be the case when you are sending a payload back to the API.
Some of the more commonly used resources have interfaces layered on top of the raw data model to provide a cleaner developer experience. These include:
Outside of this, other commonly accessed resources include:
- Cat - category data
- CatParent - the relationship between a category & its parent(s)
- ProdCat - the relationship between a product & the categories it is in
Country
- supported countriesCountryRegions
- regions withing countries, associated post codes & supported shipping methodsCoupon
- coupon codes & discountsCurrency
- supported currencies & their associated ratesEnquiries
- enquiries submitted via a contact form- Webhooks - subscribe to a webhook to receive push notifications from certain events - e.g new order
Wishlist
- a customer wishlist - related to aCustomer
WishItem
- items on a customer wishlist - related to aWishlist
.
Product related resources
The following resources store data about products:
- Product - main product data
- ExtraImages - additional product images
- Inventory - product inventory
- Merchandising - product promotion & special / discounts
- Options - simple or advanced product option configuration - e.g. colour, size. Note this resource has quite complicated formats.
- Variants - variations of the product with their own code, pricing, inventory etc. Generally representing the combination of options - e.g. Small, Green T-shirt
- PricingAdvanced - pricing records for a product relating to price tiers (by customer group), quantity pricing, multicurrency.
- ProdAccessGroup - access control relating to products (if enabled on the website)
- ProductAttributes - additional attributes & associated values stored against a product - used for filtering & display on a product page
Variant related resources
Variants (product variations) operate almost like standalone SKUs - in that they can have their own code
, price
, description
, inventory
etc. Some of the resources that relate to products can also relate to Variants
:
- VariantOptions - linking a variant to a specific combination of options.
- PricingAdvanced - pricing records (as described above) but related to the variant entry instead.
- Inventory - inventory records for this variant
Order related resources
Order
- main order dataOrderline
- one or more orderlines related to the orderOrderlineDiscounts
- discounts applied to an order or orderlineOrderlineTax
- additional tax information relating to tax applied to an orderlineShipments
- tracking an order shipment - who it was shipped with, tracking number, link etcShipmentLines
- what orderlines were included in a shipment
Customer related resources
Customer
- primary customer dataUserCustomerGroups
- group codes that the customer is in