Connecting to ZenRows

Using API Key Authentication

To use the ZenRows API, you need to obtain an API key from your ZenRows account. Navigate to the ZenRows dashboard at app.zenrows.com and copy your API key from the account settings.

After setting the following connection properties, you are ready to connect:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your ZenRows API key.

Example connection string:

Profile=C:\profiles\ZenRows.apip;AuthScheme=APIKey;ProfileSettings="APIKey=your_api_key";

Available Tables

The ZenRows profile provides access to the following tables:

• AmazonDiscovery - Amazon product listings matching a search query
• AmazonProducts - Detailed product information for a specific Amazon ASIN
• WalmartDiscovery - Walmart product listings matching a search query
• WalmartProducts - Detailed product information for a specific Walmart SKU
• WalmartReviews - Customer reviews for a specific Walmart product
• GoogleSearchResults - Organic search results from Google SERP
• ZillowDiscovery - Zillow property listings matching a search query
• ZillowProperties - Detailed property information for a specific Zillow listing
• IdealistaDiscovery - Idealista property listings matching a search URL
• IdealistaProperties - Detailed property information for a specific Idealista listing

Usage Examples

AmazonDiscovery:

SELECT * FROM AmazonDiscovery WHERE Query = 'laptop'

AmazonProducts:

SELECT * FROM AmazonProducts WHERE Asin = 'B08N5WRWNW'

WalmartDiscovery:

SELECT * FROM WalmartDiscovery WHERE Query = 'headphones'

WalmartProducts:

SELECT * FROM WalmartProducts WHERE Sku = '647079623'

WalmartReviews:

SELECT * FROM WalmartReviews WHERE Sku = '647079623'

GoogleSearchResults:

SELECT * FROM GoogleSearchResults WHERE Url = 'https://www.google.com/search?q=cdata'

ZillowDiscovery:

SELECT * FROM ZillowDiscovery WHERE Url = 'https://www.zillow.com/ks/?searchQueryState=%7B%7D'

ZillowProperties:

SELECT * FROM ZillowProperties WHERE ZillowPropertyId = '12345678'

IdealistaDiscovery:

SELECT * FROM IdealistaDiscovery WHERE Url = 'https://www.idealista.com/en/sale-homes/madrid-province/'

IdealistaProperties:

SELECT * FROM IdealistaProperties WHERE PropertyId = '12345678'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	The API key for your ZenRows account.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT, OAUTH_PASSWORD