Dynamics Connected Objects

• CreatedAt - datetime - when account was created
• CreatedBy - string - Dynamics user that created account
• LastUpdated - datetime
• Name - string - account name
• OpenDeals - number - count of open deals associated with account
• OpenDealsAt - datetime - timestamp of most open deal associated with account
• OpenRevenue - number - revenue from all open deals
• OpenRevenueAt - datetime - timestamp of last open revenue associated with account
• Owner - string - Dynamics user the account belongs to
• Revenue - number - revenue generated by account

Activity

• ActualDurationInSeconds - number - actual duration in seconds of activity
• ActualEnd - datetime - when the activity ends
• ActualStart - datetime - when the activity starts
• IsAppointment - boolean - true if it's an appointment, otherwise false
• IsCall - boolean - true if it's a call, otherwise false
• IsCompleted - boolean - true if activity has been completed, otherwise false
• IsTask - boolean - true if it's a task, otherwise false
• LastUpdated - datetime
• Name - string - subject of the activity
• Owner - string - Dynamics user the activity belongs to

Lead

• CreatedBy - string - Dynamics user that created the lead
• CreatedOn - timestamp - when lead was created
• DecisionMaker - boolean
• IsQualified - boolean
• LastUpdated - datetime
• Name - string - lead's name
• Owner - string - Dynamics user the lead belongs to

Deal (Opportunity)