Connecting to Scrapfly

The Scrapfly API uses API Key authentication. The API key is passed as the key query parameter on every request.

Using API Key Authentication

Your Scrapfly API key is required to create a connection. To obtain your API key:

1. Log into your Scrapfly account at scrapfly.io.
2. Navigate to Dashboard and select API Keys.
3. Copy your API key (begins with scp-live- for production or scp-test- for the test environment).

After obtaining your API key, set the following connection properties:

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

Example connection string:

Profile=C:\profiles\Scrapfly.apip;AuthScheme=APIKey;ProfileSettings='APIKey=your_api_key';

Available Tables

The Scrapfly API Profile provides access to the following tables:

• Account - Scrapfly account details including subscription plan, project settings, usage statistics, and billing information.
• Scrapes - Scrapfly web scraping results including rendered content, response metadata, proxy context, and scrape configuration. Requires a Url filter on every query.

Usage Examples

Account:

SELECT * FROM Account

Scrapes:

SELECT * FROM Scrapes WHERE Url = 'https://example.com'

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 used to authenticate requests to the Scrapfly service.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT