Square Square

Square

Source

Use Dataddo's Square connector to explore any data available via the official API of Square. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.

DATA FIELDS

Explore Data You Can Extract from Square

Data Category

Need fields you don't see?

Let us know and we'll add them to the connector. Just send a request here..

Available Attributes (212)

Attribute
type

Type

string
id

Id

string
created_at

Created At

datetime
category_id

Category Id

string
updated_at

Updated At

datetime
version

Version

integer
is_deleted

is_deleted

integer
present_at_all_locations

Present At All Locations

integer
item_data_name

Item Data Name

string
item_data_is_taxable

Item Data Is Taxable

integer
item_data_tax_ids

Item Data Tax Ids

string
item_data_variations_type

Item Data Variations Type

string
item_data_variations_id

Item Data Variations Id

string
item_data_variations_updated_at

Item Data Variations Updated At

datetime
item_data_variations_created_at

Item Data Variations Created At

datetime
item_data_variations_version

Item Data Variations Version

integer
item_data_is_deleted

Item Data Is Deleted

integer
item_data_present_at_all_locations

Item Data Present At All Locations

integer
item_variation_data_item_id

Item Variation Data Item Id

string
item_variation_data_name

Item Variation Data Name

string
item_variation_data_ordinal

Item Variation Data Ordinal

integer
item_variation_pricing_type

Item Variation Pricing Type

string
item_variation_sellable

Item Variation Sellable

integer
item_variation_stockable

Item Variation Stockable

integer
item_variation_default_unit_cost_amount

Item Variation Default Unit Cost Amount

float
item_variation_default_unit_cost_currency

Item Variation Default Unit Cost Currency

string
item_variation_vendor_infos_type

Item Variation Vendor Infos Type

string
item_variation_vendor_infos_id

Item Variation Vendor Infos Id

string
item_variation_vendor_info_updated_at

Item Variation Vendor Info Updated At

datetime
item_variation_vendor_info_created_at

Item Variation Vendor Info Created At

datetime
item_variation_vendor_info_version

Item Variation Vendor Info Version

integer
item_variation_vendor_info_is_deleted

Item Variation Vendor Info Is Deleted

integer
item_variation_vendor_info_present_at_all_locations

Item Variation Vendor Info Present At All Locations

string
item_variation_vendor_info_data_ordinal

Item Variation Vendor Info Data Ordinal

integer
item_variation_vendor_info_data_price_money_amount

Item Variation Vendor Info Data Price Money Amount

float
item_variation_vendor_info_data_price_money_currency

Item Variation Vendor Info Data Price Money Currency

string
item_variation_vendor_info_data_item_variation_id

Item Variation Vendor Info Data Item Variation Id

string
item_variation_vendor_info_data_item_vendor_id

Item Variation Vendor Info Data Item Vendor Id

string
item_data_product_type

Item Data Product Type

string
item_data_ecom_available

Item Data Ecom Available

integer
item_data_ecom_visibility

Item Data Ecom Visibility

string
item_data_is_archived

Item Data Is Archived

integer
reporting_category_id

Reporting Category Id

string
id

Id

string
created_at

Created At

datetime
updated_at

Updated At

datetime
given_name sensitive

Given Name

string
family_name sensitive

Family Name

string
email_address sensitive

Email Address

string
phone_number sensitive

Phone Number

string
reference_id sensitive

Reference Id

string
note

Note

string
creation_source

Creation Source

string
version

Version

integer
address_line_1 sensitive

Address Line 1

string
address_line_2 sensitive

Address Line 2

string
locality

Locality

string
administrative_district_level_1

Administrative District Level 1

string
postal_code sensitive

Postal Code

string
country

Country

string
email_unsubscribed

Email Unsubscribed

boolean
group_ids

Group Ids

string
segment_ids

Segment Ids

string
id

Id

string
name

Name

string
address_line_1

Address Line 1

string
address_locality

Address Locality

string
address_administrative_district_level_1

Address Administrative District Level 1

string
address_postal_code

Address Postal Code

string
address_country

Address Country

string
timezone

Timezone

string
capabilities

Capabilities

string
status

Status

string
created_at

Created At

datetime
merchant_id

Merchant Id

