Shortio

Tables in the Shortio connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	clicks	24		Incremental	dt	API Reference
2	links	36		Full Refresh		API Reference

Table: clicks

No	Column Name	Type	Notes
1	st	INTEGER
2	country	VARCHAR
3	method	VARCHAR
4	os	VARCHAR
5	city	VARCHAR
6	social	VARCHAR
7	utm_campaign	VARCHAR
8	ab_path	VARCHAR
9	ip	VARCHAR
10	utm_medium	VARCHAR
11	goal_completed	VARCHAR
12	ua	VARCHAR
13	url	VARCHAR
14	lcpath	VARCHAR
15	dt	VARCHAR	Incremental sync key
16	path	VARCHAR
17	ref	VARCHAR
18	refhost	VARCHAR
19	proto	VARCHAR
20	browser	VARCHAR
21	host	VARCHAR
22	browser_version	VARCHAR
23	human	BOOLEAN
24	utm_source	VARCHAR

Table: links

No	Column Name	Type	Notes
1	Owner	VARCHAR
2	User	VARCHAR
3	secureShortURL	VARCHAR
4	shortURL	VARCHAR
5	icon	VARCHAR
6	integrationGA	VARCHAR
7	integrationGTM	VARCHAR
8	idString	VARCHAR
9	utmContent	VARCHAR
10	source	VARCHAR
11	title	VARCHAR
12	expiredURL	VARCHAR
13	iphoneURL	VARCHAR
14	path	VARCHAR
15	archived	BOOLEAN
16	createdAt	VARCHAR
17	password	VARCHAR
18	androidURL	VARCHAR
19	redirectType	VARCHAR
20	splitURL	VARCHAR
21	integrationAdroll	VARCHAR
22	updatedAt	VARCHAR
23	utmSource	VARCHAR
24	utmCampaignId	VARCHAR
25	utmTerm	VARCHAR
26	originalURL	VARCHAR
27	utmCampaign	VARCHAR
28	expiresAt	VARCHAR
29	tags	VARCHAR
30	AutodeletedAt	VARCHAR
31	DomainId	INTEGER
32	integrationFB	VARCHAR
33	splitPercent	VARCHAR
34	utmMedium	VARCHAR
35	cloaking	BOOLEAN
36	clicksLimit	VARCHAR

External Resources

• Shortio Api

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.