Skip to main content
Skip table of contents

Magento API Reference

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the prefix internal_ in their names. Public API procedures do not have such prefix in their names.

Customers

Customers
Parameter
<customer_id> (optional): Return single customer, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

integer

Customer Id

group_id

integer

Group Id

default_billing

string

Default billing

default_shipping

string

Default shipping

confirmation

string

Confirmation

created_at

timestamp

Created at

updated_at

timestamp

Updated at

created_in

string

Created in

dob

string

Date of birth

email

string

Email

firstname

string

Firstname

lastname

string

Lastname

middlename

string

Middlename

prefix

string

Prefix

suffix

string

Suffix

gender

integer

Gender

store_id

integer

Store Id

taxvat

string

Taxvat

website_id

integer

Website Id

Example

SQL
CREATE VIEW magento_examples.example_Customers
AS 
SELECT * FROM magento.Customers (
	preview => TRUE
)

Invoices

Invoices
Parameter
<invoice_id> (optional): Return single invoice, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

base_currency_code

string

Base Currency Code

base_discount_amount

bigdecimal

Base Discount Amount

base_grand_total

bigdecimal

Base Grand Total

base_discount_tax_compensation_amount

bigdecimal

Base Discount Tax Compensation Amount

base_shipping_amount

bigdecimal

Base Shipping Amount

base_shipping_discount_tax_compensation_amnt

bigdecimal

Base Shipping Discount Tax Compensation Amnt

base_shipping_incl_tax

bigdecimal

Base Shipping Incl Tax

base_shipping_tax_amount

bigdecimal

Base Shipping Tax Amount

base_subtotal

bigdecimal

Base Subtotal

base_subtotal_incl_tax

bigdecimal

Base Subtotal Incl Tax

base_tax_amount

bigdecimal

Base Tax Amount

base_total_refunded

bigdecimal

Base Total Refunded

base_to_global_rate

bigdecimal

Base To Global Rate

base_to_order_rate

bigdecimal

Base To Order Rate

billing_address_id

integer

Billing Address Id

can_void_flag

bigdecimal

Can Void Flag

created_at

timestamp

Created At

discount_amount

bigdecimal

Discount Amount

discount_description

string

Discount Description

email_sent

bigdecimal

Email Sent

entity_id

integer

Entity Id

global_currency_code

string

Global Currency Code

grand_total

bigdecimal

Grand Total

discount_tax_compensation_amount

bigdecimal

Discount Tax Compensation Amount

increment_id

string

Increment Id

is_used_for_refund

bigdecimal

Is Used For Refund

order_currency_code

string

Order Currency Code

order_id

integer

Order Id

shipping_address_id

integer

Shipping Address Id

shipping_amount

bigdecimal

Shipping Amount

shipping_discount_tax_compensation_amount

bigdecimal

Shipping Discount Tax Compensation Amount

shipping_incl_tax

bigdecimal

Shipping Incl Tax

shipping_tax_amount

bigdecimal

Shipping Tax Amount

state

bigdecimal

State

store_currency_code

string

Store Currency Code

store_id

integer

Store Id

store_to_base_rate

bigdecimal

Store To Base Rate

store_to_order_rate

bigdecimal

Store To Order Rate

subtotal

bigdecimal

Subtotal

subtotal_incl_tax

bigdecimal

Subtotal Incl Tax

tax_amount

bigdecimal

Tax Amount

total_qty

bigdecimal

Total Qty

transaction_id

string

Transaction Id

updated_at

timestamp

Updated At

extension_attributes_base_customer_balance_amount

bigdecimal

Extension Attributes Base Customer Balance Amount

extension_attributes_customer_balance_amount

bigdecimal

Extension Attributes Customer Balance Amount

extension_attributes_base_gift_cards_amount

bigdecimal

Extension Attributes Base Gift Cards Amount

extension_attributes_gift_cards_amount

bigdecimal

Extension Attributes Gift Cards Amount

extension_attributes_gw_price

string

Extension Attributes Gw Price

extension_attributes_gw_items_base_price

string

Extension Attributes Gw Items Base Price

extension_attributes_gw_items_price

string

Extension Attributes Gw Items Price

extension_attributes_gw_card_base_price

string

Extension Attributes Gw Card Base Price

extension_attributes_gw_card_price

string

Extension Attributes Gw Card Price

extension_attributes_gw_base_tax_amount

string

Extension Attributes Gw Base Tax Amount

extension_attributes_gw_tax_amount

string

Extension Attributes Gw Tax Amount

extension_attributes_gw_items_base_tax_amount

string

Extension Attributes Gw Items Base Tax Amount

extension_attributes_gw_items_tax_amount

string

Extension Attributes Gw Items Tax Amount

extension_attributes_gw_card_base_tax_amount

string

Extension Attributes Gw Card Base Tax Amount

extension_attributes_gw_card_tax_amount

string

Extension Attributes Gw Card Tax Amount

extension_attributes_vertex_tax_calculation_shipping_address_address_type

string

Extension Attributes Vertex Tax Calculation Shipping Address Address Type

extension_attributes_vertex_tax_calculation_shipping_address_city

string

Extension Attributes Vertex Tax Calculation Shipping Address City

extension_attributes_vertex_tax_calculation_shipping_address_company

string

Extension Attributes Vertex Tax Calculation Shipping Address Company

extension_attributes_vertex_tax_calculation_shipping_address_country_id

string

Extension Attributes Vertex Tax Calculation Shipping Address Country Id

extension_attributes_vertex_tax_calculation_shipping_address_customer_address_id

integer

Extension Attributes Vertex Tax Calculation Shipping Address Customer Address Id

extension_attributes_vertex_tax_calculation_shipping_address_customer_id

integer

Extension Attributes Vertex Tax Calculation Shipping Address Customer Id

extension_attributes_vertex_tax_calculation_shipping_address_email

string

Extension Attributes Vertex Tax Calculation Shipping Address Email

extension_attributes_vertex_tax_calculation_shipping_address_entity_id

integer

Extension Attributes Vertex Tax Calculation Shipping Address Entity Id

extension_attributes_vertex_tax_calculation_shipping_address_fax

string

Extension Attributes Vertex Tax Calculation Shipping Address Fax

