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 | 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 |