API Connectors

users-love-us medal soc2
Send your Lazada data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Lazada Connector Reference

4 metrics37 dimensions
Fields

The Lazada connector exposes 41 fields (4 metrics, 37 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Lazada Fields

Lazada Categories fields

The Categories report of the Lazada connector includes 5 fields.

ID Type Name Description
category_id TEXT Category ID The unique identifier of the category.
category_leaf BOOLEAN Category Leaf Whether the category is a leaf category.
category_name TEXT Category Name The name of the category.
category_path TEXT Category Path The full path of the category in the tree.
parent_category_id TEXT Parent Category ID The identifier of the parent category.

Lazada Products fields

The Products report of the Lazada connector includes 15 fields.

ID Type Name Description
brand TEXT Brand The brand of the product.
created_time TIMESTAMP Product Created Time The date and time the product was created.
primary_category TEXT Primary Category The primary category ID of the product.
product_available NUMERIC Product Available The available quantity of the SKU.
product_id TEXT Product ID The unique identifier of the product.
product_name TEXT Product Name The name of the product.
product_price NUMERIC Product Price The price of the SKU.
product_quantity NUMERIC Product Quantity The stock quantity of the SKU.
product_special_price NUMERIC Product Special Price The special (discounted) price of the SKU.
product_status TEXT Product Status The status of the product.
seller_sku TEXT Seller SKU The seller-defined SKU code.
shop_sku TEXT Shop SKU The Lazada shop SKU code.
sku_id TEXT SKU ID The unique identifier of the SKU.
sku_status TEXT SKU Status The status of the SKU.
updated_time TIMESTAMP Product Updated Time The date and time the product was last updated.

Lazada other fields

The Lazada connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID The seller ID of the connected Lazada account.
account_name TEXT Account Name The name of the connected Lazada account.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date The date of the record.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20