extension_attributes_vertex_tax_calculation_shipping_address_firstname

string

Extension Attributes Vertex Tax Calculation Shipping Address First Name

extension_attributes_vertex_tax_calculation_shipping_address_lastname

string

Extension Attributes Vertex Tax Calculation Shipping Address Last Name

extension_attributes_vertex_tax_calculation_shipping_address_middlename

string

Extension Attributes Vertex Tax Calculation Shipping Address Middle Name

extension_attributes_vertex_tax_calculation_shipping_address_parent_id

integer

Extension Attributes Vertex Tax Calculation Shipping Address Parent Id

extension_attributes_vertex_tax_calculation_shipping_address_postcode

string

Extension Attributes Vertex Tax Calculation Shipping Address Postcode

extension_attributes_vertex_tax_calculation_shipping_address_prefix

string

Extension Attributes Vertex Tax Calculation Shipping Address Prefix

extension_attributes_vertex_tax_calculation_shipping_address_region

string

Extension Attributes Vertex Tax Calculation Shipping Address Region

extension_attributes_vertex_tax_calculation_shipping_address_region_code

string

Extension Attributes Vertex Tax Calculation Shipping Address Region Code

extension_attributes_vertex_tax_calculation_shipping_address_region_id

string

Extension Attributes Vertex Tax Calculation Shipping Address Region Id

extension_attributes_vertex_tax_calculation_shipping_address_street

string

Extension Attributes Vertex Tax Calculation Shipping Address Street

extension_attributes_vertex_tax_calculation_shipping_address_suffix

string

Extension Attributes Vertex Tax Calculation Shipping Address Suffix

extension_attributes_vertex_tax_calculation_shipping_address_telephone

string

Extension Attributes Vertex Tax Calculation Shipping Address Telephone

extension_attributes_vertex_tax_calculation_shipping_address_vat_id

string

Extension Attributes Vertex Tax Calculation Shipping Address Vat Id

extension_attributes_vertex_tax_calculation_shipping_address_vat_is_valid

string

Extension Attributes Vertex Tax Calculation Shipping Address Vat Is Valid

extension_attributes_vertex_tax_calculation_shipping_address_vat_request_date

string

Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Date

extension_attributes_vertex_tax_calculation_shipping_address_vat_request_id

string

Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Id

extension_attributes_vertex_tax_calculation_shipping_address_vat_request_success

bigdecimal

Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Success

extension_attributes_vertex_tax_calculation_billing_address_city

string

Extension Attributes Vertex Tax Calculation Billing Address City

extension_attributes_vertex_tax_calculation_billing_address_company

string

Extension Attributes Vertex Tax Calculation Billing Address Company

extension_attributes_vertex_tax_calculation_billing_address_country_id

string

Extension Attributes Vertex Tax Calculation Billing Address Country Id

extension_attributes_vertex_tax_calculation_billing_address_customer_address_id

integer

Extension Attributes Vertex Tax Calculation Billing Address Customer Address Id

extension_attributes_vertex_tax_calculation_billing_address_customer_id

integer

Extension Attributes Vertex Tax Calculation Billing Address Customer Id

extension_attributes_vertex_tax_calculation_billing_address_email

string

Extension Attributes Vertex Tax Calculation Billing Address Email

extension_attributes_vertex_tax_calculation_billing_address_entity_id

integer

Extension Attributes Vertex Tax Calculation Billing Address Entity Id

extension_attributes_vertex_tax_calculation_billing_address_fax

string

Extension Attributes Vertex Tax Calculation Billing Address Fax

extension_attributes_vertex_tax_calculation_billing_address_firstname

string

Extension Attributes Vertex Tax Calculation Billing Address First Name

extension_attributes_vertex_tax_calculation_billing_address_lastname

string

Extension Attributes Vertex Tax Calculation Billing Address Last Name

extension_attributes_vertex_tax_calculation_billing_address_middlename

string

Extension Attributes Vertex Tax Calculation Billing Address Middle Name

extension_attributes_vertex_tax_calculation_billing_address_parent_id

integer

Extension Attributes Vertex Tax Calculation Billing Address Parent Id

extension_attributes_vertex_tax_calculation_billing_address_postcode

string

Extension Attributes Vertex Tax Calculation Billing Address Postcode

extension_attributes_vertex_tax_calculation_billing_address_prefix

string

Extension Attributes Vertex Tax Calculation Billing Address Prefix

extension_attributes_vertex_tax_calculation_billing_address_region

string

Extension Attributes Vertex Tax Calculation Billing Address Region

extension_attributes_vertex_tax_calculation_billing_address_region_code

string

Extension Attributes Vertex Tax Calculation Billing Address Region Code

extension_attributes_vertex_tax_calculation_billing_address_region_id

string

Extension Attributes Vertex Tax Calculation Billing Address Region Id

extension_attributes_vertex_tax_calculation_billing_address_street

string

Extension Attributes Vertex Tax Calculation Billing Address Street

extension_attributes_vertex_tax_calculation_billing_address_suffix

string

Extension Attributes Vertex Tax Calculation Billing Address Suffix

extension_attributes_vertex_tax_calculation_billing_address_telephone

string

Extension Attributes Vertex Tax Calculation Billing Address Telephone

extension_attributes_vertex_tax_calculation_billing_address_vat_id

string

Extension Attributes Vertex Tax Calculation Billing Address Vat Id

extension_attributes_vertex_tax_calculation_billing_address_vat_is_valid

string

Extension Attributes Vertex Tax Calculation Billing Address Vat Is Valid

extension_attributes_vertex_tax_calculation_billing_address_vat_request_date

string

Extension Attributes Vertex Tax Calculation Billing Address Vat Request Date

extension_attributes_vertex_tax_calculation_billing_address_vat_request_id

string

Extension Attributes Vertex Tax Calculation Billing Address Vat Request Id

extension_attributes_vertex_tax_calculation_billing_address_vat_request_success

bigdecimal

Extension Attributes Vertex Tax Calculation Billing Address Vat Request Success

extension_attributes_vertex_tax_calculation_order_adjustment_negative

bigdecimal

Extension Attributes Vertex Tax Calculation Order Adjustment Negative

extension_attributes_vertex_tax_calculation_order_adjustment_positive

bigdecimal

