Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
  • Usage-Based Pricing
  • Connectors
  • Applications
    • Application Reports
    • Lite Connectors
    • 15Five
    • 360Learning
    • 6sense
    • ActiveCampaign
    • Acumatica
    • Ada
    • Adjust
    • Adobe Analytics
    • Adobe Analytics Data Feed
    • Adobe Commerce
    • ADP Workforce Now
    • AdRoll
    • Affinity
    • Afterpay
    • Aha
    • Aircall
    • Airtable
    • Alchemer
    • Algolia
    • Amazon Ads
    • Amazon Attribution
    • Amazon Cloudfront
    • Amazon Selling Partner
    • Amplitude
    • Anaplan
    • Appcues
    • Appfigures
    • Apple App Store
    • Apple Search Ads
    • AppsFlyer
    • Asana
    • Assembled
    • Attentive
    • Attio
    • Aumni
    • Auth0
    • Autodesk BIM 360
    • AvantLink
    • Awin
    • AWS CloudTrail
    • AWS Cost Explorer
    • AWS Inventory
    • Azure Boards
    • Azure Devops
    • BallotReady
    • BambooHR
    • BigCommerce
    • BillingPlatform
    • Birdeye
    • Bitly
    • Blackboard
    • Braintree
    • Branch
    • Braze
    • Brevo
    • Brex
    • Buildkite
    • Buzzsprout
    • Calabrio
    • Calendly
    • Campaign Monitor
    • Canny
    • Canvas
    • Care Quality Commission
    • Castor EDC
    • Ceridian Dayforce
    • Chameleon
    • ChannelAdvisor
    • Chargebee
    • ChargeDesk
    • ChartMogul
    • Checkout.com
    • Chorus
    • Churnkey
    • ChurnZero
    • Cimis
    • Cin7
    • CircleCI
    • Clari
    • ClickUp
    • Close
    • Coassemble
    • Codefresh
    • Collibra
    • Column
    • commercetools
    • Confluence
    • Contrast Security
    • Copper
    • Coupa
    • Criteo
    • Crossbeam
    • crowd.dev
    • Customer.io
    • Cvent
    • D2L Brightspace
    • dbt Cloud
    • DCL Logistics
    • DEAR
    • Delighted
    • Deputy
    • Destini
    • Dixa
    • Docebo
    • Drata
    • Drift
    • Drip
    • Dropbox Sign
    • Duoplane
    • e-conomic
    • EasyPost
    • Ellucian Banner
    • Eloqua
    • Employment Hero
    • Epicor Prophet 21
    • Eventbrite
    • Everhour
    • Expensify
    • EZOfficeInventory
    • Facebook Ads
    • Facebook Pages
    • FinancialForce
    • Flexport
    • Float
    • Fone Dynamics
    • Forj Community
    • Fountain
    • Freightview
    • FreshBooks
    • Freshchat
    • Freshdesk
    • Freshdesk Contact Center
    • Freshservice
    • Freshsuccess
    • Freshteam
    • Friendbuy
    • Front
    • FullStory
    • Gainsight Customer Success
    • Gem
    • GetFeedback
    • GitHub
    • Gladly
    • GlobalMeet
    • GoCardless
    • Gong
    • Google Ad Manager
    • Google Ads
    • Google Analytics
    • Google Analytics (MCF)
    • Google Analytics 360
    • Google Analytics 4
    • Google Analytics 4 Export
    • Google Calendar
    • Google Campaign Manager 360
    • Google Display & Video 360
    • Google Play
    • Google Search Ads 360
    • Google Search Console
    • Google Tasks
    • Gorgias
    • Greenhouse
    • GreenPowerMonitor
    • Grepsr
    • GRIN
    • Guru
    • HappyFox
    • Harvest
    • Heap
    • Height
    • Help Scout
    • Helpshift
    • HiBob
    • Hopin
    • HubSpot
    • iLevel
    • Impact
    • incident.io
    • Infobip
    • Insightly
    • Instagram Business
    • Integral Ad Science
    • Integrate
    • Intercom
    • Ironclad
    • ironSource
    • Iterable
    • Ivanti
    • Jira
    • Jira Align
    • Jotform
    • JustCall
    • Kandji
    • Katana
    • KeyPay
    • Khoros Care
    • Kissmetrics
    • Klarna
    • Klaviyo
    • Konnect Insights
    • Kustomer
    • Lattice
    • LaunchDarkly
    • LearnUpon
    • Lessonly
    • Lever
    • Liftoff
    • Lightspeed Retail
    • Linear
    • LinkedIn Ad Analytics
    • LinkedIn Company Pages
    • LinkSquares
    • LiveChat
    • Loaded Commerce
    • Lob
    • Looker
    • Loop
    • Loopio
    • Luma
    • Magento
    • Mailchimp
    • Mailgun
    • Mandrill
    • Marin Software
    • Marketo
    • Mavenlink
    • Maxio Chargify
    • Medallia
    • Megaphone
    • Meltwater
    • Mention
    • Microsoft Advertising
    • Microsoft Dynamics
    • Microsoft Lists
    • Microsoft Teams
    • Mixmax
    • Mixpanel
    • MNTN
    • Mode
    • Moloco
    • Monday.com
    • Mux
    • Namely
    • Navan
    • nCino
    • NetSuite SuiteAnalytics
    • Notion
    • Nylas
    • Okta
    • Ometria
    • Open Data DC
    • Open Exchange Rates
    • Opsgenie
    • Optimizely
    • Oracle Business Intelligence Publisher
    • Oracle E-Business Suite
    • Oracle Fusion Cloud Applications
    • Oracle Moat Analytics
    • Oracle PeopleSoft
    • Oracle Siebel CRM
    • Orbit
    • Ordway
    • Ortto
    • OsCommerce
    • Outbrain
    • Outreach
    • PagerDuty
    • Papershift
    • Pardot
    • PartnerStack Vendor
    • Paychex
    • PayPal
    • Pendo
    • Persona
    • Personio
    • Pingdom
    • Pinpoint
    • Pinterest Ads
    • Pipe17
    • Pipedrive
    • Pivotal Tracker
    • Piwik PRO
    • Playvox
    • PostHog
    • PowerReviews Enterprise
    • PowerSchool
    • PrestaShop
    • Prive
    • Productboard
    • Qualaroo
    • Qualtrics
    • QuickBooks
    • Ramp
    • Rarible
    • Recharge
    • Recurly
    • Reddit Ads
    • Reltio
    • Reply
    • RetailNext
    • Retently
    • Revel Systems
    • RevOps
    • RevX
    • RingCentral
    • Rippling
    • Rollbar
    • Rootly
    • RTB House
    • Sage HR
    • Sage Intacct
    • Sailthru
    • Salesforce
    • Salesforce Commerce Cloud
    • Salesforce Marketing Cloud
    • Salesloft
    • Salsify
    • Samsara
    • SAP Business ByDesign
    • SAP Business One
    • SAP Concur
    • SCORM
    • Security Journey
    • SendGrid
    • Sensor Tower
    • ServiceNow
    • ServiceTitan
    • Sharetribe
    • ShipHero
    • ShipStation
    • Shopify
    • Shopware
    • Short.io
    • Shortcut
    • Simplecast
    • Simplesat
    • Skilljar
    • SkuVault
    • Slab
    • Slack
    • Smadex
    • Smartwaiver
    • Snapchat Ads
    • SonarQube
    • Split
    • Splunk
    • Spotify Ads
    • Spree Commerce
    • Square
      • Setup Guide
      • Release Notes
    • Squarespace
    • StackAdapt
    • Standard Metrics
    • Statsig
    • Statuspage
    • Stripe
    • Stylight
    • Subscript
    • SurveyMonkey
    • Survicate
    • Swoogo
    • Tableau
    • Taboola
    • Talkdesk
    • Talkwalker
    • Teamwork
    • Tempo
    • The Trade Desk
    • Thinkific
    • TikTok Ads
    • Toggl Track
    • Transcend
    • Trello
    • Trisolute
    • Twilio
    • Twitter Ads
    • Twitter Organic
    • Typeform
    • Unicommerce
    • Upland Software
    • UpPromote
    • UserVoice
    • Veeva
    • Verizon Media
    • Vitally
    • Vonage
    • VWO
    • Web Scraper
    • When I Work
    • Wherefour
    • WooCommerce
    • WordPress
    • Workable
    • Workday Financial Management
    • Workday HCM
    • Workday RaaS
    • Workday Strategic Sourcing
    • WorkflowMax
    • WorkRamp
    • Wrike
    • Xero
    • Xray
    • Yahoo DSP
    • Yahoo Search Ads on Yahoo Japan
    • Yotpo
    • YouTube Analytics
    • Zen Cart
    • Zendesk Chat
    • Zendesk Sell
    • Zendesk Sunshine
    • Zendesk Support
    • Zenefits
    • Zingtree
    • Zoho Books
    • Zoho Campaigns
    • Zoho CRM
    • Zoho Desk
    • Zoom
    • Zuora
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In

