Endpoint Retrieve an Invoice Item

Name

get_invoice_item

Description

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

Related Tables

InvoiceItems

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Stripe Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the InvoiceItems table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Stripe

Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.

Stripe

InvoiceItems

Required Parameters
Invoice Item Id	Fill-in the parameter...

API Destination

This Endpoint belongs to the InvoiceItems table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to retrieve an invoice item:

API Destination - Stripe

Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.

Stripe

InvoiceItems

Lookup

Required Parameters
Invoice Item Id	Fill-in the parameter...

ODBC application

Use these SQL queries in your ODBC application data source:

Read an invoice line item

<p>Reads a single invoice line item from the <code>InvoiceItems</code> table by specifying the <code>Id</code>. This example demonstrates how to filter results to a specific line item using the WHERE clause.</p>

SELECT * FROM InvoiceItems
WHERE Id = 'abc'

SQL Server

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

Read an invoice line item

<p>Reads a single invoice line item from the <code>InvoiceItems</code> table by specifying the <code>Id</code>. This example demonstrates how to filter results to a specific line item using the WHERE clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM InvoiceItems
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];