Lettura da entità di Stripe - AWS Glue

Lettura da entità di Stripe

Prerequisiti

  • Un oggetto di Stripe da cui si desidera leggere.

Entità supportate

Entità Può essere Filtrato Supporta Limite Supporta Ordina per Supporta Seleziona * Supporta Partizionamento
SaldoNoNoNoNo
Transazioni di saldoNo
CostiNo
ControversieNo
LInk ai fileNo
PaymentIntentsNo
SetupIntentsNo
PagamentiNo
RimborsiNo
ProdottiNo
PrezziNo
CouponNo
Codici promozionaliNo
Codici fiscaliNoNoNo
Aliquote fiscaliNo
Tariffe di spedizioneNo
SessioniNo
Note di creditoNo
CustomerNo
FattureNo
Unità di fatturazioneNoNo
PianiNo
PreventiviNoNo
SottoscrizioniNo
Articoli di abbonamentoNoNoNo
Programmi di abbonamentoNo
AccountNoNo
Tariffe di applicazioneNo
Specifiche del PaeseNoNoNo
TrasferimentiNo
Avvisi anticipati di frodeNo
Tipi di reportNoNoNoNo

Esempio

stripe_read = glueContext.create_dynamic_frame.from_options( connection_type="stripe", connection_options={ "connectionName": "connectionName", "ENTITY_NAME": "coupons", "API_VERSION": "v1" } )

Dettagli dell'entità e del campo di Stripe

