SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with FastSpring.

• Create or update product (upsert)
• Generate revenue report
• Generate subscription report
• Read a product by ID
• Read account charges
• Read account orders by email
• Read accounts
• Read accounts with specific product orders
• Read an order by ID
• Read an order by reference
• Read or search quotes
• Read orders
• Read orders for a subscription
• Read orders placed in last 30 days
• Read orders with date range
• Read product IDs
• Read product prices
• Read product publish status
• Read products
• Update multiple products from CSV
• Update product