Extension Attributes Vertex Tax Calculation Order Adjustment Positive

extension_attributes_vertex_tax_calculation_order_applied_rule_ids

string

Extension Attributes Vertex Tax Calculation Order Applied Rule Ids

extension_attributes_vertex_tax_calculation_order_base_adjustment_negative

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Adjustment Negative

extension_attributes_vertex_tax_calculation_order_base_adjustment_positive

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Adjustment Positive

extension_attributes_vertex_tax_calculation_order_base_currency_code

string

Extension Attributes Vertex Tax Calculation Order Base Currency Code

extension_attributes_vertex_tax_calculation_order_base_discount_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Amount

extension_attributes_vertex_tax_calculation_order_base_discount_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Canceled

extension_attributes_vertex_tax_calculation_order_base_discount_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Invoiced

extension_attributes_vertex_tax_calculation_order_base_discount_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Refunded

extension_attributes_vertex_tax_calculation_order_base_grand_total

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Grand Total

extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Amount

extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Invoiced

extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Refunded

extension_attributes_vertex_tax_calculation_order_base_shipping_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Amount

extension_attributes_vertex_tax_calculation_order_base_shipping_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Canceled

extension_attributes_vertex_tax_calculation_order_base_shipping_discount_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Discount Amount

extension_attributes_vertex_tax_calculation_order_base_shipping_discount_tax_compensation_amnt

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Discount Tax Compensation Amnt

extension_attributes_vertex_tax_calculation_order_base_shipping_incl_tax

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Incl Tax

extension_attributes_vertex_tax_calculation_order_base_shipping_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Invoiced

extension_attributes_vertex_tax_calculation_order_base_shipping_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Refunded

extension_attributes_vertex_tax_calculation_order_base_shipping_tax_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Tax Amount

extension_attributes_vertex_tax_calculation_order_base_shipping_tax_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Shipping Tax Refunded

extension_attributes_vertex_tax_calculation_order_base_subtotal

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Subtotal

extension_attributes_vertex_tax_calculation_order_base_subtotal_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Subtotal Canceled

extension_attributes_vertex_tax_calculation_order_base_subtotal_incl_tax

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Subtotal Incl Tax

extension_attributes_vertex_tax_calculation_order_base_subtotal_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Subtotal Invoiced

extension_attributes_vertex_tax_calculation_order_base_subtotal_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Subtotal Refunded

extension_attributes_vertex_tax_calculation_order_base_tax_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Tax Amount

extension_attributes_vertex_tax_calculation_order_base_tax_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Tax Canceled

extension_attributes_vertex_tax_calculation_order_base_tax_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Tax Invoiced

extension_attributes_vertex_tax_calculation_order_base_tax_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Tax Refunded

extension_attributes_vertex_tax_calculation_order_base_total_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Canceled

extension_attributes_vertex_tax_calculation_order_base_total_due

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Due

extension_attributes_vertex_tax_calculation_order_base_total_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Invoiced

extension_attributes_vertex_tax_calculation_order_base_total_invoiced_cost

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Invoiced Cost

extension_attributes_vertex_tax_calculation_order_base_total_offline_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Offline Refunded

extension_attributes_vertex_tax_calculation_order_base_total_online_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Online Refunded

extension_attributes_vertex_tax_calculation_order_base_total_paid

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Paid

extension_attributes_vertex_tax_calculation_order_base_total_qty_ordered

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Qty Ordered

extension_attributes_vertex_tax_calculation_order_base_total_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base Total Refunded

extension_attributes_vertex_tax_calculation_order_base_to_global_rate

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base To Global Rate

extension_attributes_vertex_tax_calculation_order_base_to_order_rate

bigdecimal

Extension Attributes Vertex Tax Calculation Order Base To Order Rate

extension_attributes_vertex_tax_calculation_order_billing_address_id

integer

Extension Attributes Vertex Tax Calculation Order Billing Address Id

extension_attributes_vertex_tax_calculation_order_can_ship_partially

bigdecimal

Extension Attributes Vertex Tax Calculation Order Can Ship Partially

extension_attributes_vertex_tax_calculation_order_can_ship_partially_item

bigdecimal

Extension Attributes Vertex Tax Calculation Order Can Ship Partially Item

extension_attributes_vertex_tax_calculation_order_coupon_code

string

Extension Attributes Vertex Tax Calculation Order Coupon Code

extension_attributes_vertex_tax_calculation_order_created_at

string

Extension Attributes Vertex Tax Calculation Order Created At

extension_attributes_vertex_tax_calculation_order_customer_dob

string

Extension Attributes Vertex Tax Calculation Order Customer DOB

extension_attributes_vertex_tax_calculation_order_customer_email

string

Extension Attributes Vertex Tax Calculation Order Customer Email

extension_attributes_vertex_tax_calculation_order_customer_firstname

string

Extension Attributes Vertex Tax Calculation Order Customer First Name

extension_attributes_vertex_tax_calculation_order_customer_gender

bigdecimal

Extension Attributes Vertex Tax Calculation Order Customer Gender

extension_attributes_vertex_tax_calculation_order_customer_group_id

integer

Extension Attributes Vertex Tax Calculation Order Customer Group Id

extension_attributes_vertex_tax_calculation_order_customer_id

integer

Extension Attributes Vertex Tax Calculation Order Customer Id

extension_attributes_vertex_tax_calculation_order_customer_is_guest

bigdecimal

Extension Attributes Vertex Tax Calculation Order Customer Is Guest

extension_attributes_vertex_tax_calculation_order_customer_lastname

string

Extension Attributes Vertex Tax Calculation Order Customer Last Name

extension_attributes_vertex_tax_calculation_order_customer_middlename

string

Extension Attributes Vertex Tax Calculation Order Customer Middle Name

extension_attributes_vertex_tax_calculation_order_customer_note

string

Extension Attributes Vertex Tax Calculation Order Customer Note

extension_attributes_vertex_tax_calculation_order_customer_note_notify

bigdecimal

Extension Attributes Vertex Tax Calculation Order Customer Note Notify

extension_attributes_vertex_tax_calculation_order_customer_prefix

string

Extension Attributes Vertex Tax Calculation Order Customer Prefix

extension_attributes_vertex_tax_calculation_order_customer_suffix

