ADO.NET Provider for Stripe

Build 23.0.8771

Orders

Query the available orders in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 uses 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 本製品.

  • Id, Customer, Status and AccountId support the following operators: IN,<,>>=,<,<=,=.
  • Created support the following operators: IN,<,>>=,<,<=,=.

The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

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

Columns

Name Type References Description
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.
ApplicationFee Integer Integer.
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.
Email 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-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String The Id of the connected account to get orders for

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8771