Release Noteslink


October 2023link

The Square connector now supports the Bank Accounts, Gift Cards, Invoices, Merchants, and Subscriptions endpoints of the Square API. We have added the following new tables:

  • BANK_ACCOUNT
  • CUSTOM_ATTRIBUTE_DEFINITION
  • DEVICE_CODE
  • GIFT_CARD
  • GIFT_CARD_ACTIVITY
  • GIFT_CARD_CUSTOMER
  • INVOICE
  • INVOICE_RECIPIENT
  • INVOICE_CUSTOM_FIELD
  • INVOICE_PAYMENT_REQUEST
  • INVOICE_PAYMENT_REMINDER
  • LOCATION_CUSTOM_ATTRIBUTE
  • MERCHANT
  • MERCHANT_CUSTOM_ATTRIBUTE
  • SUBSCRIPTION
  • SUBSCRIPTION_ACTION
  • SUBSCRIPTION_ACTION_PHASE
  • SUBSCRIPTION_PHASE
  • SUBSCRIPTION_EVENT
  • SUBSCRIPTION_EVENT_PHASE
  • VENDOR
  • VENDOR_CONTACT

September 2023link

We have added the scopes, SUBSCRIPTIONS_READ, INVOICES_READ, GIFTCARDS_READ, MERCHANT_PROFILE_READ, DEVICE_CREDENTIAL_MANAGEMENT, VENDOR_READ, and BANK_ACCOUNTS_READ to our Square connectors. These scopes are required to access the Subscriptions, Invoices, Gift Cards, Businesses and Financials endpoints, which are currently under development.