string

Extension Attributes Vertex Tax Calculation Order Customer Suffix

extension_attributes_vertex_tax_calculation_order_customer_taxvat

string

Extension Attributes Vertex Tax Calculation Order Customer Tax Vat

extension_attributes_vertex_tax_calculation_order_discount_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Amount

extension_attributes_vertex_tax_calculation_order_discount_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Canceled

extension_attributes_vertex_tax_calculation_order_discount_description

string

Extension Attributes Vertex Tax Calculation Order Discount Description

extension_attributes_vertex_tax_calculation_order_discount_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Invoiced

extension_attributes_vertex_tax_calculation_order_discount_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Refunded

extension_attributes_vertex_tax_calculation_order_edit_increment

bigdecimal

Extension Attributes Vertex Tax Calculation Order Edit Increment

extension_attributes_vertex_tax_calculation_order_email_sent

bigdecimal

Extension Attributes Vertex Tax Calculation Order Email Sent

extension_attributes_vertex_tax_calculation_order_entity_id

integer

Extension Attributes Vertex Tax Calculation Order Entity Id

extension_attributes_vertex_tax_calculation_order_ext_customer_id

string

Extension Attributes Vertex Tax Calculation Order Ext Customer Id

extension_attributes_vertex_tax_calculation_order_ext_order_id

string

Extension Attributes Vertex Tax Calculation Order Ext Order Id

extension_attributes_vertex_tax_calculation_order_forced_shipment_with_invoice

bigdecimal

Extension Attributes Vertex Tax Calculation Order Forced Shipment With Invoice

extension_attributes_vertex_tax_calculation_order_global_currency_code

string

Extension Attributes Vertex Tax Calculation Order Global Currency Code

extension_attributes_vertex_tax_calculation_order_grand_total

bigdecimal

Extension Attributes Vertex Tax Calculation Order Grand Total

extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Amount

extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Invoiced

extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Refunded

extension_attributes_vertex_tax_calculation_order_hold_before_state

string

Extension Attributes Vertex Tax Calculation Order Hold Before State

extension_attributes_vertex_tax_calculation_order_hold_before_status

string

Extension Attributes Vertex Tax Calculation Order Hold Before Status

extension_attributes_vertex_tax_calculation_order_increment_id

string

Extension Attributes Vertex Tax Calculation Order Increment Id

extension_attributes_vertex_tax_calculation_order_is_virtual

bigdecimal

Extension Attributes Vertex Tax Calculation Order Is Virtual

extension_attributes_vertex_tax_calculation_order_order_currency_code

string

Extension Attributes Vertex Tax Calculation Order Currency Code

extension_attributes_vertex_tax_calculation_order_original_increment_id

string

Extension Attributes Vertex Tax Calculation Order Original Increment Id

extension_attributes_vertex_tax_calculation_order_payment_authorization_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Payment Authorization Amount

extension_attributes_vertex_tax_calculation_order_payment_auth_expiration

bigdecimal

Extension Attributes Vertex Tax Calculation Order Payment Auth Expiration

extension_attributes_vertex_tax_calculation_order_protect_code

string

Extension Attributes Vertex Tax Calculation Order Protect Code

extension_attributes_vertex_tax_calculation_order_quote_address_id

integer

Extension Attributes Vertex Tax Calculation Order Quote Address Id

extension_attributes_vertex_tax_calculation_order_quote_id

integer

Extension Attributes Vertex Tax Calculation Order Quote Id

extension_attributes_vertex_tax_calculation_order_relation_child_id

string

Extension Attributes Vertex Tax Calculation Order Relation Child Id

extension_attributes_vertex_tax_calculation_order_relation_child_real_id

string

Extension Attributes Vertex Tax Calculation Order Relation Child Real Id

extension_attributes_vertex_tax_calculation_order_relation_parent_id

string

Extension Attributes Vertex Tax Calculation Order Relation Parent Id

extension_attributes_vertex_tax_calculation_order_relation_parent_real_id

string

Extension Attributes Vertex Tax Calculation Order Relation Parent Real Id

extension_attributes_vertex_tax_calculation_order_remote_ip

string

Extension Attributes Vertex Tax Calculation Order Remote Ip

extension_attributes_vertex_tax_calculation_order_shipping_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Amount

extension_attributes_vertex_tax_calculation_order_shipping_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Canceled

extension_attributes_vertex_tax_calculation_order_shipping_description

string

Extension Attributes Vertex Tax Calculation Order Shipping Description

extension_attributes_vertex_tax_calculation_order_shipping_discount_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Discount Amount

extension_attributes_vertex_tax_calculation_order_shipping_discount_tax_compensation_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Discount Tax Compensation Amount

extension_attributes_vertex_tax_calculation_order_shipping_incl_tax

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Incl Tax

extension_attributes_vertex_tax_calculation_order_shipping_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Invoiced

extension_attributes_vertex_tax_calculation_order_shipping_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Refunded

extension_attributes_vertex_tax_calculation_order_shipping_tax_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Tax Amount

extension_attributes_vertex_tax_calculation_order_shipping_tax_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Shipping Tax Refunded

extension_attributes_vertex_tax_calculation_order_state

string

Extension Attributes Vertex Tax Calculation Order State

extension_attributes_vertex_tax_calculation_order_status

string

Extension Attributes Vertex Tax Calculation Order Status

extension_attributes_vertex_tax_calculation_order_store_currency_code

string

Extension Attributes Vertex Tax Calculation Order Store Currency Code

extension_attributes_vertex_tax_calculation_order_store_id

integer

Extension Attributes Vertex Tax Calculation Order Store Id

extension_attributes_vertex_tax_calculation_order_store_name

string

Extension Attributes Vertex Tax Calculation Order Store Name

extension_attributes_vertex_tax_calculation_order_store_to_base_rate

bigdecimal

Extension Attributes Vertex Tax Calculation Order Store To Base Rate

extension_attributes_vertex_tax_calculation_order_store_to_order_rate

bigdecimal

Extension Attributes Vertex Tax Calculation Order Store To Order Rate

extension_attributes_vertex_tax_calculation_order_subtotal

bigdecimal

Extension Attributes Vertex Tax Calculation Order Subtotal

