Sample

 

https://connectors.windsor.ai/salesforce?api_key=[your API key]&date_preset=last_7d&fields=contact_firstname,contact_lastname,contact_email,contact_phone&_renderer=csv

The Salesforce CRM connector lets you pull Salesforce data on an object level. The currently supported objects are:
  • Account
  • Lead
  • Contact
  • Task
  • Opportunity
  • Campaign

If you want to pull custom fields please refer to our Salesforce connector knowledge base articles


Fields

IDTypeNameDescription
account_account_sourceTEXTAccount SourceAccount Source
account_annual_revenueNUMERICAccount Annual RevenueAccount Annual Revenue
account_billing_addressTEXTAccount Billing AddressAccount Billing Address
account_billing_cityTEXTAccount Billing CityAccount Billing City
account_billing_countryTEXTAccount Billing CountryAccount Billing Country
account_billing_geocode_accuracyTEXTAccount Billing Geocode AccuracyAccount Billing Geocode Accuracy
account_billing_latitudeNUMERICAccount Billing LatitudeAccount Billing Latitude
account_billing_longitudeNUMERICAccount Billing LongitudeAccount Billing Longitude
account_billing_postal_codeTEXTAccount Billing Zip/Postal CodeAccount Billing Zip/Postal Code
account_billing_stateTEXTAccount Billing State/ProvinceAccount Billing State/Province
account_billing_streetTEXTAccount Billing StreetAccount Billing Street
account_created_by_idTEXTAccount Created By IDAccount Created By ID
account_created_dateDATEAccount Created DateAccount Created date
account_descriptionTEXTAccount DescriptionAccount Description
account_faxTEXTAccount FaxAccount Fax
account_idTEXTAccount IDAccount ID
account_industryTEXTAccount IndustryAccount Industry
account_is_deletedBOOLEANAccount DeletedAccount Deleted
account_jigsawTEXTAccount Data.com KeyAccount Data.com Key
account_jigsaw_company_idTEXTAccount Jigsaw Company IDAccount Jigsaw Company ID
account_last_activity_dateTEXTAccount Last ActivityAccount Last Activity
account_last_modified_by_idTEXTAccount Last Modified By IDAccount Last Modified By ID
account_last_modified_dateDATEAccount Last Modified DateAccount Last Modified date
account_last_referenced_dateDATEAccount Last Referenced DateAccount Last Referenced date
account_last_viewed_dateDATEAccount Last Viewed DateAccount Last Viewed date
account_master_record_idTEXTAccount Master Record IDAccount Master Record ID
account_nameTEXTAccount NameAccount Name
account_number_of_employeesNUMERICAccount EmployeesAccount Employees
account_operating_hours_idTEXTAccount Operating Hour IDAccount Operating Hour ID
account_owner_idTEXTAccount Owner IDAccount Owner ID
account_parent_idTEXTAccount Parent Account IDAccount Parent Account ID
account_phoneTEXTAccount PhoneAccount Phone
account_photo_urlTEXTAccount Photo URLAccount Photo URL
account_shipping_addressTEXTAccount Shipping AddressAccount Shipping Address
account_shipping_cityTEXTAccount Shipping CityAccount Shipping City
account_shipping_countryTEXTAccount Shipping CountryAccount Shipping Country
account_shipping_geocode_accuracyTEXTAccount Shipping Geocode AccuracyAccount Shipping Geocode Accuracy
account_shipping_latitudeNUMERICAccount Shipping LatitudeAccount Shipping Latitude
account_shipping_longitudeNUMERICAccount Shipping LongitudeAccount Shipping Longitude
account_shipping_postal_codeTEXTAccount Shipping Zip/Postal CodeAccount Shipping Zip/Postal Code
account_shipping_stateTEXTAccount Shipping State/ProvinceAccount Shipping State/Province
account_shipping_streetTEXTAccount Shipping StreetAccount Shipping Street
account_sic_descTEXTAccount SIC DescriptionAccount SIC Description
account_system_modstampTEXTAccount System ModstampAccount System Modstamp
account_typeTEXTAccount TypeAccount Type
account_websiteTEXTAccount WebsiteAccount Website
campaign_actual_costNUMERICCampaign Actual Cost in CampaignCampaign Actual Cost in Campaign
campaign_amount_all_opportunitiesNUMERICCampaign Value Opportunities in CampaignCampaign Value Opportunities in Campaign
campaign_amount_won_opportunitiesNUMERICCampaign Value Won Opportunities in CampaignCampaign Value Won Opportunities in Campaign
campaign_budgeted_costNUMERICCampaign Budgeted Cost in CampaignCampaign Budgeted Cost in Campaign
campaign_campaign_member_record_type_idTEXTCampaign Record Type IDCampaign Record Type ID
campaign_created_by_idTEXTCampaign Created By IDCampaign Created By ID
campaign_created_dateDATECampaign Created DateCampaign Created date
campaign_descriptionTEXTCampaign DescriptionCampaign Description
campaign_end_dateDATECampaign End DateCampaign End date
campaign_expected_responseNUMERICCampaign Expected Response (%)Campaign Expected Response (%)
campaign_expected_revenueNUMERICCampaign Expected Revenue in CampaignCampaign Expected Revenue in Campaign
campaign_idTEXTCampaign IDCampaign ID
campaign_is_activeBOOLEANCampaign ActiveCampaign Active
campaign_is_deletedBOOLEANCampaign DeletedCampaign Deleted
campaign_last_activity_dateTEXTCampaign Last ActivityCampaign Last Activity
campaign_last_modified_by_idTEXTCampaign Last Modified By IDCampaign Last Modified By ID
campaign_last_modified_dateDATECampaign Last Modified DateCampaign Last Modified date
campaign_last_referenced_dateDATECampaign Last Referenced DateCampaign Last Referenced date
campaign_last_viewed_dateDATECampaign Last Viewed DateCampaign Last Viewed date
campaign_nameTEXTCampaign NameCampaign Name
campaign_number_of_contactsNUMERICCampaign Contacts in CampaignCampaign Contacts in Campaign
campaign_number_of_converted_leadsNUMERICCampaign Converted Leads in CampaignCampaign Converted Leads in Campaign
campaign_number_of_leadsNUMERICCampaign Leads in CampaignCampaign Leads in Campaign
campaign_number_of_opportunitiesNUMERICCampaign Opportunities in CampaignCampaign Opportunities in Campaign
campaign_number_of_responsesNUMERICCampaign Responses in CampaignCampaign Responses in Campaign
campaign_number_of_won_opportunitiesNUMERICCampaign Won Opportunities in CampaignCampaign Won Opportunities in Campaign
campaign_number_sentNUMERICCampaign Num Sent in CampaignCampaign Num Sent in Campaign
campaign_owner_idTEXTCampaign Owner IDCampaign Owner ID
campaign_parent_idTEXTCampaign Parent Campaign IDCampaign Parent Campaign ID
campaign_start_dateDATECampaign Start DateCampaign Start date
campaign_statusTEXTCampaign StatusCampaign Status
campaign_system_modstampTEXTCampaign System ModstampCampaign System Modstamp
campaign_typeTEXTCampaign TypeCampaign Type
contact_accountidTEXTContact Account IDID of the account that’s the parent of this contact.
contact_assistantnameTEXTContact Assistants NameThe assistant’s name.
contact_assistantphoneTEXTContact Assitants Phone NumberThe assistant’s telephone number.
contact_birthdateDATEContact BirthdateThe contact’s birthdate.
contact_createdbyTEXTContact Created ByThe user who created the contact
contact_createddateDATEContact Creation DateThe Creation Date (Duplicate)
contact_dateDATEContact DateThe Creation Date
contact_departmentTEXTContact DepartmentThe contact’s department.
contact_descriptionTEXTContact DescriptionContact's description
contact_emailTEXTContact EmailThe contact’s email address.
contact_emailbounceddateTIMESTAMPContact Email Bounced DateIf bounce management is activated and an email sent to the contact bounces, the date and time of the bounce.
contact_emailbouncedreasonTEXTContact Email Bounced ReasonIf bounce management is activated and an email sent to the contact bounces, the reason for the bounce.
contact_faxTEXTContact FaxThe contact’s fax number (Label is Business Fax).
contact_firstnameTEXTContact First NameThe contact’s first name (up to 40 characters).
contact_homephoneTEXTContact Home PhoneThe contact’s home telephone number.
contact_isdeletedTEXTContact Is DeletedIs contact deleted
contact_isemailbouncedTEXTContact Is Email BouncedContact's description
contact_lastactivitydateDATEContact Last Activity DateValue is the most recent of either: Due date of the most recent event logged against the record or due date of the most recently closed task associated with the record.
contact_lastmodifieddateDATEContact Last Modified DateContact last modified date
contact_lastnameTEXTContact Last NameRequiredLast name of the contact (up to 80 characters).
contact_leadsourceTEXTContact Lead SourceThe lead’s source.
contact_mailingcityTEXTContact Mailing CityMailing address details.
contact_mailingcountryTEXTContact Mailing CountryMailing country.
contact_mailingpostalcodeTEXTContact Mailing Postal CodeThe zip or postal code in the mailing address
contact_mailingstateTEXTContact Mailing StateMailing state details.
contact_mailingstreetTEXTContact Mailing StreetStreet address for mailing address.
contact_mobilephoneTEXTContact Mobile PhoneContact’s mobile phone number.
contact_nameTEXTContact NameContact full name
contact_othercityTEXTContact Other CityAlternative city details.
contact_othercountryTEXTContact Other CountryAlternative country details.
contact_otherphoneTEXTContact Other PhoneTelephone for alternate address.
contact_otherpostalcodeTEXTContact Other Postal CodeAlternative postal code details.
contact_otherstateTEXTContact Other StateAlternate address details (state).
contact_otherstreetTEXTContact Other StreetStreet for alternate address.
contact_owneridTEXTContact Owner IDThe ID of the owner of the account associated with this contact.
contact_phoneTEXTContact Business PhoneTelephone number for the contact
contact_reportstoidTEXTContact Reports to IDID of contact's manager
contact_salutationTEXTContact SalutationHonorific abbreviation, word, or phrase to be used in front of name in greetings, such as Dr. or Mrs.
contact_titleTEXTContact TitleTitle of the contact, such as CEO or Vice President.
dateDATELast Modified DateThe Last Modified Date of the selected Object
emailTEXTLead Email (duplicate)Lead Email
lead_addressTEXTLead AddressLead Address
lead_annual_revenueNUMERICLead Annual RevenueLead Annual Revenue
lead_cityTEXTLead CityLead City
lead_companyTEXTLead CompanyLead Company
lead_converted_account_idTEXTLead Converted Account IDLead Converted Account ID
lead_converted_contact_idTEXTLead Converted Contact IDLead Converted Contact ID
lead_converted_dateDATELead Converted DateLead Converted date
lead_converted_opportunity_idTEXTLead Converted Opportunity IDLead Converted Opportunity ID
lead_countryTEXTLead CountryLead Country
lead_created_by_idTEXTLead Created By IDLead Created By ID
lead_created_dateDATELead Created DateLead Created date
lead_descriptionTEXTLead DescriptionLead Description
lead_emailTEXTLead EmailLead Email
lead_email_bounced_dateDATELead Email Bounced DateLead Email Bounced date
lead_email_bounced_reasonTEXTLead Email Bounced ReasonLead Email Bounced Reason
lead_first_nameTEXTLead First NameLead First Name
lead_geocode_accuracyTEXTLead Geocode AccuracyLead Geocode Accuracy
lead_idTEXTLead IDLead ID
lead_individual_idTEXTLead Individual IDLead Individual ID
lead_industryTEXTLead IndustryLead Industry
lead_is_convertedBOOLEANLead ConvertedLead Converted
lead_is_deletedBOOLEANLead DeletedLead Deleted
lead_is_unread_by_ownerTEXTLead Unread By OwnerLead Unread By Owner
lead_jigsawTEXTLead Data.com KeyLead Data.com Key
lead_jigsaw_contact_idTEXTLead Jigsaw Contact IDLead Jigsaw Contact ID
lead_last_activity_dateTEXTLead Last ActivityLead Last Activity
lead_last_modified_by_idTEXTLead Last Modified By IDLead Last Modified By ID
lead_last_modified_dateDATELead Last Modified DateLead Last Modified date
lead_last_nameTEXTLead Last NameLead Last Name
lead_last_referenced_dateDATELead Last Referenced DateLead Last Referenced date
lead_last_viewed_dateDATELead Last Viewed DateLead Last Viewed date
lead_latitudeNUMERICLead LatitudeLead Latitude
lead_lead_sourceTEXTLead SourceLead Source
lead_longitudeNUMERICLead LongitudeLead Longitude
lead_master_record_idTEXTLead Master Record IDLead Master Record ID
lead_nameTEXTLead Full NameLead Full Name
lead_number_of_employeesNUMERICLead EmployeesLead Employees
lead_owner_idTEXTLead Owner IDLead Owner ID
lead_phoneTEXTLead PhoneLead Phone
lead_photo_urlTEXTLead Photo URLLead Photo URL
lead_postal_codeTEXTLead Zip/Postal CodeLead Zip/Postal Code
lead_ratingTEXTLead RatingLead Rating
lead_salutationTEXTLead SalutationLead Salutation
lead_stateTEXTLead State/ProvinceLead State/Province
lead_statusTEXTLead StatusLead Status
lead_streetTEXTLead StreetLead Street
lead_system_modstampTEXTLead System ModstampLead System Modstamp
lead_titleTEXTLead TitleLead Title
lead_websiteTEXTLead WebsiteLead Website
opportunity_account_idTEXTOpportunity Account IDOpportunity Account ID
opportunity_amountNUMERICOpportunity AmountOpportunity Amount
opportunity_campaign_idTEXTOpportunity Campaign IDOpportunity Campaign ID
opportunity_close_dateDATEOpportunity Close DateOpportunity Close date
opportunity_contact_idTEXTOpportunity Contact IDOpportunity Contact ID
opportunity_created_by_idTEXTOpportunity Created By IDOpportunity Created By ID
opportunity_created_dateDATEOpportunity Created DateOpportunity Created date
opportunity_descriptionTEXTOpportunity DescriptionOpportunity Description
opportunity_fiscalTEXTOpportunity Fiscal PeriodOpportunity Fiscal Period
opportunity_fiscal_quarterNUMERICOpportunity Fiscal QuarterOpportunity Fiscal Quarter
opportunity_fiscal_yearNUMERICOpportunity Fiscal YearOpportunity Fiscal Year
opportunity_forecast_categoryTEXTOpportunity Forecast CategoryOpportunity Forecast Category
opportunity_forecast_category_nameTEXTOpportunity Forecast CategoryOpportunity Forecast Category
opportunity_has_open_activityBOOLEANOpportunity Has Open ActivityOpportunity Has Open Activity
opportunity_has_opportunity_line_itemBOOLEANOpportunity Has Line ItemOpportunity Has Line Item
opportunity_has_overdue_taskBOOLEANOpportunity Has Overdue TaskOpportunity Has Overdue Task
opportunity_idTEXTOpportunity IDOpportunity ID
opportunity_is_closedBOOLEANOpportunity ClosedOpportunity Closed
opportunity_is_deletedBOOLEANOpportunity DeletedOpportunity Deleted
opportunity_is_wonBOOLEANOpportunity WonOpportunity Won
opportunity_last_activity_dateDATEOpportunity Last ActivityOpportunity Last Activity
opportunity_last_amount_changed_history_idDATEOpportunity History IDOpportunity History ID
opportunity_last_close_date_changed_history_idTEXTOpportunity History IDOpportunity History ID
opportunity_last_modified_by_idTEXTOpportunity Last Modified By IDOpportunity Last Modified By ID
opportunity_last_modified_dateDATEOpportunity Last Modified DateOpportunity Last Modified date
opportunity_last_referenced_dateDATEOpportunity Last Referenced DateOpportunity Last Referenced date
opportunity_last_viewed_dateDATEOpportunity Last Viewed DateOpportunity Last Viewed date
opportunity_lead_sourceTEXTOpportunity Lead SourceOpportunity Lead Source
opportunity_nameTEXTOpportunity NameOpportunity Name
opportunity_next_stepTEXTOpportunity Next StepOpportunity Next Step
opportunity_owner_idTEXTOpportunity Owner IDOpportunity Owner ID
opportunity_pricebook2_idTEXTOpportunity Price Book IDOpportunity Price Book ID
opportunity_probabilityNUMERICOpportunity Probability (%)Opportunity Probability (%)
opportunity_stage_nameTEXTOpportunity StageOpportunity Stage
opportunity_system_modstampTEXTOpportunity System ModstampOpportunity System Modstamp
opportunity_typeTEXTOpportunity TypeOpportunity Type
task_account_idTEXTTask Account IDTask Account ID
task_activity_dateDATETask Due Date OnlyTask Due Date Only
task_call_dispositionTEXTTask Call ResultTask Call Result
task_call_duration_in_secondsNUMERICTask Call DurationTask Call Duration
task_call_objectTEXTTask Call Object IdentifierTask Call Object Identifier
task_call_typeTEXTTask Call TypeTask Call Type
task_completed_date_timeDATETask Completed DateTask Completed date
task_created_by_idTEXTTask Created By IDTask Created By ID
task_created_dateDATETask Created DateTask Created date
task_descriptionTEXTTask DescriptionTask Description
task_idTEXTTask Activity IDTask Activity ID
task_is_archivedBOOLEANTask ArchivedTask Archived
task_is_closedBOOLEANTask ClosedTask Closed
task_is_deletedBOOLEANTask DeletedTask Deleted
task_is_high_priorityBOOLEANTask High PriorityTask High Priority
task_is_recurrenceBOOLEANTask Create Recurring Series of TasksTask Create Recurring Series of Tasks
task_is_reminder_setBOOLEANTask Reminder SetTask Reminder Set
task_last_modified_by_idTEXTTask Last Modified By IDTask Last Modified By ID
task_last_modified_dateDATETask Last Modified DateTask Last Modified date
task_owner_idTEXTTask Assigned To IDTask Assigned To ID
task_priorityTEXTTask PriorityTask Priority
task_recurrence_activity_idTEXTTask Recurrence Activity IDTask Recurrence Activity ID
task_recurrence_day_of_monthNUMERICTask Recurrence Day of MonthTask Recurrence Day of Month
task_recurrence_day_of_week_maskNUMERICTask Recurrence Day of Week MaskTask Recurrence Day of Week Mask
task_recurrence_end_date_onlyTEXTTask Recurrence EndTask Recurrence End
task_recurrence_instanceTEXTTask Recurrence InstanceTask Recurrence Instance
task_recurrence_intervalNUMERICTask Recurrence IntervalTask Recurrence Interval
task_recurrence_month_of_yearTEXTTask Recurrence Month of YearTask Recurrence Month of Year
task_recurrence_regenerated_typeTEXTTask Repeat This TaskTask Repeat This Task
task_recurrence_start_date_onlyTEXTTask Recurrence StartTask Recurrence Start
task_recurrence_time_zone_sid_keyTEXTTask Recurrence Time ZoneTask Recurrence Time Zone
task_recurrence_typeTEXTTask Recurrence TypeTask Recurrence Type
task_reminder_date_timeTEXTTask Reminder Date/TimeTask Reminder Date/Time
task_statusTEXTTask StatusTask Status
task_subjectTEXTTask SubjectTask Subject
task_system_modstampTEXTTask System ModstampTask System Modstamp
task_task_subtypeTEXTTask SubtypeTask Subtype
task_what_idTEXTTask Related To IDTask Related To ID
task_who_idTEXTTask Name IDTask Name ID