Example |
Query |
Get all Customers |
SELECT * FROM Customers
|
Get a Customer |
SELECT * FROM Customers
WHERE Id = 'abc'
|
Get Customers (Filter by Date) |
SELECT * FROM Customers
WHERE Created > '2010-01-01'
|
Insert a Customer |
INSERT INTO Customers
([Name]
, [Email]
, [Description]
, [Phone]
, [Balance]
, [AddressLine1]
, [AddressLine2]
, [AddressCity]
, [AddressState]
, [AddressCountry]
, [AddressPostalCode]
, [InvoicePrefix]
)
VALUES('Cust-1'
, 'email@abc.com'
, 'Some desc'
, '+1 222-333-4444'
, 0
, '55 Main St.'
, 'Suite 100'
, 'New York'
, 'NY'
, 'USA'
, '07204' --JSON fragment
, 'INVC'
)
|
Update a Customer |
UPDATE Customers
SET Name='Cust1-Updated'
, Email='a-updated@b.com'
, Phone='+1 800-123-2345'
, Description='Desc-updated'
, AddressLine1='Line-1-upd'
, AddressLine2='Line-2-upd'
, AddressCity='SomeCity'
, AddressState='NY'
, AddressCountry='USA'
, AddressPostalCode='112233'
, ShippingPhone='+1 800-123-2345'
, ShippingName='SHName-upd'
, ShippingAddressLine1='Line-1-upd'
, ShippingAddressLine2='Line-2-upd'
, ShippingAddressCity='SomeCity'
, ShippingAddressState='NY'
, ShippingAddressCountry='USA'
, ShippingAddressPostalCode='112233'
, Balance=100
WHERE Id='cus_IcUG2lD69ZHuol'
|
Delete a Customer |
DELETE FROM Customers
WHERE Id = 'abc'
|
Get all Products |
SELECT * FROM Products
|
Get a Product |
SELECT * FROM Products
WHERE Id = 'abc'
|
Update a Product |
UPDATE Products
SET [name] = 'new name'
WHERE Id = 'abc'
|
Inserts a Product |
INSERT INTO Products
( [Name]
, [Caption]
, [Description]
, [Type]
--, [UnitLabel] --only when product type=service
, [Active]
, [PackageDimensionsHeight]
, [PackageDimensionsWidth]
, [PackageDimensionsLength]
, [PackageDimensionsWeight]
, [URL]
, [Image1]
, [Image2]
, [Image3]
)
VALUES('SSIS PowerPack 3'
, 'SSIS Caption 3'
, 'SSIS PowerPack description long ....'
, 'good' --or service
--, 'Unit label' --only when product type=service
, 'True' --active ?
, '12'
, '13'
, '14'
, '1000'
, 'https://zappysys.com/products/ssis-powerpack/'
, 'https://zappysys.com/images/tech/web-api-logo.png'
, 'https://zappysys.com/images/tech/xml-logo.png'
, 'https://zappysys.com/images/tech/salesforce-logo.png'
)
|
Update a Product |
UPDATE Products
SET [Name]='SSIS PowerPack 3 - Updated'
, [Caption]='Caption-updated'
, [Description]='Desc-updated'
--, [UnitLabel] --only when product type=service
, [Active]='true'
, [PackageDimensionsHeight]=12
, [PackageDimensionsWidth]=13
, [PackageDimensionsLength]=14
, [PackageDimensionsWeight]=1122
, [URL]='https://zappysys.com/products/ssis-powerpack/?updated=1'
, [Image1]='https://zappysys.com/images/tech/web-api-logo.png?updated=1'
, [Image2]='https://zappysys.com/images/tech/xml-logo.png?updated=1'
WHERE Id='prod_MiSJzGZ8PDM9uh'
|
Delete a Product |
DELETE FROM Products
WHERE Id = 'abc'
|
Get all Invoices |
SELECT * FROM Invoices
|
Get an Invoice |
SELECT * FROM Invoices
WHERE Id = 'abc'
|
Get all Invoice Line Items |
SELECT * FROM InvoiceItems
|
Get an Invoice Line Item |
SELECT * FROM InvoiceItems
WHERE Id = 'abc'
|
Insert an Invoice |
INSERT INTO Invoices([Customer],[AmountRemaining])
VALUES ('cus_LqWX1s0E32JJeZL', 12345)
|
Update an Invoice |
UPDATE Invoices
SET [DaysUntilDue] = 20
WHERE Id = 'abc'
|
Delete an invoice |
DELETE FROM Invoices
WHERE Id = 'abc'
|