Windsor brings all your Square data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Square Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
bank_accounts__account_number_suffix | TEXT | bank_accounts.account_number_suffix | bank_accounts.account_number_suffix | bank_accounts |
bank_accounts__account_type | TEXT | bank_accounts.account_type | bank_accounts.account_type | bank_accounts |
bank_accounts__bank_name | TEXT | bank_accounts.bank_name | bank_accounts.bank_name | bank_accounts |
bank_accounts__country | TEXT | bank_accounts.country | bank_accounts.country | bank_accounts |
bank_accounts__creditable | BOOLEAN | bank_accounts.creditable | bank_accounts.creditable | bank_accounts |
bank_accounts__currency | TEXT | bank_accounts.currency | bank_accounts.currency | bank_accounts |
bank_accounts__debitable | BOOLEAN | bank_accounts.debitable | bank_accounts.debitable | bank_accounts |
bank_accounts__holder_name | TEXT | bank_accounts.holder_name | bank_accounts.holder_name | bank_accounts |
bank_accounts__id | TEXT | bank_accounts.id | bank_accounts.id | bank_accounts |
bank_accounts__location_id | TEXT | bank_accounts.location_id | bank_accounts.location_id | bank_accounts |
bank_accounts__primary_bank_identification_number | TEXT | bank_accounts.primary_bank_identification_number | bank_accounts.primary_bank_identification_number | bank_accounts |
bank_accounts__status | TEXT | bank_accounts.status | bank_accounts.status | bank_accounts |
bank_accounts__version | NUMERIC | bank_accounts.version | bank_accounts.version | bank_accounts |
cash_drawers__closed_at | TIMESTAMP | cash_drawers.closed_at | cash_drawers.closed_at | cash_drawers |
cash_drawers__closed_cash_money | OBJECT | cash_drawers.closed_cash_money | cash_drawers.closed_cash_money | cash_drawers |
cash_drawers__description | TEXT | cash_drawers.description | cash_drawers.description | cash_drawers |
cash_drawers__ended_at | TIMESTAMP | cash_drawers.ended_at | cash_drawers.ended_at | cash_drawers |
cash_drawers__expected_cash_money | OBJECT | cash_drawers.expected_cash_money | cash_drawers.expected_cash_money | cash_drawers |
cash_drawers__id | TEXT | cash_drawers.id | cash_drawers.id | cash_drawers |
cash_drawers__opened_at | TIMESTAMP | cash_drawers.opened_at | cash_drawers.opened_at | cash_drawers |
cash_drawers__opened_cash_money | OBJECT | cash_drawers.opened_cash_money | cash_drawers.opened_cash_money | cash_drawers |
cash_drawers__state | TEXT | cash_drawers.state | cash_drawers.state | cash_drawers |
categories__category_data | OBJECT | categories.category_data | categories.category_data | categories |
categories__id | TEXT | categories.id | categories.id | categories |
categories__is_deleted | BOOLEAN | categories.is_deleted | categories.is_deleted | categories |
categories__present_at_all_locations | BOOLEAN | categories.present_at_all_locations | categories.present_at_all_locations | categories |
categories__type | TEXT | categories.type | categories.type | categories |
categories__updated_at | TIMESTAMP | categories.updated_at | categories.updated_at | categories |
categories__version | NUMERIC | categories.version | categories.version | categories |
customers__address | OBJECT | customers.address | customers.address | customers |
customers__birthday | TEXT | customers.birthday | customers.birthday | customers |
customers__cards | OBJECT | customers.cards | customers.cards | customers |
customers__company_name | TEXT | customers.company_name | customers.company_name | customers |
customers__created_at | TIMESTAMP | customers.created_at | customers.created_at | customers |
customers__creation_source | TEXT | customers.creation_source | customers.creation_source | customers |
customers__email_address | TEXT | customers.email_address | customers.email_address | customers |
customers__family_name | TEXT | customers.family_name | customers.family_name | customers |
customers__given_name | TEXT | customers.given_name | customers.given_name | customers |
customers__group_ids | OBJECT | customers.group_ids | customers.group_ids | customers |
customers__id | TEXT | customers.id | customers.id | customers |
customers__phone_number | TEXT | customers.phone_number | customers.phone_number | customers |
customers__preferences | OBJECT | customers.preferences | customers.preferences | customers |
customers__reference_id | TEXT | customers.reference_id | customers.reference_id | customers |
customers__segment_ids | OBJECT | customers.segment_ids | customers.segment_ids | customers |
customers__updated_at | TIMESTAMP | customers.updated_at | customers.updated_at | customers |
customers__version | NUMERIC | customers.version | customers.version | customers |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
discounts__discount_data | OBJECT | discounts.discount_data | discounts.discount_data | discounts |
discounts__id | TEXT | discounts.id | discounts.id | discounts |
discounts__is_deleted | BOOLEAN | discounts.is_deleted | discounts.is_deleted | discounts |
discounts__present_at_all_locations | BOOLEAN | discounts.present_at_all_locations | discounts.present_at_all_locations | discounts |
discounts__present_at_location_ids | OBJECT | discounts.present_at_location_ids | discounts.present_at_location_ids | discounts |
discounts__type | TEXT | discounts.type | discounts.type | discounts |
discounts__updated_at | TIMESTAMP | discounts.updated_at | discounts.updated_at | discounts |
discounts__version | NUMERIC | discounts.version | discounts.version | discounts |
inventory__calculated_at | TIMESTAMP | inventory.calculated_at | inventory.calculated_at | inventory |
inventory__catalog_object_id | TEXT | inventory.catalog_object_id | inventory.catalog_object_id | inventory |
inventory__catalog_object_type | TEXT | inventory.catalog_object_type | inventory.catalog_object_type | inventory |
inventory__location_id | TEXT | inventory.location_id | inventory.location_id | inventory |
inventory__quantity | TEXT | inventory.quantity | inventory.quantity | inventory |
inventory__state | TEXT | inventory.state | inventory.state | inventory |
items__custom_attribute_values | OBJECT | items.custom_attribute_values | items.custom_attribute_values | items |
items__id | TEXT | items.id | items.id | items |
items__image_id | TEXT | items.image_id | items.image_id | items |
items__is_deleted | BOOLEAN | items.is_deleted | items.is_deleted | items |
items__item_data | OBJECT | items.item_data | items.item_data | items |
items__present_at_all_locations | BOOLEAN | items.present_at_all_locations | items.present_at_all_locations | items |
items__present_at_location_ids | OBJECT | items.present_at_location_ids | items.present_at_location_ids | items |
items__type | TEXT | items.type | items.type | items |
items__updated_at | TIMESTAMP | items.updated_at | items.updated_at | items |
items__version | NUMERIC | items.version | items.version | items |
locations__address | OBJECT | locations.address | locations.address | locations |
locations__business_email | TEXT | locations.business_email | locations.business_email | locations |
locations__business_hours | OBJECT | locations.business_hours | locations.business_hours | locations |
locations__business_name | TEXT | locations.business_name | locations.business_name | locations |
locations__capabilities | OBJECT | locations.capabilities | locations.capabilities | locations |
locations__country | TEXT | locations.country | locations.country | locations |
locations__created_at | TIMESTAMP | locations.created_at | locations.created_at | locations |
locations__currency | TEXT | locations.currency | locations.currency | locations |
locations__description | TEXT | locations.description | locations.description | locations |
locations__facebook_url | TEXT | locations.facebook_url | locations.facebook_url | locations |
locations__id | TEXT | locations.id | locations.id | locations |
locations__instagram_username | TEXT | locations.instagram_username | locations.instagram_username | locations |
locations__language_code | TEXT | locations.language_code | locations.language_code | locations |
locations__mcc | TEXT | locations.mcc | locations.mcc | locations |
locations__merchant_id | TEXT | locations.merchant_id | locations.merchant_id | locations |
locations__name | TEXT | locations.name | locations.name | locations |
locations__phone_number | TEXT | locations.phone_number | locations.phone_number | locations |
locations__status | TEXT | locations.status | locations.status | locations |
locations__timezone | TEXT | locations.timezone | locations.timezone | locations |
locations__twitter_username | TEXT | locations.twitter_username | locations.twitter_username | locations |
locations__type | TEXT | locations.type | locations.type | locations |
locations__website_url | TEXT | locations.website_url | locations.website_url | locations |
loyalty__balance | NUMERIC | loyalty.balance | loyalty.balance | loyalty |
loyalty__created_at | TIMESTAMP | loyalty.created_at | loyalty.created_at | loyalty |
loyalty__customer_id | TEXT | loyalty.customer_id | loyalty.customer_id | loyalty |
loyalty__id | TEXT | loyalty.id | loyalty.id | loyalty |
loyalty__lifetime_points | NUMERIC | loyalty.lifetime_points | loyalty.lifetime_points | loyalty |
loyalty__mapping | OBJECT | loyalty.mapping | loyalty.mapping | loyalty |
loyalty__program_id | TEXT | loyalty.program_id | loyalty.program_id | loyalty |
loyalty__updated_at | TIMESTAMP | loyalty.updated_at | loyalty.updated_at | loyalty |
modifier_list__id | TEXT | modifier_list.id | modifier_list.id | modifier_list |
modifier_list__is_deleted | BOOLEAN | modifier_list.is_deleted | modifier_list.is_deleted | modifier_list |
modifier_list__modifier_list_data | OBJECT | modifier_list.modifier_list_data | modifier_list.modifier_list_data | modifier_list |
modifier_list__present_at_all_locations | BOOLEAN | modifier_list.present_at_all_locations | modifier_list.present_at_all_locations | modifier_list |
modifier_list__type | TEXT | modifier_list.type | modifier_list.type | modifier_list |
modifier_list__updated_at | TIMESTAMP | modifier_list.updated_at | modifier_list.updated_at | modifier_list |
modifier_list__version | NUMERIC | modifier_list.version | modifier_list.version | modifier_list |
orders__closed_at | TIMESTAMP | orders.closed_at | orders.closed_at | orders |
orders__created_at | TIMESTAMP | orders.created_at | orders.created_at | orders |
orders__customer_id | TEXT | orders.customer_id | orders.customer_id | orders |
orders__discounts | OBJECT | orders.discounts | orders.discounts | orders |
orders__fulfillments | OBJECT | orders.fulfillments | orders.fulfillments | orders |
orders__id | TEXT | orders.id | orders.id | orders |
orders__line_items | OBJECT | orders.line_items | orders.line_items | orders |
orders__location_id | TEXT | orders.location_id | orders.location_id | orders |
orders__net_amounts | OBJECT | orders.net_amounts | orders.net_amounts | orders |
orders__refunds | OBJECT | orders.refunds | orders.refunds | orders |
orders__return_amounts | OBJECT | orders.return_amounts | orders.return_amounts | orders |
orders__returns | OBJECT | orders.returns | orders.returns | orders |
orders__service_charges | OBJECT | orders.service_charges | orders.service_charges | orders |
orders__source | OBJECT | orders.source | orders.source | orders |
orders__state | TEXT | orders.state | orders.state | orders |
orders__taxes | OBJECT | orders.taxes | orders.taxes | orders |
orders__tenders | OBJECT | orders.tenders | orders.tenders | orders |
orders__total_discount_money | OBJECT | orders.total_discount_money | orders.total_discount_money | orders |
orders__total_money | OBJECT | orders.total_money | orders.total_money | orders |
orders__total_service_charge_money | OBJECT | orders.total_service_charge_money | orders.total_service_charge_money | orders |
orders__total_tax_money | OBJECT | orders.total_tax_money | orders.total_tax_money | orders |
orders__total_tip_money | OBJECT | orders.total_tip_money | orders.total_tip_money | orders |
orders__updated_at | TIMESTAMP | orders.updated_at | orders.updated_at | orders |
orders__version | NUMERIC | orders.version | orders.version | orders |
payments__amount_money | OBJECT | payments.amount_money | payments.amount_money | payments |
payments__approved_money | OBJECT | payments.approved_money | payments.approved_money | payments |
payments__card_details | OBJECT | payments.card_details | payments.card_details | payments |
payments__created_at | TIMESTAMP | payments.created_at | payments.created_at | payments |
payments__customer_id | TEXT | payments.customer_id | payments.customer_id | payments |
payments__delay_action | TEXT | payments.delay_action | payments.delay_action | payments |
payments__delay_duration | TEXT | payments.delay_duration | payments.delay_duration | payments |
payments__delayed_until | TEXT | payments.delayed_until | payments.delayed_until | payments |
payments__employee_id | TEXT | payments.employee_id | payments.employee_id | payments |
payments__id | TEXT | payments.id | payments.id | payments |
payments__location_id | TEXT | payments.location_id | payments.location_id | payments |
payments__note | TEXT | payments.note | payments.note | payments |
payments__order_id | TEXT | payments.order_id | payments.order_id | payments |
payments__processing_fee | OBJECT | payments.processing_fee | payments.processing_fee | payments |
payments__receipt_number | TEXT | payments.receipt_number | payments.receipt_number | payments |
payments__receipt_url | TEXT | payments.receipt_url | payments.receipt_url | payments |
payments__refund_ids | OBJECT | payments.refund_ids | payments.refund_ids | payments |
payments__refunded_money | OBJECT | payments.refunded_money | payments.refunded_money | payments |
payments__risk_evaluation | OBJECT | payments.risk_evaluation | payments.risk_evaluation | payments |
payments__source_type | TEXT | payments.source_type | payments.source_type | payments |
payments__status | TEXT | payments.status | payments.status | payments |
payments__total_money | OBJECT | payments.total_money | payments.total_money | payments |
payments__updated_at | TIMESTAMP | payments.updated_at | payments.updated_at | payments |
payments__version_token | TEXT | payments.version_token | payments.version_token | payments |
refunds__amount_money | OBJECT | refunds.amount_money | refunds.amount_money | refunds |
refunds__created_at | TIMESTAMP | refunds.created_at | refunds.created_at | refunds |
refunds__id | TEXT | refunds.id | refunds.id | refunds |
refunds__location_id | TEXT | refunds.location_id | refunds.location_id | refunds |
refunds__order_id | TEXT | refunds.order_id | refunds.order_id | refunds |
refunds__payment_id | TEXT | refunds.payment_id | refunds.payment_id | refunds |
refunds__processing_fee | OBJECT | refunds.processing_fee | refunds.processing_fee | refunds |
refunds__reason | TEXT | refunds.reason | refunds.reason | refunds |
refunds__status | TEXT | refunds.status | refunds.status | refunds |
refunds__updated_at | TIMESTAMP | refunds.updated_at | refunds.updated_at | refunds |
shifts__breaks | OBJECT | shifts.breaks | shifts.breaks | shifts |
shifts__created_at | TIMESTAMP | shifts.created_at | shifts.created_at | shifts |
shifts__employee_id | TEXT | shifts.employee_id | shifts.employee_id | shifts |
shifts__end_at | TIMESTAMP | shifts.end_at | shifts.end_at | shifts |
shifts__id | TEXT | shifts.id | shifts.id | shifts |
shifts__location_id | TEXT | shifts.location_id | shifts.location_id | shifts |
shifts__start_at | TIMESTAMP | shifts.start_at | shifts.start_at | shifts |
shifts__status | TEXT | shifts.status | shifts.status | shifts |
shifts__team_member_id | TEXT | shifts.team_member_id | shifts.team_member_id | shifts |
shifts__timezone | TEXT | shifts.timezone | shifts.timezone | shifts |
shifts__updated_at | TIMESTAMP | shifts.updated_at | shifts.updated_at | shifts |
shifts__version | NUMERIC | shifts.version | shifts.version | shifts |
shifts__wage | OBJECT | shifts.wage | shifts.wage | shifts |
source | TEXT | Source | The name of the Windsor connector returning the row | |
taxes__absent_at_location_ids | OBJECT | taxes.absent_at_location_ids | taxes.absent_at_location_ids | taxes |
taxes__id | TEXT | taxes.id | taxes.id | taxes |
taxes__is_deleted | BOOLEAN | taxes.is_deleted | taxes.is_deleted | taxes |
taxes__present_at_all_locations | BOOLEAN | taxes.present_at_all_locations | taxes.present_at_all_locations | taxes |
taxes__tax_data | OBJECT | taxes.tax_data | taxes.tax_data | taxes |
taxes__type | TEXT | taxes.type | taxes.type | taxes |
taxes__updated_at | TIMESTAMP | taxes.updated_at | taxes.updated_at | taxes |
taxes__version | NUMERIC | taxes.version | taxes.version | taxes |
team_member_wages__hourly_rate | OBJECT | team_member_wages.hourly_rate | team_member_wages.hourly_rate | team_member_wages |
team_member_wages__id | TEXT | team_member_wages.id | team_member_wages.id | team_member_wages |
team_member_wages__team_member_id | TEXT | team_member_wages.team_member_id | team_member_wages.team_member_id | team_member_wages |
team_member_wages__title | TEXT | team_member_wages.title | team_member_wages.title | team_member_wages |
team_members__assigned_locations | OBJECT | team_members.assigned_locations | team_members.assigned_locations | team_members |
team_members__created_at | TIMESTAMP | team_members.created_at | team_members.created_at | team_members |
team_members__email_address | TEXT | team_members.email_address | team_members.email_address | team_members |
team_members__family_name | TEXT | team_members.family_name | team_members.family_name | team_members |
team_members__given_name | TEXT | team_members.given_name | team_members.given_name | team_members |
team_members__id | TEXT | team_members.id | team_members.id | team_members |
team_members__is_owner | BOOLEAN | team_members.is_owner | team_members.is_owner | team_members |
team_members__phone_number | TEXT | team_members.phone_number | team_members.phone_number | team_members |
team_members__reference_id | TEXT | team_members.reference_id | team_members.reference_id | team_members |
team_members__status | TEXT | team_members.status | team_members.status | team_members |
team_members__updated_at | TIMESTAMP | team_members.updated_at | team_members.updated_at | team_members |
today | DATE | Today | Today's date |