本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。
先決條件
-
您要讀取的條紋物件。
支援的實體
實體 | 可以篩選 | 支援限制 | 支援 排序方式 | 支援選取 * | 支援分割 |
---|---|---|---|---|---|
餘額 | 否 | 否 | 否 | 是 | 否 |
餘額交易 | 是 | 是 | 否 | 是 | 是 |
費用 | 是 | 是 | 否 | 是 | 是 |
爭議 | 是 | 是 | 否 | 是 | 是 |
檔案連結 | 是 | 是 | 否 | 是 | 是 |
PaymentIntents | 是 | 是 | 否 | 是 | 是 |
SetupIntents | 是 | 是 | 否 | 是 | 是 |
支出 | 是 | 是 | 否 | 是 | 是 |
退款 | 是 | 是 | 否 | 是 | 是 |
產品 | 是 | 是 | 否 | 是 | 是 |
價格 | 是 | 是 | 否 | 是 | 是 |
優惠券 | 是 | 是 | 否 | 是 | 是 |
促銷代碼 | 是 | 是 | 否 | 是 | 是 |
稅務代碼 | 否 | 是 | 否 | 是 | 否 |
稅率 | 是 | 是 | 否 | 是 | 是 |
寄件費率 | 是 | 是 | 否 | 是 | 是 |
工作階段 | 是 | 是 | 否 | 是 | 是 |
貸項通知單 | 是 | 是 | 否 | 是 | 是 |
客戶 | 是 | 是 | 否 | 是 | 是 |
發票 | 是 | 是 | 否 | 是 | 是 |
發票項目 | 是 | 是 | 否 | 是 | 否 |
計畫 | 是 | 是 | 否 | 是 | 是 |
引號 | 是 | 是 | 否 | 是 | 否 |
訂閱 | 是 | 是 | 否 | 是 | |
訂閱項目 | 否 | 是 | 否 | 是 | 否 |
訂閱排程 | 是 | 是 | 否 | 是 | 是 |
帳戶 | 否 | 是 | 否 | 是 | 是 |
應用程式費用 | 是 | 是 | 否 | 是 | 是 |
國家/地區規格 | 否 | 是 | 否 | 是 | 否 |
轉接 | 是 | 是 | 否 | 是 | 是 |
早期詐騙警告 | 是 | 是 | 否 | 是 | 是 |
報告類型 | 否 | 否 | 否 | 是 | 否 |
範例
stripe_read = glueContext.create_dynamic_frame.from_options(
connection_type="stripe",
connection_options={
"connectionName": "connectionName",
"ENTITY_NAME": "coupons",
"API_VERSION": "v1"
}
)
條紋實體和欄位詳細資訊
實體 | 欄位 | 資料類型 | 支援的運算子 |
---|---|---|---|
餘額 | |||
有用 | 清單 | ||
connect_reserved | 清單 | ||
待定 | 清單 | ||
即時模式 | Boolean | ||
object | 字串 | ||
instant_available | 清單 | ||
發出 | Struct | ||
餘額交易 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | ||
available_on | DateTime | =, >=, <=,<,> | |
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
描述 | 字串 | ||
exchange_rate | BigDecimal | ||
費用 | Integer | ||
fee_details | 清單 | ||
net | Integer | ||
report_category | 字串 | ||
source | 字串 | = | |
status | 字串 | ||
type | 字串 | = | |
cross_border_classification | 字串 | ||
費用 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | =, <, > | |
amount_captured | Integer | ||
amount_refunded | Integer | ||
應用程式 | 字串 | ||
application_fee | 字串 | ||
application_fee_amount | Integer | ||
balance_transaction | 字串 | ||
billing_details | Struct | ||
calculated_statement_descriptor | 字串 | ||
已擷取 | Boolean | ||
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
customer | 字串 | = | |
描述 | 字串 | ||
目的地 | 字串 | ||
爭議 | 字串 | ||
有爭議 | Boolean | = | |
failure_balance_transaction | 字串 | ||
failure_code | 字串 | ||
failure_message | 字串 | ||
fraud_details | Struct | ||
發票 | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
on_behalf_of | 字串 | ||
order | 字串 | ||
結果 | Struct | ||
付費 | Boolean | ||
payment_intent | 字串 | = | |
payment_method | 字串 | ||
payment_method_details | Struct | ||
receipt_email | 字串 | ||
receipt_number | 字串 | ||
receipt_url | 字串 | ||
已退款 | Boolean | = | |
退款 | Struct | ||
檢閱 | 字串 | ||
運送 | Struct | ||
source | Struct | ||
source_transfer | 字串 | ||
statement_descriptor | 字串 | ||
statement_descriptor_suffix | 字串 | ||
status | 字串 | ||
傳輸 | 字串 | ||
transfer_data | Struct | ||
transfer_group | 字串 | = | |
爭議 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | =, <, > | |
balance_transaction | 字串 | ||
balance_transactions | 清單 | ||
費用 | 字串 | = | |
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
證據 | Struct | ||
evidence_details | Struct | ||
is_charge_refundable | Boolean | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
payment_intent | 字串 | = | |
reason | 字串 | = | |
status | 字串 | ||
payment_method_details | Struct | ||
檔案連結 | |||
id | 字串 | ||
object | 字串 | ||
已建立 | DateTime | =, >=, <=,<,> | |
已過期 | Boolean | = | |
expires_at | DateTime | ||
file | 字串 | = | |
即時模式 | Boolean | ||
中繼資料 | Struct | ||
url | 字串 | ||
PaymentIntents | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | ||
amount_capturable | Integer | ||
amount_details | Struct | ||
amount_received | Integer | ||
應用程式 | 字串 | ||
application_fee_amount | Integer | ||
auto_payment_methods | Struct | ||
Canceled_at | DateTime | ||
cancellation_reason | 字串 | ||
capture_method | 字串 | ||
client_secret | 字串 | ||
confirmation_method | 字串 | ||
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
customer | 字串 | = | |
描述 | 字串 | ||
發票 | 字串 | ||
last_payment_error | Struct | ||
latest_charge | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
next_action | Struct | ||
on_behalf_of | 字串 | ||
payment_method | 字串 | ||
payment_method_options | Struct | ||
payment_method_types | 清單 | ||
payment_method_configuration_details | Struct | ||
處理 | Struct | ||
receipt_email | 字串 | ||
檢閱 | 字串 | ||
setup_future_usage | 字串 | ||
寄件 | Struct | ||
source | 字串 | ||
statement_descriptor | 字串 | ||
statement_descriptor_suffix | 字串 | ||
status | 字串 | ||
transfer_data | Struct | ||
transfer_group | 字串 | ||
SetupIntents | |||
id | 字串 | ||
object | 字串 | ||
應用程式 | 字串 | ||
cancellation_reason | 字串 | ||
client_secret | 字串 | ||
已建立 | DateTime | =, >=, <=,<,> | |
customer | 字串 | = | |
描述 | 字串 | ||
flow_directions | 清單 | ||
last_setup_error | Struct | ||
latest_attempt | 字串 | ||
即時模式 | Boolean | ||
命令 | 字串 | ||
中繼資料 | Struct | ||
next_action | Struct | ||
on_behalf_of | 字串 | ||
payment_method | 字串 | ||
payment_method_options | Struct | ||
payment_method_types | 清單 | ||
single_use_mandate | 字串 | ||
status | 字串 | ||
使用方式 | 字串 | ||
auto_payment_methods | Struct | ||
支出 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | =, <, > | |
arrival_date | DateTime | =, >=, <=,<,> | |
自動 | Boolean | ||
balance_transaction | 字串 | ||
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
描述 | 字串 | = | |
目的地 | 字串 | ||
failure_balance_transaction | 字串 | ||
failure_code | 字串 | ||
failure_message | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
方法 | 字串 | ||
original_payout | 字串 | ||
reversed_by | 字串 | ||
reconciliation_status | 字串 | ||
source_type | 字串 | ||
statement_descriptor | 字串 | ||
status | 字串 | ||
type | 字串 | ||
application_fee | 字串 | ||
application_fee_amount | Integer | ||
退款 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | ||
balance_transaction | 字串 | ||
費用 | 字串 | = | |
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
中繼資料 | Struct | ||
destination_details | Struct | ||
payment_intent | 字串 | = | |
reason | 字串 | ||
receipt_number | 字串 | ||
source_transfer_reversal | 字串 | ||
status | 字串 | ||
transfer_reversal | 字串 | ||
產品 | |||
id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
屬性 | 清單 | ||
已建立 | DateTime | =, >=, <=,<,> | |
default_price | 字串 | ||
描述 | 字串 | ||
images | 清單 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
name | 字串 | ||
package_dimensions | Struct | ||
可出貨 | Boolean | ||
statement_descriptor | 字串 | ||
tax_code | 字串 | ||
type | 字串 | = | |
unit_label | 字串 | ||
已更新 | DateTime | ||
url | 字串 | ||
功能 | 清單 | ||
價格 | |||
id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
billing_scheme | 字串 | ||
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | = | |
custom_unit_amount | Struct | ||
即時模式 | Boolean | ||
lookup_key | 字串 | ||
中繼資料 | Struct | ||
nickname | 字串 | ||
產品 | 字串 | = | |
週期性 | Struct | ||
tax_behavior | 字串 | ||
tiers_mode | 字串 | ||
transform_quantity | Struct | ||
type | 字串 | = | |
unit_amount | Integer | ||
unit_amount_decimal | 字串 | ||
優惠券 | |||
Id | 字串 | ||
object | 字串 | ||
amount_off | Integer | ||
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | = | |
duration | 字串 | = | |
duration_in_months | Integer | =,<,> | |
即時模式 | Boolean | ||
max_redemptions | Integer | =, <, > | |
中繼資料 | Struct | ||
name | 字串 | ||
百分比折扣 | Double | = | |
redeem_by | DateTime | =, >=, <=, <, > | |
times_redeemed | Integer | ||
有效 | Boolean | ||
促銷代碼 | |||
Id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
code | 字串 | = | |
優惠券 | Struct | ||
已建立 | DateTime | =,>=,<=,<,> | |
customer | 字串 | ||
expires_at | DateTime | ||
即時模式 | Boolean | ||
max_redemptions | Integer | ||
中繼資料 | Struct | ||
限制 | Struct | ||
times_redeemed | Integer | ||
稅務代碼 | |||
Id | 字串 | ||
object | 字串 | ||
描述 | 字串 | ||
name | 字串 | ||
稅率 | |||
Id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
國家/地區 | 字串 | ||
已建立 | DateTime | =, >=, <=, <, > | |
描述 | 字串 | ||
display_name | 字串 | ||
包含 | Boolean | = | |
司法管轄區 | 字串 | ||
jurisdiction_level | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
百分比 | Double | ||
effective_percentage | Double | ||
state | 字串 | ||
tax_type | 字串 | ||
寄件費率 | |||
Id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
已建立 | DateTime | =, >=, <=, <, > | |
delivery_estimate | Struct | ||
display_name | 字串 | ||
fixed_amount | Struct | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
tax_behavior | 字串 | ||
tax_code | 字串 | ||
type | 字串 | ||
工作階段 | |||
id | 字串 | ||
object | 字串 | ||
after_expiration | Struct | ||
allow_promotion_codes | Boolean | ||
amount_subtotal | Integer | ||
amount_total | Integer | ||
auto_tax | Struct | ||
billing_address_collection | 字串 | ||
cancel_url | 字串 | ||
client_reference_id | 字串 | ||
同意 | Struct | ||
consent_collection | Struct | ||
已建立 | DateTime | =, >=, <=, <, > | |
currency | 字串 | ||
custom_text | Struct | ||
customer | 字串 | ||
customer_creation | 字串 | ||
customer_details | Struct | ||
customer_email | 字串 | ||
expires_at | DateTime | ||
發票 | 字串 | ||
invoice_creation | Struct | ||
即時模式 | Boolean | ||
locale | 字串 | ||
中繼資料 | Struct | ||
模式 | 字串 | ||
payment_intent | 字串 | = | |
payment_link | 字串 | ||
payment_method_collection | 字串 | ||
payment_method_options | Struct | ||
payment_method_types | 清單 | ||
payment_status | 字串 | ||
phone_number_collection | Struct | ||
已復原_來自 | 字串 | ||
setup_intent | 字串 | ||
shipping_address_collection | Struct | ||
shipping_cost | Struct | ||
shipping_details | Struct | ||
shipping_options | 清單 | ||
status | 字串 | ||
submit_type | 字串 | ||
訂閱 | 字串 | ||
success_url | 字串 | ||
tax_id_collection | Struct | ||
total_details | Struct | ||
url | 字串 | ||
ui_mode | 字串 | ||
貸項通知單 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | ||
已建立 | DateTime | =, >=, <=, <, > | |
currency | 字串 | ||
customer | 字串 | = | |
customer_balance_transaction | 字串 | ||
discount_amount | Integer | ||
discount_amounts | 清單 | ||
發票 | 字串 | = | |
lines | Struct | ||
即時模式 | Boolean | ||
備註 | 字串 | ||
中繼資料 | Struct | ||
number | 字串 | ||
out_of_band_amount | Integer | ||
字串 | |||
reason | 字串 | ||
退款 | 字串 | ||
status | 字串 | ||
小計 | Integer | ||
subtotal_excluding_tax | Integer | ||
tax_amounts | 清單 | ||
total | Integer | ||
total_excluding_tax | Integer | ||
type | 字串 | ||
voided_at | DateTime | ||
amount_shipping | Integer | ||
effective_at | DateTime | ||
shipping_cost | Struct | ||
客戶 | |||
id | 字串 | ||
object | 字串 | ||
address | Struct | ||
balance | Integer | ||
已建立 | DateTime | ||
currency | 字串 | =, >=, <=, <, > | |
default_source | 字串 | ||
拖欠 | Boolean | = | |
描述 | 字串 | ||
折扣 | Struct | ||
字串 | = | ||
invoice_prefix | 字串 | ||
invoice_settings | Struct | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
name | 字串 | ||
next_invoice_sequence | Integer | ||
phone | 字串 | ||
preferred_locales | 清單 | ||
運送 | Struct | ||
tax_exempt | 字串 | ||
test_clock | 字串 | ||
發票 | |||
id | 字串 | ||
object | 字串 | ||
account_country | 字串 | ||
account_name | 字串 | ||
account_tax_ids | 清單 | ||
amount_due | Integer | ||
amount_paid | Integer | ||
amount_remaining | Integer | ||
應用程式 | 字串 | ||
application_fee_amount | Integer | ||
attempt_count | Integer | ||
已嘗試 | Boolean | = | |
auto_advance | Boolean | = | |
auto_tax | Struct | ||
billing_reason | 字串 | ||
費用 | 字串 | ||
collection_method | 字串 | = | |
已建立 | DateTime | =, >=, <=, <, > | |
currency | 字串 | ||
custom_fields | 清單 | ||
customer | 字串 | = | |
customer_address | Struct | ||
customer_email | 字串 | ||
customer_name | 字串 | ||
customer_phone | 字串 | ||
customer_shipping | Struct | ||
customer_tax_exempt | 字串 | ||
customer_tax_ids | 清單 | ||
default_payment_method | 字串 | ||
default_source | 字串 | ||
default_tax_rates | 清單 | ||
描述 | 字串 | ||
折扣 | Struct | ||
折扣 | 清單 | ||
due_date | DateTime | =, >=, <=, <, > | |
ending_balance | Integer | ||
頁尾 | 字串 | ||
from_invoice | Struct | ||
託管_invoice_url | 字串 | ||
invoice_pdf | 字串 | ||
last_finalization_error | Struct | ||
latest_revision | 字串 | ||
lines | Struct | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
next_payment_attempt | DateTime | ||
number | 字串 | ||
on_behalf_of | 字串 | ||
付費 | Boolean | = | |
帶_外_帶 | Boolean | ||
payment_intent | 字串 | ||
payment_settings | Struct | ||
period_end | DateTime | =, >=, <=, <, > | |
period_start | DateTime | =, >=, <=, <, > | |
post_payment_credit_notes_amount | Integer | ||
pre_payment_credit_notes_amount | Integer | ||
引號 | 字串 | ||
receipt_number | 字串 | ||
轉譯 | Struct | ||
rendering_options | Struct | ||
start_balance | Integer | ||
statement_descriptor | 字串 | ||
status | 字串 | = | |
status_transitions | Struct | ||
訂閱 | 字串 | ||
subscription_details | Struct | ||
小計 | Integer | =, <, > | |
subtotal_excluding_tax | Integer | ||
稅金 | Integer | ||
test_clock | 字串 | ||
total | Integer | =, <, > | |
total_discount_amounts | 清單 | ||
total_excluding_tax | Integer | ||
total_tax_amounts | 清單 | ||
transfer_data | Struct | ||
webhooks_delivered_at | DateTime | ||
automatically_finalizes_at | DateTime | ||
effective_at | DateTime | ||
發行者 | Struct | ||
發票項目 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | =, <, > | |
currency | 字串 | ||
customer | 字串 | = | |
date | DateTime | ||
描述 | 字串 | ||
可折扣 | Boolean | ||
折扣 | 清單 | ||
發票 | 字串 | = | |
即時模式 | Boolean | ||
中繼資料 | Struct | ||
period | Struct | ||
計劃 | Struct | ||
價格 | Struct | ||
按比例分配 | Boolean | = | |
數量 | Integer | ||
訂閱 | 字串 | ||
subscription_item | 字串 | ||
tax_rates | 清單 | ||
test_clock | 字串 | ||
unit_amount | Integer | ||
unit_amount_decimal | 字串 | ||
計畫 | |||
id | 字串 | ||
object | 字串 | ||
active | Boolean | = | |
aggregate_usage | 字串 | ||
amount | Integer | ||
amount_decimal | 字串 | ||
billing_scheme | 字串 | ||
已建立 | DateTime | =, >=, <=, <, > | |
currency | 字串 | = | |
間隔 | 字串 | = | |
interval_count | Integer | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
nickname | 字串 | ||
產品 | 字串 | = | |
tiers_mode | 字串 | ||
transform_usage | Struct | ||
trial_period_days | Integer | =, <, > | |
usage_type | 字串 | ||
儀表 | 字串 | ||
引號 | |||
id | 字串 | ||
object | 字串 | ||
amount_subtotal | Integer | ||
amount_total | Integer | ||
應用程式 | 字串 | ||
application_fee_amount | Integer | ||
application_fee_percent | Double | ||
auto_tax | Struct | ||
collection_method | 字串 | ||
已計算 | Struct | ||
已建立 | DateTime | ||
currency | 字串 | ||
customer | 字串 | = | |
default_tax_rates | 清單 | ||
描述 | 字串 | ||
折扣 | 清單 | ||
expires_at | DateTime | ||
頁尾 | 字串 | ||
from_quote | Struct | ||
header | 字串 | ||
發票 | 字串 | ||
invoice_settings | Struct | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
number | 字串 | ||
on_behalf_of | 字串 | ||
status | 字串 | = | |
status_transitions | Struct | ||
訂閱 | 字串 | ||
subscription_data | Struct | ||
subscription_schedule | 字串 | ||
test_clock | 字串 | ||
total_details | Struct | ||
transfer_data | Struct | ||
訂閱 | |||
id | 字串 | ||
object | 字串 | ||
應用程式 | 字串 | ||
application_fee_percent | Double | ||
auto_tax | Struct | ||
billing_cycle_anchor | DateTime | ||
billing_thresholds | Struct | ||
cancel_at | DateTime | ||
cancel_at_period_end | Boolean | ||
Canceled_at | DateTime | ||
collection_method | 字串 | = | |
已建立 | DateTime | =, >=, <=,<,> | |
currency | 字串 | ||
current_period_end | DateTime | =, >=, <= | |
current_period_start | DateTime | =, >=, <= | |
customer | 字串 | = | |
days_until_due | Integer | ||
default_payment_method | 字串 | ||
default_source | 字串 | ||
default_tax_rates | 清單 | ||
描述 | 字串 | ||
折扣 | Struct | ||
ended_at | DateTime | ||
items | Struct | ||
latest_invoice | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
next_pending_invoice_item_invoice | DateTime | ||
pause_collection | Struct | ||
payment_settings | Struct | ||
pending_invoice_item_interval | Struct | ||
pending_setup_intent | 字串 | ||
pending_update | Struct | ||
計劃 | Struct | ||
數量 | Integer | ||
schedule | 字串 | ||
start_date | DateTime | ||
status | 字串 | = | |
test_clock | 字串 | ||
transfer_data | Struct | ||
trial_end | DateTime | ||
trial_start | DateTime | ||
訂閱項目 | |||
Id | 字串 | ||
object | 字串 | ||
billing_thresholds | Struct | ||
已建立 | DateTime | =, >=, <=, <, > | |
中繼資料 | Struct | ||
計劃 | Struct | ||
價格 | Struct | ||
訂閱 | 字串 | ||
tax_rates | 清單 | ||
折扣 | 清單 | ||
訂閱排程 | |||
object | 字串 | ||
應用程式 | 字串 | ||
Canceled_at | DateTime | ||
已完成_於 | DateTime | ||
已建立 | DateTime | ||
current_phase | Struct | ||
customer | 字串 | = | |
default_settings | Struct | ||
end_behavior | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
階段 | 清單 | ||
Release_at | DateTime | ||
released_subscription | 字串 | ||
renewal_interval | 字串 | ||
status | 字串 | ||
訂閱 | 字串 | ||
test_clock | 字串 | ||
帳戶 | |||
details_submitted | Boolean | ||
tos_acceptance | Struct | ||
type | 字串 | ||
中繼資料 | Struct | ||
id | 字串 | ||
object | 字串 | ||
default_currency | 字串 | ||
功能 | Struct | ||
charges_enabled | Boolean | ||
設定 | Struct | ||
需求 | Struct | ||
payouts_enabled | Boolean | ||
future_requirements | Struct | ||
external_accounts | Struct | ||
控制器 | Struct | ||
國家/地區 | 字串 | ||
字串 | |||
已建立 | DateTime | =, >=, <=, <, > | |
business_profile | Struct | ||
business_type | 字串 | ||
company | Struct | ||
應用程式費用 | |||
id | 字串 | ||
object | 字串 | ||
帳戶 | 字串 | ||
amount | Integer | =, <, > | |
amount_refunded | Integer | =, <, > | |
應用程式 | 字串 | ||
balance_transaction | 字串 | ||
費用 | 字串 | = | |
已建立 | DateTime | ||
currency | 字串 | ||
即時模式 | Boolean | ||
Origin_transaction | 字串 | ||
已退款 | Boolean | = | |
退款 | Struct | ||
fee_source | Struct | ||
國家/地區規格 | |||
id | 字串 | ||
object | 字串 | ||
default_currency | 字串 | ||
supported_bank_account_currencies | Struct | ||
supported_payment_currencies | 清單 | ||
supported_payment_methods | 清單 | ||
Support_transfer_countries | 清單 | ||
verification_fields | Struct | ||
轉接 | |||
id | 字串 | ||
object | 字串 | ||
amount | Integer | =, <, > | |
amount_reversed | Integer | ||
balance_transaction | 字串 | ||
已建立 | DateTime | =, >=, <=, <, > | |
currency | 字串 | = | |
描述 | 字串 | ||
目的地 | 字串 | = | |
destination_payment | 字串 | ||
即時模式 | Boolean | ||
中繼資料 | Struct | ||
撤銷 | Struct | ||
已反轉 | Boolean | ||
source_transaction | 字串 | ||
source_type | 字串 | ||
transfer_group | 字串 | = | |
早期詐騙警告 | |||
id | 字串 | ||
object | 字串 | ||
可操作 | Boolean | ||
費用 | 字串 | = | |
已建立 | DateTime | =, >=, <=, <, > | |
fraud_type | 字串 | ||
即時模式 | Boolean | ||
payment_intent | 字串 | = | |
報告類型 | |||
id | 字串 | ||
object | 字串 | ||
data_available_end | DateTime | ||
data_available_start | DateTime | ||
default_columns | 清單 | ||
即時模式 | Boolean | ||
name | 字串 | ||
已更新 | DateTime | ||
version | Integer |
分割查詢
如果您想要在 Spark 中使用並行PARTITION_FIELD
,NUM_PARTITIONS
可以提供其他 Spark LOWER_BOUND
選項 UPPER_BOUND
、、 。透過這些參數,原始查詢會分割為可由 Spark 任務同時執行的子查詢NUM_PARTITIONS
數目。
-
PARTITION_FIELD
:用於分割查詢的欄位名稱。 -
LOWER_BOUND
:所選分割區欄位的包含下限值。對於日期,我們接受 Spark SQL查詢中使用的 Spark 日期格式。有效值的範例:
"2024-07-01T00:00:00.000Z"
。 -
UPPER_BOUND
:所選分割區欄位的專屬上限值。 -
NUM_PARTITIONS
:分割區數量。
實體智慧分割欄位支援詳細資訊擷取於下表。
實體名稱 | 分割欄位 | 資料類型 |
---|---|---|
餘額交易 | 已建立 | DateTime |
費用 | 已建立 | DateTime |
爭議 | 已建立 | DateTime |
檔案連結 | 已建立 | DateTime |
PaymentIntents | 已建立 | DateTime |
SetupIntents | 已建立 | DateTime |
支出 | 已建立 | DateTime |
退款 | 已建立 | DateTime |
產品 | 已建立 | DateTime |
價格 | 已建立 | DateTime |
優惠券 | 已建立 | DateTime |
促銷代碼 | 已建立 | DateTime |
稅率 | 已建立 | DateTime |
寄件費率 | 已建立 | DateTime |
工作階段 | 已建立 | DateTime |
貸項通知單 | 已建立 | DateTime |
客戶 | 已建立 | DateTime |
發票 | 已建立 | DateTime |
計畫 | 已建立 | DateTime |
訂閱 | 已建立 | DateTime |
訂閱排程 | 已建立 | DateTime |
帳戶 | 已建立 | DateTime |
應用程式費用 | 已建立 | DateTime |
轉接 | 已建立 | DateTime |
早期詐騙警告 | 已建立 | DateTime |
範例
stripe_read = glueContext.create_dynamic_frame.from_options(
connection_type="stripe",
connection_options={
"connectionName": "connectionName",
"ENTITY_NAME": "coupons",
"API_VERSION": "v1",
"PARTITION_FIELD": "created"
"LOWER_BOUND": "2024-05-01T20:55:02.000Z"
"UPPER_BOUND": "2024-07-11T20:55:02.000Z"
"NUM_PARTITIONS": "10"
}
)