extension_attributes_vertex_tax_calculation_order_subtotal_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Subtotal Canceled

extension_attributes_vertex_tax_calculation_order_subtotal_incl_tax

bigdecimal

Extension Attributes Vertex Tax Calculation Order Subtotal Incl Tax

extension_attributes_vertex_tax_calculation_order_subtotal_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Subtotal Invoiced

extension_attributes_vertex_tax_calculation_order_subtotal_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Subtotal Refunded

extension_attributes_vertex_tax_calculation_order_tax_amount

bigdecimal

Extension Attributes Vertex Tax Calculation Order Tax Amount

extension_attributes_vertex_tax_calculation_order_tax_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Tax Canceled

extension_attributes_vertex_tax_calculation_order_tax_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Tax Invoiced

extension_attributes_vertex_tax_calculation_order_tax_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Tax Refunded

extension_attributes_vertex_tax_calculation_order_total_canceled

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Canceled

extension_attributes_vertex_tax_calculation_order_total_due

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Due

extension_attributes_vertex_tax_calculation_order_total_invoiced

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Invoiced

extension_attributes_vertex_tax_calculation_order_total_item_count

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Item Count

extension_attributes_vertex_tax_calculation_order_total_offline_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Offline Refunded

extension_attributes_vertex_tax_calculation_order_total_online_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Online Refunded

extension_attributes_vertex_tax_calculation_order_total_paid

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Paid

extension_attributes_vertex_tax_calculation_order_total_qty_ordered

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Qty Ordered

extension_attributes_vertex_tax_calculation_order_total_refunded

bigdecimal

Extension Attributes Vertex Tax Calculation Order Total Refunded

extension_attributes_vertex_tax_calculation_order_updated_at

string

Extension Attributes Vertex Tax Calculation Order Updated At

extension_attributes_vertex_tax_calculation_order_weight

bigdecimal

Extension Attributes Vertex Tax Calculation Order Weight

extension_attributes_vertex_tax_calculation_order_x_forwarded_for

string

Extension Attributes Vertex Tax Calculation Order X Forwarded For

Example

SQL
CREATE VIEW magento_examples.example_Invoices
AS 
SELECT * FROM magento.Invoices (
	preview => TRUE
)

Orders

Orders
Parameter
<order_id> (optional): Return single order, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

adjustment_negative

bigdecimal

Adjustment Negative

adjustment_positive

bigdecimal

Adjustment Positive

applied_rule_ids

string

Applied Rule Ids

base_adjustment_negative

bigdecimal

Base Adjustment Negative

base_adjustment_positive

bigdecimal

Base Adjustment Positive

base_currency_code

string

Base Currency Code

base_discount_amount

bigdecimal

Base Discount Amount

base_discount_canceled

bigdecimal

Base Discount Canceled

base_discount_invoiced

bigdecimal

Base Discount Invoiced

base_discount_refunded

bigdecimal

Base Discount Refunded

base_grand_total

bigdecimal

Base Grand Total

base_discount_tax_compensation_amount

bigdecimal

Base Discount Tax Compensation Amount

base_discount_tax_compensation_invoiced

bigdecimal

Base discount tax compensation invoiced

base_discount_tax_compensation_refunded

bigdecimal

Base Discount Tax Compensation Refunded

base_shipping_amount

bigdecimal

Base Shipping Amount

base_shipping_canceled

bigdecimal

Base Shipping Canceled

base_shipping_discount_amount

bigdecimal

Base Shipping Discount Amount

base_shipping_discount_tax_compensation_amnt

bigdecimal

Base Shipping Discount Tax Compensation Amnt

base_shipping_incl_tax

bigdecimal

Base Shipping Incl Tax

base_shipping_invoiced

bigdecimal

Base Shipping Invoiced

base_shipping_refunded

bigdecimal

Base Shipping Refunded

base_shipping_tax_amount

bigdecimal

Base Shipping Tax Amount

base_shipping_tax_refunded

bigdecimal

Base Shipping Tax Refunded

base_subtotal

bigdecimal

Base Subtotal

base_subtotal_canceled

bigdecimal

Base Subtotal Canceled

base_subtotal_incl_tax

bigdecimal

Base Subtotal Incl Tax

base_subtotal_invoiced

bigdecimal

Base Subtotal Invoiced

base_subtotal_refunded

bigdecimal

Base Subtotal Refunded

base_tax_amount

bigdecimal

Base Tax Amount

base_tax_canceled

bigdecimal

Base Tax Canceled

base_tax_invoiced

bigdecimal

Base Tax Invoiced

base_tax_refunded

bigdecimal

Base Tax Refunded

base_total_canceled

bigdecimal

Base Total Canceled

base_total_due

bigdecimal

Base Total Due

base_total_invoiced

bigdecimal

Base Total Invoiced

base_total_invoiced_cost

bigdecimal

Base Total Invoiced Cost

base_total_offline_refunded

bigdecimal

Base Total Offline Refunded

base_total_online_refunded

bigdecimal

Base Total Online Refunded

base_total_paid

bigdecimal

Base Total Paid

base_total_qty_ordered

bigdecimal

Base Total Qty Ordered

base_total_refunded

bigdecimal

Base Total Refunded

base_to_global_rate

bigdecimal

Base To Global Rate

base_to_order_rate

bigdecimal

Base To Order Rate

billing_address_id

bigdecimal

Billing Address Id

can_ship_partially

bigdecimal

Can Ship Partially

can_ship_partially_item

bigdecimal

Can Ship Partially Item

coupon_code

string

Coupon Code

created_at

timestamp

Created At

customer_dob

string

Customer DOB

customer_email

string

Customer Email

customer_firstname

string

Customer First Name

customer_gender

bigdecimal

Customer Gender

customer_group_id

bigdecimal

Customer Group Id

customer_id

bigdecimal

Customer Id

customer_is_guest

bigdecimal

Customer Is Guest

customer_lastname

string

Customer Last Name

customer_middlename

string

Customer Middle Name

customer_note

string

Customer Note

customer_note_notify

bigdecimal

Customer Note Notify

customer_prefix

string

Customer Prefix

customer_suffix

string

Customer Suffix

customer_taxvat

string

Customer Tax Vat

discount_amount

bigdecimal

Discount Amount

