Lectura desde entidades de Stripe
Requisitos previos
-
Un objeto de Stripe desde el que desea leer.
Entidades compatibles
| Entidad | Se puede filtrar | Admite límite | Admite Ordenar por | Admite Seleccionar * | Admite Partición |
|---|---|---|---|---|---|
| Saldo | No | No | No | Sí | No |
| Transacciones de saldo | Sí | Sí | No | Sí | Sí |
| Cargos | Sí | Sí | No | Sí | Sí |
| Disputas | Sí | Sí | No | Sí | Sí |
| Enlaces a los archivos | Sí | Sí | No | Sí | Sí |
| PaymentIntents | Sí | Sí | No | Sí | Sí |
| SetupIntents | Sí | Sí | No | Sí | Sí |
| Pagos | Sí | Sí | No | Sí | Sí |
| Reembolsos | Sí | Sí | No | Sí | Sí |
| Productos | Sí | Sí | No | Sí | Sí |
| Precios | Sí | Sí | No | Sí | Sí |
| Cupones | Sí | Sí | No | Sí | Sí |
| Códigos de promoción | Sí | Sí | No | Sí | Sí |
| Códigos fiscales | No | Sí | No | Sí | No |
| Cuotas fiscales | Sí | Sí | No | Sí | Sí |
| Cuotas de envío | Sí | Sí | No | Sí | Sí |
| Sesiones | Sí | Sí | No | Sí | Sí |
| Notas de crédito | Sí | Sí | No | Sí | Sí |
| Cliente | Sí | Sí | No | Sí | Sí |
| Facturas | Sí | Sí | No | Sí | Sí |
| Elementos de la factura | Sí | Sí | No | Sí | No |
| Planes | Sí | Sí | No | Sí | Sí |
| Cuotas | Sí | Sí | No | Sí | No |
| Suscripciones | Sí | Sí | No | Sí | |
| Elementos de suscripción | No | Sí | No | Sí | No |
| Esquemas de suscripción | Sí | Sí | No | Sí | Sí |
| Cuentas | No | Sí | No | Sí | Sí |
| Tarifas de la aplicación | Sí | Sí | No | Sí | Sí |
| Especificaciones de país | No | Sí | No | Sí | No |
| Transferencias | Sí | Sí | No | Sí | Sí |
| Advertencias anticipadas de fraude | Sí | Sí | No | Sí | Sí |
| Tipos de informes | No | No | No | Sí | No |
Ejemplo
stripe_read = glueContext.create_dynamic_frame.from_options( connection_type="stripe", connection_options={ "connectionName": "connectionName", "ENTITY_NAME": "coupons", "API_VERSION": "v1" } )
Detalles de la entidad y del campo de Stripe
| Entidad | Campo | Tipo de datos | Operadores admitidos |
|---|---|---|---|
| Saldo | |||
| available | Enumeración | ||
| connect_reserved | Enumeración | ||
| pendiente | Enumeración | ||
| livemode | Booleano | ||
| objeto | Cadena | ||
| instant_available | Enumeración | ||
| issuing | Struct | ||
| Transacciones de saldo | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | ||
| available_on | DateTime | =, >=, <=,<,> | |
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| Descripción | Cadena | ||
| exchange_rate | BigDecimal | ||
| fee | Entero | ||
| fee_details | Enumeración | ||
| net | Entero | ||
| reporting_category | Cadena | ||
| origen | Cadena | = | |
| status | Cadena | ||
| type | Cadena | = | |
| cross_border_classification | Cadena | ||
| Cargos | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | =, <, > | |
| amount_captured | Entero | ||
| amount_refunded | Entero | ||
| aplicación | Cadena | ||
| application_fee | Cadena | ||
| application_fee_amount | Entero | ||
| balance_transaction | Cadena | ||
| billing_details | Struct | ||
| calculated_statement_descriptor | Cadena | ||
| captured | Booleano | ||
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| cliente | Cadena | = | |
| Descripción | Cadena | ||
| destination | Cadena | ||
| dispute | Cadena | ||
| disputed | Booleano | = | |
| failure_balance_transaction | Cadena | ||
| failure_code | Cadena | ||
| failure_message | Cadena | ||
| fraud_details | Struct | ||
| factura | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| on_behalf_of | Cadena | ||
| orden | Cadena | ||
| outcome | Struct | ||
| paid | Booleano | ||
| payment_intent | Cadena | = | |
| payment_method | Cadena | ||
| payment_method_details | Struct | ||
| receipt_email | Cadena | ||
| receipt_number | Cadena | ||
| receipt_url | Cadena | ||
| refunded | Booleano | = | |
| reembolsos | Struct | ||
| revisión | Cadena | ||
| shipping | Struct | ||
| origen | Struct | ||
| source_transfer | Cadena | ||
| statement_descriptor | Cadena | ||
| statement_descriptor_suffix | Cadena | ||
| status | Cadena | ||
| transfer | Cadena | ||
| transfer_data | Struct | ||
| transfer_group | Cadena | = | |
| Disputas | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | =, <, > | |
| balance_transaction | Cadena | ||
| balance_transactions | Enumeración | ||
| cargo | Cadena | = | |
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| evidence | Struct | ||
| evidence_details | Struct | ||
| is_charge_refundable | Booleano | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| payment_intent | Cadena | = | |
| razón | Cadena | = | |
| status | Cadena | ||
| payment_method_details | Struct | ||
| Enlaces a los archivos | |||
| id | Cadena | ||
| objeto | Cadena | ||
| created | DateTime | =, >=, <=,<,> | |
| expired | Booleano | = | |
| expires_at | DateTime | ||
| archivo | Cadena | = | |
| livemode | Booleano | ||
| metadatos | Struct | ||
| url | Cadena | ||
| PaymentIntents | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | ||
| amount_capturable | Entero | ||
| amount_details | Struct | ||
| amount_received | Entero | ||
| aplicación | Cadena | ||
| application_fee_amount | Entero | ||
| automatic_payment_methods | Struct | ||
| canceled_at | DateTime | ||
| cancellation_reason | Cadena | ||
| capture_method | Cadena | ||
| client_secret | Cadena | ||
| confirmation_method | Cadena | ||
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| cliente | Cadena | = | |
| Descripción | Cadena | ||
| factura | Cadena | ||
| last_payment_error | Struct | ||
| latest_charge | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| next_action | Struct | ||
| on_behalf_of | Cadena | ||
| payment_method | Cadena | ||
| payment_method_options | Struct | ||
| payment_method_types | Enumeración | ||
| payment_method_configuration_details | Struct | ||
| En proceso | Struct | ||
| receipt_email | Cadena | ||
| revisión | Cadena | ||
| setup_future_usage | Cadena | ||
| shipping | Struct | ||
| origen | Cadena | ||
| statement_descriptor | Cadena | ||
| statement_descriptor_suffix | Cadena | ||
| status | Cadena | ||
| transfer_data | Struct | ||
| transfer_group | Cadena | ||
| SetupIntents | |||
| id | Cadena | ||
| objeto | Cadena | ||
| aplicación | Cadena | ||
| cancellation_reason | Cadena | ||
| client_secret | Cadena | ||
| created | DateTime | =, >=, <=,<,> | |
| cliente | Cadena | = | |
| Descripción | Cadena | ||
| flow_directions | Enumeración | ||
| last_setup_error | Struct | ||
| latest_attempt | Cadena | ||
| livemode | Booleano | ||
| mandate | Cadena | ||
| metadatos | Struct | ||
| next_action | Struct | ||
| on_behalf_of | Cadena | ||
| payment_method | Cadena | ||
| payment_method_options | Struct | ||
| payment_method_types | Enumeración | ||
| single_use_mandate | Cadena | ||
| status | Cadena | ||
| uso | Cadena | ||
| automatic_payment_methods | Struct | ||
| Pagos | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | =, <, > | |
| arrival_date | DateTime | =, >=, <=,<,> | |
| automatic | Booleano | ||
| balance_transaction | Cadena | ||
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| Descripción | Cadena | = | |
| destination | Cadena | ||
| failure_balance_transaction | Cadena | ||
| failure_code | Cadena | ||
| failure_message | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| method | Cadena | ||
| original_payout | Cadena | ||
| reversed_by | Cadena | ||
| reconciliation_status | Cadena | ||
| source_type | Cadena | ||
| statement_descriptor | Cadena | ||
| status | Cadena | ||
| type | Cadena | ||
| application_fee | Cadena | ||
| application_fee_amount | Entero | ||
| Reembolsos | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | ||
| balance_transaction | Cadena | ||
| cargo | Cadena | = | |
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| metadatos | Struct | ||
| destination_details | Struct | ||
| payment_intent | Cadena | = | |
| razón | Cadena | ||
| receipt_number | Cadena | ||
| source_transfer_reversal | Cadena | ||
| status | Cadena | ||
| transfer_reversal | Cadena | ||
| Productos | |||
| id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| atributos | Enumeración | ||
| created | DateTime | =, >=, <=,<,> | |
| default_price | Cadena | ||
| Descripción | Cadena | ||
| images | Enumeración | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| nombre | Cadena | ||
| package_dimensions | Struct | ||
| shippable | Booleano | ||
| statement_descriptor | Cadena | ||
| tax_code | Cadena | ||
| type | Cadena | = | |
| unit_label | Cadena | ||
| updated | DateTime | ||
| url | Cadena | ||
| características | Enumeración | ||
| Precios | |||
| id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| billing_scheme | Cadena | ||
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | = | |
| custom_unit_amount | Struct | ||
| livemode | Booleano | ||
| lookup_key | Cadena | ||
| metadatos | Struct | ||
| nickname | Cadena | ||
| producto | Cadena | = | |
| recurring | Struct | ||
| tax_behavior | Cadena | ||
| tiers_mode | Cadena | ||
| transform_quantity | Struct | ||
| type | Cadena | = | |
| unit_amount | Entero | ||
| unit_amount_decimal | Cadena | ||
| Cupones | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| amount_off | Entero | ||
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | = | |
| Duración | Cadena | = | |
| duration_in_months | Entero | =,<,> | |
| livemode | Booleano | ||
| max_redemptions | Entero | =, <, > | |
| metadatos | Struct | ||
| nombre | Cadena | ||
| percent_off | Doble | = | |
| redeem_by | DateTime | =, >=, <=, <, > | |
| times_redeemed | Entero | ||
| válido | Booleano | ||
| Códigos de promoción | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| code | Cadena | = | |
| coupon | Struct | ||
| created | DateTime | =,>=,<=,<,> | |
| cliente | Cadena | ||
| expires_at | DateTime | ||
| livemode | Booleano | ||
| max_redemptions | Entero | ||
| metadatos | Struct | ||
| restricciones | Struct | ||
| times_redeemed | Entero | ||
| Códigos fiscales | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| Descripción | Cadena | ||
| nombre | Cadena | ||
| Cuotas fiscales | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| país | Cadena | ||
| created | DateTime | =, >=, <=, <, > | |
| Descripción | Cadena | ||
| display_name | Cadena | ||
| inclusive | Booleano | = | |
| jurisdiction | Cadena | ||
| jurisdiction_level | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| percentage | Doble | ||
| effective_percentage | Doble | ||
| estado | Cadena | ||
| tax_type | Cadena | ||
| Cuotas de envío | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| created | DateTime | =, >=, <=, <, > | |
| delivery_estimate | Struct | ||
| display_name | Cadena | ||
| fixed_amount | Struct | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| tax_behavior | Cadena | ||
| tax_code | Cadena | ||
| type | Cadena | ||
| Sesiones | |||
| id | Cadena | ||
| objeto | Cadena | ||
| after_expiration | Struct | ||
| allow_promotion_codes | Booleano | ||
| amount_subtotal | Entero | ||
| amount_total | Entero | ||
| automatic_tax | Struct | ||
| billing_address_collection | Cadena | ||
| cancel_url | Cadena | ||
| client_reference_id | Cadena | ||
| consent | Struct | ||
| consent_collection | Struct | ||
| created | DateTime | =, >=, <=, <, > | |
| divisa | Cadena | ||
| custom_text | Struct | ||
| cliente | Cadena | ||
| customer_creation | Cadena | ||
| customer_details | Struct | ||
| customer_email | Cadena | ||
| expires_at | DateTime | ||
| factura | Cadena | ||
| invoice_creation | Struct | ||
| livemode | Booleano | ||
| locale | Cadena | ||
| metadatos | Struct | ||
| mode | Cadena | ||
| payment_intent | Cadena | = | |
| payment_link | Cadena | ||
| payment_method_collection | Cadena | ||
| payment_method_options | Struct | ||
| payment_method_types | Enumeración | ||
| payment_status | Cadena | ||
| phone_number_collection | Struct | ||
| recovered_from | Cadena | ||
| setup_intent | Cadena | ||
| shipping_address_collection | Struct | ||
| shipping_cost | Struct | ||
| shipping_details | Struct | ||
| shipping_options | Enumeración | ||
| status | Cadena | ||
| submit_type | Cadena | ||
| Suscripción | Cadena | ||
| success_url | Cadena | ||
| tax_id_collection | Struct | ||
| total_details | Struct | ||
| url | Cadena | ||
| ui_mode | Cadena | ||
| Notas de crédito | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | ||
| created | DateTime | =, >=, <=, <, > | |
| divisa | Cadena | ||
| cliente | Cadena | = | |
| customer_balance_transaction | Cadena | ||
| discount_amount | Entero | ||
| discount_amounts | Enumeración | ||
| factura | Cadena | = | |
| lines | Struct | ||
| livemode | Booleano | ||
| memo | Cadena | ||
| metadatos | Struct | ||
| número | Cadena | ||
| out_of_band_amount | Entero | ||
| Cadena | |||
| razón | Cadena | ||
| refund | Cadena | ||
| status | Cadena | ||
| subtotal | Entero | ||
| subtotal_excluding_tax | Entero | ||
| tax_amounts | Enumeración | ||
| total | Entero | ||
| total_excluding_tax | Entero | ||
| type | Cadena | ||
| voided_at | DateTime | ||
| amount_shipping | Entero | ||
| effective_at | DateTime | ||
| shipping_cost | Struct | ||
| Cliente | |||
| id | Cadena | ||
| objeto | Cadena | ||
| dirección | Struct | ||
| balance | Entero | ||
| created | DateTime | ||
| divisa | Cadena | =, >=, <=, <, > | |
| default_source | Cadena | ||
| delinquent | Booleano | = | |
| Descripción | Cadena | ||
| discount | Struct | ||
| correo electrónico | Cadena | = | |
| invoice_prefix | Cadena | ||
| invoice_settings | Struct | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| nombre | Cadena | ||
| next_invoice_sequence | Entero | ||
| phone | Cadena | ||
| preferred_locales | Enumeración | ||
| shipping | Struct | ||
| tax_exempt | Cadena | ||
| test_clock | Cadena | ||
| Facturas | |||
| id | Cadena | ||
| objeto | Cadena | ||
| account_country | Cadena | ||
| account_name | Cadena | ||
| account_tax_ids | Enumeración | ||
| amount_due | Entero | ||
| amount_paid | Entero | ||
| amount_remaining | Entero | ||
| aplicación | Cadena | ||
| application_fee_amount | Entero | ||
| attempt_count | Entero | ||
| attempted | Booleano | = | |
| auto_advance | Booleano | = | |
| automatic_tax | Struct | ||
| billing_reason | Cadena | ||
| cargo | Cadena | ||
| collection_method | Cadena | = | |
| created | DateTime | =, >=, <=, <, > | |
| divisa | Cadena | ||
| custom_fields | Enumeración | ||
| cliente | Cadena | = | |
| customer_address | Struct | ||
| customer_email | Cadena | ||
| customer_name | Cadena | ||
| customer_phone | Cadena | ||
| customer_shipping | Struct | ||
| customer_tax_exempt | Cadena | ||
| customer_tax_ids | Enumeración | ||
| default_payment_method | Cadena | ||
| default_source | Cadena | ||
| default_tax_rates | Enumeración | ||
| Descripción | Cadena | ||
| discount | Struct | ||
| discounts | Enumeración | ||
| due_date | DateTime | =, >=, <=, <, > | |
| ending_balance | Entero | ||
| footer | Cadena | ||
| from_invoice | Struct | ||
| hosted_invoice_url | Cadena | ||
| invoice_pdf | Cadena | ||
| last_finalization_error | Struct | ||
| latest_revision | Cadena | ||
| lines | Struct | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| next_payment_attempt | DateTime | ||
| número | Cadena | ||
| on_behalf_of | Cadena | ||
| paid | Booleano | = | |
| paid_out_of_band | Booleano | ||
| payment_intent | Cadena | ||
| payment_settings | Struct | ||
| period_end | DateTime | =, >=, <=, <, > | |
| period_start | DateTime | =, >=, <=, <, > | |
| post_payment_credit_notes_amount | Entero | ||
| pre_payment_credit_notes_amount | Entero | ||
| quote | Cadena | ||
| receipt_number | Cadena | ||
| rendering | Struct | ||
| rendering_options | Struct | ||
| starting_balance | Entero | ||
| statement_descriptor | Cadena | ||
| status | Cadena | = | |
| status_transitions | Struct | ||
| Suscripción | Cadena | ||
| subscription_details | Struct | ||
| subtotal | Entero | =, <, > | |
| subtotal_excluding_tax | Entero | ||
| tax | Entero | ||
| test_clock | Cadena | ||
| total | Entero | =, <, > | |
| total_discount_amounts | Enumeración | ||
| total_excluding_tax | Entero | ||
| total_tax_amounts | Enumeración | ||
| transfer_data | Struct | ||
| webhooks_delivered_at | DateTime | ||
| automatically_finalizes_at | DateTime | ||
| effective_at | DateTime | ||
| emisor | Struct | ||
| Elementos de la factura | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | =, <, > | |
| divisa | Cadena | ||
| cliente | Cadena | = | |
| date | DateTime | ||
| Descripción | Cadena | ||
| discountable | Booleano | ||
| discounts | Enumeración | ||
| factura | Cadena | = | |
| livemode | Booleano | ||
| metadatos | Struct | ||
| periodo | Struct | ||
| plan | Struct | ||
| precio | Struct | ||
| proration | Booleano | = | |
| quantity | Entero | ||
| Suscripción | Cadena | ||
| subscription_item | Cadena | ||
| tax_rates | Enumeración | ||
| test_clock | Cadena | ||
| unit_amount | Entero | ||
| unit_amount_decimal | Cadena | ||
| Planes | |||
| id | Cadena | ||
| objeto | Cadena | ||
| activa | Booleano | = | |
| aggregate_usage | Cadena | ||
| cantidad | Entero | ||
| amount_decimal | Cadena | ||
| billing_scheme | Cadena | ||
| created | DateTime | =, >=, <=, <, > | |
| divisa | Cadena | = | |
| intervalo | Cadena | = | |
| interval_count | Entero | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| nickname | Cadena | ||
| producto | Cadena | = | |
| tiers_mode | Cadena | ||
| transform_usage | Struct | ||
| trial_period_days | Entero | =, <, > | |
| usage_type | Cadena | ||
| medidor | Cadena | ||
| Cuotas | |||
| id | Cadena | ||
| objeto | Cadena | ||
| amount_subtotal | Entero | ||
| amount_total | Entero | ||
| aplicación | Cadena | ||
| application_fee_amount | Entero | ||
| application_fee_percent | Doble | ||
| automatic_tax | Struct | ||
| collection_method | Cadena | ||
| computed | Struct | ||
| created | DateTime | ||
| divisa | Cadena | ||
| cliente | Cadena | = | |
| default_tax_rates | Enumeración | ||
| Descripción | Cadena | ||
| discounts | Enumeración | ||
| expires_at | DateTime | ||
| footer | Cadena | ||
| from_quote | Struct | ||
| header | Cadena | ||
| factura | Cadena | ||
| invoice_settings | Struct | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| número | Cadena | ||
| on_behalf_of | Cadena | ||
| status | Cadena | = | |
| status_transitions | Struct | ||
| Suscripción | Cadena | ||
| subscription_data | Struct | ||
| subscription_schedule | Cadena | ||
| test_clock | Cadena | ||
| total_details | Struct | ||
| transfer_data | Struct | ||
| Suscripciones | |||
| id | Cadena | ||
| objeto | Cadena | ||
| aplicación | Cadena | ||
| application_fee_percent | Doble | ||
| automatic_tax | Struct | ||
| billing_cycle_anchor | DateTime | ||
| billing_thresholds | Struct | ||
| cancel_at | DateTime | ||
| cancel_at_period_end | Booleano | ||
| canceled_at | DateTime | ||
| collection_method | Cadena | = | |
| created | DateTime | =, >=, <=,<,> | |
| divisa | Cadena | ||
| current_period_end | DateTime | =, >=, <= | |
| current_period_start | DateTime | =, >=, <= | |
| cliente | Cadena | = | |
| days_until_due | Entero | ||
| default_payment_method | Cadena | ||
| default_source | Cadena | ||
| default_tax_rates | Enumeración | ||
| Descripción | Cadena | ||
| discount | Struct | ||
| ended_at | DateTime | ||
| items | Struct | ||
| latest_invoice | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| next_pending_invoice_item_invoice | DateTime | ||
| pause_collection | Struct | ||
| payment_settings | Struct | ||
| pending_invoice_item_interval | Struct | ||
| pending_setup_intent | Cadena | ||
| pending_update | Struct | ||
| plan | Struct | ||
| quantity | Entero | ||
| horario | Cadena | ||
| start_date | DateTime | ||
| status | Cadena | = | |
| test_clock | Cadena | ||
| transfer_data | Struct | ||
| trial_end | DateTime | ||
| trial_start | DateTime | ||
| Elementos de suscripción | |||
| Id | Cadena | ||
| objeto | Cadena | ||
| billing_thresholds | Struct | ||
| created | DateTime | =, >=, <=, <, > | |
| metadatos | Struct | ||
| plan | Struct | ||
| precio | Struct | ||
| Suscripción | Cadena | ||
| tax_rates | Enumeración | ||
| discounts | Enumeración | ||
| Esquemas de suscripción | |||
| objeto | Cadena | ||
| aplicación | Cadena | ||
| canceled_at | DateTime | ||
| completed_at | DateTime | ||
| created | DateTime | ||
| current_phase | Struct | ||
| cliente | Cadena | = | |
| default_settings | Struct | ||
| end_behavior | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| phases | Enumeración | ||
| released_at | DateTime | ||
| released_subscription | Cadena | ||
| renewal_interval | Cadena | ||
| status | Cadena | ||
| Suscripción | Cadena | ||
| test_clock | Cadena | ||
| Cuentas | |||
| details_submitted | Booleano | ||
| tos_acceptance | Struct | ||
| type | Cadena | ||
| metadatos | Struct | ||
| id | Cadena | ||
| objeto | Cadena | ||
| default_currency | Cadena | ||
| capacidades | Struct | ||
| charges_enabled | Booleano | ||
| ajustes | Struct | ||
| Requisitos | Struct | ||
| payouts_enabled | Booleano | ||
| future_requirements | Struct | ||
| external_accounts | Struct | ||
| controlador | Struct | ||
| país | Cadena | ||
| correo electrónico | Cadena | ||
| created | DateTime | =, >=, <=, <, > | |
| business_profile | Struct | ||
| business_type | Cadena | ||
| company | Struct | ||
| Tarifas de la aplicación | |||
| id | Cadena | ||
| objeto | Cadena | ||
| inscrita | Cadena | ||
| cantidad | Entero | =, <, > | |
| amount_refunded | Entero | =, <, > | |
| aplicación | Cadena | ||
| balance_transaction | Cadena | ||
| cargo | Cadena | = | |
| created | DateTime | ||
| divisa | Cadena | ||
| livemode | Booleano | ||
| originating_transaction | Cadena | ||
| refunded | Booleano | = | |
| reembolsos | Struct | ||
| fee_source | Struct | ||
| Especificaciones de país | |||
| id | Cadena | ||
| objeto | Cadena | ||
| default_currency | Cadena | ||
| supported_bank_account_currencies | Struct | ||
| supported_payment_currencies | Enumeración | ||
| supported_payment_methods | Enumeración | ||
| supported_transfer_countries | Enumeración | ||
| verification_fields | Struct | ||
| Transferencias | |||
| id | Cadena | ||
| objeto | Cadena | ||
| cantidad | Entero | =, <, > | |
| amount_reversed | Entero | ||
| balance_transaction | Cadena | ||
| created | DateTime | =, >=, <=, <, > | |
| divisa | Cadena | = | |
| Descripción | Cadena | ||
| destination | Cadena | = | |
| destination_payment | Cadena | ||
| livemode | Booleano | ||
| metadatos | Struct | ||
| reversals | Struct | ||
| reversed | Booleano | ||
| source_transaction | Cadena | ||
| source_type | Cadena | ||
| transfer_group | Cadena | = | |
| Advertencias anticipadas de fraude | |||
| id | Cadena | ||
| objeto | Cadena | ||
| actionable | Booleano | ||
| cargo | Cadena | = | |
| created | DateTime | =, >=, <=, <, > | |
| fraud_type | Cadena | ||
| livemode | Booleano | ||
| payment_intent | Cadena | = | |
| Tipos de informes | |||
| id | Cadena | ||
| objeto | Cadena | ||
| data_available_end | DateTime | ||
| data_available_start | DateTime | ||
| default_columns | Enumeración | ||
| livemode | Booleano | ||
| nombre | Cadena | ||
| updated | DateTime | ||
| versión | Entero |
Consultas de partición
Puede proporcionar las opciones adicionales de Spark PARTITION_FIELD, LOWER_BOUND, UPPER_BOUND y NUM_PARTITIONS si quiere usar la simultaneidad en Spark. Con estos parámetros, la consulta original se dividiría en un número NUM_PARTITIONS de subconsultas que las tareas de Spark pueden ejecutar simultáneamente.
-
PARTITION_FIELD: el nombre del campo que se usará para particionar la consulta. -
LOWER_BOUND: un valor de límite inferior inclusivo del campo de partición elegido.Para la fecha, aceptamos el formato de fecha de Spark que se usa en las consultas de Spark SQL. Ejemplo de valor válido:
"2024-07-01T00:00:00.000Z". -
UPPER_BOUND: un valor límite superior exclusivo del campo de partición elegido. -
NUM_PARTITIONS: el número de particiones.
Los detalles de compatibilidad del campo de particionamiento por entidad se muestran en la siguiente tabla.
| Nombre de la entidad | Campo de partición | Tipo de datos |
|---|---|---|
| Transacciones de saldo | created | DateTime |
| Cargos | created | DateTime |
| Disputas | created | DateTime |
| Enlaces a los archivos | created | DateTime |
| PaymentIntents | created | DateTime |
| SetupIntents | created | DateTime |
| Pagos | created | DateTime |
| Reembolsos | created | DateTime |
| Productos | created | DateTime |
| Precios | created | DateTime |
| Cupones | created | DateTime |
| Códigos de promoción | created | DateTime |
| Cuotas fiscales | created | DateTime |
| Cuotas de envío | created | DateTime |
| Sesiones | created | DateTime |
| Notas de crédito | created | DateTime |
| Cliente | created | DateTime |
| Facturas | created | DateTime |
| Planes | created | DateTime |
| Suscripciones | created | DateTime |
| Esquemas de suscripción | created | DateTime |
| Cuentas | created | DateTime |
| Tarifas de la aplicación | created | DateTime |
| Transferencias | created | DateTime |
| Advertencias anticipadas de fraude | created | DateTime |
Ejemplo
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" } )