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
![](https://windsor.ai/wp-content/uploads/2023/11/magento-2.png.webp)
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 | NUMERIC | 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 | NUMERIC | 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 | NUMERIC | 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_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 | NUMERIC | 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 |