April 2023link

We have changed the sync strategy for the SHIFT table to improve the accuracy and reliability of its data. We now perform a historical sync to capture the 90-day-old historical records on a weekly basis. Even though this may temporarily slow down your syncs and increase your MAR consumption, this change in the sync strategy ensures that the data in the SHIFT table has no discrepancies and errors.


May 2022link

We have changed the composite key of the ORDER_LINE_ITEM_MODIFIER table. The new composite key is a combination of the uid and order_line_item_id columns. Be sure to update your queries.


July 2021link

We now use the id column as the primary key in the DISPUTE table. We will deprecate the dispute_id column from the DISPUTE table after October 15, 2021, to support Square's API changes. Be sure to update your queries. For more information about Disputes, see Square's documentation.


June 2021link

We have updated our OAuth scopes to support the Disputes endpoint of the Square API. You must re-authorize the connector. On your Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See Square's documentation for more information.


March 2021link

We have updated our OAuth scopes to support the Cash Drawer, Loyalty, and Labor-Shift endpoints of the Square API. You must re-authorize the connector. On your Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See Square's documentation for more information.

We have added a new table, SHIFTS. See Square's documentation on search shifts for more information.

We have added two new tables, CASH_DRAWER and CASH_DRAWER_EVENT. See Square's documentation on cash drawers for more information.

We have added two new tables, DISPUTES and DISPUTES_EVIDENCE. See Square's documentation on Disputes for more information.

We have added six new tables:

  • LOYALTY_PROGRAM
  • LOYALTY_PROGRAM_ACCRUAL_RULE
  • LOYALTY_PROGRAM_REWARD_TIER
  • LOYALTY_ACCOUNT
  • LOYALTY_ACCOUNT_MAPPING
  • LOYALTY_REWARD

See Square's documentation on Loyalty for more information.


January 2021link

We have added a new column, customer_id, to the ORDER table. See Square's Order object documentation for more information.

We have added two new columns, present_at_location_ids and absent_at_location_ids, to the CATALOG_OBJECT table.


August 2020link

We have added two new tables, PAYMENT and CARD_PAYMENT_DETAILS.

We have added a new column, payment_id, to the REFUND table.

We have added two new columns, card_type and prepaid_type, to the CARD table.


January 2020link

  • We can now delete records with no OrdersFulfillments from the ORDER_FULFILLMENT table.

  • You can now configure your Square connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.


August 2019link

  • We have added the following fields to the ORDER table:

    • order_source_name
    • return_amount
    • net_amount
    • rounding_adjustment
    • created_at
    • updated_at
    • closed_at
    • state
    • total_service_charge_money
  • We have added the uid field to the following tables:

    • ORDER_LINE_ITEM
    • ORDER_LINE_ITEM_DISCOUNT
    • ORDER_LINE_ITEM_MODIFIER
    • ORDER_LINE_ITEM_TAX
  • We have added the order_id field to the TENDER and REFUND tables.

  • We have added the following tables to the Square schema:

    • ORDER_RETURN
    • ORDER_RETURN_DISCOUNT
    • ORDER_RETURN_LINE_ITEM
    • ORDER_RETURN_LINE_ITEM_MODIFIER
    • ORDER_RETURN_SERVICE_CHARGE
    • ORDER_RETURN_TAX
    • ORDER_SERVICE_CHARGE
  • In order to incorporate changes announced by Square, we will deprecate the TRANSACTION table in the future. All the data in the TRANSACTION table will be available in the ORDER table.


April 2019link

Square, Inc. is a financial services, merchant services aggregator, and mobile payment company.

Link to Square Documentation


Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?