Walmart Marketplace API Reference

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the internal_ prefix in their names. Public API procedures do not have such prefixes in their names.

Areas

States on which you can provide two-day shipping of an item
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Areas AS 
	SELECT * 
	FROM (
		CALL walmart.Areas ()
	) AS x

AvailableReconReportDates

Available Marketplace reconciliation report dates for the Seller
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_AvailableReconReportDates AS 
SELECT * 
FROM (
CALL walmart.AvailableReconReportDates ()
) AS x;;

CA_Inventories

Inventories
Parameter
<sku> (optional): An arbitrary alphanumeric unique ID
<item_table> (optional): Table with items containing column sku
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CA_Inventories AS 
SELECT * 
FROM (
CALL walmart.CA_Inventories (
preview => true
)
) AS x;;

CA_Inventory

Inventory
Parameter
<sku> (optional): An arbitrary alphanumeric unique ID
<sku_table> (optional): Table with items containing column sku
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CA_Inventory AS 
SELECT * 
FROM (
CALL walmart.CA_Inventory (
preview => true
)
) AS x;;

CA_Items

All items
Parameter
<lifecycleStatus> (optional): The lifecycle status of an item describes where the item listing is in the overall lifecycle. Examples of allowed values are ACTIVE , ARCHIVED, RETIRED
<publishedStatus> (optional): The published status of an item describes where the item is in the submission process. Examples of allowed values are PUBLISHED, UNPUBLISHED
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CA_Items AS 
SELECT * 
FROM (
CALL walmart.CA_Items (
preview => true
)
) AS x;;

CA_Orders

Orders
Parameter
<createdEndDate> (optional): Fetches all purchase CA_Orders that were created before this date
<createdStartDate> (optional): Fetches all purchase CA_Orders that were created after this date
<customerOrderId> (optional): The customer order ID
<fromExpectedShipDate> (optional): Fetches all purchase CA_Orders that have order lines with an expected ship date after this date
<productInfo> (optional): Provides the image URL and product weight in response, if available. Allowed values are true or false
<purchaseOrderId> (optional): The purchase order ID
<sku> (optional): A seller-provided Product ID
<status> (optional): Status of purchase order line. Valid statuses are: Created, Acknowledged, Shipped, Delivered and Cancelled
<toExpectedShipDate> (optional): Fetches all purchase CA_Orders that have order lines with an expected ship date before this date
<updateLastDaysNumber> (optional): Works with target table to make data reread for having order data updated for the number of last days
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CA_Orders AS 
SELECT * 
FROM (
CALL walmart.CA_Orders (
createdStartDate => TIMESTAMPADD (SQL_TSI_DAY, -10, CURDATE ()),
preview => true
)
) AS x;;

CA_Report_Inventory

Inventory Report
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<requestId> (optional): Report Request Id
<label> (optional): Multi-tenancy label

CA_Report_InventoryHealthReport_Sync

Inventory Health Report Sync
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

CarrierMethods

Available carrier methods
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CarrierMethods AS 
	SELECT * 
	FROM (
		CALL walmart.CarrierMethods ()
	) AS x

CountByStatus

Count of items based on status
Parameter
<status> (optional): Statuses of Item in CSV
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_CountByStatus AS 
SELECT * 
FROM (
CALL walmart.CountByStatus (
	status => 'UNPUBLISHED'
)
) AS x;;

Departments

Departments
Parameter
<departmentId> (optional): departmentId
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Departments AS 
SELECT * 
FROM (
	CALL walmart.Departments ()
) AS x;;

EventTypes

Event types and resource names that you can subscribe to
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_EventTypes AS 
SELECT * 
FROM (
	CALL walmart.EventTypes ()
) AS x;;

Exceptions

Items which has been defined as exceptions using "Create Override Exception" API
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Exceptions AS 
	SELECT * 
	FROM (
		CALL walmart.Exceptions ()
	) AS x

FeedItems

Feed items
Parameter
<feedId> (optional): A unique ID returned from the Bulk Upload API, used for tracking the Feed File
<feedId_table> (optional): Table with the columns feedId to get info for each of
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_FeedItems AS 
	SELECT * 
	FROM (
		CALL walmart.FeedItems (
			feedId => 'CC4522C0011140DD86D0DFD1E3E8DB45@AQMBCgA'
		)
	) AS x

