Windsor brings all your Magento data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL

Magento Field Reference

Sample

https://connectors.windsor.ai/magento?api_key=[your API key]&date_preset=last_7d&fields=date,order_increment_id,order_status,order_grand_total,order_store_id,order_store_name

Fields

ID	Type	Name	Description	Report
account_id	TEXT	Account Id	The Account Id (Store Id)
account_name	TEXT	Account Name	The Account Name (Store Name)
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The Date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
order_applied_rule_ids	TEXT	Order Applied Rule Ids	The Applied Rule Ids	order
order_base_currency_code	TEXT	Order Base Currency Code	The Base Currency Code	order
order_base_discount_amount	NUMERIC	Order Base Discount Amount	The Base Discount Amount	order
order_base_discount_invoiced	TEXT	Order Base Discount Invoiced	The Base Discount Invoiced	order
order_base_discount_tax_compensation_amount	NUMERIC	Order Base Discount Tax Compensation Amount	The Base Discount Tax Compensation Amount	order
order_base_discount_tax_compensation_invoiced	TEXT	Order Base Discount Tax Compensation Invoiced	The Base Discount Tax Compensation Invoiced	order
order_base_grand_total	NUMERIC	Order Base Grand Total	The Base Grand Total	order
order_base_shipping_amount	NUMERIC	Order Base Shipping Amount	The Base Shipping Amount	order
order_base_shipping_cancelled	NUMERIC	Order Base Shipping Cancelled	The Base Shipping Cancelled	order
order_base_shipping_discount_amount	NUMERIC	Order Base Shipping Discount Amount	The Base Shipping Discount Amount	order
order_base_shipping_discount_tax_compensation_amnt	TEXT	Order Base Shipping Discount Tax Compensation Amnt	The Base Shipping Discount Tax Compensation Amnt	order
order_base_shipping_incl_tax	TEXT	Order Base Shipping Incl Tax	The Base Shipping Incl Tax	order
order_base_shipping_invoiced	TEXT	Order Base Shipping Invoiced	The Base Shipping Invoiced	order
order_base_shipping_tax_amount	NUMERIC	Order Base Shipping Tax Amount	The Base Shipping Tax Amount	order
order_base_subtotal	NUMERIC	Order Base Subtotal	The Base Subtotal	order
order_base_subtotal_incl_tax	NUMERIC	Order Base Subtotal Incl Tax	The Base Subtotal Incl Tax	order
order_base_subtotal_invoiced	NUMERIC	Order Base Subtotal Invoiced	The Base Subtotal Invoiced	order
order_base_tax_amount	NUMERIC	Order Base Tax Amount	The Base Tax Amount	order
order_base_tax_invoiced	TEXT	Order Base Tax Invoiced	The Base Tax Invoiced	order
order_base_to_global_rate	NUMERIC	Order Base To Global Rate	The Base To Global Rate	order
order_base_to_order_rate	NUMERIC	Order Base To Order Rate	The Base To Order Rate	order
order_base_total_due	NUMERIC	Order Base Total Due	The Base Total Due	order
order_base_total_invoiced	NUMERIC	Order Base Total Invoiced	The Base Total Invoiced	order
order_base_total_invoiced_cost	NUMERIC	Order Base Total Invoiced Cost	The Base Total Invoiced Cost	order
order_base_total_paid	NUMERIC	Order Base Total Paid	The Base Total Paid	order
order_billing_address_id	TEXT	Order Billing Address Id	The Billing Address Id	order
order_coupon_code	TEXT	Order's Coupon Code	The Coupon Code	order
order_created_at	TIMESTAMP	Order Created At	The Created At	order
order_customer_email	TEXT	Order Customer Email	The Customer Email	order
order_customer_firstname	TEXT	Order Customer Firstname	The Customer Firstname	order
order_customer_is_guest	BOOLEAN	Order Customer Is Guest	The Customer Is Guest	order
order_customer_lastname	TEXT	Order Customer Lastname	The Customer Lastname	order
order_customer_note_notify	TEXT	Order Customer Note Notify	The Customer Note Notify	order
order_discount_amount	TEXT	Order Discount Amount	The Discount Amount	order
order_discount_description	TEXT	Order Discount Description	The Discount Description	order
order_discount_invoiced	TEXT	Order Discount Invoiced	The Discount Invoiced	order
order_discount_tax_compensation_amount	NUMERIC	Order Discount Tax Compensation Amount	The Discount Tax Compensation Amount	order
order_discount_tax_compensation_invoiced	TEXT	Order Discount Tax Compensation Invoiced	The Discount Tax Compensation Invoiced	order
order_email_sent	NUMERIC	Order Email Sent	The Email Sent	order
order_entity_id	TEXT	Order Entity Id	The Entity Id	order
order_global_currency_code	TEXT	Order Global Currency Code	The Global Currency Code	order
order_grand_total	NUMERIC	Order Grand Total	The Grand Total	order
order_increment_id	TEXT	Order Increment Id(order id)	The Increment Id	order
order_is_virtual	BOOLEAN	Order Is Virtual	The Is Virtual	order
order_item_amount_refunded	NUMERIC	Order Item Amount Refunded	Amount refunded for the order item	order_item
order_item_applied_rule_ids	TEXT	Order Item Applied Rule Ids	Applied rule ids for the order item	order_item
order_item_base_amount_refunded	NUMERIC	Order Item Base Amount Refunded	Base amount refunded for the order item	order_item
order_item_base_cost	NUMERIC	Order Item Base Cost	Base cost for the order item	order_item
order_item_base_discount_amount	NUMERIC	Order Item Base Discount Amount	Base discount amount for the order item	order_item
order_item_base_discount_invoiced	NUMERIC	Order Item Base Discount Invoiced	Base discount invoiced for the order item	order_item
order_item_base_discount_refunded	NUMERIC	Order Item Base Discount Refunded	Base discount refunded for the order item	order_item
order_item_base_discount_tax_compensation_amount	NUMERIC	Order Item Base Discount Tax Compensation Amount	Base discount tax compensation amount for the order item	order_item
order_item_base_discount_tax_compensation_invoiced	NUMERIC	Order Item Base Discount Tax Compensation Invoiced	Base discount tax compensation invoiced for the order item	order_item
order_item_base_discount_tax_compensation_refunded	NUMERIC	Order Item Base Discount Tax Compensation Refunded	Base discount tax compensation refunded for the order item	order_item
order_item_base_original_price	NUMERIC	Order Item Base Original Price	Base original price for the order item	order_item
order_item_base_price	NUMERIC	Order Item Base Price	Base price for the order item	order_item
order_item_base_price_incl_tax	NUMERIC	Order Item Base Price Incl Tax	Base price incl tax for the order item	order_item
order_item_base_row_invoiced	NUMERIC	Order Item Base Row Invoiced	Base row invoiced for the order item	order_item
order_item_base_row_total	NUMERIC	Order Item Base Row Total	Base row total for the order item	order_item
order_item_base_row_total_incl_tax	NUMERIC	Order Item Base Row Total Incl Tax	Base row total incl tax for the order item	order_item
order_item_base_tax_amount	NUMERIC	Order Item Base Tax Amount	Base tax amount for the order item	order_item
order_item_base_tax_before_discount	NUMERIC	Order Item Base Tax Before Discount	Base tax before discount for the order item	order_item
order_item_base_tax_invoiced	NUMERIC	Order Item Base Tax Invoiced	Base tax invoiced for the order item	order_item
order_item_base_tax_refunded	NUMERIC	Order Item Base Tax Refunded	Base tax refunded for the order item	order_item
order_item_base_weee_tax_applied_amount	NUMERIC	Order Item Base Weee Tax Applied Amount	Base weee tax applied amount for the order item	order_item
order_item_base_weee_tax_applied_row_amnt	NUMERIC	Order Item Base Weee Tax Applied Row Amount	Base weee tax applied row amount for the order item	order_item
order_item_base_weee_tax_disposition	NUMERIC	Order Item Base Weee Tax Disposition	Base weee tax disposition for the order item	order_item
order_item_base_weee_tax_row_disposition	NUMERIC	Order Item Base Weee Tax Row Disposition	Base weee tax row disposition for the order item	order_item
order_item_created_at	TIMESTAMP	Order Item Created At	Created at timestamp for the order item	order_item
order_item_discount_amount	NUMERIC	Order Item Discount Amount	Discount amount for the order item	order_item
order_item_discount_invoiced	NUMERIC	Order Item Discount Invoiced	Discount invoiced for the order item	order_item
order_item_discount_percent	NUMERIC	Order Item Discount Percent	Discount percent for the order item	order_item
order_item_discount_refunded	NUMERIC	Order Item Discount Refunded	Discount refunded for the order item	order_item
order_item_discount_tax_compensation_amount	NUMERIC	Order Item Discount Tax Compensation Amount	Discount tax compensation amount for the order item	order_item
order_item_discount_tax_compensation_canceled	NUMERIC	Order Item Discount Tax Compensation Canceled	Discount tax compensation canceled for the order item	order_item
order_item_discount_tax_compensation_invoiced	NUMERIC	Order Item Discount Tax Compensation Invoiced	Discount tax compensation invoiced for the order item	order_item
order_item_discount_tax_compensation_refunded	NUMERIC	Order Item Discount Tax Compensation Refunded	Discount tax compensation refunded for the order item	order_item
order_item_free_shipping	BOOLEAN	Order Item Free Shipping	Free shipping for the order item	order_item
order_item_is_qty_decimal	BOOLEAN	Order Item Is Qty Decimal	Is qty decimal for the order item	order_item
order_item_is_virtual	BOOLEAN	Order Item Is Virtual	Is virtual for the order item	order_item
order_item_item_id	TEXT	Order Item Id	Item id for the order item	order_item
order_item_locked_do_invoice	NUMERIC	Order Item Locked Do Invoice	Locked do invoice for the order item	order_item
order_item_locked_do_ship	NUMERIC	Order Item Locked Do Ship	Locked do ship for the order item	order_item
order_item_name	TEXT	Order Item Name	Name of the order item	order_item
order_item_no_discount	BOOLEAN	Order Item No Discount	No discount for the order item	order_item
order_item_order_id	TEXT	Order Item Order Id	Order id for the order item	order_item
order_item_original_price	NUMERIC	Order Item Original Price	Original price for the order item	order_item
order_item_parent_item_id	TEXT	Order Item Parent Item Id	Parent item id for the order item	order_item
order_item_price	NUMERIC	Order Item Price	Price of the order item	order_item
order_item_price_incl_tax	NUMERIC	Order Item Price Incl Tax	Price including tax for the order item	order_item
order_item_product_id	TEXT	Order Item Product Id	Product id for the order item	order_item
order_item_product_type	TEXT	Order Item Product Type	Product type for the order item	order_item
order_item_qty_backordered	NUMERIC	Order Item Qty Backordered	Quantity backordered for the order item	order_item
order_item_qty_canceled	NUMERIC	Order Item Qty Canceled	Quantity canceled for the order item	order_item
order_item_qty_invoiced	NUMERIC	Order Item Qty Invoiced	Quantity invoiced for the order item	order_item
order_item_qty_ordered	NUMERIC	Order Item Qty Ordered	Quantity ordered for the order item	order_item
order_item_qty_refunded	NUMERIC	Order Item Qty Refunded	Quantity refunded for the order item	order_item
order_item_qty_returned	NUMERIC	Order Item Qty Returned	Quantity returned for the order item	order_item
order_item_qty_shipped	NUMERIC	Order Item Qty Shipped	Quantity shipped for the order item	order_item
order_item_quote_item_id	TEXT	Order Item Quote Item Id	Quote item id for the order item	order_item
order_item_row_invoiced	NUMERIC	Order Item Row Invoiced	Row invoiced for the order item	order_item
order_item_row_total	NUMERIC	Order Item Row Total	Row total for the order item	order_item
order_item_row_total_incl_tax	NUMERIC	Order Item Row Total Incl Tax	Row total including tax for the order item	order_item
order_item_row_weight	NUMERIC	Order Item Row Weight	Row weight for the order item	order_item
order_item_sku	TEXT	Order Item SKU	SKU for the order item	order_item
order_item_store_id	TEXT	Order Item Store Id	Store id for the order item	order_item
order_item_tax_amount	NUMERIC	Order Item Tax Amount	Tax amount for the order item	order_item
order_item_tax_before_discount	NUMERIC	Order Item Tax Before Discount	Tax before discount for the order item	order_item
order_item_tax_canceled	NUMERIC	Order Item Tax Canceled	Tax canceled for the order item	order_item
order_item_tax_invoiced	NUMERIC	Order Item Tax Invoiced	Tax invoiced for the order item	order_item
order_item_tax_percent	NUMERIC	Order Item Tax Percent	Tax percent for the order item	order_item
order_item_tax_refunded	NUMERIC	Order Item Tax Refunded	Tax refunded for the order item	order_item
order_item_updated_at	TIMESTAMP	Order Item Updated At	Updated at timestamp for the order item	order_item
order_item_weee_tax_applied	BOOLEAN	Order Item Weee Tax Applied	Weee tax applied for the order item	order_item
order_item_weee_tax_applied_amount	NUMERIC	Order Item Weee Tax Applied Amount	Weee tax applied amount for the order item	order_item
order_item_weee_tax_applied_row_amount	NUMERIC	Order Item Weee Tax Applied Row Amount	Weee tax applied row amount for the order item	order_item
order_item_weee_tax_disposition	NUMERIC	Order Item Weee Tax Disposition	Weee tax disposition for the order item	order_item
order_item_weee_tax_row_disposition	NUMERIC	Order Item Weee Tax Row Disposition	Weee tax row disposition for the order item	order_item
order_item_weight	NUMERIC	Order Item Weight	Weight of the order item	order_item
order_order_currency_code	TEXT	Order Currency Code	The Order Currency Code	order
order_protect_code	TEXT	Order Protect Code	The Protect Code	order
order_quote_id	TEXT	Order Quote Id	The Quote Id	order
order_remote_ip	TEXT	Order Remote Ip	The Remote Ip	order
order_shipping_amount	NUMERIC	Order Shipping Amount	The Shipping Amount	order
order_shipping_description	TEXT	Order Shipping Description	The Shipping Description	order
order_shipping_discount_amount	NUMERIC	Order Shipping Discount Amount	The Shipping Discount Amount	order
order_shipping_discount_tax_compensation_amount	NUMERIC	Order Shipping Discount Tax Compensation Amount	The Shipping Discount Tax Compensation Amount	order
order_shipping_incl_tax	TEXT	Order Shipping Incl Tax	The Shipping Incl Tax	order
order_shipping_invoiced	TEXT	Order Shipping Invoiced	The Shipping Invoiced	order
order_shipping_tax_amount	NUMERIC	Order Shipping Tax Amount	The Shipping Tax Amount	order
order_state	TEXT	Order State	The State	order
order_status	TEXT	Order Status	The Status	order
order_store_currency_code	TEXT	Order Store Currency Code	The Store Currency Code	order
order_store_id	TEXT	Order Store Id	The Store Id	order
order_store_name	TEXT	Order Store Name	The Store Name	order
order_store_to_base_rate	NUMERIC	Order Store To Base Rate	The Store To Base Rate	order
order_store_to_order_rate	NUMERIC	Order Store To Order Rate	The Store To Order Rate	order
order_subtotal	NUMERIC	Order Subtotal	The Subtotal	order
order_subtotal_incl_tax	NUMERIC	Order Subtotal Incl Tax	The Subtotal Incl Tax	order
order_subtotal_invoiced	NUMERIC	Order Subtotal Invoiced	The Subtotal Invoiced	order
order_tax_amount	NUMERIC	Order Tax Amount	The Tax Amount	order
order_tax_invoiced	TEXT	Order Tax Invoiced	The Tax Invoiced	order
order_total_due	TEXT	Order Total Due	The Total Due	order
order_total_invoiced	TEXT	Order Total Invoiced	The Total Invoiced	order
order_total_item_count	NUMERIC	Order Total Item Count	The Total Item Count	order
order_total_paid	TEXT	Order Total Paid	The Total Paid	order
order_total_qty_ordered	NUMERIC	Order Total Qty Ordered	The Total Qty Ordered	order
order_updated_at	TIMESTAMP	Order Updated At	The Updated At	order
order_weight	NUMERIC	Order Weight	The Weight	order
orders_count	NUMERIC	Orders Count	Orders Count	order
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_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