discount_canceled

bigdecimal

Discount Canceled

discount_description

string

Discount Description

discount_invoiced

bigdecimal

Discount Invoiced

discount_refunded

bigdecimal

Discount Refunded

edit_increment

bigdecimal

Edit Increment

email_sent

bigdecimal

Email Sent

entity_id

integer

Entity Id

ext_customer_id

string

Ext Customer Id

ext_order_id

string

Ext Order Id

forced_shipment_with_invoice

bigdecimal

Forced Shipment With Invoice

global_currency_code

string

Global Currency Code

grand_total

bigdecimal

Grand Total

discount_tax_compensation_amount

bigdecimal

Discount Tax Compensation Amount

discount_tax_compensation_invoiced

bigdecimal

Discount Tax Compensation Invoiced

discount_tax_compensation_refunded

bigdecimal

Discount Tax Compensation Refunded

hold_before_state

string

Hold Before State

hold_before_status

string

Hold Before Status

increment_id

string

Increment Id

is_virtual

bigdecimal

Is Virtual

order_currency_code

string

Order Currency Code

original_increment_id

string

Original Increment Id

payment_authorization_amount

bigdecimal

Payment Authorization Amount

payment_auth_expiration

bigdecimal

Payment Auth Expiration

protect_code

string

Protect Code

quote_address_id

bigdecimal

Quote Address Id

quote_id

bigdecimal

Quote Id

relation_child_id

string

Relation Child Id

relation_child_real_id

string

Relation Child Real Id

relation_parent_id

string

Relation Parent Id

relation_parent_real_id

string

Relation Parent Real Id

remote_ip

string

Remote Ip

shipping_amount

bigdecimal

Shipping Amount

shipping_canceled

bigdecimal

Shipping Canceled

shipping_description

string

Shipping Description

shipping_discount_amount

bigdecimal

Shipping Discount Amount

shipping_discount_tax_compensation_amount

bigdecimal

Shipping Discount Tax Compensation Amount

shipping_incl_tax

bigdecimal

Shipping Incl Tax

shipping_invoiced

bigdecimal

Shipping Invoiced

shipping_refunded

bigdecimal

Shipping Refunded

shipping_tax_amount

bigdecimal

Shipping Tax Amount

shipping_tax_refunded

bigdecimal

Shipping Tax Refunded

state

string

State

status

string

Status

store_currency_code

string

Store Currency Code

store_id

bigdecimal

Store Id

store_name

string

Store Name

store_to_base_rate

bigdecimal

Store To Base Rate

store_to_order_rate

bigdecimal

Store To Order Rate

subtotal

bigdecimal

Subtotal

subtotal_canceled

bigdecimal

Subtotal Canceled

subtotal_incl_tax

bigdecimal

Subtotal Incl Tax

subtotal_invoiced

bigdecimal

Subtotal Invoiced

subtotal_refunded

bigdecimal

Subtotal Refunded

tax_amount

bigdecimal

Tax Amount

tax_canceled

bigdecimal

Tax Canceled

tax_invoiced

bigdecimal

Tax Invoiced

tax_refunded

bigdecimal

Tax Refunded

total_canceled

bigdecimal

Total Canceled

total_due

bigdecimal

Total Due

total_invoiced

bigdecimal

Total Invoiced

total_item_count

bigdecimal

Total Item Count

total_offline_refunded

bigdecimal

Total Offline Refunded

total_online_refunded

bigdecimal

Total Online Refunded

total_paid

bigdecimal

Total Paid

total_qty_ordered

bigdecimal

Total Qty Ordered

total_refunded

bigdecimal

Total Refunded

updated_at

timestamp

Updated At

weight

bigdecimal

Weight

x_forwarded_for

string

X Forwarded For

billing_address_address_type

string

Billing Address Type

billing_address_city

string

Billing Address City

billing_address_company

string

Billing Address Company

billing_address_country_id

string

Billing Address Country Id

billing_address_customer_address_id

bigdecimal

Billing Address Customer Address Id

billing_address_customer_id

integer

Billing Address Customer Id

billing_address_email

string

Billing Address Email

billing_address_entity_id

integer

Billing Address Entity Id

billing_address_fax

string

Billing Address Fax

billing_address_firstname

string

Billing Address First Name

billing_address_lastname

string

Billing Address Last Name

billing_address_middlename

string

Billing Address Middle Name

billing_address_parent_id

integer

Billing Address Parent Id

billing_address_postcode

string

Billing Address Postcode

billing_address_prefix

string

Billing Address Prefix

billing_address_region

string

Billing Address Region

billing_address_region_code

string

Billing Address Region Code

billing_address_region_id

integer

Billing Address Region Id

billing_address_street

string

Billing Address Street

billing_address_suffix

string

Billing Address Suffix

billing_address_telephone

string

Billing Address Telephone

billing_address_vat_id

string

Billing Address Vat Id

billing_address_vat_is_valid

bigdecimal

Billing Address Vat Is Valid

billing_address_vat_request_date

string

Billing Address Vat Request Date

billing_address_vat_request_id

string

Billing Address Vat Request Id

billing_address_vat_request_success

bigdecimal

Billing Address Vat Request Success

billing_address_extension_attributes_vertex_vat_country_code

string

Billing Address Extension Attributes Vertex Vat Country Code

payment_account_status

string

Payment Account Status

payment_additional_data

string

Payment Additional Data

payment_additional_information

string

Payment Additional Information

payment_address_status

string

Payment Address Status

payment_amount_authorized

bigdecimal

Payment Amount Authorized

payment_amount_canceled

bigdecimal

Payment Amount Canceled

payment_amount_ordered

bigdecimal

Payment Amount Ordered

payment_amount_paid

bigdecimal

Payment Amount Paid

payment_amount_refunded

bigdecimal

Payment Amount Refunded

payment_anet_trans_method

string

Payment Anet Trans Method

payment_base_amount_authorized

bigdecimal

Payment Base Amount Authorized

payment_base_amount_canceled

bigdecimal

Payment Base Amount Canceled

payment_base_amount_ordered

bigdecimal

Payment Base Amount Ordered

payment_base_amount_paid

bigdecimal

Payment Base Amount Paid

payment_base_amount_paid_online

bigdecimal