Feeds

Feed statuses for all the specified Feed IDs
Parameter
<feedId> (optional): A unique ID returned from the Bulk Upload API, used for tracking the Feed File
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Feeds AS 
	SELECT * 
	FROM (
		CALL walmart.Feeds (
			feedId => NULL
		)
	) AS x

FulfillmentCenters

Fulfillment centers
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_FullfillmentCenters AS 
	SELECT * 
	FROM (
		CALL walmart.FullfillmentCenters ()
	) AS x

InboundOrderErrors

WFS error responses with error codes
Parameter
<shipmentId> (optional): Unique ID identifying each shipment
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_InboundOrderErrors AS 
SELECT * 
FROM (
	CALL walmart.InboundOrderErrors (
		shipmentId => NULL
	)
) AS x;;

InboundShipmentItems

After Sellers create an Inbound Order successfully, the response from Create Inbound Shipments API will tell whether the order can be sent in a single shipment to one WFS fulfillment center or needs to be split into multiple shipments to different fulfillment centers
Parameter
<shipmentId> (optional): Unique ID identifying each shipment
<shipmentId_table> (optional): Table with the columns shipmentId to get info for each of
<shipments_fromCreateDate> (optional): Shipment create date starting range
<shipments_toCreateDate> (optional): Shipment create date starting end range
<shipments_status> (optional): Current shipment status
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_InboundShipmentItems AS 
	SELECT * 
		FROM (
			CALL walmart.InboundShipmentItems (
				shipmentId => NULL
			)
	) AS x;;

InboundShipments

After Sellers create an Inbound Order successfully, the response from Create Inbound Shipments API will tell whether the order can be sent in a single shipment to one WFS fulfillment center or needs to be split into multiple shipments to different fulfillment centers
Parameter
<fromCreateDate> (optional): Shipment create date starting range
<toCreateDate> (optional): Shipment create date starting end range
<inboundOrderId> (optional): Unique ID identifying inbound shipment request
<shipmentId> (optional): Unique ID identifying each shipment
<status> (optional): Current shipment status
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_InboundShipments AS 
	SELECT * 
		FROM (
			CALL walmart.InboundShipments (
				fromCreateDate => NULL,
				inboundOrderId => NULL,
				shipmentId => NULL,
				status => NULL,
				toCreateDate => NULL
			)
) AS x;;

Inventories

Multiple item inventory for all ship nodes
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Inventories AS 
	SELECT * 
	FROM (
		CALL walmart.Inventories (
			preview => true
	)
) AS x;;

Inventory

Inventory for a given item or for all
Parameter
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<shipNode> (optional): The shipNode for which the inventory is requested
<sku_table> (optional): Table with the columns sku to get info for each of
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Inventory AS 
	SELECT * 
	FROM (
		CALL walmart.Inventory (
			shipNode => NULL,
			sku => 'DIM200_2'
		)
	) AS x

Item

Item and displays the item details
Parameter
<productIdType> (required): Item code type specifier allows to filter by specific code type, (e.g. GTIN)
<id> (required): Represents the seller-specified unique ID for each item. Takes SKU code by default. If you require more specific item codes, such as GTIN, UPC, ISBN, EAN, or ITEM_ID, you need to use the productIdType query parameter and specify the desired code e.g. productIdType=GTIN
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Item AS 
	SELECT * 
		FROM (
			CALL walmart.Item (
				id => 'DIM200_2',
				productIdType => 'SKU'
			)
	) AS x;;

Items

All items
Parameter
<lifecycleStatus> (optional): The lifecycle status of an item describes where the item listing is in the overall lifecycle. Examples of allowed values are ACTIVE , ARCHIVED, RETIRED
<publishedStatus> (optional): The published status of an item describes where the item is in the submission process. Examples of allowed values are PUBLISHED, UNPUBLISHED
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Items AS 
	SELECT * 
		FROM (
			CALL walmart.Items (
				lifecycleStatus => NULL,
				publishedStatus => NULL,
				sku => NULL
	)
) AS x;;

ItemsSearch

Item Search API allows you to query the Walmart
Parameter
<gtin> (optional): Specifies a Global Trade Item Number (GTIN) search
<query> (optional): Specifies a keyword search as a String
<upc> (optional): Specifies a Universal Product Code (UPC) search
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_ItemsSearch AS 
	SELECT * 
		FROM (
			CALL walmart.ItemsSearch (
				gtin => NULL,
				query => 'a',
				upc => NULL
		)
) AS x;;

