Terminus Data Studio Required Dynamics 365 Integration Fields

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

Dynamics Entity Required Fields (DYN Internal Name)
  Account
  • accountid
  • statecode
  • name
  • _parentaccountid_value
  • websiteurl
  • _ownerid_value
  • createdon
  • _createdby_value
  • modifiedon
  • _modifiedby_value
  Contact
  • contacted
  • statecode
  • _parentcustomerid_value
  • lastname
  • firstname
  • salutation
  • fullname
  • address2_line1
  • address2_city
  • address2_stateorprovince
  • address2_postalcode
  • address2_country
  • address2_latitude
  • address2_longitude
  • address1_line1
  • address1_city
  • address1_stateorprovince
  • address1_postalcode
  • address1_country
  • address1_latitude
  • address1_longitude
  • telephone1
  • fax
  • mobilephone
  • address1_telephone1
  • address1_telephone2
  • assistantphone
  • emailaddress1
  • jobtitle
  • department
  • assistantname
  • leadsourcecode
  • birthdate
  • description
  • _ownerid_value
  • createdon
  • _createdby_value
  • modifiedon
  • _modifiedby_value
  Lead
  • leadid
  • statecode
  • lastname
  • firstname
  • salutation
  • fullname
  • jobtitle
  • companyname
  • address1_line1
  • address1_city
  • address1_stateorprovince
  • address1_postalcode
  • address1_country
  • telephone1
  • mobilephone
  • emailaddress1
  • websiteurl
  • description
  • leadsourcecode
  • statuscode
  • industrycode
  • revenue_base
  • numberofemployees
  • _ownerid_value
  • donotemail
  • createdon
  • _createdby_value
  • modifiedon
  • _modifiedby_value
  • modifiedon
  • _parentaccountid_value
  • _parentcontactid_value
  • _qualifyingopportunityid_value
  • _campaignid_value
  • _masterid_value
  Opportunity
  • opportunityid
  • _parentaccountid_value
  • name
  • salesstage
  • actualvalue_base
  • actualclosedate
  • statecode_closed
  • statecode_won
  • _ownerid_value
  • createdon
  • _createdby_value
  • modifiedon
  • _modifiedby_value
  User
  • systemuserid
  • lastname
  • firstname
  • fullname
  • jobtitle
  • address1_line1
  • address1_city
  • address1_stateorprovince
  • address1_postalcode
  • address1_country
  • address1_latitude
  • address1_longitude
  • internalemailaddress
  • address1_telephone1
  • address1_telephone2
  • nickname
  • _parentsystemuserid_value
  • createdon
  • _createdby_value
  • modifiedon
  • _modifiedby_value
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.