GoHighLevel Connector Reference
The GoHighLevel connector supports custom fields
The GoHighLevel connector exposes 248 fields (16 metrics, 232 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Create Contact Create a contact in the connected GoHighLevel location. Provide at least one of first_name, last_name, name, email or phone; the rest (company, address, website, timezone, source, tags) are optional. GoHighLevel deduplicates on email/phone within the location, so a matching contact may be updated instead of a new one created. Use update_contact to change an existing contact by id.
Create a contact in the connected GoHighLevel location. Provide at least one of first_name, last_name, name, email or phone; the rest (company, address, website, timezone, source, tags) are optional. GoHighLevel deduplicates on email/phone within the location, so a matching contact may be updated instead of a new one created. Use update_contact to change an existing contact by id.
Update Contact Update an existing GoHighLevel contact by id. Only the fields you provide are changed; omit a field to leave it untouched. Tags replace the contact's existing tags rather than adding to them. The contact_id can be obtained from a GoHighLevel contacts query or the create_contact result.
Update an existing GoHighLevel contact by id. Only the fields you provide are changed; omit a field to leave it untouched. Tags replace the contact's existing tags rather than adding to them. The contact_id can be obtained from a GoHighLevel contacts query or the create_contact result.
Create Invoice Create a draft invoice in the connected GoHighLevel location for an existing contact. Provide the contact_id, a business_name, a currency (ISO code such as USD), issue and due dates (YYYY-MM-DD) and at least one line item (name, amount, optional qty and description). Item amounts are per-unit in the invoice currency. The invoice is created as a draft and is not sent to the contact; send it from the GoHighLevel UI. contact_id comes from a GoHighLevel contacts query or the create_contact result.
Create a draft invoice in the connected GoHighLevel location for an existing contact. Provide the contact_id, a business_name, a currency (ISO code such as USD), issue and due dates (YYYY-MM-DD) and at least one line item (name, amount, optional qty and description). Item amounts are per-unit in the invoice currency. The invoice is created as a draft and is not sent to the contact; send it from the GoHighLevel UI. contact_id comes from a GoHighLevel contacts query or the create_contact result.
GoHighLevel Fields
GoHighLevel Contacts fields
The Contacts report of the GoHighLevel connector includes 50 fields.
GoHighLevel Contacts fields (contact_additional_emails to contact_last_name_lower_case)
| ID | Type | Name | Description |
|---|---|---|---|
| contact_additional_emails | OBJECT | Contact Additional Emails | Contact's additional emails. |
| contact_additional_phones | OBJECT | Contact Additional Phones | Contact's additional phone numbers. |
| contact_address | TEXT | Contact Address | Contact's address. |
| contact_assigned_to | TEXT | Contact Assigned To | User assigned to the contact. |
| contact_business_id | TEXT | Contact Business ID | Contact's business ID. |
| contact_business_name | TEXT | Contact Business Name | Contact's business name. |
| contact_city | CITY | Contact City | Contact's city. |
| contact_company | TEXT | Contact Company Name | Contact's company name. |
| contact_country | COUNTRY | Contact Country | Contact's country. |
| contact_date_added | Contact Date Added | Date when the contact was added. | |
| contact_date_of_birth | TEXT | Contact Date of Birth | Contact's date of birth. |
| contact_date_updated | Contact Date Updated | Date when the contact was last updated. | |
| contact_dnd | BOOLEAN | Contact DND | Contact's Do Not Disturb status. |
| contact_email | TEXT | Contact Email | Contact's email address. |
| contact_first_attribution_ad_id | TEXT | Contact First Attribution Ad ID | Ad platform ad ID of the contact's first touch. |
| contact_first_attribution_ad_source | TEXT | Contact First Attribution Ad Source | Ad platform that the contact's first touch came from. |
| contact_first_attribution_campaign | TEXT | Contact First Attribution Campaign | Campaign of the contact's first touch. |
| contact_first_attribution_campaign_id | TEXT | Contact First Attribution Campaign ID | Ad platform campaign ID of the contact's first touch. |
| contact_first_attribution_content | TEXT | Contact First Attribution Content | utmContent of the contact's first touch. |
| contact_first_attribution_medium | TEXT | Contact First Attribution Medium | Medium of the contact's first touch. |
| contact_first_attribution_medium_id | TEXT | Contact First Attribution Medium ID | Medium ID of the contact's first touch. |
| contact_first_attribution_session_source | TEXT | Contact First Attribution Session Source | Traffic category of the contact's first touch, e.g. Paid Social. |
| contact_first_attribution_utm_medium | TEXT | Contact First Attribution UTM Medium | utmMedium of the contact's first touch. |
| contact_first_attribution_utm_source | TEXT | Contact First Attribution UTM Source | utmSource of the contact's first touch, e.g. facebook. |
| contact_first_name | TEXT | Contact First Name | Contact's first name. |
| contact_first_name_lower_case | TEXT | Contact First Name Lower Case | Contact's first name in lower case. |
| contact_followers | OBJECT | Contact Followers | Followers of the contact. |
| contact_id | TEXT | Contact ID | Contact's unique identifier. |
| contact_last_attribution_ad_id | TEXT | Contact Last Attribution Ad ID | Ad platform ad ID of the contact's last touch. |
| contact_last_attribution_ad_source | TEXT | Contact Last Attribution Ad Source | Ad platform that the contact's last touch came from. |
| contact_last_attribution_campaign | TEXT | Contact Last Attribution Campaign | Campaign of the contact's last touch. |
| contact_last_attribution_campaign_id | TEXT | Contact Last Attribution Campaign ID | Ad platform campaign ID of the contact's last touch. |
| contact_last_attribution_content | TEXT | Contact Last Attribution Content | utmContent of the contact's last touch. |
| contact_last_attribution_medium | TEXT | Contact Last Attribution Medium | Medium of the contact's last touch. |
| contact_last_attribution_medium_id | TEXT | Contact Last Attribution Medium ID | Medium ID of the contact's last touch. |
| contact_last_attribution_session_source | TEXT | Contact Last Attribution Session Source | Traffic category of the contact's last touch, e.g. Paid Social. |
| contact_last_attribution_utm_medium | TEXT | Contact Last Attribution UTM Medium | utmMedium of the contact's last touch. |
| contact_last_attribution_utm_source | TEXT | Contact Last Attribution UTM Source | utmSource of the contact's last touch, e.g. facebook. |
| contact_last_name | TEXT | Contact Last Name | Contact's last name. |
| contact_last_name_lower_case | TEXT | Contact Last Name Lower Case | Contact's last name in lower case. |
GoHighLevel Contacts fields (contact_opportunities to contact_website)
| ID | Type | Name | Description |
|---|---|---|---|
| contact_opportunities | OBJECT | Contact Opportunities | Opportunities associated with the contact. |
| contact_phone | TEXT | Contact Phone | Contact's phone number. |
| contact_phone_label | TEXT | Contact Phone Label | Contact's phone label. |
| contact_postal_code | TEXT | Contact Postal Code | Contact's postal code. |
| contact_source | TEXT | Contact Source | Contact's source. |
| contact_state | REGION | Contact State | Contact's state. |
| contact_tags | OBJECT | Contact Tags | Contact's tags. |
| contact_type | TEXT | Contact Type | Contact's type. |
| contact_valid_email | TEXT | Contact Valid Email | Contact's valid email. |
| contact_website | TEXT | Contact Website | Contact's website. |
GoHighLevel Conversations fields
The Conversations report of the GoHighLevel connector includes 20 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| conversation_company_name | TEXT | Conversation Company Name | Company name of the contact in the conversation. |
| conversation_contact_id | TEXT | Conversation Contact ID | ID of the contact associated with the conversation. |
| conversation_contact_name | TEXT | Conversation Contact Name | Name of the contact in the conversation. |
| conversation_date_added | Conversation Date Added | Date when the conversation was added. | |
| conversation_date_updated | Conversation Date Updated | Date when the conversation was last updated. | |
| conversation_email | TEXT | Conversation Email | Email of the contact in the conversation. |
| conversation_followers | OBJECT | Conversation Followers | Followers of the conversation. |
| conversation_full_name | TEXT | Conversation Full Name | Full name of the contact in the conversation. |
| conversation_id | TEXT | Conversation ID | Conversation's unique identifier. |
| conversation_is_last_message_internal_comment | BOOLEAN | Conversation Is Last Message Internal Comment | Indicates if the last message is an internal comment. |
| conversation_last_manual_message_date | Conversation Last Manual Message Date | Date of the last manual message in the conversation. | |
| conversation_last_message_body | TEXT | Conversation Last Message Body | Body of the last message in the conversation. |
| conversation_last_message_date | Conversation Last Message Date | Date of the last message in the conversation. | |
| conversation_last_message_direction | TEXT | Conversation Last Message Direction | Direction of the last message in the conversation. |
| conversation_last_message_type | TEXT | Conversation Last Message Type | Type of the last message in the conversation. |
| conversation_last_outbound_message_action | TEXT | Conversation Last Outbound Message Action | Action of the last outbound message in the conversation. |
| conversation_phone | TEXT | Conversation Phone | Phone number of the contact in the conversation. |
| conversation_tags | OBJECT | Conversation Tags | Tags associated with the conversation. |
| conversation_type | TEXT | Conversation Type | Type of the conversation. |
| conversation_unread_count | NUMERIC | Conversation Unread Count | Number of unread messages in the conversation. |
GoHighLevel Invoices fields
The Invoices report of the GoHighLevel connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| invoice_amount_due | NUMERIC | Invoice Amount Due | Amount due for the invoice. |
| invoice_amount_paid | NUMERIC | Invoice Amount Paid | Amount paid for the invoice. |
| invoice_automatic_taxes_calculated | BOOLEAN | Invoice Automatic Taxes Calculated | Indicates if automatic taxes have been calculated for the invoice. |
| invoice_automatic_taxes_enabled | BOOLEAN | Invoice Automatic Taxes Enabled | Indicates if automatic taxes are enabled for the invoice. |
| invoice_contact_details | OBJECT | Invoice Contact Details | Contact details associated with the invoice. |
| invoice_created_at | DATE | Invoice Created At | Timestamp when the invoice was created. |
| invoice_currency | TEXT | Invoice Currency | Currency of the invoice. |
| invoice_discount | OBJECT | Invoice Discount | Discount applied to the invoice. |
| invoice_due_date | DATE | Invoice Due Date | Date when the invoice is due. |
| invoice_id | TEXT | Invoice ID | Invoice's unique identifier. |
| invoice_issue_date | DATE | Invoice Issue Date | Date when the invoice was issued. |
| invoice_items | OBJECT | Invoice Items | List of items included in the invoice. |
| invoice_live_mode | BOOLEAN | Invoice Live Mode | Indicates if the invoice is in live mode. |
| invoice_name | TEXT | Invoice Name | Name of the invoice. |
| invoice_number | TEXT | Invoice Number | Number of the invoice. |
| invoice_payment_schedule | TEXT | Invoice Payment Schedule | Payment schedule for the invoice. |
| invoice_status | TEXT | Invoice Status | Status of the invoice. |
| invoice_title | TEXT | Invoice Title | Title of the invoice. |
| invoice_total | NUMERIC | Invoice Total | Total amount of the invoice. |
| invoice_total_summary_discount | NUMERIC | Invoice Total Summary Discount | Discount amount for the invoice total summary. |
| invoice_total_summary_sub_total | NUMERIC | Invoice Total Summary Sub Total | Sub total amount for the invoice total summary. |
| invoice_total_summary_tax | NUMERIC | Invoice Total Summary Tax | Tax amount for the invoice total summary. |
| invoice_updated_at | DATE | Invoice Updated At | Timestamp when the invoice was last updated. |
GoHighLevel Location fields
The Location report of the GoHighLevel connector includes 38 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Location's unique identifier. |
| account_name | TEXT | Account Name | Name of the location. |
| location_address | TEXT | Location Address | Address of the location. |
| location_business_address | TEXT | Location Business Address | Business address associated with the location. |
| location_business_city | CITY | Location Business City | Business city associated with the location. |
| location_business_country | COUNTRY | Location Business Country | Business country associated with the location. |
| location_business_logo_url | IMAGE_URL | Location Business Logo URL | Business logo URL associated with the location. |
| location_business_name | TEXT | Location Business Name | Business name associated with the location. |
| location_business_postal_code | TEXT | Location Business Postal Code | Business postal code associated with the location. |
| location_business_state | REGION | Location Business State | Business state associated with the location. |
| location_business_timezone | TEXT | Location Business Timezone | Business timezone associated with the location. |
| location_business_website | TEXT | Location Business Website | Business website associated with the location. |
| location_city | CITY | Location City | City of the location. |
| location_company_id | TEXT | Location Company ID | Company ID associated with the location. |
| location_country | COUNTRY | Location Country | Country of the location. |
| location_domain | TEXT | Location Domain | Domain of the location. |
| location_email | TEXT | Location Email | Email associated with the location. |
| location_first_name | TEXT | Location First Name | First name associated with the location. |
| location_id | TEXT | Location ID | Location's unique identifier. |
| location_last_name | TEXT | Location Last Name | Last name associated with the location. |
| location_logo_url | IMAGE_URL | Location Logo URL | Logo URL of the location. |
| location_name | TEXT | Location Name | Name of the location. |
| location_phone | TEXT | Location Phone | Phone number associated with the location. |
| location_postal_code | TEXT | Location Postal Code | Postal code of the location. |
| location_social_blog_rss | TEXT | Location Social Blog RSS | Blog RSS URL associated with the location. |
| location_social_facebook_url | TEXT | Location Social Facebook URL | Facebook URL associated with the location. |
| location_social_foursquare | TEXT | Location Social Foursquare | Foursquare URL associated with the location. |
| location_social_google_places_id | TEXT | Location Social Google Places ID | Google Places ID associated with the location. |
| location_social_google_plus | TEXT | Location Social Google Plus | Google Plus URL associated with the location. |
| location_social_instagram | TEXT | Location Social Instagram | Instagram URL associated with the location. |
| location_social_linkedin | TEXT | Location Social LinkedIn | LinkedIn URL associated with the location. |
| location_social_pinterest | TEXT | Location Social Pinterest | Pinterest URL associated with the location. |
| location_social_twitter | TEXT | Location Social Twitter | Twitter URL associated with the location. |
| location_social_yelp | TEXT | Location Social Yelp | Yelp URL associated with the location. |
| location_social_youtube | TEXT | Location Social YouTube | YouTube URL associated with the location. |
| location_state | REGION | Location State | State of the location. |
| location_timezone | TEXT | Location Timezone | Timezone of the location. |
| location_website | TEXT | Location Website | Website of the location. |
GoHighLevel Opportunities fields
The Opportunities report of the GoHighLevel connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunity_assigned_to | TEXT | Opportunity Assigned To | User assigned to the opportunity. |
| opportunity_contact_company_name | TEXT | Opportunity Contact Company Name | Contact's company name associated with the opportunity. |
| opportunity_contact_email | TEXT | Opportunity Contact Email | Contact's email associated with the opportunity. |
| opportunity_contact_id | TEXT | Opportunity Contact ID | Contact ID associated with the opportunity. |
| opportunity_contact_name | TEXT | Opportunity Contact Name | Contact name associated with the opportunity. |
| opportunity_contact_phone | TEXT | Opportunity Contact Phone | Contact's phone number associated with the opportunity. |
| opportunity_contact_tags | TEXT | Opportunity Contact Tags | Tags associated with the contact of the opportunity. |
| opportunity_created_at | Opportunity Created At | Timestamp when the opportunity was created. | |
| opportunity_first_attribution_campaign | TEXT | Opportunity First Attribution Campaign | Campaign of the opportunity's first touch. |
| opportunity_first_attribution_campaign_id | TEXT | Opportunity First Attribution Campaign ID | Ad platform campaign ID of the opportunity's first touch. |
| opportunity_first_attribution_content | TEXT | Opportunity First Attribution Content | utmContent of the opportunity's first touch. |
| opportunity_first_attribution_medium | TEXT | Opportunity First Attribution Medium | Medium of the opportunity's first touch. |
| opportunity_first_attribution_medium_id | TEXT | Opportunity First Attribution Medium ID | Medium ID of the opportunity's first touch. |
| opportunity_first_attribution_session_source | TEXT | Opportunity First Attribution Session Source | Traffic category of the opportunity's first touch, e.g. Paid Social. |
| opportunity_first_attribution_utm_medium | TEXT | Opportunity First Attribution UTM Medium | utmMedium of the opportunity's first touch. |
| opportunity_first_attribution_utm_source | TEXT | Opportunity First Attribution UTM Source | utmSource of the opportunity's first touch, e.g. facebook. |
| opportunity_id | TEXT | Opportunity ID | Opportunity's unique identifier. |
| opportunity_last_attribution_campaign | TEXT | Opportunity Last Attribution Campaign | Campaign of the opportunity's last touch. |
| opportunity_last_attribution_campaign_id | TEXT | Opportunity Last Attribution Campaign ID | Ad platform campaign ID of the opportunity's last touch. |
| opportunity_last_attribution_content | TEXT | Opportunity Last Attribution Content | utmContent of the opportunity's last touch. |
| opportunity_last_attribution_medium | TEXT | Opportunity Last Attribution Medium | Medium of the opportunity's last touch. |
| opportunity_last_attribution_medium_id | TEXT | Opportunity Last Attribution Medium ID | Medium ID of the opportunity's last touch. |
| opportunity_last_attribution_session_source | TEXT | Opportunity Last Attribution Session Source | Traffic category of the opportunity's last touch, e.g. Paid Social. |
| opportunity_last_attribution_utm_medium | TEXT | Opportunity Last Attribution UTM Medium | utmMedium of the opportunity's last touch. |
| opportunity_last_attribution_utm_source | TEXT | Opportunity Last Attribution UTM Source | utmSource of the opportunity's last touch, e.g. facebook. |
| opportunity_last_stage_change_at | Opportunity Last Stage Change At | Timestamp of the last stage change of the opportunity. | |
| opportunity_last_status_change_at | Opportunity Last Status Change At | Timestamp of the last status change of the opportunity. | |
| opportunity_lost_reason_id | TEXT | Opportunity Lost Reason ID | Lost reason ID of the opportunity. |
| opportunity_monetary_value | NUMERIC | Opportunity Monetary Value | Monetary value of the opportunity. |
| opportunity_name | TEXT | Opportunity Name | Name of the opportunity. |
| opportunity_pipeline_id | TEXT | Opportunity Pipeline ID | Pipeline ID of the opportunity. |
| opportunity_pipeline_stage_id | TEXT | Opportunity Pipeline Stage ID | Pipeline stage ID of the opportunity. |
| opportunity_pipeline_stage_uid | TEXT | Opportunity Pipeline Stage UID | Pipeline stage UID of the opportunity. |
| opportunity_source | TEXT | Opportunity Source | Source of the opportunity. |
| opportunity_status | TEXT | Opportunity Status | Status of the opportunity. |
| opportunity_updated_at | Opportunity Updated At | Timestamp when the opportunity was last updated. |
GoHighLevel Orders fields
The Orders report of the GoHighLevel connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| order_amount | NUMERIC | Order Amount | Amount of the order. |
| order_contact_email | TEXT | Order Contact Email | Contact email associated with the order. |
| order_contact_id | TEXT | Order Contact ID | Contact ID associated with the order. |
| order_contact_name | TEXT | Order Contact Name | Contact name associated with the order. |
| order_coupon_code | TEXT | Order Coupon Code | Coupon code applied to the order. |
| order_created_at | Order Created At | Timestamp when the order was created. | |
| order_created_by | TEXT | Order Created By | User who created the order. |
| order_currency | TEXT | Order Currency | Currency of the order. |
| order_discount | NUMERIC | Order Discount | Discount applied to the order. |
| order_fulfillment_status | TEXT | Order Fulfillment Status | Fulfillment status of the order. |
| order_id | TEXT | Order ID | Order's unique identifier. |
| order_live_mode | BOOLEAN | Order Live Mode | Indicates if the order is in live mode. |
| order_onetime_products | NUMERIC | Order Onetime Products | Onetime products in the order. |
| order_recurring_products | NUMERIC | Order Recurring Products | Recurring products in the order. |
| order_source_id | TEXT | Order Source ID | Source ID of the order. |
| order_source_meta | OBJECT | Order Source Meta | Source metadata of the order. |
| order_source_name | TEXT | Order Source Name | Source name of the order. |
| order_source_sub_type | TEXT | Order Source Sub Type | Source sub-type of the order. |
| order_source_type | TEXT | Order Source Type | Source type of the order. |
| order_status | TEXT | Order Status | Status of the order. |
| order_subtotal | NUMERIC | Order Subtotal | Subtotal of the order. |
| order_total_products | NUMERIC | Order Total Products | Total number of products in the order. |
| order_updated_at | Order Updated At | Timestamp when the order was last updated. |
GoHighLevel Pipelines fields
The Pipelines report of the GoHighLevel connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| pipeline_id | TEXT | Pipeline ID | Pipeline's unique identifier. |
| pipeline_name | TEXT | Pipeline Name | Name of the pipeline. |
| pipeline_show_in_funnel | BOOLEAN | Pipeline Show In Funnel | Indicates if the pipeline is shown in the funnel view. |
| pipeline_show_in_pie_chart | BOOLEAN | Pipeline Show In Pie Chart | Indicates if the pipeline is shown in the pie chart view. |
| pipeline_stages | OBJECT | Pipeline Stages | Stages within the pipeline. |
GoHighLevel Transactions fields
The Transactions report of the GoHighLevel connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| transaction_amount | NUMERIC | Transaction Amount | Amount of the transaction. |
| transaction_amount_refunded | NUMERIC | Transaction Amount Refunded | Amount refunded for the transaction. |
| transaction_charge_id | TEXT | Transaction Charge ID | Charge ID associated with the transaction. |
| transaction_charge_snapshot | OBJECT | Transaction Charge Snapshot | Charge snapshot associated with the transaction. |
| transaction_contact_id | TEXT | Transaction Contact ID | Contact ID associated with the transaction. |
| transaction_contact_name | TEXT | Transaction Contact Name | Name of the contact associated with the transaction. |
| transaction_created_at | Transaction Created At | Timestamp when the transaction was created. | |
| transaction_created_by | TEXT | Transaction Created By | User who created the transaction. |
| transaction_currency | TEXT | Transaction Currency | Currency of the transaction. |
| transaction_entity_id | TEXT | Transaction Entity ID | Entity ID of the transaction. |
| transaction_entity_source_id | TEXT | Transaction Entity Source ID | Entity source ID of the transaction. |
| transaction_entity_source_meta | OBJECT | Transaction Entity Source Meta | Entity source metadata of the transaction. |
| transaction_entity_source_name | TEXT | Transaction Entity Source Name | Entity source name of the transaction. |
| transaction_entity_source_sub_type | TEXT | Transaction Entity Source Sub Type | Entity source sub-type of the transaction. |
| transaction_entity_source_type | TEXT | Transaction Entity Source Type | Entity source type of the transaction. |
| transaction_entity_type | TEXT | Transaction Entity Type | Entity type of the transaction. |
| transaction_fulfilled_at | Transaction Fulfilled At | Timestamp when the transaction was fulfilled. | |
| transaction_id | TEXT | Transaction ID | Transaction's unique identifier. |
| transaction_ip_address | TEXT | Transaction IP Address | IP address associated with the transaction. |
| transaction_live_mode | BOOLEAN | Transaction Live Mode | Indicates if the transaction is in live mode. |
| transaction_merged_from_contact_id | TEXT | Transaction Merged From Contact ID | Merged from contact ID associated with the transaction. |
| transaction_payment_method | TEXT | Transaction Payment Method | Payment method used for the transaction. |
| transaction_payment_provider_connected_account | TEXT | Transaction Payment Provider Connected Account | Payment provider connected account of the transaction. |
| transaction_payment_provider_type | TEXT | Transaction Payment Provider Type | Payment provider type of the transaction. |
| transaction_status | TEXT | Transaction Status | Status of the transaction. |
| transaction_subscription_id | TEXT | Transaction Subscription ID | Subscription ID associated with the transaction. |
| transaction_updated_at | Transaction Updated At | Timestamp when the transaction was last updated. |
GoHighLevel Users fields
The Users report of the GoHighLevel connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| user_deleted | BOOLEAN | User Deleted | Indicates if the user is deleted. |
| user_email | TEXT | User Email | Email of the user. |
| user_first_name | TEXT | User First Name | First name of the user. |
| user_id | TEXT | User ID | User's unique identifier. |
| user_last_name | TEXT | User Last Name | Last name of the user. |
| user_name | TEXT | User Name | Name of the user. |
| user_phone | TEXT | User Phone | Phone number of the user. |
GoHighLevel other fields
The GoHighLevel connector has 19 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 | 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 | |
| date | DATE | Date | Record's date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | 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 |
