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) |

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) |

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];