Entità Campo Tipo di dati Operatori supportati
Saldo
disponibileElenco
connect_reservedElenco
in sospesoElenco
livemodeBooleano
oggettoStringa
instant_availableElenco
issuingStruct
Transazioni di saldo
idStringa
oggettoStringa
amountNumero intero
available_onDateTime=, >=, <=,<,>
creatoDateTime=, >=, <=,<,>
currencyStringa
descriptionStringa
exchange_rateBigDecimal
feeNumero intero
fee_detailsElenco
netNumero intero
reporting_categoryStringa
sourceStringa=
statusStringa
tipoStringa=
cross_border_classificationStringa
Costi
idStringa
oggettoStringa
amountNumero intero=, <, >
amount_capturedNumero intero
amount_refundedNumero intero
applicazioneStringa
application_feeStringa
application_fee_amountNumero intero
balance_transactionStringa
billing_detailsStruct
calculated_statement_descriptorStringa
capturedBooleano
creatoDateTime=, >=, <=,<,>
currencyStringa
customerStringa=
descriptionStringa
destinazioneStringa
disputeStringa
disputedBooleano=
failure_balance_transactionStringa
failure_codeStringa
failure_messageStringa
fraud_detailsStruct
fatturaStringa
livemodeBooleano
metadataStruct
on_behalf_ofStringa
orderStringa
outcomeStruct
paidBooleano
payment_intentStringa=
payment_methodStringa
payment_method_detailsStruct
receipt_emailStringa
receipt_numberStringa
receipt_urlStringa
refundedBooleano=
refundsStruct
reviewStringa
shippingStruct
sourceStruct
source_transferStringa
statement_descriptorStringa
statement_descriptor_suffixStringa
statusStringa
transferStringa
transfer_dataStruct
transfer_groupStringa=
Controversie
idStringa
oggettoStringa
amountNumero intero=, <, >
balance_transactionStringa
balance_transactionsElenco
chargeStringa=
creatoDateTime=, >=, <=,<,>
currencyStringa
evidenceStruct
evidence_detailsStruct
is_charge_refundableBooleano
livemodeBooleano
metadataStruct
payment_intentStringa=
motivoStringa=
statusStringa
payment_method_detailsStruct
Link ai file
idStringa
oggettoStringa
creatoDateTime=, >=, <=,<,>
expiredBooleano=
expires_atDateTime
fileStringa=
livemodeBooleano
metadataStruct
urlStringa
PaymentIntents
idStringa
oggettoStringa
amountNumero intero
amount_capturableNumero intero
amount_detailsStruct
amount_receivedNumero intero
applicazioneStringa
application_fee_amountNumero intero
automatic_payment_methodsStruct
canceled_atDateTime
cancellation_reasonStringa
capture_methodStringa
client_secretStringa
confirmation_methodStringa
creatoDateTime=, >=, <=,<,>
currencyStringa
customerStringa=
descriptionStringa
fatturaStringa
last_payment_errorStruct
latest_chargeStringa
livemodeBooleano
metadataStruct
next_actionStruct
on_behalf_ofStringa
payment_methodStringa
payment_method_optionsStruct
payment_method_typesElenco
payment_method_configuration_detailsStruct
elaborazioneStruct
receipt_emailStringa
reviewStringa
setup_future_usageStringa
shippingStruct
sourceStringa
statement_descriptorStringa
statement_descriptor_suffixStringa
statusStringa
transfer_dataStruct
transfer_groupStringa
SetupIntents
idStringa
oggettoStringa
applicazioneStringa
cancellation_reasonStringa
client_secretStringa
creatoDateTime=, >=, <=,<,>
customerStringa=
descriptionStringa
flow_directionsElenco
last_setup_errorStruct
latest_attemptStringa
livemodeBooleano
mandateStringa
metadataStruct
next_actionStruct
on_behalf_ofStringa
payment_methodStringa
payment_method_optionsStruct
payment_method_typesElenco
single_use_mandateStringa
statusStringa
utilizzoStringa
automatic_payment_methodsStruct
Pagamenti
idStringa
oggettoStringa
amountNumero intero=, <, >
arrival_dateDateTime=, >=, <=,<,>
automaticBooleano
balance_transactionStringa
creatoDateTime=, >=, <=,<,>
currencyStringa
descriptionStringa=
destinazioneStringa
failure_balance_transactionStringa
failure_codeStringa
failure_messageStringa
livemodeBooleano
metadataStruct
metodoStringa
original_payoutStringa
reversed_byStringa
reconciliation_statusStringa
source_typeStringa
statement_descriptorStringa
statusStringa
tipoStringa
application_feeStringa
application_fee_amountNumero intero
Refunds (Rimborsi)
idStringa
oggettoStringa
amountNumero intero
balance_transactionStringa
chargeStringa=
creatoDateTime=, >=, <=,<,>
currencyStringa
metadataStruct
destination_detailsStruct
payment_intentStringa=
motivoStringa
receipt_numberStringa
source_transfer_reversalStringa
statusStringa
transfer_reversalStringa
Prodotti
idStringa
oggettoStringa
attivaBooleano=
attributesElenco
createdDateTime=, >=, <=,<,>
default_priceStringa
descriptionStringa
imagesElenco
livemodeBooleano
metadataStruct
nomeStringa
package_dimensionsStruct
shippableBooleano
statement_descriptorStringa
tax_codeStringa
tipoStringa=
unit_labelStringa
updatedDateTime
urlStringa
caratteristicheElenco
Prezzi
idStringa
oggettoStringa
attivaBooleano=
billing_schemeStringa
creatoDateTime=, >=, <=,<,>
currencyStringa=
custom_unit_amountStruct
livemodeBooleano
lookup_keyStringa
metadataStruct
nicknameStringa
productStringa=
recurringStruct
tax_behaviorStringa
tiers_modeStringa
transform_quantityStruct
tipoStringa=
unit_amountNumero intero
unit_amount_decimalStringa
Coupon
IdStringa
oggettoStringa
amount_offNumero intero
creatoDateTime=, >=, <=,<,>
currencyStringa=
durataStringa=
duration_in_monthsNumero intero=,<,>
livemodeBooleano
max_redemptionsNumero intero=, <, >
metadataStruct
nomeStringa
percent_offDoppio=
redeem_byDateTime=, >=, <=, <, >
times_redeemedNumero intero
validBooleano
Codici promozionali
IdStringa
oggettoStringa
attivaBooleano=
codeStringa=
couponStruct
creatoDateTime=,>=,<=,<,>
customerStringa
expires_atDateTime
livemodeBooleano
max_redemptionsNumero intero
metadataStruct
restrizioniStruct
times_redeemedNumero intero
Codici fiscali
IdStringa
oggettoStringa
descriptionStringa
nomeStringa
Aliquote fiscali
IdStringa
oggettoStringa
attivaBooleano=
countryStringa
creatoDateTime=, >=, <=, <, >
descriptionStringa
display_nameStringa
inclusiveBooleano=
jurisdictionStringa
jurisdiction_levelStringa
livemodeBooleano
metadataStruct
percentageDoppio
effective_percentageDoppio
statoStringa
tax_typeStringa
Tariffe di spedizione
IdStringa
oggettoStringa
attivaBooleano=
creatoDateTime=, >=, <=, <, >
delivery_estimateStruct
display_nameStringa
fixed_amountStruct
livemodeBooleano
metadataStruct
tax_behaviorStringa
tax_codeStringa
tipoStringa
Sessioni
idStringa
oggettoStringa
after_expirationStruct
allow_promotion_codesBooleano
amount_subtotalNumero intero
amount_totalNumero intero
automatic_taxStruct
billing_address_collectionStringa
cancel_urlStringa
client_reference_idStringa
consentStruct
consent_collectionStruct
creatoDateTime=, >=, <=, <, >
currencyStringa
custom_textStruct
customerStringa
customer_creationStringa
customer_detailsStruct
customer_emailStringa
expires_atDateTime
fatturaStringa
invoice_creationStruct
livemodeBooleano
localeStringa
metadataStruct
modeStringa
payment_intentStringa=
payment_linkStringa
payment_method_collectionStringa
payment_method_optionsStruct
payment_method_typesElenco
payment_statusStringa
phone_number_collectionStruct
recovered_fromStringa
setup_intentStringa
shipping_address_collectionStruct
shipping_costStruct
shipping_detailsStruct
shipping_optionsElenco
statusStringa
submit_typeStringa
sottoscrizioneStringa
success_urlStringa
tax_id_collectionStruct
total_detailsStruct
urlStringa
ui_modeStringa
Note di credito
idStringa
oggettoStringa
amountNumero intero
creatoDateTime=, >=, <=, <, >
currencyStringa
customerStringa=
customer_balance_transactionStringa
discount_amountNumero intero
discount_amountsElenco
fatturaStringa=
linesStruct
livemodeBooleano
memoStringa
metadataStruct
numberStringa
out_of_band_amountNumero intero
pdfStringa
motivoStringa
refundStringa
statusStringa
subtotalNumero intero
subtotal_excluding_taxNumero intero
tax_amountsElenco
totalNumero intero
total_excluding_taxNumero intero
tipoStringa
voided_atDateTime
amount_shippingNumero intero
effective_atDateTime
shipping_costStruct
Customer
idStringa
oggettoStringa
addressStruct
balanceNumero intero
creatoDateTime
currencyStringa=, >=, <=, <, >
default_sourceStringa
delinquentBooleano=
descriptionStringa
discountStruct
e-mailStringa=
invoice_prefixStringa
invoice_settingsStruct
livemodeBooleano
metadataStruct
nomeStringa
next_invoice_sequenceNumero intero
telefonoStringa
preferred_localesElenco
shippingStruct
tax_exemptStringa
test_clockStringa
Fatture
idStringa
oggettoStringa
account_countryStringa
account_nameStringa
account_tax_idsElenco
amount_dueNumero intero
amount_paidNumero intero
amount_remainingNumero intero
applicazioneStringa
application_fee_amountNumero intero
attempt_countNumero intero
attemptedBooleano=
auto_advanceBooleano=
automatic_taxStruct
billing_reasonStringa
chargeStringa
collection_methodStringa=
creatoDateTime=, >=, <=, <, >
currencyStringa
custom_fieldsElenco
customerStringa=
customer_addressStruct
customer_emailStringa
customer_nameStringa
customer_phoneStringa
customer_shippingStruct
customer_tax_exemptStringa
customer_tax_idsElenco
default_payment_methodStringa
default_sourceStringa
default_tax_ratesElenco
descriptionStringa
discountStruct
discountsElenco
due_dateDateTime=, >=, <=, <, >
ending_balanceNumero intero
footerStringa
from_invoiceStruct
hosted_invoice_urlStringa
invoice_pdfStringa
last_finalization_errorStruct
latest_revisionStringa
linesStruct
livemodeBooleano
metadataStruct
next_payment_attemptDateTime
numberStringa
on_behalf_ofStringa
paidBooleano=
paid_out_of_bandBooleano
payment_intentStringa
payment_settingsStruct
period_endDateTime=, >=, <=, <, >
period_startDateTime=, >=, <=, <, >
post_payment_credit_notes_amountNumero intero
pre_payment_credit_notes_amountNumero intero
quoteStringa
receipt_numberStringa
renderingStruct
rendering_optionsStruct
starting_balanceNumero intero
statement_descriptorStringa
statusStringa=
status_transitionsStruct
sottoscrizioneStringa
subscription_detailsStruct
subtotalNumero intero=, <, >
subtotal_excluding_taxNumero intero
taxNumero intero
test_clockStringa
totalNumero intero=, <, >
total_discount_amountsElenco
total_excluding_taxNumero intero
total_tax_amountsElenco
transfer_dataStruct
webhooks_delivered_atDateTime
automatically_finalizes_atDateTime
effective_atDateTime
approvatoreStruct
Unità di fatturazione
idStringa
oggettoStringa
amountNumero intero=, <, >
currencyStringa
customerStringa=
dataDateTime
descriptionStringa
discountableBooleano
discountsElenco
fatturaStringa=
livemodeBooleano
metadataStruct
puntoStruct
planStruct
priceStruct
prorationBooleano=
quantityNumero intero
sottoscrizioneStringa
subscription_itemStringa
tax_ratesElenco
test_clockStringa
unit_amountNumero intero
unit_amount_decimalStringa
Piani
idStringa
oggettoStringa
attivaBooleano=
aggregate_usageStringa
amountNumero intero
amount_decimalStringa
billing_schemeStringa
creatoDateTime=, >=, <=, <, >
currencyStringa=
intervalloStringa=
interval_countNumero intero
livemodeBooleano
metadataStruct
nicknameStringa
productStringa=
tiers_modeStringa
transform_usageStruct
trial_period_daysNumero intero=, <, >
usage_typeStringa
meterStringa
Preventivi
idStringa
oggettoStringa
amount_subtotalNumero intero
amount_totalNumero intero
applicazioneStringa
application_fee_amountNumero intero
application_fee_percentDoppio
automatic_taxStruct
collection_methodStringa
calcolatoStruct
creatoDateTime
currencyStringa
customerStringa=
default_tax_ratesElenco
descriptionStringa
discountsElenco
expires_atDateTime
footerStringa
from_quoteStruct
intestazioneStringa
fatturaStringa
invoice_settingsStruct
livemodeBooleano
metadataStruct
numberStringa
on_behalf_ofStringa
statusStringa=
status_transitionsStruct
sottoscrizioneStringa
subscription_dataStruct
subscription_scheduleStringa
test_clockStringa
total_detailsStruct
transfer_dataStruct
Sottoscrizioni
idStringa
oggettoStringa
applicazioneStringa
application_fee_percentDoppio
automatic_taxStruct
billing_cycle_anchorDateTime
billing_thresholdsStruct
cancel_atDateTime
cancel_at_period_endBooleano
canceled_atDateTime
collection_methodStringa=
creatoDateTime=, >=, <=,<,>
currencyStringa
current_period_endDateTime=, >=, <=
current_period_startDateTime=, >=, <=
customerStringa=
days_until_dueNumero intero
default_payment_methodStringa
default_sourceStringa
default_tax_ratesElenco
descriptionStringa
discountStruct
ended_atDateTime
itemsStruct
latest_invoiceStringa
livemodeBooleano
metadataStruct
next_pending_invoice_item_invoiceDateTime
pause_collectionStruct
payment_settingsStruct
pending_invoice_item_intervalStruct
pending_setup_intentStringa
pending_updateStruct
planStruct
quantityNumero intero
scheduleStringa
start_dateDateTime
statusStringa=
test_clockStringa
transfer_dataStruct
trial_endDateTime
trial_startDateTime
Articoli di abbonamento
IdStringa
oggettoStringa
billing_thresholdsStruct
creatoDateTime=, >=, <=, <, >
metadataStruct
planStruct
priceStruct
sottoscrizioneStringa
tax_ratesElenco
discountsElenco
Programmi di abbonamento
oggettoStringa
applicazioneStringa
canceled_atDateTime
completed_atDateTime
creatoDateTime
current_phaseStruct
customerStringa=
default_settingsStruct
end_behaviorStringa
livemodeBooleano
metadataStruct
phasesElenco
released_atDateTime
released_subscriptionStringa
renewal_intervalStringa
statusStringa
sottoscrizioneStringa
test_clockStringa
Account
details_submittedBooleano
tos_acceptanceStruct
tipoStringa
metadataStruct
idStringa
oggettoStringa
default_currencyStringa
capabilitiesStruct
charges_enabledBooleano
impostazioniStruct
requirementsStruct
payouts_enabledBooleano
future_requirementsStruct
external_accountsStruct
controllerStruct
countryStringa
e-mailStringa
creatoDateTime=, >=, <=, <, >
business_profileStruct
business_typeStringa
companyStruct
Tariffe di applicazione
idStringa
oggettoStringa
accountStringa
amountNumero intero=, <, >
amount_refundedNumero intero=, <, >
applicazioneStringa
balance_transactionStringa
chargeStringa=
creatoDateTime
currencyStringa
livemodeBooleano
originating_transactionStringa
refundedBooleano=
refundsStruct
fee_sourceStruct
Specifiche del Paese
idStringa
oggettoStringa
default_currencyStringa
supported_bank_account_currenciesStruct
supported_payment_currenciesElenco
supported_payment_methodsElenco
supported_transfer_countriesElenco
verification_fieldsStruct
Trasferimenti
idStringa
oggettoStringa
amountNumero intero=, <, >
amount_reversedNumero intero
balance_transactionStringa
creatoDateTime=, >=, <=, <, >
currencyStringa=
descriptionStringa
destinazioneStringa=
destination_paymentStringa
livemodeBooleano
metadataStruct
reversalsStruct
reversedBooleano
source_transactionStringa
source_typeStringa
transfer_groupStringa=
Avvisi anticipati di frode
idStringa
oggettoStringa
actionableBooleano
chargeStringa=
creatoDateTime=, >=, <=, <, >
fraud_typeStringa
livemodeBooleano
payment_intentStringa=
Tipi di report
idStringa
oggettoStringa
data_available_endDateTime
data_available_startDateTime
default_columnsElenco
livemodeBooleano
nomeStringa
updatedDateTime
versionNumero intero

