Connecting to ShortIo

Using API Key Authentication

Short.io uses API Key authentication. To obtain your API key:

1. Log in to your Short.io account
2. Navigate to Settings > Integrations & API > API
3. Click Create API Key and copy your API key

After obtaining the API key, you are ready to connect:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your Short.io API key obtained from Settings > Integrations & API > API.

Example connection string:

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

Available Tables

The Short.io profile provides access to the following tables:

• Domains - Short.io domains associated with the authenticated account
• Links - Short links for a domain
• LinkExpand - Expand a short link by domain and path
• LinksByOriginalUrl - Retrieve multiple short links matching a given original destination URL
• Folders - Link folders within a specific domain
• LinkPermissions - Permission records for a specific link within a domain
• CountryTargeting - Country-based redirect targeting rules for a specific short link
• RegionTargeting - Region-based redirect targeting rules for a specific short link
• Regions - List of available regions/states for a given country code
• DomainStatistics - Aggregated click and traffic statistics for a Short.io domain
• LinkStatistics - Aggregated click and traffic statistics for a specific Short.io link

Usage Examples

Domains:

SELECT * FROM Domains

Links:

SELECT * FROM Links WHERE DomainId = 1234567

LinkExpand:

SELECT * FROM LinkExpand WHERE Domain = 'mytest123.short.gy' AND Path = 'ekVmWr'

LinksByOriginalUrl:

SELECT * FROM LinksByOriginalUrl WHERE Domain = 'mytest123.short.gy' AND OriginalURL = 'https://example.com'

Folders:

SELECT * FROM Folders WHERE DomainId = 1234567

LinkPermissions:

SELECT * FROM LinkPermissions WHERE DomainId = 1234567 AND LinkId = 'lnk_abc123'

CountryTargeting:

SELECT * FROM CountryTargeting WHERE LinkId = 'lnk_abc123'

RegionTargeting:

SELECT * FROM RegionTargeting WHERE LinkId = 'lnk_abc123'

Regions:

SELECT * FROM Regions WHERE Country = 'US'

DomainStatistics:

SELECT * FROM DomainStatistics WHERE DomainId = 1234567

LinkStatistics:

SELECT * FROM LinkStatistics WHERE LinkId = 'lnk_abc123'

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	Your Short.io API key from Settings > Integrations & API > API.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT