Squarespace - Get Transactions

Description

This module allows querying payment transactions from a Squarespace store. It includes sales, refunds, and other financial movements.

Configuration

Required Credentials

• API Key: Squarespace API key

Parameters

Parameter	Type	Required	Description
credentials_id	credential	Yes	Squarespace credentials
transaction_id	string	No	Specific transaction ID
modifiedAfter	string	No	Transactions after (ISO 8601)
modifiedBefore	string	No	Transactions before (ISO 8601)
cursor	string	No	Pagination cursor

Output

{
  "success": true,
  "transactions": [...],
  "count": 100,
  "total_amount": "5432.10",
  "total_sales": 95,
  "total_refunds": 5,
  "hasNextPage": true,
  "nextCursor": "abc123...",
  "message": "100 transactions retrieved"
}

Transaction Fields

• id: Transaction ID
• createdOn: Transaction date
• modifiedOn: Modification date
• salesOrderId: Associated order ID
• total: Total amount
• customerEmail: Customer email
• paymentState: Payment state
• lineItems: Item details

Usage Example

Get all transactions

{}

Specific transaction

{
  "transaction_id": "5f3e..."
}

Last month’s transactions

{
  "modifiedAfter": "2024-01-01T00:00:00Z",
  "modifiedBefore": "2024-01-31T23:59:59Z"
}

API Used

• Endpoint: GET /1.0/commerce/transactions
• Documentation: Squarespace Transactions API

Notes

• Transactions are read-only
• Refunds appear as transactions with negative amounts
• The total_amount field is the sum of all transactions
• total_sales and total_refunds are calculated counters
• Includes transactions for physical products, digital products, and subscriptions

Related Nodes

• SquarespaceGetOrders - Get orders associated with transactions
• SquarespaceGetProfiles - Get customer profile of a transaction