Query the available orders in Stripe.
Table Specific Information
Server-Side Query Support
The connector will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the connector.
- Id, Created, Customer, Status support the following operators:IN,<,>>=, <, <=, =.
The provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive:
-an Order by specifying its Id:
SELECT * FROM Orders WHERE Id='or_12345678'
-an Order by specifying its Ids:
SELECT * FROM Orders WHERE Id IN ('or_12345678','or_123456789','or_123456788')
-Orders created after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):
SELECT * FROM Orders WHERE Created > '2016-01-03'
-Orders for a given Customer:
SELECT * FROM Orders WHERE Customer='cus_12345678'
-Orders with a specific Status:
SELECT * FROM Orders WHERE Status='paid'
|Id [KEY]||String||ID of card.|
|Amount||Integer||A positive integer in the smallest currency unit (that is, 100 cents for $1.00, or 1 for ¥1, Japanese Yen being a 0-decimal currency) representing the total amount for the order.|
|Application||String||ID of the Connect Application that created the order.|
|Created||Datetime||Time of creation.|
|Charge||String||The ID of the payment used to pay for the order. Present if the order status is paid, fulfilled, or refunded.|
|Currency||String||3-letter ISO code representing the currency in which the order was made.|
|Customer||String||The customer used for the order.|
|String||The email address of the customer placing the order.|
|ExternalCouponCode||String||The external coupon code.|
|ItemsAggregate||String||List of items constituting the order.|
|SelectedShippingMethod||String||The shipping method that is currencly selected for this order, if any.|
|Shipping||String||The shipping address for the order. Present if the order is for goods to be shipped.|
|ShippingMethodsAggregate||String||A list of supported shipping methods for this order.|
|Status||String||Current order status.|
|StatusTransitions||String||The datetimes at which the order status was updated.|
|Updated||Datetime||The time when the order is last updated.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|AccountId||String||The Id of the connected account to get orders for|