Endpoint Get Account Charges by Id
Name
get_account_charges_by_id
Description
Related Tables
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Account Id |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| AccountId |
DT_WSTR
|
nvarchar(100)
|
100 | |
| ChargeDate |
DT_DBDATE
|
date
|
||
| Total |
DT_R8
|
float
|
||
| Currency |
DT_WSTR
|
nvarchar(12)
|
12 | |
| PayoutCurrency |
DT_WSTR
|
nvarchar(12)
|
12 | |
| TotalInPayoutCurrency |
DT_R8
|
float
|
||
| Status |
DT_WSTR
|
nvarchar(50)
|
50 | |
| OrderId |
DT_WSTR
|
nvarchar(100)
|
100 | |
| OrderReference |
DT_WSTR
|
nvarchar(100)
|
100 | |
| SubscriptionId |
DT_WSTR
|
nvarchar(100)
|
100 | |
| Timestamp |
DT_I8
|
bigint
|
||
| TimestampValue |
DT_I8
|
bigint
|
||
| TimestampInSeconds |
DT_I8
|
bigint
|
||
| TimestampDisplay |
DT_WSTR
|
nvarchar(100)
|
100 |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | 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 or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the AccountCharges table, therefore it is better to use it, instead of accessing the endpoint directly:
| Required Parameters | |
|---|---|
| Account Id | Fill-in the parameter... |
API Destination
This Endpoint belongs to the AccountCharges table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get account charges by id:
| Required Parameters | |
|---|---|
| Account Id | Fill-in the parameter... |
ODBC application
Use these SQL queries in your ODBC application data source:
Get account charges by id
SELECT * FROM AccountCharges
WHERE AccountId = 'abcd-1234-accountid'
get_account_charges_by_id 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 by id
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM AccountCharges
WHERE AccountId = ''abcd-1234-accountid''';
EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];
get_account_charges_by_id endpoint belongs to
AccountCharges
table(s), and can therefore be used via those table(s).