Paypal to Azure SQL Database integration

Connect Paypal to Azure SQL Database and automatically sync your finance & accounting data.

Get started free Paypal connector

Paypal

Data source

Authenticating...

Ready to connect

CONNECTOR SOURCE

Paypal to Azure SQL Database

Connect Paypal to Azure SQL Database and automatically sync your finance & accounting data. Weld extracts Invoices, Payments, Accounts, and Transactions from Paypal, loads them into Azure SQL Database, and lets you transform the data using SQL or dbt, no custom scripts required.

Paypal data schema

Open full-page schema explorer

28tables

567fields

10relationships

available_balance_currency_code

string

available_balance_value

total_balance_currency_code

string

total_balance_value

string

withheld_balance_currency_code

string

withheld_balance_value

merchant_preferences_cancel_url

string

merchant_preferences_return_url

string

name

string

payment_preferences_auto_bill_outstanding

boolean

payment_preferences_payment_failure_threshold

int

payment_preferences_setup_fee_currency_code

string

billing_plan_billing_cycle

frequency_interval_count

int

frequency_interval_unit

string

pricing_scheme_fixed_price_currency_code

string

pricing_scheme_fixed_price_value

string

pricing_scheme_pricing_model

string

pricing_scheme_version

int

billing_plan_pricing_tier

allowed_response_options_accept_claim_accept_claim_types

string

allowed_response_options_acknowledge_return_item_acknowledgement_types

string

allowed_response_options_make_offer_offer_types

string

buyer_response_due_date

date

communication_details_email

string

communication_details_note

string

communication_details_time_posted

date

create_time

date

dispute_disputed_transaction

gross_amount_currency_code

string

gross_amount_value

string

gross_asset_asset_symbol

string

dispute_disputed_transaction_item

dispute_id

string

disputed_transaction_index

int

index

int

dispute_amount_currency_code

dispute_life_cycle_stage

dispute_fund_movement

asset_quantity_in_subunits

action_info_mandatory

boolean

action_info_response_option

string

date

dispute_life_cycle_stage

string

documents

string

evidence_info_refund_ids

string

dispute_supporting_info

dispute_life_cycle_stage

dispute_offer_history

dispute_life_cycle_stage

offer_amount_currency_code

dispute_refund_transaction

gross_amount_currency_code

additional_recipients

amount_breakdown_custom_amount_currency_code

string

amount_breakdown_custom_amount_value

string

amount_breakdown_custom_label

string

amount_breakdown_discount_invoice_discount_amount_currency_code

string

amount_breakdown_discount_invoice_discount_amount_value

discount_amount_currency_code

string

discount_amount_value

tax_amount_currency_code

string

invoice_payment_transaction

billing_info_additional_info

string

billing_info_address_address_line_1

string

billing_info_address_address_line_2

string

billing_info_address_address_line_3

string

billing_info_address_admin_area_1

string

billing_info_address_admin_area_2

string

billing_info_address_admin_area_3

string

invoice_refund_transaction

invoice_invoicer_phone

billing_info_current_cycle_sequence

int

billing_info_failed_payments_count

int

billing_info_final_payment_time

date

billing_info_last_failed_payment_amount_currency_code

string

billing_info_last_failed_payment_amount_value

string

billing_info_last_failed_payment_next_payment_retry_time

date

billing_info_last_failed_payment_reason_code

string

billing_info_last_failed_payment_time

date

subscription_cycle_execution

current_pricing_scheme_version

auction_info_auction_buyer_id

string

auction_info_auction_closing_date

date

auction_info_auction_item_site

string

auction_info_auction_site

string

cart_info_paypal_invoice_id

string

cart_info_tax_inclusive

boolean

transaction_item_detail

transaction_id

string

transaction_event_code

string

index

int

adjustment_amount_currency_code

string

adjustment_amount_value

string

basic_shipping_amount_currency_code

string

basic_shipping_amount_value

string

discount_amount_currency_code

string

discount_amount_value

string

transaction_item_tax_amount

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

int

index

int

tax_amount_currency_code

transaction_item_checkout_option

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

checkout_option_value

string

_weld_synced

date

transaction_incentive

transaction_event_code

string

incentive_amount_currency_code

string

incentive_amount_value

string

incentive_code

string

incentive_program_code

Open full-page schema explorer

Everything you need to get started

Paypal

Setup guide Data schema28 tables Connector page

Azure SQL Database

Setup guide Connector page

Weld Connect API

Set up programmatically

Use the Weld Connect REST API to create Paypal connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Paypal ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "paypal",
    "destination_schema_name": "paypal_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQs

How do I sync Paypal data to Azure SQL Database?

Sign up for Weld, connect Paypal as a source and Azure SQL Database as a destination. Weld handles the extraction, loading, and lets you transform data using SQL or dbt.

What Paypal data can I sync to Azure SQL Database?

You can sync Invoices, Payments, Accounts, Transactions, and Customers. The available objects depend on your Paypal account permissions and configuration.

How often does Weld sync data from Paypal?

Sync frequency depends on your Weld plan. Schedules range from every 5 minutes to daily intervals. Each sync processes only new and changed data.

Can I transform Paypal data before it lands in Azure SQL Database?

Yes. Weld supports SQL-based transformations in the platform and integrates with dbt Cloud. You can clean, join, and model your data before analysis.

Is the Paypal to Azure SQL Database integration secure?

Yes. Weld encrypts all data in transit and at rest, is SOC 2 Type II certified, and supports IP whitelisting. Credentials are stored encrypted and never logged.