LagTime

Lag Time for an item with a given SKU
Parameter
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<sku_table> (optional): Table with the columns sku to get info for each of
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_LagTime AS 
	SELECT * 
	FROM (
		CALL walmart.LagTime (
		sku => 'PRO40'
	)
) AS x;;

MultiNodeInventoryForSkuAndAllShipnodes

Inventory count for an item across all ship nodes or one specific ship node
Parameter
<sku> (required): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<shipNode> (optional): ShipNode Id of the ship node for which the inventory is requested
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_MultiNodeInventoryForSkuAndAllShipnodes AS 
	SELECT * 
	FROM (
		CALL walmart.MultiNodeInventoryForSkuAndAllShipnodes (
			shipNode => NULL,
			sku => 'DIM200_2'
		)
) AS x;;

Orders

Details of all orders for specified search criteria
Parameter
<createdEndDate> (optional): Fetches all purchase orders that were created before this date
<createdStartDate> (optional): Fetches all purchase orders that were created after this date
<customerOrderId> (optional): The customer order ID
<fromExpectedShipDate> (optional): Fetches all purchase orders that have order lines with an expected ship date after this date
<lastModifiedEndDate> (optional): Fetches all purchase orders that were modified before this date
<lastModifiedStartDate> (optional): Fetches all purchase orders that were modified after this date
<orderType> (optional): Specifies if the order is a regular order or replacement order. Possible values are REGULAR or REPLACEMENT
<productInfo> (optional): Provides the image URL and product weight in response, if available. Allowed values are true or false
<purchaseOrderId> (optional): The purchase order ID
<replacementInfo> (optional): Provides additional attributes - originalCustomerOrderID, orderType - related to Replacement order, in response, if available. Allowed values are true or false
<shipNodeType> (optional): Specifies the type of shipNode. Allowed values are SellerFulfilled, WFSFulfilled and 3PLFulfilled and CSV list of them
<shippingProgramType> (optional): Specifies the type of program
<sku> (optional): A seller-provided Product ID
<status> (optional): Status of purchase order line. Valid statuses are: Created, Acknowledged, Shipped, Delivered and Cancelled
<toExpectedShipDate> (optional): Fetches all purchase orders that have order lines with an expected ship date before this date
<updateLastDaysNumber> (optional): Works with target table to make data reread for having order data updated for the number of last days
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Orders AS 
	SELECT * 
	FROM (
		CALL walmart.Orders (
			createdEndDate => NULL,
			createdStartDate => NULL,
			customerOrderId => NULL,
			fromExpectedShipDate => NULL,
			lastModifiedEndDate => NULL,
			lastModifiedStartDate => TIMESTAMPADD (SQL_TSI_DAY, -10, CURDATE ()),
			orderType => NULL,
			productInfo => NULL,
			purchaseOrderId => NULL,
			replacementInfo => NULL,
			shipNodeType => NULL,
			shippingProgramType => NULL,
			sku => NULL,
			status => NULL,
			toExpectedShipDate => NULL
		)
	) AS x

PromotionalPrices

Promotional prices
Parameter
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<sku_table> (optional): Table with the columns sku to get info for each of
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_PromotionalPrices AS 
	SELECT * 
	FROM (
		CALL walmart.PromotionalPrices ()
	) AS x

ReleasedOrders

