FastSpring Connector
Documentation
Version: 1
Documentation
Endpoint

Get Account Charges

Name

get_account_charges

Description

Related Tables

AccountCharges

Parameters

Parameter Label Required Options Description
PageSize PageSize NO
Email Email NO Account email
CustomKey Account custom key NO
GlobalKey Account global key NO
OrderID Account orderID NO
OrderReference Account orderReference NO
SubscriptionId Account subscriptionId NO
Products Products NO filters results to include only transactions involving the specified product ID(s) / product path(s)
Refunds Show Returned Only NO
Option Value
true true
false false
filters results to include orders with or without returns; response includes returns array with return IDs where applicable
SubscriptionStatus Subscription Status NO
Option Value
active active
ended ended
canceled canceled
started started
'active', 'ended', 'canceled', 'started' will return accounts with subscriptions in the corresponding state

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
AccountId DT_WSTR nvarchar(100) 100 False
ChargeDate DT_DBDATE date False
Total DT_R8 float False
Currency DT_WSTR nvarchar(12) 12 False
PayoutCurrency DT_WSTR nvarchar(12) 12 False
TotalInPayoutCurrency DT_R8 float False
Status DT_WSTR nvarchar(50) 50 False
OrderId DT_WSTR nvarchar(100) 100 False
OrderReference DT_WSTR nvarchar(100) 100 False
SubscriptionId DT_WSTR nvarchar(100) 100 False
Timestamp DT_I8 bigint False
TimestampValue DT_I8 bigint False
TimestampInSeconds DT_I8 bigint False
TimestampDisplay DT_WSTR nvarchar(100) 100 False
If the column you are looking for is missing, consider customizing FastSpring Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use FastSpring Connector in API Source component to read data or in API Destination component to read/write data:

Read from AccountCharges table using API Destination

This Endpoint belongs to AccountCharges table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

FastSpring
AccountCharges
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get account charges 

SELECT * FROM get_account_charges

get_account_charges endpoint belongs to AccountCharges table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get account charges 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_account_charges';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

get_account_charges endpoint belongs to AccountCharges table(s), and can therefore be used via those table(s).