Amazon Vendor Central API to Azure SQL Database integration

Connect Amazon Vendor Central API to Azure SQL Database and automatically sync your ecommerce platform data.

Get started free Amazon Vendor Central API connector

Amazon Vendor Central API

Data source

Authenticating...

Ready to connect

CONNECTOR SOURCE

Amazon Vendor Central API to Azure SQL Database

Connect Amazon Vendor Central API to Azure SQL Database and automatically sync your ecommerce platform data. Weld extracts Orders, Products, Customers, and Inventory from Amazon Vendor Central API, loads them into Azure SQL Database, and lets you transform the data using SQL or dbt, no custom scripts required.

Amazon Vendor Central API data schema

Open full-page schema explorer

32tables

468fields

Loading diagram…

catalog_item

purchase_order_status

vendor_purchase_order

browse_classification_display_name

string

browse_classification_classification_id

catalog_item_classification

catalog_item_dimension

catalog_item_identifier

catalog_item_product_type

catalog_item_relationship

catalog_item_sales_rank_classification

catalog_item_sales_rank_display_group_ranks

website_display_group

catalog_item_vendor_details

manufacturer_code_parent

string

product_category_display_name

string

product_category_value

string

product_group

string

product_subcategory_display_name

string

product_subcategory_value

string

replenishment_category

string

_weld_synced

date

purchase_order_status

purchase_order_number

string

purchase_order_status

selling_party_party_id

string

selling_party_address_name

string

selling_party_address_address_line_1

string

selling_party_address_address_line_2

string

purchase_order_status_item

purchase_order_number

string

item_sequence_number

string

buyer_product_identifier

string

vendor_product_identifier

string

net_cost_currency_code

string

net_cost_amount

double

net_cost_unit_of_measure

string

list_price_currency_code

string

purchase_order_status_item_ordered_quantity_detail

purchase_order_number

ordered_quantity_amount

double

ordered_quantity_unit_of_measure

string

ordered_quantity_unit_size

double

cancelled_quantity_amount

double

cancelled_quantity_unit_of_measure

string

cancelled_quantity_unit_size

double

_weld_synced

date

purchase_order_status_item_acknowledgement_status_detail

purchase_order_number

accepted_quantity_amount

double

accepted_quantity_unit_of_measure

string

accepted_quantity_unit_size

double

rejected_quantity_amount

double

rejected_quantity_unit_of_measure

string

rejected_quantity_unit_size

double

_weld_synced

date

vendor_purchase_order

purchase_order_number

string

purchase_order_state

string

order_details_purchase_order_date

date

order_details_purchase_order_changed_date

date

order_details_purchase_order_state_changed_date

date

order_details_purchase_order_type

string

order_details_import_details_method_of_payment

string

order_details_import_details_international_commercial_terms

string

vendor_purchase_order_item

purchase_order_number

string

item_sequence_number

string

amazon_product_identifier

string

vendor_product_identifier

string

ordered_quantity_amount

double

ordered_quantity_unit_of_measure

string

ordered_quantity_unit_size

double

is_back_order_allowed

boolean

vendor_forecasting_report

asin

string

forecast_generation_date

vendor_inventory_consignment_retail_report

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_inventory_manufacturing_retail_report

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_inventory_sourcing_retail_report

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_net_pure_product_margin_report

net_pure_product_margin

double

_weld_synced

date

vendor_real_time_inventory_report

highly_available_inventory

long

_weld_synced

date

vendor_real_time_sales_report

vendor_real_time_traffic_report

vendor_sales_consignment_business_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_consignment_retail_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_manufacturing_business_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_manufacturing_retail_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_sourcing_business_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_sourcing_retail_report

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_traffic_report

Open full-page schema explorer

Everything you need to get started

Amazon Vendor Central API

Setup guide Data schema32 tables Connector page

Azure SQL Database

Setup guide Connector page

Weld Connect API

Set up programmatically

Use the Weld Connect REST API to create Amazon Vendor Central API 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 Amazon Vendor Central API ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "amazon-vendor-central",
    "destination_schema_name": "amazon-vendor-central_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQs

How do I sync Amazon Vendor Central API data to Azure SQL Database?

Sign up for Weld, connect Amazon Vendor Central API 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 Amazon Vendor Central API data can I sync to Azure SQL Database?

You can sync Orders, Products, Customers, Inventory, and Transactions. The available objects depend on your Amazon Vendor Central API account permissions and configuration.

How often does Weld sync data from Amazon Vendor Central API?

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 Amazon Vendor Central API 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 Amazon Vendor Central API 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.