EndPoint Retrieve an Invoice Item

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_invoice_item

Description

Retrieves the invoice item with the given Id. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Invoice Item Id	YES		Retrieve an invoice item for the Invoice Id.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(100)`	100	False
InvoiceId	`DT_WSTR`	`nvarchar(1020)`	1020	False
Object	`DT_WSTR`	`nvarchar(100)`	100	False
Amount	`DT_I8`	`bigint`		False
AmountDecimal	`DT_WSTR`	`nvarchar(4000)`	4000	False
Currency	`DT_WSTR`	`nvarchar(100)`	100	False
Customer	`DT_WSTR`	`nvarchar(1020)`	1020	False
Date	`DT_DBTIMESTAMP`	`datetime`		False
Description	`DT_WSTR`	`nvarchar(255)`	255	False
Discountable	`DT_BOOL`	`bit`		False
Discounts	`DT_WSTR`	`nvarchar(100)`	100	False
Livemode	`DT_BOOL`	`bit`		False
PeriodEnd	`DT_DBTIMESTAMP`	`datetime`		False
PeriodStart	`DT_DBTIMESTAMP`	`datetime`		False
PriceID	`DT_WSTR`	`nvarchar(120)`	120	False
PriceObject	`DT_WSTR`	`nvarchar(100)`	100	False
PriceActive	`DT_BOOL`	`bit`		False
PriceBillingScheme	`DT_WSTR`	`nvarchar(100)`	100	False
PriceCreated	`DT_DBTIMESTAMP`	`datetime`		False
PriceCurrency	`DT_WSTR`	`nvarchar(100)`	100	False
PriceLivemode	`DT_BOOL`	`bit`		False
PriceLookupKey	`DT_WSTR`	`nvarchar(1020)`	1020	False
PriceNickname	`DT_WSTR`	`nvarchar(100)`	100	False
PriceProductId	`DT_WSTR`	`nvarchar(100)`	100	False
PriceRecurringAggregateUsage	`DT_WSTR`	`nvarchar(100)`	100	False
PriceRecurringInterval	`DT_WSTR`	`nvarchar(100)`	100	False
PriceRecurringIntervalCount	`DT_I8`	`bigint`		False
PriceRecurringTrialPeriodDays	`DT_I8`	`bigint`		False
PriceRecurringUsageType	`DT_WSTR`	`nvarchar(100)`	100	False
PriceTiersMode	`DT_WSTR`	`nvarchar(1020)`	1020	False
PriceTransformQuantity	`DT_WSTR`	`nvarchar(1020)`	1020	False
PriceType	`DT_WSTR`	`nvarchar(100)`	100	False
PriceUnitAmount	`DT_I8`	`bigint`		False
PriceUnitAmountDecimal	`DT_WSTR`	`nvarchar(100)`	100	False
Proration	`DT_BOOL`	`bit`		False
Quantity	`DT_I8`	`bigint`		False
SubscriptionId	`DT_WSTR`	`nvarchar(100)`	100	False
TaxRates	`DT_WSTR`	`nvarchar(100)`	100	False
UnitAmount	`DT_I8`	`bigint`		False
UnitAmountDecimal	`DT_WSTR`	`nvarchar(100)`	100	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	False

Required columns that you need to supply are bolded.