Connecting to Walmart Marketplace via SQL

You can use SQL to connect to Microsoft Advertising in the CData Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need a ChannelType, ClientId, ClientSecret.

How to Connect

Before you start retrieving data, you need to run the connector script for Walmart Marketplace in the CData Virtuality Studio or the Web UI and enter your credentials in the following lines:

SQL

CALL SYSADMIN.createConnection (
    name => 'walmart_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'ClientId=<ClientId>,EndPoint=https://marketplace.walmartapis.com/v3,SecurityType=None,ClientSecret=&#60;ClientSecret>'
);;
 
CALL SYSADMIN.createDataSource (
    name => 'walmart_src'
    ,translator => 'walmart'
    ,modelProperties => 'ChannelType=<ChannelType>'
    ,translatorProperties => ''
);;