Reference

Table Invoices

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_invoices
INSERT
UPDATE
UPSERT
DELETE delete_invoice
LOOKUP get_single_invoice

Examples

SSIS

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

Read from Invoices table using API Source

API Source - Stripe
This connector support read/write operations for Stripe APIs
Stripe
Invoices
Optional Parameters
Customer Id
Status (draft or open or paid or uncollectible or void)
Subscription Id
Collection method (charge_automatically or send_invoice)
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)
Due Date later than (yyyy-MM-dd)
Due Date on or later than (yyyy-MM-dd)
Due Date earlier than (yyyy-MM-dd)
Due Date on or earlier than (yyyy-MM-dd)
SSIS API Source - Read from table or endpoint

Read/write to Invoices table using API Destination

API Destination - Stripe
This connector support read/write operations for Stripe APIs
Stripe
Invoices
Select
Optional Parameters
Customer Id
Status (draft or open or paid or uncollectible or void)
Subscription Id
Collection method (charge_automatically or send_invoice)
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)
Due Date later than (yyyy-MM-dd)
Due Date on or later than (yyyy-MM-dd)
Due Date earlier than (yyyy-MM-dd)
Due Date 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:

Get all Invoices

Read all invoices 

SELECT * FROM Invoices

Get an Invoice

Read an invoice 

SELECT * FROM Invoices
WHERE Id = 'abc'

Insert an Invoice

Insert an invoice 

INSERT INTO Invoices([Customer],[AmountRemaining])
VALUES ('cus_LqWX1s0E32JJeZL', 12345)

Update an Invoice

Update an invoice 

UPDATE Invoices
SET [DaysUntilDue] = 20
WHERE Id = 'abc'

Delete an invoice

Delete an invoice 

DELETE FROM Invoices
WHERE Id = 'abc'

SQL Server

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

Get all Invoices

Read all invoices 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Get an Invoice

Read an invoice 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Insert an Invoice

Insert an invoice 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Invoices([Customer],[AmountRemaining])
VALUES (''cus_LqWX1s0E32JJeZL'', 12345)';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Update an Invoice

Update an invoice 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Invoices
SET [DaysUntilDue] = 20
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Delete an invoice

Delete an invoice 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Invoices
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];