API Connectors

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

Digistorm Connector Reference

2 metrics85 dimensions
Fields

The Digistorm connector exposes 87 fields (2 metrics, 85 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Digistorm Fields

Digistorm Dimensions fields

The Dimensions report of the Digistorm connector includes 3 fields.

ID Type Name Description
account_id TEXT Account ID Business Manager Account ID
account_name TEXT Account name Business Manager Account Name
date DATE Date Date

Digistorm leads fields

The leads report of the Digistorm connector includes 66 fields.

Digistorm leads fields (leads_child_created_at to leads_child_guardians_1_pivot_relationship_uuid)

ID Type Name Description
leads_child_created_at TIMESTAMP leads child created at leads child created at
leads_child_date_of_birth TIMESTAMP leads child date of birth leads child date of birth
leads_child_first_name TEXT leads child first name leads child first name
leads_child_form_entries_0_form_title TEXT leads child first form form title leads child first form form title
leads_child_form_entries_0_form_type NUMERIC leads child first form form type leads child first form form type
leads_child_form_entries_0_form_uuid TEXT leads child first form form uuid leads child first form form uuid
leads_child_form_entries_0_uuid TEXT leads child first form uuid leads child first form uuid
leads_child_form_entries_1_form_title TEXT leads child second form form title leads child second form form title
leads_child_form_entries_1_form_type NUMERIC leads child second form form type leads child second form form type
leads_child_form_entries_1_form_uuid TEXT leads child second form form uuid leads child second form form uuid
leads_child_form_entries_1_uuid TEXT leads child second form uuid leads child second form uuid
leads_child_gender_name TEXT leads child gender name leads child gender name
leads_child_gender_uuid TEXT leads child gender uuid leads child gender uuid
leads_child_guardians_0_email TEXT leads child first guardian email leads child first guardian email
leads_child_guardians_0_first_name TEXT leads child first guardian first name leads child first guardian first name
leads_child_guardians_0_last_name TEXT leads child first guardian last name leads child first guardian last name
leads_child_guardians_0_nationality TEXT leads child first guardian nationality leads child first guardian nationality
leads_child_guardians_0_occupation TEXT leads child first guardian occupation leads child first guardian occupation
leads_child_guardians_0_occupational_group TEXT leads child first guardian occupational group leads child first guardian occupational group
leads_child_guardians_0_phone_numbers_0_label TEXT leads child first guardian phone numbers 0 label leads child first guardian phone numbers 0 label
leads_child_guardians_0_phone_numbers_0_number TEXT leads child first guardian phone numbers 0 number leads child first guardian phone numbers 0 number
leads_child_guardians_0_pivot_is_primary TEXT leads child first guardian pivot is primary leads child first guardian pivot is primary
leads_child_guardians_0_pivot_relationship_name TEXT leads child first guardian pivot relationship name leads child first guardian pivot relationship name
leads_child_guardians_0_pivot_relationship_uuid TEXT leads child first guardian pivot relationship uuid leads child first guardian pivot relationship uuid
leads_child_guardians_0_qualification TEXT leads child first guardian qualification leads child first guardian qualification
leads_child_guardians_0_religion TEXT leads child first guardian religion leads child first guardian religion
leads_child_guardians_0_salutation TEXT leads child first guardian salutation leads child first guardian salutation
leads_child_guardians_0_school_education TEXT leads child first guardian school education leads child first guardian school education
leads_child_guardians_0_uuid TEXT leads child first guardian uuid leads child first guardian uuid
leads_child_guardians_1_email TEXT leads child second guardian email leads child second guardian email
leads_child_guardians_1_first_name TEXT leads child second guardian first name leads child second guardian first name
leads_child_guardians_1_last_name TEXT leads child second guardian last name leads child second guardian last name
leads_child_guardians_1_nationality TEXT leads child second guardian nationality leads child second guardian nationality
leads_child_guardians_1_occupation TEXT leads child second guardian occupation leads child second guardian occupation
leads_child_guardians_1_occupational_group TEXT leads child second guardian occupational group leads child second guardian occupational group
leads_child_guardians_1_phone_numbers_0_label TEXT leads child second guardian phone numbers 0 label leads child second guardian phone numbers 0 label
leads_child_guardians_1_phone_numbers_0_number TEXT leads child second guardian phone numbers 0 number leads child second guardian phone numbers 0 number
leads_child_guardians_1_pivot_is_primary TEXT leads child second guardian pivot is primary leads child second guardian pivot is primary
leads_child_guardians_1_pivot_relationship_name TEXT leads child second guardian pivot relationship name leads child second guardian pivot relationship name
leads_child_guardians_1_pivot_relationship_uuid TEXT leads child second guardian pivot relationship uuid leads child second guardian pivot relationship uuid

Digistorm leads fields (leads_child_guardians_1_qualification to leads_uuid)

ID Type Name Description
leads_child_guardians_1_qualification TEXT leads child second guardian qualification leads child second guardian qualification
leads_child_guardians_1_religion TEXT leads child second guardian religion leads child second guardian religion
leads_child_guardians_1_salutation TEXT leads child second guardian salutation leads child second guardian salutation
leads_child_guardians_1_school_education TEXT leads child second guardian school education leads child second guardian school education
leads_child_guardians_1_uuid TEXT leads child second guardian uuid leads child second guardian uuid
leads_child_indigenous_status TEXT leads child indigenous status leads child indigenous status
leads_child_is_citizen TEXT leads child is citizen leads child is citizen
leads_child_last_name TEXT leads child last name leads child last name
leads_child_nationality TEXT leads child nationality leads child nationality
leads_child_religion TEXT leads child religion leads child religion
leads_child_updated_at TIMESTAMP leads child updated at leads child updated at
leads_child_uuid TEXT leads child uuid leads child uuid
leads_child_visa TEXT leads child visa leads child visa
leads_created_at TIMESTAMP leads created at leads created at
leads_notes_0_body TEXT leads first note body leads first note body
leads_notes_0_uuid TEXT leads first note uuid leads first note uuid
leads_notes_1_body TEXT leads second note body leads second note body
leads_notes_1_uuid TEXT leads second note uuid leads second note uuid
leads_pipeline_stage_name TEXT leads pipeline stage name leads pipeline stage name
leads_pipeline_stage_uuid TEXT leads pipeline stage uuid leads pipeline stage uuid
leads_pipeline_stage_win_probability TEXT leads pipeline stage win probability leads pipeline stage win probability
leads_proposed_entry_year TEXT leads proposed entry year leads proposed entry year
leads_proposed_year_level_name TEXT leads proposed year level name leads proposed year level name
leads_proposed_year_level_uuid TEXT leads proposed year level uuid leads proposed year level uuid
leads_updated_at TIMESTAMP leads updated at leads updated at
leads_uuid TEXT leads uuid leads uuid

Digistorm other fields

The Digistorm connector has 18 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
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20