DemandScience Data Studio Required Dynamics 365 Integration Fields – DemandScience Help Center

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 _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

Related articles

You must sign in to view this content.