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

Magento Field Reference 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

IDTypeNameDescriptionReport
account_idTEXTAccount IdThe Account Id (Store Id)
account_nameTEXTAccount NameThe Account Name (Store Name)
dateDATEDateThe Date
order_applied_rule_idsNUMERICOrder Applied Rule IdsThe Applied Rule Idsorder
order_base_currency_codeTEXTOrder Base Currency CodeThe Base Currency Codeorder
order_base_discount_amountNUMERICOrder Base Discount AmountThe Base Discount Amountorder
order_base_discount_invoicedTEXTOrder Base Discount InvoicedThe Base Discount Invoicedorder
order_base_discount_tax_compensation_amountNUMERICOrder Base Discount Tax Compensation AmountThe Base Discount Tax Compensation Amountorder
order_base_discount_tax_compensation_invoicedTEXTOrder Base Discount Tax Compensation InvoicedThe Base Discount Tax Compensation Invoicedorder
order_base_grand_totalNUMERICOrder Base Grand TotalThe Base Grand Totalorder
order_base_shipping_amountNUMERICOrder Base Shipping AmountThe Base Shipping Amountorder
order_base_shipping_cancelledNUMERICOrder Base Shipping CancelledThe Base Shipping Cancelledorder
order_base_shipping_discount_amountNUMERICOrder Base Shipping Discount AmountThe Base Shipping Discount Amountorder
order_base_shipping_discount_tax_compensation_amntTEXTOrder Base Shipping Discount Tax Compensation AmntThe Base Shipping Discount Tax Compensation Amntorder
order_base_shipping_incl_taxTEXTOrder Base Shipping Incl TaxThe Base Shipping Incl Taxorder
order_base_shipping_invoicedTEXTOrder Base Shipping InvoicedThe Base Shipping Invoicedorder
order_base_shipping_tax_amountNUMERICOrder Base Shipping Tax AmountThe Base Shipping Tax Amountorder
order_base_subtotalNUMERICOrder Base SubtotalThe Base Subtotalorder
order_base_subtotal_incl_taxNUMERICOrder Base Subtotal Incl TaxThe Base Subtotal Incl Taxorder
order_base_subtotal_invoicedNUMERICOrder Base Subtotal InvoicedThe Base Subtotal Invoicedorder
order_base_tax_amountNUMERICOrder Base Tax AmountThe Base Tax Amountorder
order_base_tax_invoicedTEXTOrder Base Tax InvoicedThe Base Tax Invoicedorder
order_base_to_global_rateNUMERICOrder Base To Global RateThe Base To Global Rateorder
order_base_to_order_rateNUMERICOrder Base To Order RateThe Base To Order Rateorder
order_base_total_dueNUMERICOrder Base Total DueThe Base Total Dueorder
order_base_total_invoicedNUMERICOrder Base Total InvoicedThe Base Total Invoicedorder
order_base_total_invoiced_costNUMERICOrder Base Total Invoiced CostThe Base Total Invoiced Costorder
order_base_total_paidNUMERICOrder Base Total PaidThe Base Total Paidorder
order_billing_address_idNUMERICOrder Billing Address IdThe Billing Address Idorder
order_coupon_codeTEXTOrder's Coupon CodeThe Coupon Codeorder
order_created_atTIMESTAMPOrder Created AtThe Created Atorder
order_customer_emailTEXTOrder Customer EmailThe Customer Emailorder
order_customer_firstnameTEXTOrder Customer FirstnameThe Customer Firstnameorder
order_customer_is_guestBOOLEANOrder Customer Is GuestThe Customer Is Guestorder
order_customer_lastnameTEXTOrder Customer LastnameThe Customer Lastnameorder
order_customer_note_notifyTEXTOrder Customer Note NotifyThe Customer Note Notifyorder
order_discount_amountTEXTOrder Discount AmountThe Discount Amountorder
order_discount_descriptionTEXTOrder Discount DescriptionThe Discount Descriptionorder
order_discount_invoicedTEXTOrder Discount InvoicedThe Discount Invoicedorder
order_discount_tax_compensation_amountNUMERICOrder Discount Tax Compensation AmountThe Discount Tax Compensation Amountorder
order_discount_tax_compensation_invoicedTEXTOrder Discount Tax Compensation InvoicedThe Discount Tax Compensation Invoicedorder
order_email_sentNUMERICOrder Email SentThe Email Sentorder
order_entity_idNUMERICOrder Entity IdThe Entity Idorder
order_global_currency_codeTEXTOrder Global Currency CodeThe Global Currency Codeorder
order_grand_totalNUMERICOrder Grand TotalThe Grand Totalorder
order_increment_idTEXTOrder Increment Id(order id)The Increment Idorder
order_is_virtualBOOLEANOrder Is VirtualThe Is Virtualorder
order_order_currency_codeTEXTOrder Currency CodeThe Order Currency Codeorder
order_protect_codeTEXTOrder Protect CodeThe Protect Codeorder
order_quote_idNUMERICOrder Quote IdThe Quote Idorder
order_remote_ipTEXTOrder Remote IpThe Remote Iporder
order_shipping_amountNUMERICOrder Shipping AmountThe Shipping Amountorder
order_shipping_descriptionTEXTOrder Shipping DescriptionThe Shipping Descriptionorder
order_shipping_discount_amountNUMERICOrder Shipping Discount AmountThe Shipping Discount Amountorder
order_shipping_discount_tax_compensation_amountNUMERICOrder Shipping Discount Tax Compensation AmountThe Shipping Discount Tax Compensation Amountorder
order_shipping_incl_taxTEXTOrder Shipping Incl TaxThe Shipping Incl Taxorder
order_shipping_invoicedTEXTOrder Shipping InvoicedThe Shipping Invoicedorder
order_shipping_tax_amountNUMERICOrder Shipping Tax AmountThe Shipping Tax Amountorder
order_stateTEXTOrder StateThe Stateorder
order_statusTEXTOrder StatusThe Statusorder
order_store_currency_codeTEXTOrder Store Currency CodeThe Store Currency Codeorder
order_store_idTEXTOrder Store IdThe Store Idorder
order_store_nameTEXTOrder Store NameThe Store Nameorder
order_store_to_base_rateNUMERICOrder Store To Base RateThe Store To Base Rateorder
order_store_to_order_rateNUMERICOrder Store To Order RateThe Store To Order Rateorder
order_subtotalNUMERICOrder SubtotalThe Subtotalorder
order_subtotal_incl_taxNUMERICOrder Subtotal Incl TaxThe Subtotal Incl Taxorder
order_subtotal_invoicedNUMERICOrder Subtotal InvoicedThe Subtotal Invoicedorder
order_tax_amountNUMERICOrder Tax AmountThe Tax Amountorder
order_tax_invoicedTEXTOrder Tax InvoicedThe Tax Invoicedorder
order_total_dueTEXTOrder Total DueThe Total Dueorder
order_total_invoicedTEXTOrder Total InvoicedThe Total Invoicedorder
order_total_item_countNUMERICOrder Total Item CountThe Total Item Countorder
order_total_paidTEXTOrder Total PaidThe Total Paidorder
order_total_qty_orderedNUMERICOrder Total Qty OrderedThe Total Qty Orderedorder
order_updated_atTIMESTAMPOrder Updated AtThe Updated Atorder
order_weightNUMERICOrder WeightThe Weightorder
todayDATETodayToday's date