Query di partizionamento

Se si desidera utilizzare la simultaneità in Spark, possono essere fornite opzioni Spark PARTITION_FIELD, LOWER_BOUND, UPPER_BOUND, NUM_PARTITIONS aggiuntive. Con questi parametri, la query originale viene suddivisa in NUM_PARTITIONS query secondarie che possono essere eseguite contemporaneamente dalle attività Spark.

  • PARTITION_FIELD: il nome del campo da utilizzare per partizionare la query.

  • LOWER_BOUND: un valore limite inferiore inclusivo del campo di partizione scelto.

    Per la data, accettiamo il formato di data di Spark utilizzato nelle query di Spark SQL. Esempio di valore valido: "2024-07-01T00:00:00.000Z".

  • UPPER_BOUND: un valore limite superiore esclusivo del campo di partizione scelto.

  • NUM_PARTITIONS: numero di partizioni.

I dettagli di supporto del campo di partizionamento per entità sono riportati nella tabella di seguito.

Nome entità Campo di partizionamento Tipo di dati
Transazioni di saldocreatoDateTime
CosticreatoDateTime
ControversiecreatoDateTime
Link ai filecreatoDateTime
PaymentIntentscreatoDateTime
SetupIntentscreatoDateTime
PagamenticreatoDateTime
Refunds (Rimborsi)creatoDateTime
ProdotticreatoDateTime
PrezzicreatoDateTime
CouponcreatoDateTime
Codici promozionalicreatoDateTime
Aliquote fiscalicreatoDateTime
Tariffe di spedizionecreatoDateTime
SessionicreatoDateTime
Note di creditocreatoDateTime
CustomercreatoDateTime
FatturecreatoDateTime
PianicreatoDateTime
SottoscrizionicreatoDateTime
Programmi di abbonamentocreatoDateTime
AccountcreatoDateTime
Tariffe di applicazionecreatoDateTime
TrasferimenticreatoDateTime
Avvisi anticipati di frodecreatoDateTime

Esempio

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" } )