Payment Base Amount Paid Online

payment_base_amount_refunded

bigdecimal

Payment Base Amount Refunded

payment_base_amount_refunded_online

bigdecimal

Payment Base Amount Refunded Online

payment_base_shipping_amount

bigdecimal

Payment Base Shipping Amount

payment_base_shipping_captured

bigdecimal

Payment Base Shipping Captured

payment_base_shipping_refunded

bigdecimal

Payment Base Shipping Refunded

payment_cc_approval

string

Payment Cc Approval

payment_cc_avs_status

string

Payment Cc Avs Status

payment_cc_cid_status

string

Payment Cc Cid Status

payment_cc_debug_request_body

string

Payment Cc Debug Request Body

payment_cc_debug_response_body

string

Payment Cc Debug Response Body

payment_cc_debug_response_serialized

string

Payment Cc Debug Response Serialized

payment_cc_exp_month

string

Payment Cc Exp Month

payment_cc_exp_year

string

Payment Cc Exp Year

payment_cc_last4

string

Payment Cc Last4

payment_cc_number_enc

string

Payment Cc Number Enc

payment_cc_owner

string

Payment Cc Owner

payment_cc_secure_verify

string

Payment Cc Secure Verify

payment_cc_ss_issue

string

Payment Cc Ss Issue

payment_cc_ss_start_month

string

Payment Cc Ss Start Month

payment_cc_ss_start_year

string

Payment Cc Ss Start Year

payment_cc_status

string

Payment Cc Status

payment_cc_status_description

string

Payment Cc Status Description

payment_cc_trans_id

string

Payment Cc Trans Id

payment_cc_type

string

Payment Cc Type

payment_echeck_account_name

string

Payment Echeck Account Name

payment_echeck_account_type

string

Payment Echeck Account Type

payment_echeck_bank_name

string

Payment Echeck Bank Name

payment_echeck_routing_number

string

Payment Echeck Routing Number

payment_echeck_type

string

Payment Echeck Type

payment_entity_id

integer

Payment Entity Id

payment_last_trans_id

string

Payment Last Trans Id

payment_method

string

Payment Method

payment_parent_id

integer

Payment Parent Id

payment_po_number

string

Payment Po Number

payment_protection_eligibility

string

Payment Protection Eligibility

payment_quote_payment_id

bigdecimal

Payment Quote Payment Id

payment_shipping_amount

bigdecimal

Payment Shipping Amount

payment_shipping_captured

bigdecimal

Payment Shipping Captured

payment_shipping_refunded

bigdecimal

Payment Shipping Refunded

payment_extension_attributes_notification_message

string

Payment Extension Attributes Notification Message

payment_extension_attributes_vault_payment_token_entity_id

integer

Payment Extension Attributes Vault Payment Token Entity Id

payment_extension_attributes_vault_payment_token_customer_id

bigdecimal

Payment Extension Attributes Vault Payment Token Customer Id

payment_extension_attributes_vault_payment_token_public_hash

string

Payment Extension Attributes Vault Payment Token Public Hash

payment_extension_attributes_vault_payment_token_payment_method_code

string

Payment Extension Attributes Vault Payment Token Payment Method Code

payment_extension_attributes_vault_payment_token_type

string

Payment Extension Attributes Vault Payment Token Type

payment_extension_attributes_vault_payment_token_created_at

timestamp

Payment Extension Attributes Vault Payment Token Created At

payment_extension_attributes_vault_payment_token_expires_at

string

Payment Extension Attributes Vault Payment Token Expires At

payment_extension_attributes_vault_payment_token_gateway_token

string

Payment Extension Attributes Vault Payment Token Gateway Token

payment_extension_attributes_vault_payment_token_token_details

string

Payment Extension Attributes Vault Payment Token Token Details

payment_extension_attributes_vault_payment_token_is_active

boolean

Payment Extension Attributes Vault Payment Token Is Active

payment_extension_attributes_vault_payment_token_is_visible

boolean

Payment Extension Attributes Vault Payment Token Is Visible

Example

SQL
CREATE VIEW magento_examples.example_Orders
AS 
SELECT * FROM magento.Orders (
	preview => TRUE
)

OrdersItems

OrdersItems
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

additional_data

string

Additional Data

amount_refunded

bigdecimal

Amount Refunded

applied_rule_ids

string

Applied Rule Ids

base_amount_refunded

bigdecimal

Base Amount Refunded

base_cost

bigdecimal

Base Cost

base_discount_amount

bigdecimal

Base Discount Amount

base_discount_invoiced

bigdecimal

Base Discount Invoiced

base_discount_refunded

bigdecimal

Base Discount Refunded

base_discount_tax_compensation_amount

bigdecimal

Base Discount Tax Compensation Amount

base_discount_tax_compensation_invoiced

bigdecimal

Base Discount Tax Compensation Invoiced

base_discount_tax_compensation_refunded

bigdecimal

Base Discount Tax Compensation Refunded

base_original_price

bigdecimal

Base Original Price

base_price

bigdecimal

Base Price

base_price_incl_tax

bigdecimal

Base Price Incl Tax

base_row_invoiced

bigdecimal

Base Row Invoiced

base_row_total

bigdecimal

Base Row Total

base_row_total_incl_tax

bigdecimal

Base Row Total Incl Tax

base_tax_amount

bigdecimal

Base Tax Amount

base_tax_before_discount

bigdecimal

Base Tax Before Discount

base_tax_invoiced

bigdecimal

Base Tax Invoiced

base_tax_refunded

bigdecimal

Base Tax Refunded

base_weee_tax_applied_amount

bigdecimal

Base Weee Tax Applied Amount

base_weee_tax_applied_row_amnt

bigdecimal

Base Weee Tax Applied Row Amnt

base_weee_tax_disposition

bigdecimal

Base Weee Tax Disposition

base_weee_tax_row_disposition

bigdecimal

Base Weee Tax Row Disposition

created_at

timestamp

Created At

description

string

Description

discount_amount

bigdecimal

Discount Amount

discount_invoiced

bigdecimal

Discount Invoiced

discount_percent

bigdecimal

Discount Percent

discount_refunded

bigdecimal

Discount Refunded

discount_tax_compensation_amount

bigdecimal

Discount Tax Compensation Amount

