Reference

Endpoint Get Product IDs

Name

get_product_ids

Description

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(255) 255
If the column you are looking for is missing, consider customizing FastSpring Connector.

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

API Source - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Get Product IDs
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Get Product IDs
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Read product ids

Read all orders 

SELECT * FROM get_product_ids

SQL Server

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

Read product ids

Read all orders 

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

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];