string
country

Country

string
language_code

Language Code

string
currency

Currency

string
phone_number

Phone Number

string
business_name

Business Name

string
type

Type

string
business_hours_day_of_week

Business Hours Day Of Week

string
business_hours_start_local_time

Business Hours Start Local Time

string
business_hours_end_local_time

Business Hours End Local Time

string
business_email

Business Email

string
description

Description

string
coordinates_latitude

Coordinates Latitude

float
coordinates_longitude

Coordinates Longitude

float
logo_url

Logo Url

string
mcc

Mcc

string
full_format_logo_url

Full Format Logo Url

string
tax_ids_eu_vat

Tax Ids Eu Vat

string
tax_ids_es_nif

Tax Ids Es Nif

string
id

Id

string
location_id

Location Id

string
line_items_uid

Line Items Uid

string
line_items_catalog_object_id

Line Items Catalog Object Id

string
line_items_quantity

Line Items Quantity

integer
line_items_name

Line Items Name

string
line_items_variation_name

Line Items Variation Name

string
line_items_base_price_money

Line Items Base Price Money

float
line_items_base_price_currency

Line Items Base Price Money Currency

string
line_items_total_tax_money

Line Items Total Tax Money

float
line_items_total_tax_money_currency

Line Items Total Tax Money Currency

string
line_items_total_discount_money

Line Items Total Discount Money

float
line_items_total_discount_money_currency

Line Items Total Discount Money Currency

string
line_items_total_money

Line Items Total Money

float
line_items_total_money_currency

Line Items Total Money Currency

string
line_items_variation_total_price_money

Line Items Variation Total Price Money

float
line_items_variation_total_price_money_currency

Line Items Variation Total Price Money Currency

string
line_items_applied_taxes_uid

Line Items Applied Taxes Uid

string
line_items_applied_taxes_tax_uid

Line Items Applied Taxes Tax Uid

string
line_items_applied_taxes_tax_applied_money

Line Items Applied Taxes Tax Applied Money

float
line_items_applied_taxes_tax_applied_money_currency

Line Items Applied Taxes Tax Applied Money Currency

string
line_items_item_type

Line Items Item Type

string
taxes_uid

Taxes Uid

string
taxes_catalog_object_id

Taxes Catalog Object Id

string
taxes_catalog_version

Taxes Catalog Version

integer
taxes_name

Taxes Name

string
taxes_percentage

Taxes Percentage

string
taxes_type

Taxes Type

string
taxes_applied_money

Taxes Applied Money

float
taxes_applied_money_currency

Taxes Applied Money Currency

string
taxes_scope

Taxes Scope

string
created_at

Created At

datetime
updated_at

Updated At

datetime
state

State

string
version

Version

string
total_tax_money

Total Tax Money

float
total_tax_money_currency

Total Tax Money Currency

string
total_discount_money

Total Discount Money

float
total_discount_money_currency

Total Discount Money Currency

string
total_tip_money

Total Tip Money

float
total_tip_money_currency

Total Tip Money Currency

string
total_money

Total Money

float
total_money_currency

Total Money Currency

string
total_service_charge_money

Total Service Charge Money

float
total_service_charge_money_currency

Total Service Charge Money Currency

string
net_amounts_total_money

Net Amounts Total Money

float
net_amounts_total_money_currency

Net Amounts Total Money Currency

string
net_amounts_tax_money

Net Amounts Tax Money

float
net_amounts_tax_money_currency

Net Amounts Tax Money Currency

string
net_amounts_discount_money

Net Amounts Discount Money

float
net_amounts_discount_money_currency

Net Amounts Discount Money Currency

string
net_amounts_tip_money

Net Amounts Tip Money

float
net_amounts_tip_money_currency

Net Amounts Tip Money Currency

string
net_amounts_service_charge_money

Net Amounts Service Charge Money

float
net_amounts_service_charge_money_currency

Net Amounts Service Charge Money Currency

string
source_name

Source Name

string
customer_id

Customer Id

string
net_amount_due_money

Net Amounts Due Money

float
net_amount_due_money_currency

Net Amounts Due Money Currency

string
id

Id

string
created_at

Created At

datetime
updated_at

Updated At