Created orders
Parameter
<createdEndDate> (optional): Fetches all purchase orders that were created before this date
<createdStartDate> (optional): Fetches all purchase orders that were created after this date
<customerOrderId> (optional): The customer order ID
<fromExpectedShipDate> (optional): Fetches all purchase orders that have order lines with an expected ship date after this date
<orderType> (optional): Specifies if the order is a regular order or replacement order. Possible values are REGULAR or REPLACEMENT
<productInfo> (optional): Provides the image URL and product weight in response, if available. Allowed values are true or false
<purchaseOrderId> (optional): The purchase order ID
<replacementInfo> (optional): Provides additional attributes - originalCustomerOrderID, orderType - related to Replacement order, in response, if available. Allowed values are true or false
<shipNodeType> (optional): Specifies the type of shipNode. Allowed values are SellerFulfilled, WFSFulfilled and 3PLFulfilled and CSV list of them
<shippingProgramType> (optional): Specifies the type of program
<sku> (optional): A seller-provided Product ID
<toExpectedShipDate> (optional): Fetches all purchase orders that have order lines with an expected ship date before this date
<updateLastDaysNumber> (optional): Works with target table to make data reread for having order data updated for the number of last days
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_ReleasedOrders AS 
	SELECT * 
	FROM (
		CALL walmart.ReleasedOrders (
			createdEndDate => NULL,
			createdStartDate => NULL,
			customerOrderId => NULL,
			fromExpectedShipDate => NULL,
			orderType => NULL,
			productInfo => NULL,
			purchaseOrderId => NULL,
			replacementInfo => NULL,
			shipNodeType => NULL,
			shippingProgramType => NULL,
			sku => NULL,
			toExpectedShipDate => NULL
		)
	) AS x

Report_BuyBox

Buy Box Report
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_BuyBox AS 
	SELECT * 
	FROM (
		CALL walmart.Report_BuyBox ()
	) AS x

Report_ItemPerformance

Item Performance Report
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_ItemPerformance AS 
	SELECT * 
	FROM (
		CALL walmart.Report_ItemPerformance ()
	) AS x

Report_Items

Item Report
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_Items AS 
	SELECT * 
	FROM (
		CALL walmart.Report_Items ()
	) AS x

Report_Reconciliation

Reconciliation Report
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_Reconciliation AS 
	SELECT * 
	FROM (
		CALL walmart.Report_Reconciliation ()
	) AS x

Report_Reconciliation_Sync

Reconciliation Report Sync
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_Reconciliation_Sync AS 
SELECT * 
FROM (
    CALL walmart.Report_Reconciliation_Sync ()
) AS x;;

Report_ReturnOverrides

Return Overrides Report
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Report_ReturnOverrides AS 
	SELECT * 
	FROM (
		CALL walmart.Report_ReturnOverrides ()
	) AS x

ReturnOrders

Retrieves the details of return orders for the specified filter criteria
Parameter
<customerOrderId> (optional): A unique ID associated with the sales order for specified customer
<initialDate> (required): Start Date for querying all return orders that were created after that date
<returnOrderId> (optional): Return order identifier of the return order object as part of array
<updateLastDaysNumber> (optional): Works with target table to make data reread for having order data updated for the number of last days
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_ReturnOrders AS 
	SELECT * 
	FROM (
		CALL walmart.ReturnOrders (
			initialDate => TIMESTAMPADD (SQL_TSI_DAY, -10, CURDATE ()),
			preview => true
		)
) AS x;;

Rules

Details of all the rules
Parameter
<ruleStatus> (optional): Status of the rule post the rule creation. Allowed values are Active, Inactive, Submitted
<ruleId> (optional): Unique identifier of the rule created for custom rule assortment
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Rules AS 
	SELECT * 
	FROM (
		CALL walmart.Rules ()
	) AS x

SellerListingQualityScore

Seller listing quality score
Parameter
<viewTrendingItems> (optional): Whether or not to include seller's items that are trending in the Listing Quality Score
<wfsFlag> (optional): Whether or not to include WFS-eligible items in the overall Listing Quality Score
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

CREATE VIEW walmart_examples.example_SellerListingQualityScore AS 
	SELECT * 
	FROM (
		CALL walmart.SellerListingQualityScore (
			preview => true
	)
) AS x;;

ShippingTemplateActivationStatus

Activation Status of the Shipping Templates, which can be set through Walmart Seller Center
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

CREATE VIEW walmart_examples.example_ShippingTemplateActivationStatus AS 
SELECT * 
FROM (
CALL walmart.ShippingTemplateActivationStatus ()
) AS x;

ShippingTemplates

Shipping templates for a Seller
Parameter
<templateId> (optional): templateId
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

CREATE VIEW walmart_examples.example_ShippingTemplates AS 
SELECT * 
FROM (
CALL walmart.ShippingTemplates ()
) AS x;;

SimulationResult

Count of items shortlisted for two-day shipping for a specific rule defined by ruleId and ruleStatus
Parameter
<ruleStatus> (required): Status of the rule post the rule creation. Allowed values are Active, Inactive, Submitted
<ruleId> (required): Unique identifier of the rule created for custom rule assortment
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

