SQL Server + Square

Log new payments from Square as new rows in SQL Server

Keep track of your Square payments with ease using this efficient workflow connecting Square and SQL Server. When a new payment is made within Square, a new row is added in your SQL Server app. This seamless flow of information ensures data consistency, so you're always up-to-date with your financial transactions. Perfect for businesses looking to streamline their payment tracking process.

When this happens...
New PaymentTriggers when a new payment is created.
TriggerPolling
automatically do this!
New RowTriggers when you add a new row.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Square and SQL Server

Discover other triggers and actions you can use with Square and SQL Server

New Appointment
Triggers when a new appointment is created.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
- Location
  Required
- Order Status
Trigger
Polling
Try It
- Customer ID
  Required
- Group
  Required
Action
Write
- Inventory Change Type
  Required
- Location
  Required
- Catalog Object
  Required
- Quantity
  Required
- Ignore unchanged counts
Action
Write

- Location
  Required
- Order ID
  Required
- Customer ID
  Required
- Accepted_payment_methods
  Required
- Payment due date
  Required
- Tipping enabled
- Invoice title
- Invoice number
- Description
- Delivery method
  Required
- Scheduled at
- Date of sale
Action
Write
- Payment
  Required
- Refund amount
- Reason
- Team member
Action
Write

- Help_text
- Location
  Required
Action
Write
- Customer ID
  Required
- First Name
- Last Name
- Email_address
- Phone_number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference ID
- Birthday
Action
Write
Find Order by ID
This action retrieves the details of a specific order from Square using the order ID.
Action
Write
- Customer_id
Action
Search
- Location
  Required
- Field_help
- Customer
- Fulfillment_state
- Status
Action
Search
- Location
  Required
- Field_help
- Customer
- Fulfillment_state
- Status
- Customer ID
- External Identifier
- Source
- Ticket Name
- Quantity
- Amount
- Currency
- Catalog Item Variation ID
- Note
- Unique Identifier
- Amount Discounted
- Amount Discounted Currency
- Name
- Percentage
- Type
- Unique Identifier
- Name
- Percentage
- Type
- Unique Identifier
Action
Search or write
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search

- Item Type
Trigger
Polling
Try It
- Location
  Required
Trigger
Polling
Try It
- Location
Trigger
Polling
Try It
- Location
  Required
- Team Member ID
  Required
- Customer ID
  Required
- Date and Time of Appointment
  Required
- Appointment Service ID
  Required
- Note
Action
Write
- First Name
- Last Name
- Email_address
- Phone_number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference_id
Action
Write
- Location
  Required
- Customer ID
- External Identifier
- Buyer Email Address
- Payment Type
  Required
- Payment Note
- Quantity
  Required
- Amount
  Required
- Currency
  Required
- Line Item Name
- Catalog Item Variation ID
- Pickup
- Display Name
- Carrier
- Expected Ship Date/Time
- Shipping Note
- Fulfillment Email Address
- Phone number of the fulfillment recipient
- Address Line 1
- Address Line 2
- State
- County
- Country
- City
- Postal Code
- Discount Type
- Name
- Percentage
- Amount Discounted
- Discount Currency
- Name
- Percentage
- Type
Action
Write
- Customer ID
  Required
- Group
  Required
Action
Write
- Customer
  Required
- Attribute
  Required
- Value
  Required
- Idempotency Key
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Field_help
- Email_address
- Phone Number
- Reference ID
Action
Search
- Field_help
- Text Filter
- Location
Action
Search
- Field_help
- Email_address
- Phone Number
- Reference ID
- First Name
- Last Name
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
Action
Search or write
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- DisclaimerCopy
- Query
  Required
Action
Write
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

About Square

Square creates tools that help sellers of all sizes start, run and grow their businesses. Square’s point-of-sale service offers tools for every part of running a business, from accepting credit cards and tracking inventory to real-time analytics and invoicing.

Learn moreLearn moreHelpHelp

Related categories

eCommerce

Payment Processing

Similar apps

PayPal

Payment Processing

Shopify

eCommerce

Epos Now

Payment Processing