API Connectors

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

DatamedIQ Connector Reference

3 metrics22 dimensions
Fields

The DatamedIQ connector exposes 25 fields (3 metrics, 22 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


DatamedIQ Fields

DatamedIQ Dimensions fields

The Dimensions report of the DatamedIQ connector includes 17 fields.

ID Type Name Description
account_id TEXT Account ID The associated account id.
account_name TEXT Account name The associated account name
atc_1_class TEXT atc1Class atc1Class
atc_1_class_description TEXT atc1ClassDescription atc1ClassDescription
atc_2_class TEXT atc2Class atc2Class
atc_2_class_description TEXT atc2ClassDescription atc2ClassDescription
atc_3_class TEXT atc3Class atc3Class
atc_3_class_description TEXT atc3ClassDescription atc3ClassDescription
atc_4_class TEXT atc4Class atc4Class
atc_4_class_description TEXT atc4ClassDescription atc4ClassDescription
brand TEXT Brand Brand
company_name TEXT Company Name Company
pack TEXT Pack Pack
product_group TEXT Product Group Product Group
pzn TEXT Pzn Pzn
week TEXT Week Week number in ISO 8601 format, Monday-Sunday.
year TEXT Year Year (yyyy)

DatamedIQ Metrics fields

The Metrics report of the DatamedIQ connector includes 3 fields.

ID Type Name Description
price_ravp NUMERIC priceRavp priceRavp
sales NUMERIC Sales Sales
units NUMERIC Units Units

DatamedIQ other fields

The DatamedIQ connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC 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.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date