Integration Specifications
Refresh Cadence
The Walmart Marketplace extractor updates daily. In each update, we pull data from the previous 7 complete days.
Availability
This integration is available for:
Enterprise
Growth
API Endpoints
This extractor is based on the Walmart Developer Portal docs. The following endpoints are used to replicate data into Daasity:
Fulfillment Orders Status (no historical extraction)
Inventories (no historical extraction)
Items (no historical extraction)
Entity Relationship Diagram (ERD)
Walmart Marketplace Schema
The Walmart Marketplace extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Inventories
Endpoint: Inventories
Update Method: Upsert
Table Name: walmart_marketplace.inventories
Inventory Nodes
Endpoint: Inventories
Update Method: Upsert
nodes are nested into each Inventory
Table Name: walmart_marketplace.inventory_nodes
Item Unpublished Reasons
Endpoint: Items
Update Method: Upsert
Reasons are nested inside the reason element, which is nested into the unpublishedReasons element of Items
Table Name: walmart_marketplace.item_reasons
Items
Endpoint: Items
Update Method: Upsert
Table Name: walmart_marketplace.items
Return Line Group Label Carrier Info List
Endpoint: Returns
Update Method: Upsert
carrierInfoLists are are nested into each element of the Labels collection, which are in turn nested into each element of the returnLineGroups collection within Return Orders
Table Name: walmart_marketplace.return_line_group_label_carrier_info_lists
Return Line Group Labels
Endpoint: Returns
Update Method: Upsert
Labels are are nested into each element of the returnLineGroups collection within Return Orders
Table Name: walmart_marketplace.return_line_group_labels
Return Line Group Return Lines
Endpoint: Returns
Update Method: Upsert
returnLines are are nested into each element of the returnLineGroups collection within Return Orders
Table Name: walmart_marketplace.return_line_group_return_lines
Return Order Line Charge References
Endpoint: Returns
Update Method: Upsert
references are nested into charges, in turn nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_charge_references
Return Order Line Charge Taxes
Endpoint: Returns
Update Method: Upsert
tax elements are nested into charges, in turn nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_charge_taxes
Return Order Line Charges
Endpoint: Returns
Update Method: Upsert
returnLines are nested into each element of the returnLines within each Return Order
Table Name: walmart_marketplace.return_order_line_charges
Return Order Line Charge Totals
Endpoint: Returns
Update Method: Upsert
chargeTotals are nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_charge_totals
Return Order Line Current Tracking Statuses
Endpoint: Returns
Update Method: Upsert
currentTrackingStatuses are nested within returnLines, which in turn are nested into each Return Order
Table Name: walmart_marketplace.return_order_line_current_tracking_statuses
Return Order Line Refund Channels
Endpoint: Returns
Update Method: Upsert
refundChannels are nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_refund_channels
Return Order Line Tracking Detail References
Endpoint: Returns
Update Method: Upsert
references are nested within returnTrackingDetail items, which in turn are nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_tracking_details
Return Order Line Tracking Details
Endpoint: Returns
Update Method: Upsert
returnTrackingDetail items are nested into returnLines, within each Return Order
Table Name: walmart_marketplace.return_order_line_tracking_details
Return Order Lines
Endpoint: Returns
Update Method: Upsert
returnLines are are nested into each element of the returnOrderLines collection within Return Orders
Table Name: walmart_marketplace.return_order_lines
Returns
Endpoint: Returns
Update Method: Upsert
Table Name: walmart_marketplace.returns
Order Fulfillment Status Order Line Quantity Infos
Endpoint: Fulfillment Orders Status
Update Method: Upsert
orderLineQuantityInfo are nested into orderLines, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_order_line_quantity_infos
Order Fulfillment Status Order Lines
Endpoint: Fulfillment Orders Status
Update Method: Upsert
orderLines are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_order_lines
Order Fulfillment Status Shipment Lines
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipmentLines are nested into shipments, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipment_lines
Order Fulfillment Status Shipments
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipments are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipments
Order Fulfillment Status Shipment Dates
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipmentDates are nested into shipments, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipment_dates
Order Fulfillment Statuses
Endpoint: Fulfillment Orders Status
Update Method: Upsert
Table Name: walmart_marketplace.order_fulfillment_statuses
Order Fulfillment Status Order Line Quantity Infos
Endpoint: Fulfillment Orders Status
Update Method: Upsert
orderLineQuantityInfo are nested into orderLines, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_order_line_quantity_infos
Order Fulfillment Status Order Lines
Endpoint: Fulfillment Orders Status
Update Method: Upsert
orderLines are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_order_lines
Order Fulfillment Status Shipment Lines
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipmentLines are nested into shipments, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipment_lines
Order Fulfillment Status Shipments
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipments are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipments
Order Fulfillment Status Shipment Dates
Endpoint: Fulfillment Orders Status
Update Method: Upsert
shipmentDates are nested into shipments, which in turn are nested into each Fulfillment Order
Table Name: walmart_marketplace.order_fulfillment_status_shipment_dates
Order Fulfillment Statuses
Endpoint: Fulfillment Orders Status
Update Method: Upsert
Table Name: walmart_marketplace.order_fulfillment_statuses
Order Line Charges
Endpoint: Orders
Update Method: Upsert
charges are nested into orderLines, which in turn are nested into each Order
Table Name: walmart_marketplace.order_lines
Order Line Refund Charges
Endpoint: Orders
Update Method: Upsert
refundCharges belong to the refund element, which is nested into orderLines, which in turn are nested into each Order
Table Name: walmart_marketplace.order_lines
Order Line Statuses
Endpoint: Orders
Update Method: Upsert
orderLineStatuses are nested into orderLines, which in turn are nested into each Order
Table Name: walmart_marketplace.order_lines
Order Lines
Endpoint: Orders
Update Method: Upsert
orderLines are nested into each Order
Table Name: walmart_marketplace.order_lines
Orders
Endpoint: Orders
Update Method: Upsert
Table Name: walmart_marketplace.orders
Last updated