Reference

Table InvoiceItems

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_invoice_items
INSERT
UPDATE
UPSERT
DELETE delete_invoice_item
LOOKUP get_invoice_item

Examples

SSIS

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

Read from InvoiceItems table using API Source

API Source - Stripe
Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.
Stripe
InvoiceItems
Optional Parameters
Customer Id
Invoice Id
Pending
Created later than (yyyy-MM-dd)
Created on or later than (yyyy-MM-dd)
Created earlier than (yyyy-MM-dd)
Created on or earlier than (yyyy-MM-dd)
SSIS API Source - Read from table or endpoint

Read/write to InvoiceItems table using API Destination

API Destination - Stripe
Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.
Stripe
InvoiceItems
Select
Optional Parameters
Customer Id
Invoice Id
Pending
Created later than (yyyy-MM-dd)
Created on or later than (yyyy-MM-dd)
Created earlier than (yyyy-MM-dd)
Created on or earlier than (yyyy-MM-dd)
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read invoice line items

<p>Reads all records from the <code>InvoiceItems</code> table. This example demonstrates a basic SELECT query to retrieve a complete list of invoice line items.</p> 

SELECT * FROM InvoiceItems

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 invoice line items

<p>Reads all records from the <code>InvoiceItems</code> table. This example demonstrates a basic SELECT query to retrieve a complete list of invoice line items.</p> 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_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];