Data Warehouse
Getting Started
This guide outlines various methods within the system's API for retrieving data about user accounts, product data, campaign details, and more, and will assist you in leveraging the full capabilities of data warehouse API.
The endpoints described in this guide are specifically designed to support users in configuring their own custom scenarios. These APIs can be utilized in the following ways:
1. Reporting Purposes
Extract real-time data on user accounts, product and order details, or campaign performance directly from the system. Create custom reports or dashboards to track key performance indicators (KPIs), analyze trends, and support decision-making processes.
2. Integration with Search Engines
Retrieve essential data such as product details, pricing, and stock levels from the system to feed into your own search engine infrastructure.
Each section of this documentation details the structure of API requests and responses, ensuring clarity and ease of use. The data retrieved through the API is always up-to-date, encompassing all records up to the exact moment the request is executed. This ensures that users have access to the most current information for their reporting needs.
:::infoImportant Note
All methods described in this documentation should be executed using the GET
method. It is also essential to include an authorization
key in the header for each request, formatted as Token <token>
.
:::
Filtering Parameters
All endpoints in this API support the following filtering options to customize and refine your queries. Each filter option is designed to provide flexibility and control over the data retrieval process.
1. ID
The id
filter allows you to query records based on their unique identifier. The following lookups are available for this filter:
gt
: Greater thangte
: Greater than or equal tolt
: Less thanlte
: Less than or equal toexact
: Matches the exact ID
Example Usage:
Retrieve records with IDs greater than 100:
?id__gt=100
Retrieve records with IDs less than or equal to 50:
?id__lte=50
Retrieve records with the exact ID of 123:
?id=123
2. Modified Date
The modified_date
filter allows you to query records based on the timestamp of their last modification. The following lookups are supported:
gt
: Modified after the specified date and timegte
: Modified on or after the specified date and timelt
: Modified before the specified date and timelte
: Modified on or before the specified date and time
Example Usage:
Retrieve records modified after January 10, 2025:
?modified_date__gt=2025-01-10
Retrieve records modified on or before January 9, 2025:
?modified_date__lte=2025-01-09
Note: Dates and times must be provided in ISO 8601 format: YYYY-MM-DD
.
3. Sort
The sort
parameter is used to order the results of a query based on one or more fields. By default, sorting is in ascending order. Use a hyphen (-
) before a field to sort in descending order.
Example Usage:
Sort records by
id
in ascending order:?sort=id
Sort records by
modified_date
in descending order:?sort=-modified_date
4. Page
The page
parameter is used for pagination to retrieve a specific subset of records.
Example Usage:
Retrieve the second page of results:
?page=2
Example Query Combining Filters
Retrieve records with the following criteria:
IDs greater than 100
Modified on or after January 10, 2025
Sorted by
modified_date
in descending orderDisplay the first page of results
Example:
?id__gt=100&modified_date__gte=2025-01-10&sort=-modified_date&page=1
1. Email Addresses
This method is used to retrieve information about the email addresses associated with user accounts. Each email address entry provides essential details about the email address, such as its verification status, whether it is the primary email for the user, and the associated user ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/account/email-addresses
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
String
This field defines the email address.
verified
Boolean
This field defines whether the email address has been verified.
primary
Boolean
This field defines whether the email address is the primary one among the user's email addresses.
user
Integer
This field defines the user ID.
2. Addresses
This method is used to fetch address details associated with user profiles. An address entry contains information like address type, creation and modification dates, contact details, and geographical identifiers such as country, city, and district.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/addresses
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
address_type
String
This field defines the address type. Possible values are: customer, retail_store, pickup_location, checkout_provider
String
This field defines the email address associated with the address.
phone_number
String
This field defines the phone number associated with the address.
first_name
String
This field defines the name of the address owner.
last_name
String
This field defines the surname of the address owner.
line
String
This field defines the full address associated with the location.
is_active
Boolean
This field defines whether the address is active.
postcode
String
This field defines the postal code.
notes
String
This field defines the note associated with the address.
tax_office
String
This field defines the tax office associated with the address.
tax_no
String
This field defines the tax number associated with the address.
e_bill_taxpayer
Boolean
This field defines whether the person is an e-bill taxpayer.
hash_data
String
This field defines the hash value generated using specific fields associated with the address.
remote_id
String
This field defines the ID corresponding to the address from any 3rd party address service.
identity_number
String
This field defines the identification number.
title
String
This field defines the address title.
primary
String
This field defines whether the address is the default among the user's addresses.
extra_field
Dictionary
This field defines the extra fields associated with the address.
country
Integer
This field defines the country ID associated with the address.
city
Integer
This field defines the city ID associated with the address.
township
Integer
This field defines the township ID associated with the address.
district
Integer
This field defines the district ID associated with the address.
retail_store
Integer
This field defines the retail_store ID associated with the address.
user
Integer
This field defines the user ID.
3. Districts
This method retrieves district data, including name, status of activity, and related geographical identifiers like city and township.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/districts
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines the translations of the district name.
is_active
Boolean
This field defines whether the district is active.
name
String
This field defines the name of the district.
postcode
String
This field defines the postcode of the district.
city
Integer
This field defines the city ID associated with the district.
township
Integer
This field defines the township ID associated with the district.
4. Countries
This method provides a list of countries available in the system, detailing the ID, name, and code of each country.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/countries
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines the translations of the country name.
is_active
Boolean
This field defines whether the country is active.
name
String
This field defines the name of the country.
code
String
This field defines the country code.
5. Cities
Retrieves data about cities, including their names, creation and modification dates, country code, and whether they are active or not.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cities
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines the translations of the city name.
is_active
Boolean
This field defines whether the city is active.
name
String
This field defines the name of the city.
priority
Integer
This field defines the priority of the city.
postcode
String
This field defines the postcode of the city.
country
Integer
This field defines the country ID associated with the city.
6. Townships
Similar to districts, this retrieves information about townships, linked to cities in the system.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/townships
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines the translations of the township name.
is_active
Boolean
This field defines whether the township is active.
name
String
This field defines the name of the township.
postcode
String
This field defines the postcode of the township.
city
Integer
This field defines the city ID associated with the township.
7. Users
This method gets user profile details including username, email and various status or preferences indicators such as if the user is active, staff, superuser, or verified.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/users
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
date_joined
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
gender
String
This field defines the user's gender. Possible values are: male, female
user_type
String
This field defines the user type. Possible values are: guest, registered
last_login
String
This field defines the date of the user's last login.
is_superuser
Boolean
This field defines whether the user is a super user.
username
String
This field defines the username.
first_name
String
This field defines the user's first name.
last_name
String
This field defines the user's last name.
String
This field defines the user's email.
is_staff
Boolean
This field defines whether the user is a staff.
is_active
Boolean
This field defines whether the user is active.
attributes
Dictionary
This field defines a dictionary containing the user's attributes.
attributes_kwargs
Dictionary
This field defines a dictionary containing the user's attributes.
localized_attributes
Dictionary
This field defines a dictionary containing translations of the user's attributes based on the language.
localized_attributes_kwargs
Dictionary
This field defines a dictionary containing translations of the user's attributes based on the language.
email_allowed
Boolean
This field defines the user's email communication consent.
sms_allowed
Boolean
This field defines the user's SMS communication consent.
call_allowed
Boolean
This field defines the user's call communication consent.
avatar
String
This field defines the user's photo.
is_anonymized
Boolean
This field defines whether the user has been anonymized.
phone
String
This field defines the user's phone number.
date_of_birth
String
This field defines the user's birthday.
language_code
String
This field defines the user's local language.
groups
List
This field defines the permission groups to which the user is added.
user_permissions
List
This field defines the user’s permissions.
8. Favourite Products
Retrieves favorite products, containing the ID of the product and user, along with timestamps of creation and last modification. It indicates which user has marked which product as a favorite.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/favourite-products
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
user
Integer
This field defines the ID of the user who has added the favorite product.
product
Integer
This field defines the ID of the product that is marked as a favorite.
9. Product Alerts
This method provides alerts related to changes, such as when a product is back in stock or its price changes, including the user's language preference and the specific product it relates to.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/product-alerts
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
user
Integer
This field defines the ID of the user who has added the product alert.
product
Integer
This field defines the ID of the product for which the product alert has been added.
language
String
This field defines the local language.
is_active
Boolean
This field defines whether the product alert is active.
10. Orders
Fetches order-related data, detailing financial amounts, order statuses, customer information, and various logistical details surrounding order handling.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/orders/orders
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
status
String
This field defines the order status.
currency
String
This field defines the currency used for the payment.
client_type
String
This field defines the platform on which the order was placed. Possible values are: default, android, ios, instore, b2b
shipping_company
String
This field defines the shipping company responsible for delivering the order.
number
String
This field defines the unique order number.
amount
String
This field defines the order amount.
discount_amount
String
This field defines the discount amount.
shipping_amount
String
This field defines the shipping fee.
shipping_tax_rate
String
This field defines the tax rate on the shipping fee.
refund_amount
String
This field defines the amount that has been returned.
discount_refund_amount
String
This field defines the total amount of discounts that have been canceled.
shipping_refund_amount
String
This field defines the refunded shipping fee.
invoice_number
String
This field defines the invoice number.
invoice_date
String
This field defines the invoice date.
e_archive_url
String
This field defines the e-invoice URL.
tracking_number
String
This field defines the shipping tracking number.
defined_tracking_url
String
This field defines the customized tracking URL.
remote_addr
String
This field defines the IP address from which the order was placed.
has_gift_box
Boolean
This field defines whether the order will be placed in a gift box.
gift_box_note
String
This field defines the note for the gift box.
language_code
String
This field defines the language associated with the order.
notes
String
This field defines the note related to the order.
delivery_range
String
This field defines the estimated delivery time range for the order.
extra_field
Dictionary
This field defines an additional field required for the order if necessary.
user_email
String
This field defines the email address of the user who placed the order.
shipping_option_slug
String
This field defines the slug information for the selected shipping option.
payment_option_slug
String
This field defines the slug information for the selected payment option.
bin_number
String
This field defines the BIN (Bank Identification Number) of the credit card if payment was made by credit card.
installment_count
Integer
This field defines the number of installments selected during payment.
installment_interest_amount
String
This field defines the total interest applied for installment payments.
shipping_tracking_url
String
This field defines the shipping tracking URL.
user
Integer
This field defines the user ID of the person who placed the order.
basket
Integer
This field defines the basket ID associated with the order.
shipping_option
Integer
This field defines the ID of the selected shipping option.
payment_option
Integer
This field defines the ID of the selected payment option.
card
Integer
This field defines the Card ID stored in the database, associated with the BIN number and POS, if the payment was made by credit card.
installment
Integer
This field defines the Installment database ID associated with the card.
segment
Integer
This field defines the segment ID information to which the user is associated, if applicable.
shipping_address
Integer
This field defines the address ID where the order will be delivered.
billing_address
Integer
This field defines the billing address ID associated with the order.
checkout_provider
Integer
This field defines the provider ID if the order was placed through a checkout provider.
11. Order Items
Retrieves information about items included in orders, showing product identifiers, pricing, and status details.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/orders/order-items
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
status
String
This field defines the order item status.
shipping_company
String
The field defines the shipping company for the order item.
attributes
Dictionary
The field defines the attributes of the order item.
price_currency
String
The field defines the price currency for the order item.
attributes_kwargs
Dictionary
The field defines the attribute kwargs for the order item.
localized_attributes
Dictionary
The field defines the localized attributes for the order item.
localized_attributes_kwargs
Dictionary
The field defines the localized attribute kwargs for the order item.
price
String
The field defines the price of the order item.
tax_rate
String
The field defines the tax rate for the order item.
invoice_number
String
The field defines the invoice number for the order item.
invoice_date
String
The field defines the invoice date for the order item.
e_archive_url
String
The field defines the e-archive URL for the order item.
tracking_number
String
The field defines the tracking number for the order item.
defined_tracking_url
String
The field defines the custom tracking URL for the order item.
retail_price
String
The field defines the retail price for the order item.
image
String
The field defines the image of the order item.
extra_field
Dictionary
The field defines the extra field for the order item.
estimated_delivery_date
String
The field defines the estimated delivery date for the order item.
shipping_tracking_url
String
The field defines the shipping tracking URL for the order item.
order
Integer
The field defines the order ID associated with the order item.
product
Integer
The field defines the product ID associated with the order item.
parent
Integer
The field defines the parent ID associated with the order item.
extra_product_price
Integer
The field defines the ID of the extra product price associated with the product. If not specified, the default price applies.
extra_product_stock
Integer
The field defines the ID of the extra product stock associated with the product. If not specified, the default stock applies.
datasource
Integer
The field defines the seller from whom the order item was purchased.
shipping_option_group
Integer
The field defines the shipping option group to which the order item belongs.
12. Order Transactions
This method retrieves financial transaction data related to orders, including transaction types, currencies, amounts, and additional relational details such as user information and order connections.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/orders/transactions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
user_email
String
The field defines the user email of the order transactions.
transaction_type
String
The field defines the type of the order transactions.
remote_addr
String
The field defines the remote address of the order transactions.
currency
String
The field defines the currency of the order transactions.
transaction_id
String
The field defines the transaction ID of the order transactions.
raw_request
Dictionary
The field defines the raw request of the order transactions.
raw_response
Dictionary
The field defines the raw response of the order transactions.
is_succeeded
Boolean
The field defines the success status of the order transactions.
amount
String
The field defines the amount of the order transactions.
three_d_used
Boolean
The field defines the 3D usage status of the order transactions.
auth_code
String
The field defines the authorization code of the order transactions.
pos
Integer
The field defines the pos of the order transactions.
order
Integer
The field defines the order of the order transactions.
main_pos
Integer
The field defines the main pos of the order transactions.
user
Integer
The field defines the user of the order transactions.
13. Order Discount Items
This method retrieves data about discounts applied to orders, including details such as discount amounts, related offers, and conditions.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/orders/discount-items
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
name
String
The field defines the label of the applied discount.
amount
String
The field defines the total discount amount.
cancel_amount
String
The field defines the refunded amount of the discount.
data_source_discount_sharing_rate
String
The field defines the percentage of the discount covered by the seller.
data
Dictionary
The field defines the data related to the discount item.
order
Integer
The field defines the associated order ID.
conditional_offer
Integer
The field defines the associated condition offer ID.
session_offer
Integer
The field defines the associated condition offer ID.
14. Order Benefit Applicants
This method indicates the relationship between order items and discounts, showing which discount is applied to each order item by returning the IDs of the order items and their associated discount records.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/orders/benefit-applicants
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
discount_item
Integer
The field defines the associated discount item id.
order_item
Integer
The field defines the associated order item id.
15. Pretty URLs
The Pretty URLs method retrieves a list of user-friendly and SEO-optimized URL formats, referred to as Pretty URLs. Each Pretty URL entry provides a mapping from the original, non-optimized URL (old_path
) to the optimized, user-friendly URL (new_path
).
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/pretty-urls
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
old_path
String
The original URL contains query strings.
new_path
String
The new SEO-optimized URL.
func_name
String
The view function used to serve the URL (e.g., ProductDetailPageApiView).
func_module
String
The file name where func_name is defined.
func_initkwargs
Dictionary
Keyword arguments passed to the view function.
viewname
String
The URL name associated with old_path (e.g., product).
args
List
The positional arguments parsed from the URL and passed to the view.
kwargs
Dictionary
The keyword arguments parsed from the URL and passed to the view.
query_params
Dictionary
The query parameters extracted from old_path.
parent
Integer
The generated Pretty URL for the default language in multi-language setups.
language
String
The language used to slugify values of UrlGeneratorConfig placeholders to generate new_path.
old_path
String
The original URL contains query strings.
16. Products
This method retrieves detailed information about the available products, including attributes, product types, and various configurations.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/products/products
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
product_type
String
The field defines the type of the product.
attributes
Dictionary
The field defines the product's attributes.
attributes_kwargs
Dictionary
The field defines the details of the attributes.
localized_attributes
Dictionary
The field defines the product attributes that have been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the product attributes.
name
String
The field defines the name of the product.
base_code
String
The field defines the base code for the product.
sku
String
The field defines the SKU (Stock Keeping Unit) for the product.
uuid
String
The field defines a unique identifier in UUID format for the product.
is_active
Boolean
The field defines whether the product is active or not.
extra_attributes
Dictionary
The field defines additional custom attributes for the product.
listing_code
String
The field defines the listing code for the product (if applicable).
is_seller_product
Boolean
The field defines whether the product is a seller's product.
is_listable
Boolean
The field defines whether the product can be listed or not.
is_form_required
Boolean
The field defines whether the product requires a form to be filled in the checkout process.
parent
Integer
The field defines the ID of the parent product (if this product is a child product).
attribute_set
Integer
The field defines the attribute set ID that the product belongs to.
custom_attribute_set
Integer
The field defines the custom attribute set (if any) associated with the product.
pretty_url
Integer
The field defines the pretty URL ID for the product.
listable_product
Integer
The field defines whether the product is part of a listable set (if applicable).
data_source
Integer
The field defines the data source associated with the product (if applicable).
group_products
List
The field defines the grouped products (if any) associated with the main product.
17. Product Images
This method retrieves image data for products, including image links and associated metadata such as the image dimensions, status, and the product to which the image belongs.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/products/product-images
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
status
String
The field defines the current status of the image. disabled or active
image
String
The field defines the URL of the image file associated with the product.
height
Integer
The field defines the height of the image in pixels.
width
Integer
The field defines the width of the image in pixels.
order
Integer
The field defines the viewing order in which the image file will be displayed.
product
Integer
The field defines the ID of the product associated with the image.
18. Campaign Conditions
This method retrieves the specific conditions for campaigns, detailing the eligibility requirements that need to be met for a customer to benefit from a campaign. This information helps in understanding how conditions are defined for various campaigns, such as minimum purchase amounts, product quantities, or user-specific requirements.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/conditions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
condition_type
String
The field defines the type of condition. distinct, quantity, amount, query
translations
Dictionary
This field defines the translations of the condition.
upsell_message
String
This field defines the message prompting users to add more products to their cart to qualify for free shipping.
kwargs
Dictionary
This field defines various conditions and configurations for pricing and consumption.
kwargs[price_type]
String
The field defines which price type the discount will be applied to. unit_price, discount_unit_price, retail_price
product_collection
Integer
This field defines the product collection id associated with this condition.
19. Campaign Benefits
This method retrieves the benefits associated with specific campaigns that are applied when the corresponding campaign conditions are met. These benefits can include discounts, free products, or shipping offers, among others. Each benefit is linked to certain pricing conditions and may be applied globally or locally to qualifying items in the campaign.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/benefits
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
benefit_type
String
The field defines the type of benefit. multibuy, percentage, fixed, shipping_free, point, coupon, voucher, sample_product, loyalty_point
kwargs
Dictionary
This field defines various conditions and configurations for pricing and consumption.
kwargs[price_type]
String
The field defines which price type the discount will be applied to. unit_price, discount_unit_price, retail_price
product_collection
Integer
This field defines the product collection id associated with this benefit.
20. Campaign Basket Offers
This method returns details about a specific offer, including its ID, status (e.g., 'used'), type (e.g., 'coupon'), and applicable currencies. It includes timestamps for creation and modification, visibility settings, start and end dates, and usage limits. The response also provides references to the related promotion, condition, and benefit, along with the user ID associated with the offer.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/basket-offers
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
offer_type
String
This field defines the type of offer. sitewide, coupon, coupon_code, voucher_code, bulk_voucher_code, bulk_coupon
translations
Dictionary
This field defines any translations for the coupon, if available.
status
String
This field defines the current status of the coupon. active, passive, used
currencies
List
This field defines the list of currencies in which the coupon is valid (e.g., "EUR").
label
String
This field defines the label or name of the coupon (e.g., "test coupon 1").
voucher_code
String
The field defines the code to be used for the discount.
is_visible
Boolean
This field defines whether the coupon is visible to users
is_visible_on_list
Boolean
This field defines whether the coupon is visible in the list (true or false).
start_datetime
String
This field defines the start date and time when the coupon becomes valid.
end_datetime
String
This field defines the end date and time when the coupon expires.
priority
Integer
This field defines the priority of the coupon (e.g., 1 being the highest priority).
allowed_quantity_per_basket
Integer
This field defines the maximum quantity of the coupon allowed per basket (e.g., 1).
is_mergable
Boolean
This field defines whether the coupon can be merged with other coupons (true or false).
max_usage_per_user
Integer
This field defines the maximum number of times the coupon can be used by a single user (0 means no limit).
kwargs
Dictionary
This field defines additional conditions or configurations for the coupon (currently empty).
is_available_for_data_sources
Boolean
This field defines whether the coupon is available for use in data sources (false in this case).
max_stock_limit
Integer
This field defines the maximum stock limit for the coupon (0 means no limit).
promotion
Integer
This field defines the ID of the promotion associated with the coupon.
condition
Integer
This field defines the ID of the condition associated with the coupon.
benefit
Integer
This field defines the ID of the benefit associated with the coupon.
user
Integer
The field defines the user ID of the person who can use the created coupon.
21. Campaign Promotions
This method retrieves details about a specific promotion, including its ID, name, slug, creation and modification timestamps, and translations (if available). It is linked to an offer, and stores the offer’s slug along with the promotion names as seen by the user.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/promotions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines any translations for the promotions, if available.
name
String
The field defines the name of the promotion.
slug
String
The field defines the slug associated with the promotion.
22. Bulk Voucher Codes
This method returns a list of voucher codes generated for a specific campaign. It provides details such as the voucher code, its status (active or inactive), and the associated campaign.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/bulk-voucher-codes
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
translations
Dictionary
This field defines any translations for the promotions, if available.
code
String
The field defines the code to be used for the discount.
basket_offer
Integer
The field defines the ID of the associated basket offer.
order
Integer
The field defines the order to which the discount code has been applied.
discount_item
Integer
The field defines the discount item to which the discount code has been applied.
user
Integer
The field defines the user ID of the person who can use the created voucher code.
23. Session Offers
This method returns details about specific session-based offers, including the offer's ID, status, type (e.g., 'b2b'), creation and modification timestamps, the offer code, and additional response data if available.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/session-offers
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
status
String
This field defines the current status of the coupon. active, passive, used
type
String
The field defines the type of the session offer. b2b, extension, …
code
String
The field defines the code to be used for the discount.
response
Dictionary
The field defines the response of the 3rd party promotion request.
24. Loyalty Cards
This method returns details about a specific loyalty card, including its ID, account number, creation and modification timestamps, and the associated user ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/loyalty-cards
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the loyalty card.
attributes_kwargs
Dictionary
The field defines the details of the loyalty card, including points, tier, and expiration.
localized_attributes
Dictionary
The field defines the loyalty card that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the loyalty card attributes.
number
String
The field defines the loyalty card number associated with the user.
user
Integer
The field defines the ID of the user who owns the loyalty card.
25. Product Collection Items
This method returns details about a specific product collection, including its ID, UUID, creation and modification timestamps, the associated product ID, and the related collection ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/product-collection-items
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
uuid
String
The field defines the unique UUID associated with the collection item.
product
Integer
The field defines the ID of the product associated with the collection item.
collection
Integer
The field defines the ID of the collection that the collection item is associated with.
26. Product Collections
This method returns details about a specific product collection, including its ID, name, collection type (e.g., 'static'), creation and modification timestamps, UUID, slug, sort option, and active status. It may also include an expiration date if applicable..
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/campaigns/product-collections
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
uuid
String
The field defines the unique UUID associated with the collection..
collection_type
String
The field defines the type of the collection. dynamic or static
name
String
The field defines the name of the collection.
is_active
Boolean
The field defines whether the collection is active or not.
expiration_date
String
The field defines the validity date for the dynamic collection.
slug
String
The field defines the unique slug for the collection.
sort_option
Integer
The field defines the ID of the option that will be used for sorting within the collection.
27. SEO
This method returns details about a specific SEO entry, including its ID, creation and modification timestamps, URL, title, description, and keywords. It also includes any associated attributes, such as CSS class, along with localized attributes if available.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/seo
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the SEO.
attributes_kwargs
Dictionary
The field defines the details of the SEO.
localized_attributes
Dictionary
The field defines the SEO that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the SEO attributes.
url
String
The field defines the URL that will be used for SEO purposes.
title
String
The field defines the title used for SEO purposes.
description
String
The field defines the description used for SEO purposes.
keywords
String
The field defines the keywords used for SEO purposes.
28. Special Pages
This method returns details about a specific special page, including its ID, name, URL, template, and extraction strategy. It also includes information on banners, video embedded code, associated product collection, and pretty URL. The response may also include the page’s active status, creation and modification timestamps, and any localized or additional attributes.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/special-pages
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
extraction_strategy
String
The field defines the strategy selected for displaying products on the page.
attributes
Dictionary
The field defines the attributes of the special page.
attributes_kwargs
Dictionary
The field defines the details of the special page.
localized_attributes
Dictionary
The field defines the special page that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the special page attributes.
name
String
The field defines the name of the special page.
url
String
The field defines the URL through which the defined special page can be accessed.
template
String
The field defines the name of the template to be rendered.
banner
String
The field defines the URL of the banner image.
banner_mobile
String
The field defines the URL of the mobile banner image.
banner_url
String
The field defines the URL of the page banner.
banner_description
String
The field defines the description area of the banner.
is_active
Boolean
The field defines whether the special page is active or not.
video_embedded_code
String
The field defines the embedded video code added to the special page.
product_collection
Integer
The field defines the collection that will be displayed on the page.
pretty_url
Integer
The field defines the pretty URL associated with the page.
29. Widget Types
This method returns details about a specific widget type, including its ID, name, and schema. The schema contains information about the widget’s attributes, such as the title, its localizability, required status, data type, and label
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/widget-types
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
name
String
The field defines the name of the widget type.
schema
Dictionary
The field defines the schema of the widget type, which includes the structure, attributes, and relationships required to render and configure the widget.
30. Widgets
This method returns details about a specific widget, including its ID, name, slug, template, creation and modification timestamps, and content type. It also includes information about the associated widget type and any attributes, both localized and non-localized.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/widgets
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the widget
attributes_kwargs
Dictionary
The field defines the details of the widget.
localized_attributes
Dictionary
The field defines the widget that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the widget attributes.
name
String
The field defines the widget's name.
slug
String
The field defines the widget's slug.
template
String
The field defines the template used for the widget.
content_type
Integer
The field defines the widget's content type.
widget_type
Integer
The field defines the ID of the widget type that the widget is associated with.
31. Special Page Pretty URLs
This method returns details about a specific special page’s pretty URL, including its ID, creation and modification timestamps, associated special page ID, URL, and the language in which it is defined.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/special-page-pretty-urls
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
special_page
Integer
The field defines the ID of the special page that it is associated with.
url
String
The field defines the pretty URL.
language
String
The field defines the language code.
32. Landing Page Types
This method returns details about a specific landing page type, including its ID, name, slug, creation and modification timestamps, and associated function module and name. It also includes the schema for the landing page, such as attributes like product badges, with their data types, requirements, and labels.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/landing-page-types
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
name
Integer
The field defines the name of the landing page type.
slug
String
The field defines the slug of the landing page type.
func_module
String
The field defines the file name where the func_name is defined.
func_name
String
The field defines the view function used to serve the URL (e.g., ProductDetailPageApiView).
schema
Dictionary
The field defines the structure and rules for the landing page.
33. Landing Pages
This method returns details about a specific landing page, including its ID, name, URL, template, and associated landing page type. It also provides information about its active status, content type, pretty URL, and related attributes, including any localized attributes and values.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/cms/landing-pages
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the landing page.
attributes_kwargs
Dictionary
The field defines the details of the landing page.
localized_attributes
Dictionary
The field defines the landing page that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the landing page attributes.
name
String
The field defines the name of the landing page.
url
String
The field defines the URL of the landing page.
template
String
The field defines the template used for the landing page.
is_active
Boolean
The field defines whether the special page is active or not.
content_type
Integer
The field defines the landing page’s content type.
pretty_url
Integer
The field defines the pretty URL associated with the page.
landing_page_type
Integer
The field defines the ID of the landing page type associated with the landing page.
attribute_value
Integer
The field defines the ID of the attribute value associated with it.
34. Loyalty Accounts
This method returns details about a specific loyalty account, including its ID, currency, balance, and whether debit is allowed. It also includes the account number, UUID, creation and modification timestamps, and the associated user email if available.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/loyalty/accounts
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
uuid
String
The field defines the unique UUID of the loyalty account.
number
String
The field defines the loyalty account number.
user_email
String
The field defines the email address of the user who owns the loyalty account.
balance
String
The field defines the balance available in the loyalty account.
debit_allowed
Boolean
The field defines whether debit transactions are allowed on the loyalty account.
user
Integer
The field defines the ID of the user to whom the loyalty account is associated.
35. Loyalty Transfers
This method returns details about a specific loyalty transfer, including its ID, currency, amount, and reference number. It also includes the associated loyalty account ID, transaction ID, and timestamps for creation and modification.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/loyalty/transfers
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
currency
String
The field defines the currency of the loyalty transfer.
uuid
String
The field defines the unique UUID of the loyalty transfer.
amount
String
The field defines the total amount of the loyalty transfer.
reference
String
The field defines the reference field for the loyalty transfer, which is the order number if the transfer was made for an order.
transaction
String
The field defines the transaction ID created for the loyalty transfer.
36. Loyalty Transactions
This method returns details about a specific loyalty transaction, including its ID, currency, amount, and reference number. It also includes the associated user email, order ID, user ID, remote address, and timestamps for creation and modification.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/loyalty/transactions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
currency
String
The field defines the currency of the loyalty transaction.
uuid
String
The field defines the unique UUID of the loyalty transaction.
amount
String
The field defines the total amount of the loyalty transaction.
reference
String
The field defines the reference field for the loyalty transaction, which is the order number if the transfer was made for an order.
user_email
String
The field defines the email address of the user who owns the loyalty account.
order
Integer
The field defines the order associated with the transaction.
user
Integer
The field defines the ID of the user to whom the loyalty account is associated.
37. Social Accounts
This method returns details about a specific social account, including its ID, provider (e.g., 'facebook'), UID, last login date, date joined, and any additional data. It also includes the associated user ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/social-account/accounts
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
provider
String
The field defines the social account provider. e.g. akifast, facebook, apple, …
uid
String
The field defines the unique UID of the social account.
last_login
String
The field defines the last login date of the user.
date_joined
String
The field defines the date when the user registered using a social account.
extra_data
Dictionary
The field defines the extra data related to the social account provider.
38. Content Types
This method returns details about a specific content type, including its ID, app label, and model. The content type is used to link to a specific model in the application, allowing for flexible object referencing.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/content-types
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
app_label
String
The field defines the name of the app associated with the content type.
model
String
The field defines the model name associated with the content type.
39. Redirects
This method returns details about a specific redirect URLs, including its ID, the old URL path, the new redirected path, and the associated site ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/redirects
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
old_path
String
The field defines the URL at which the redirection will occur.
new_path
String
The field defines the URL to which the redirection will be made.
site
String
The field defines the site ID required for the redirection.
40. POS
This method returns details about a specific POS option, including its ID, name, slug, associated payment gateway, and resource URL. It may also include a URL for 3D secure processing, if applicable
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/payments/pos
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
name
String
The field defines the name of the POS.
slug
String
The field defines the unique slug or identifier used for the POS
gateway
String
The field defines which payment gateway the POS will use.
resource_url
String
The field defines the URL of the resources associated with the POS.
three_d_resource_url
String
The field defines the URL for the 3D secure resources of the POS.
41. Shipping Options
This method returns details about a specific shipping option, including its ID, delivery type, name, slug, and active status. It also includes the shipping option’s associated sorting order, calculator, rule (with its name and slug), and any additional information in the form of attributes like descriptions and logos
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/shippings/shipping-options
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
delivery_type
String
The field defines the type of delivery for the shipping option same_day, next_day, standard, in_store
translations
Dictionary
This field defines the translations of the district name.
name
String
The field defines the name of the shipping option.
slug
String
The field defines the slug of the shipping option.
logo
String
The field defines the logo associated with the shipping option.
is_active
Boolean
The field defines whether the shipping option is active,
sort_order
Integer
The field defines the sort order of the shipping option.
calculator
Dictionary
The field defines the rule used to calculate the price of the shipping option.
rule
Dictionary
The field defines the rule that determines under which conditions the shipping option can be selected.
kwargs
Dictionary
The field defines any additional parameters for the shipping option.
description
String
The field defines the description of the shipping option.
42. Baskets
This method returns details about a specific shopping basket, including its ID, status, creation and modification timestamps, version, and associated voucher code. It also provides information about the user and any namespaces linked to the basket, if applicable.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/baskets/baskets
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
status
Boolean
The field defines the current status of the basket. active, inactive, expired, merged, frozen, submitted
version
String
The field defines the version of the basket, useful for tracking changes.
voucher_code
String
The field defines the code of the voucher applied to the basket.
namespace
String
The field defines the identifier used to distinguish multiple baskets for a user.
user
Integer
The field defines the user id associated with the basket.
43. Basket Items
This method returns details about a specific item in a shopping basket, including its ID, quantity, product reference, and version. It also includes information such as the associated basket ID, product ID, and any additional attributes (like tax rate, unit price, image, and extra product details), if available.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/baskets/basket-items
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the basket item.
attributes_kwargs
Dictionary
The field defines the details of the basket item.
localized_attributes
Dictionary
The field defines the basket item that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the basket item attributes.
currency_type
String
The field defines the currency used for the basket item.
version
String
The field defines the version of the basket item, useful for tracking changes.
reference
String
This field defines a reference for the basket item.
quantity
Integer
This field defines the quantity of the product.
tax_rate
String
This field defines the tax rate applied to the basket item.
unit_price
String
This field defines the unit price of the product.
image
String
This field defines the URL or path to the product's image.
basket
Integer
This field defines the ID of the basket that contains the product.
product
Integer
The field defines the ID of the product associated with the basket item.
extra_product_price
Integer
The field defines the ID of the extra product price associated with the product. If not specified, the default price applies.
extra_product_stock
Integer
The field defines the ID of the extra product stock associated with the product. If not specified, the default stock applies.
parent
Integer
The field defines the ID of the associated basket item, if there is a related basket item.
datasource
Integer
The field defines the ID that indicates which seller the item belongs to.
44. Deleted Items
This method returns details about a specific deleted item, including its ID, object ID, deletion timestamp, and the content type associated with the item.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/deleted-items
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
object_id
String
The field defines the ID value of the deleted object.
deleted_date
String
The field defines the deletion date of the object.
content_type
Integer
The field defines the content type of the deleted object.
45. Category Nodes
This method returns details about a specific category node, including its ID, name, path, and depth in the category hierarchy. It also includes the number of child nodes, sorting order, associated pretty URL, and timestamps for creation and modification.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/catalogs/category-nodes
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
attributes
Dictionary
The field defines the attributes of the category node.
attributes_kwargs
Dictionary
The field defines the details of the category node.
localized_attributes
Dictionary
The field defines the category node that has been translated into other languages.
localized_attributes_kwargs
Dictionary
The field defines the details of the translations for the category node attributes.
uuid
String
The field defines the UUID of the category node.
path
String
This field defines the path as the hierarchical route from the root to the node.
depth
Integer
This field defines the depth as the level of the node in the tree, starting from zero.
numchild
Integer
This field defines the numchild as the number of direct children the node has.
order
Integer
The field defines the order of the category node.
name
String
The field defines the name of the category.
pretty_url
String
The field defines the pretty URL of the category.
sort_option
String
The field defines the ID of the sort option applied to order the category.
46. Product Prices
This method returns details about a specific product’s price, including its ID, price type (e.g., 'default'), currency type, retail price, tax rate, and the actual price. It also provides any extra fields and the associated product ID.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/catalogs/product-prices
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
created_date
String
This field defines the creation date.
modified_date
String
This field defines the last updated date.
currency_type
String
The field defines the currency type of the product price.
price_type
String
The field defines the type of price applied to the product.
retail_price
String
The field defines the retail price of the product.
tax_rate
String
The field defines the tax rate applied to the product.
price
String
The field defines the actual price of the product.
extra_field
Dictionary
The field defines additional fields or attributes related to the product.
product
Integer
The field defines the product ID associated with the product price.
47. Revision
This method retrieves details about specific revisions, tracking changes made to objects over time. This is useful for auditing purposes and ensures traceability of modifications. Each revision includes an ID, creation date, an optional comment explaining the change, and the user who made the revision.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/reversions/revisions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
date_created
String
This field defines the timestamp when the revision was created.
comment
String
This field defines an optional description or note that explains the changes made in the revision.
user
Integer
This field defines the user who created the revision, linking the changes to a specific user.
48. Version
This method provides details about a specific version of an object, capturing the state of the object at the time of revision. When a revision is made, the object version prior to the revision is saved, allowing the system to retain the state of the object before the changes were applied.
This includes versioning information such as the ID, associated object ID, the database where the object is stored, the format (e.g., 'json'), and the serialized data representing the object. Additionally, it includes details about the revision that the object version is associated with, its content type, and its representation.
This is typically used for tracking changes to objects, enabling version control, and allowing the retrieval of specific historical states of the object for auditing, rollback, or comparison purposes.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/reversions/versions
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
object_id
Integer
This field defines as the unique identifier of the versioned object in the database
db
String
This field db as the database connection where the version record is stored.
format
String
This field defines as the format in which the serialized data is stored (e.g., JSON, Pickle)
serialized_data
Dictionary
This field defines the serialized form of the object's data, representing its state at the time of the version.
object_repr
String
This field defines the string representation of the object.
revision
Integer
This field defines the revision object to which the version belongs, grouping changes together.
content_type
Integer
This field defines the model type of the versioned object.
49. Audit Events
This method returns details about an audit event, including the event's UUID, user information (email, name), timestamp, IP address, accessed URL, query parameters, post data, and request headers. Audit events are used to track user actions and system changes for security and compliance purposes.
Path: {omnitron_url}/api/v1/remote/{channel_id}/data-warehouse/audit-events
Example Response
count
Integer
This field defines the total number of records returned.
next
String
This field defines the URL of the next page.
previous
String
This field defines the URL of the previous page.
results
List
This field returns a list of results.
id
Integer
This field defines the database ID of the record.
uuid
String
This field defines a unique identifier for the event, typically used to ensure that each event can be distinctly referenced.
user
Dictionary
This field defines the user who triggered the event.
timestamp
String
This field defines the exact date and time when the event occurred.
remote_addr
String
This field defines the IP address of the client making the request.
url
String
This field defines the URL that the client accessed during the event.
query_params
Dictionary
This field defines the query parameters included in the URL during the request.
post_data
Dictionary
This field defines the data sent by the client in the HTTP POST request.
headers
Dictionary
This field defines the HTTP headers sent along with the request, which can include metadata about the request.
object_id
Integer
This field defines the unique identifier of the object being affected by the event.
content
Dictionary
This field defines the content or details of the event, typically the data or change made.
content_type
Integer
This field defines the model type of the object being affected by the event.
Was this helpful?