discount_tax_compensation_canceled

bigdecimal

Discount Tax Compensation Canceled

discount_tax_compensation_invoiced

bigdecimal

Discount Tax Compensation Invoiced

discount_tax_compensation_refunded

bigdecimal

Discount Tax Compensation Refunded

event_id

bigdecimal

Event Id

ext_order_item_id

string

Ext Order Item Id

gift_message_customer_id

bigdecimal

Gift Message Customer Id

extension_attributes_entity_id

string

Extension Attributes Entity Id

extension_attributes_entity_type

string

Extension Attributes Entity Type

extension_attributes_wrapping_add_printed_card

boolean

Extension Attributes Wrapping Add Printed Card

extension_attributes_wrapping_allow_gift_receipt

boolean

Extension Attributes Wrapping Allow Gift Receipt

extension_attributes_wrapping_id

bigdecimal

Extension Attributes Wrapping Id

gift_message_gift_message_id

bigdecimal

Gift Message Gift Message Id

gift_message_message

string

Gift Message Message

gift_message_recipient

string

Gift Message Recipient

gift_message_sender

string

Gift Message Sender

extension_attributes_gw_base_price

string

Extension Attributes Gw Base Price

extension_attributes_gw_base_price_invoiced

string

Extension Attributes Gw Base Price Invoiced

extension_attributes_gw_base_price_refunded

string

Extension Attributes Gw Base Price Refunded

extension_attributes_gw_base_tax_amount

string

Extension Attributes Gw Base Tax Amount

extension_attributes_gw_base_tax_amount_invoiced

string

Extension Attributes Gw Base Tax Amount Invoiced

extension_attributes_gw_base_tax_amount_refunded

string

Extension Attributes Gw Base Tax Amount Refunded

extension_attributes_gw_id

string

Extension Attributes Gw Id

extension_attributes_gw_price

string

Extension Attributes Gw Price

extension_attributes_gw_price_invoiced

string

Extension Attributes Gw Price Invoiced

extension_attributes_gw_price_refunded

string

Extension Attributes Gw Price Refunded

extension_attributes_gw_tax_amount

string

Extension Attributes Gw Tax Amount

extension_attributes_gw_tax_amount_invoiced

string

Extension Attributes Gw Tax Amount Invoiced

extension_attributes_gw_tax_amount_refunded

string

Extension Attributes Gw Tax Amount Refunded

free_shipping

bigdecimal

Free Shipping

gw_base_price

bigdecimal

Gw Base Price

gw_base_price_invoiced

bigdecimal

Gw Base Price Invoiced

gw_base_price_refunded

bigdecimal

Gw Base Price Refunded

gw_base_tax_amount

bigdecimal

Gw Base Tax Amount

gw_base_tax_amount_invoiced

bigdecimal

Gw Base Tax Amount Invoiced

gw_base_tax_amount_refunded

bigdecimal

Gw Base Tax Amount Refunded

gw_id

bigdecimal

Gw Id

gw_price

bigdecimal

Gw Price

gw_price_invoiced

bigdecimal

Gw Price Invoiced

gw_price_refunded

bigdecimal

Gw PRICE REFUNDED

gw_tax_amount

bigdecimal

Gw Tax Amount

gw_tax_amount_invoiced

bigdecimal

Gw Tax Amount Invoiced

gw_tax_amount_refunded

bigdecimal

Gw Tax Amount Refunded

is_qty_decimal

bigdecimal

Is Qty Decimal

is_virtual

bigdecimal

Is Virtual

item_id

integer

Item Id

locked_do_invoice

bigdecimal

Locked Do Invoice

locked_do_ship

bigdecimal

Locked Do Ship

name

string

Name

no_discount

bigdecimal

No Discount

order_id

bigdecimal

Order Id

original_price

bigdecimal

Original Price

parent_item

clob

Parent Item

parent_item_id

bigdecimal

Parent Item Id

price

bigdecimal

Price

price_incl_tax

bigdecimal

Price Incl Tax

product_id

bigdecimal

Product Id

product_option

clob

Product Option

product_type

string

Product Type

qty_backordered

bigdecimal

Qty Backordered

qty_canceled

bigdecimal

Qty Canceled

qty_invoiced

bigdecimal

Qty Invoiced

qty_ordered

bigdecimal

Qty Ordered

qty_refunded

bigdecimal

Qty Refunded

qty_returned

bigdecimal

Qty Returned

qty_shipped

bigdecimal

Qty Shipped

quote_item_id

bigdecimal

Quote Item Id

row_invoiced

bigdecimal

Row Invoiced

row_total

bigdecimal

Row Total

row_total_incl_tax

bigdecimal

Row Total Incl Tax

row_weight

bigdecimal

Row Weight

sku

string

Sku

store_id

bigdecimal

Store Id

tax_amount

bigdecimal

Tax Amount

tax_before_discount

bigdecimal

Tax Before Discount

tax_canceled

bigdecimal

Tax Canceled

tax_invoiced

bigdecimal

Tax Invoiced

tax_percent

bigdecimal

Tax Percent

tax_refunded

bigdecimal

Tax Refunded

updated_at

timestamp

Updated At

weee_tax_applied

string

Weee Tax Applied

weee_tax_applied_amount

bigdecimal

Weee Tax Applied Amount

weee_tax_applied_row_amount

bigdecimal

Weee Tax Applied Row Amount

weee_tax_disposition

bigdecimal

Weee Tax Disposition

weee_tax_row_disposition

bigdecimal

Weee Tax Row Disposition

weight

bigdecimal

Weight

Example

SQL
CREATE VIEW magento_examples.example_OrdersItems
AS 
SELECT * FROM magento.OrdersItems (
	preview => TRUE
)

Products

Products
Parameter
<sku> (optional): Return single product, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

integer

Product Id

sku

string

SKU

name

string

Name

attribute_set_id

integer

Attribute Set Id

price

bigdecimal

Price

status

integer

Status

visibility

boolean

Visibility

type_id

string

Type Id

created_at

timestamp

Created At

updated_at

timestamp

Updated At

weight

bigdecimal

Weight

Example

SQL
CREATE VIEW magento_examples.example_Products
AS 
SELECT * FROM magento.Products (
	preview => TRUE
)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.