Table Invoices
Description
No description available
Parameters
| Parameter | Label | Required | Options | Description | Help | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no parameters | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
Stripe
Invoices
Read/write to Invoices table using API Destination
Stripe
Invoices
Select
ODBC application
Use these SQL queries in your ODBC application data source:
Get all Invoices
Read all invoices
SELECT * FROM InvoicesGet 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 [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];Get an Invoice
Read an invoice
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Invoices
WHERE Id = ''abc''';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];Insert an Invoice
Insert an invoice
DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Invoices([Customer],[AmountRemaining])
VALUES (''cus_LqWX1s0E32JJeZL'', 12345)';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];Update an Invoice
Update an invoice
DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Invoices
SET [DaysUntilDue] = 20
WHERE Id = ''abc''';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];Delete an invoice
Delete an invoice
DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Invoices
WHERE Id = ''abc''';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];