Terminus Data Studio Required Salesforce Integration Fields

Below are the required fields for a Data Studio Salesforce CRM Integration. Without any of the fields below, there could be a loss of functionality or data issues within the platform.

 SFDC Object

 Required Fields

 Account

  • Id
  • IsDeleted
  • MasterRecordId
  • Name
  • Type
  • ParentId
  • Website
  • OwnerId
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp
  • LastActivityDate

 Campaign

  • Id
  • IsDeleted
  • Name
  • Type
  • StartDate
  • EndDate
  • IsActive
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 CampaignMember

  • Id
  • IsDeleted
  • CampaignId
  • LeadId
  • ContactId
  • Status
  • HasResponded
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp
  • FirstRespondedDate

 Contact

  • Id
  • IsDeleted
  • AccountId
  • Name
  • Email
  • Title
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 Lead

  • Id
  • IsDeleted
  • Name
  • Title
  • Company
  • Email
  • Website
  • Status
  • IsConverted
  • ConvertedDate
  • ConvertedAccountId
  • ConvertedContactId
  • ConvertedOpportunityId
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 Opportunity

  • Id
  • IsDeleted
  • AccountId
  • Name
  • StageName
  • Amount
  • CloseDate
  • Type
  • IsClosed
  • IsWon
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 OpportunityContactRole

  • Id
  • OpportunityId
  • ContactId
  • Role
  • IsPrimary
  • CreatedDate
  • CreatedById
  • LastModifiedDate
  • LastModifiedById
  • SystemModstamp
  • IsDeleted

 OpportunityHistory

  • Id
  • OpportunityId
  • CreatedById
  • CreatedDate
  • StageName
  • Amount
  • CloseDate
  • SystemModstamp
  • IsDeleted

 OpportunityStage

  • CreatedDate
  • LastModifiedDate
  • SystemModstamp
  • Id
  • MasterLabel
  • IsActive
  • SortOrder
  • IsClosed
  • IsWon

 RecordType

  • Id
  • Name
  • DeveloperName
  • SobjectType
  • IsActive
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 Task

  • Id
  • WhoId
  • Subject
  • OwnerId
  • Type
  • IsDeleted
  • AccountId
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 User

  • Id
  • Username
  • Name
  • Title
  • Email
  • IsActive
  • UserRoleId
  • CreatedDate
  • LastModifiedDate
  • SystemModstamp

 UserRole

  • Id
  • Name
  • ForecastUserId
  • LastModifiedDate
  • SystemModstamp
  • PortalAccountId
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.