How to Create a REST Bulk Query Data Source with Multiple Parameters

These steps walk through setting up a multi-parameter REST bulk query data source for filtering and data source control, using Shopify as an example. The same steps apply to any other REST API connector.

To watch a video explanation of this, see below or click here.

Overview

Instead of creating separate data sources for each parameter value, you can use Global Variables and REST variable placeholders to build a single, dynamic REST query data source that handles multiple scenarios.

Step 1: Create a Global Variable

A Global Variable will be used to dynamically pass values from the integration process to the data source.

1. In SmartConnect.com, create a new Global Variable, for example, GBL_SHOPIFY_VENDOR.

Step 2: Add a placeholder to the Shopify REST Definition

The generic REST connector variable will hold the Global Variable for use in the

1. Go to Maintenance and open the REST definition.
2. Click Variables and add a new placeholder with the following settings:
   • Name: vendor
   • Description: (your choice)
   • Type: Runtime
   • Value: GBL_SHOPIFY_VENDOR
   • Required: ✓ Checked

Step 3: Update the Data Source Parameter

1. Go to Data Sources and open Get All Products.
2. Click Parameters and update the vendor value to the placeholder: [vendor].

Step 4: Create the REST Bulk Query Data Source

Create a new bulk query data source using Get All Products, for example, name it “Shopify Get Products by Vendor List.”

Step 5: Build the Integration

1. Create an integration process using the new data source.
2. For example, set the Target to an Excel export file or any other Target system.
3. Complete the field mapping; at least one field must be mapped to the target.

Step 6: Configure the Variable for Runtime Use

1. Navigate to the Variable settings.
2. Open GBL_SHOPIFY_VENDOR, select Runtime, and click Update.

Step 7: Run the Integration

When running the integration, the vendor variable controls filtering behavior:

Summary

By combining Global Variables with REST variable placeholders, we can create a single dynamic REST data source that adapts to different parameter values at runtime, eliminating the need to maintain multiple data sources for different filter conditions.

Please reach out to support@eonesolutions.com with any questions on creating a multi-parameter REST bulk query data source.