API Connectors

users-love-us medal soc2
Send your Short.io data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Short.io Connector Reference

70 dimensions
Fields

The Short.io connector exposes 70 fields (0 metrics, 70 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Short.io Fields

Short.io clicks fields

The clicks report of the Short.io connector includes 8 fields.

IDTypeNameDescription
clicks__browserOBJECTclicks.browserclicks.browser
clicks__cityOBJECTclicks.cityclicks.city
clicks__countryOBJECTclicks.countryclicks.country
clicks__osOBJECTclicks.osclicks.os
clicks__socialOBJECTclicks.socialclicks.social
clicks__utm_campaignOBJECTclicks.utm_campaignclicks.utm_campaign
clicks__utm_mediumOBJECTclicks.utm_mediumclicks.utm_medium
clicks__utm_sourceOBJECTclicks.utm_sourceclicks.utm_source

Short.io other fields

The Short.io connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
account_idTEXTAccount IDAccount ID.
account_nameTEXTAccount NameAccount name.
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate.
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20