datetime
amount_money

Amount Money

float
amount_currency

Amount Currency

string
status

Status

string
delay_duration

Delay Duration

string
source_type

Source Type

string
card_status

Card Status

string
card_brand

Card Status

string
card_last_4

Card Last 4

string
card_exp_month

Card Exp Month

integer
card_exp_year

Card Exp Year

integer
card_fingerprint sensitive

Card Fingerprint

string
card_type

Card Type

string
card_prepaid_type

Card Prepaid Type

string
card_bin

Card Bin

string
entry_method

Entry Method

string
cvv_status

Cvv Status

string
avs_status

Avs Status

string
auth_result_code

Auth Result Code

string
statement_description

Statement Description

string
card_payment_timeline_authorized_at

Card Payment Timeline Authorized At

string
card_payment_timeline_captured_at

Card Payment Timeline Captured At

string
location_id

Location Id

string
order_id

Order Id

string
processing_fee_effective_at

Processing Fee Effective At

datetime
processing_fee_type

Processing Fee Type

string
processing_fee_amount_money

Processing Fee Amount Money

float
processing_fee_amount_currency

Processing Fee Amount Currency

string
note

Note

string
total_money_amount

Total Money Amount

float
total_money_currency

Total Money Currency

string
approved_money_amount

Approved Money Amount

float
approved_money_currency

Approved Money Currency

string
employee_id

Employee Id

string
receipt_number

Receipt Number

string
receipt_url

Receipt Url

string
delay_action

Delay Action

string
delayed_until

Delay Until

datetime
team_member_id

Team Member Id

string
application_details_square_product

Application Details Square Product

string
application_details_application_id

Application Details Application Id

string
version_token

Version Token

string
id

Id

string
status

Status

string
amount_money

Amount Money

float
amount_money_currency

Amount Money Currency

string
payment_id

Payment Id

string
order_id

Order Id

string
created_at

Created At

datetime
updated_at

Updated At

datetime
processing_fee_effective_at

Processing Fee Effective At

datetime
processing_fee_type

Processing Fee Type

string
processing_fee_amount_money

Processing Fee Amount Money

float
processing_fee_amount_money_currency

Processing Fee Amount Money Currency

string
location_id

Location Id

string
reason

Reason

string
team_member_id

Team Member Id

string
destination_type

Destination Type

string

Pricing

See all Dataddo plans

Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.

View pricing
One Platform to Connect All Your Data

Why Dataddo?

One Ingestion Layer for SaaS, Databases, and Files

One Ingestion Layer for SaaS, Databases, and Files

Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.

Built for Cloud and On-Premise Environments

Built for Cloud and On-Premise Environments

Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.

Full API Control - No UI Required

Full API Control - No UI Required

Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.

Managed Ingestion Operations. We Own the Reliability.

Managed Ingestion Operations. We Own the Reliability.

Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.

Full Visibility Into Every Data Flow

Full Visibility Into Every Data Flow

Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.

The Data Foundation Your AI Needs

The Data Foundation Your AI Needs

Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.

See All Platform Benefits
Testimonials

Our Customers Love Us

G2 Implementation Winter 2025

Amalia Bornstein

Global Social Content and Marketing Data Analyst

Uber Eats

“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”

G2 Implementation Winter 2025

Andrew Hart

Chief Operations Officer

Sat 7

“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”

G2 Implementation Winter 2025

Vahan Petrosayan

Director of IT & Infrastructure

Search Engine Journal

“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”

G2 Implementation Winter 2025

Michael Guntenaar

CTO

ID&T Group

“Dataddo opens up gates and takes away the hurdles of working with data.”

G2 Implementation Winter 2025

Laurent Partouche

CPO

FoodChéri & Seazon

“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”

G2 Implementation Winter 2025

Natheer Maloon

Technology Solutions Manager

Boldr

“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”

G2 Implementation Winter 2025

Zdeněk Hejnak

Data Development Team Leader

Livesport

“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”

G2 Implementation Winter 2025

Greg Senior

Business Operations Manager

Farm Focus

“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”

G2 Implementation Winter 2025 G2 Performer Winter 2025 Google Cloud Partner Tableau Technology Partner AWS Partner Network Gartner Cool Vendor