SimulResult

Count of items shortlisted for two-day shipping for a specific rule defined by ruleId and ruleStatus
Parameter
<ruleId> (optional): Unique identifier of the rule created for custom rule assortment
<ruleStatus> (optional): Status of the rule post the rule creation
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_SimulationResult AS 
	SELECT * 
	FROM (
		CALL walmart.SimulationResult (
			ruleId => '<ruleId>',
			ruleStatus => 'Active'
		)
) AS x;;

SubCategories

Sub-categories which can be used while defining the rule
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_SubCategories AS 
	SELECT * 
	FROM (
		CALL walmart.SubCategories ()
	) AS x

Subscriptions

All subscriptions
Parameter
<eventType> (optional): Use this to get list of all subscriptions for a specific event type
<resourceName> (optional): Use this to get list of all subscriptions for a specific resource
<status> (optional): Use this to get list of all subscriptions in ACTIVE or INACTIVE status
<subscriptionId> (optional): Use this to get details of a specific subscription
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

CREATE VIEW walmart_examples.example_Subscriptions AS 
	SELECT * 
	FROM (
		CALL walmart.Subscriptions (
			eventType => NULL,
			resourceName => NULL,
			status => NULL,
			subscriptionId => NULL
		)
) AS x;;

Taxonomy

Category taxonomy is uses to categorize items. It describes the Departments, Categories, and Subcategories levels
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_Taxonomy AS 
	SELECT * 
	FROM (
		CALL walmart.Taxonomy ()
	) AS x

ThirdPartyFulfilmentCenters

Third party fulfillment providers
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_ThirdPartyFulfilmentCenters AS 
	SELECT * 
	FROM (
		CALL walmart.ThirdPartyFulfilmentCenters ()
	) AS x

TrendingResult

Get Trending Item List
Parameter
<departmentId> (required): departmentId
<categoryId> (optional): categoryId
<timeFrame> (optional): Returns all trending items for the given time frame in days
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_TrendingResult AS 
	SELECT * 
	FROM (
		CALL walmart.TrendingResult (
			categoryId => NULL,
			departmentId => '1043024',
			timeFrame => NULL
		)
) AS x;;

TokenDetail

Checks token permissions
Parameter

Example

CREATE VIEW walmart_examples.example_TokenDetail AS 
	SELECT * 
	FROM (
		CALL walmart.TokenDetail ()
	) AS x

UnpublishedItemCount

Unpubished Item
Parameter
<fromDate> (required): Returns all unpublished items count with reason codes since the given date
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_UnpublishedItemCount AS 
	SELECT * 
	FROM (
		CALL walmart.UnpublishedItemCount (
			fromDate => TIMESTAMPADD (SQL_TSI_YEAR, -10, CURDATE ())
		)
) AS x;;

UnpublishedItems

Unpublished Items
Parameter
<fromDate> (required): Returns all unpublished items since the given date
<itemsWithInventory> (optional): Filter the item list to return only items that have inventory
<marketTrending> (optional): Filter the item list to return only items that are trending on Walmart
<offerLifecycleStatus> (optional): The lifecycle status of an item describes where the item listing is in the overall lifecycle. Examples of allowed values are ACTIVE , ARCHIVED, RETIRED
<unpublishedReasonCode> (optional): Unpublished reason code
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_UnpublishedItems AS 
	SELECT * 
	FROM (
		CALL walmart.UnpublishedItems (
			fromDate => TIMESTAMPADD (SQL_TSI_YEAR, -10, CURDATE ()),
			itemsWithInventory => NULL,
			marketTrending => NULL,
			offerLifecycleStatus => NULL,
			unpublishedReasonCode => NULL
		)
) AS x;;

WfsInventory

Available to Sell inventory quantities for all WFS items in your catalog
Parameter
<fromModifiedDate> (optional): last inventory modified date - starting range
<toModifiedDate> (optional): last inventory modified date - ending range
<sku> (optional): An arbitrary alphanumeric unique ID, specified by the seller, which identifies each item
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Example

CREATE VIEW walmart_examples.example_WfsInventory AS 
	SELECT * 
	FROM (
		CALL walmart.WfsInventory (
			fromModifiedDate => NULL,
			sku => 'DIM200_2',
			toModifiedDate => NULL
		)
) AS x;;