Pipedrive Connected Objects

After you connect your Pipedrive account with Spinify, the following fields are linked to the objects in Spinify for you to use when creating leaderboards or achievements.

Deal (with corresponding field in Pipedrive deal object)

  • Name - 'title'
  • CloseDate - 'won_time'
  • Type - 'currency'
  • Amount - 'value'
  • IsClosed - true if 'status' is not 'closed', otherwise false
  • IsWon - true if status is "won", otherwise false
  • SalesStage - 'stage_name'
  • LastContacted - 'update_time'
  • LastUpdated - 'update_time' 
  • CreatedAt - 'add_time'

Activity (with corresponding field in Pipedrive activity object)

  • Name - 'subject'
  • Type - 'type'
  • Done - 'done'
  • DueTime - 'due_time'
  • Duration - 'duration' (converted to seconds in Spinify)
  • LastUpdated - 'update_time'
  • AddTime - 'add_time'
  • LastNotificationTime - 'last_notification_time'
  • LastNotificationUserId - 'last_notification_user_id'
  • Active - 'active_flag'
  • UpdateUserId - 'update_user_id'
  • Note - 'note'
  • CreatedByUserId - 'created_by_user_id'
  • OrgName - 'org_name'
  • PersonName - 'person_name'
  • DealTitle - 'deal_title'
  • AssignedToUserId - 'assigned_to_user_id'
  • MarkedDoneTime - 'marked_as_done_time'
  • IsDeleted - true if 'object_deleted' is not blank, otherwise false

Organization (with corresponding field in Pipedrive organization object)

  • Name - 'name'
  • Owner - 'owner_id'
  • LastUpdated - 'update_time'
  • AddTime - 'add_time'
  • OpenDealsCount - 'open_deals_count'
  • RelatedOpenDealsCount - 'related_open_deals_count'
  • ClosedDealsCount - 'closed_deals_count'
  • RelatedClosedDealsCount - 'related_closed_deals_count'
  • EmailMessagesCount - 'email_messages_count'
  • PeopleCount - 'people_count'
  • ActivitiesCount - 'activities_count'
  • DoneActivitiesCount - 'done_activities_count'
  • UndoneActivitiesCount - 'undone_activities_count'
  • ReferenceActivitiesCount - 'reference_activities_count'
  • FilesCount - 'files_count'
  • NotesCount - 'notes_count'
  • FollowersCount - 'followers_count'
  • WonDealsCount - 'won_deals_count'
  • RelatedWonDealsCount - 'related_won_deals_count'
  • LostDealsCount - 'lost_deals_count'
  • RelatedLostDealsCount - 'related_lost_deals_count'
  • CategoryId - 'category_id'
  • CountryCode - 'country_code'
  • NextActivityDate - 'next_activity_date'
  • NextActivityTime - 'next_activity_time'
  • NextActivityId - 'next_activity_id'
  • LastActivityId - 'last_activity_id'
  • LastActivityDate - 'last_activity_date'
  • Active - 'active_flag'
  • Address - 'address'
  • AddressSubpremise - 'address_subpremise'
  • AddressStreetNumber - 'address_street_number'
  • AddressRoute - 'address_route'
  • AddressLocality - 'address_locality'
  • AddressAdminAreaLevel1 - 'address_admin_area_level_1'
  • AddressAdminAreaLevel2 - 'address_admin_area_level_2'
  • AddressCountry - 'address_country'
  • AddressPostalCode - 'address_postal_code'
  • AddressFormattedAddress - 'address_formatted_address'
  • IsDeleted -  false if 'object_deleted' == blank otherwise true

Person (with corresponding field in Pipedrive person object)

  • Name - 'name'
  • Owner - 'owner_id'
  • LastUpdated - 'update_time'
  • AddTime - 'add_time'
  • FirstName - 'first_name'
  • LastName - 'last_name'
  • OrgId - 'org_id'
  • OrgName - 'org_name'
  • OpenDealsCount - 'open_deals_count'
  • RelatedOpenDealsCount - 'related_open_deals_count'
  • ClosedDealsCount - 'closed_deals_count'
  • RelatedClosedDealsCount - 'related_closed_deals_count'
  • EmailMessagesCount - 'email_messages_count'
  • ParticipantOpenDealsCount -  'participant_open_deals_count'
  • ParticipantClosedDealsCount -  'participant_closed_deals_count'
  • ActivitiesCount - 'activities_count'
  • DoneActivitiesCount - 'done_activities_count'
  • UndoneActivitiesCount - 'undone_activities_count'
  • ReferenceActivitiesCount - 'reference_activities_count'
  • FilesCount - 'files_count'
  • NotesCount - 'notes_count'
  • FollowersCount - 'followers_count'
  • WonDealsCount - 'won_deals_count'
  • RelatedWonDealsCount - 'related_won_deals_count'
  • LostDealsCount - 'lost_deals_count'
  • RelatedLostDealsCount - 'related_lost_deals_count'
  • NextActivityDate - 'next_activity_date'
  • NextActivityTime - 'next_activity_time'
  • NextActivityId - 'next_activity_id'
  • LastActivityId - 'last_activity_id'
  • LastActivityDate - 'last_activity_date'
  • Active - 'active_flag'
  • LastIncomingMailTime - 'last_incoming_mail_time'
  • LastOncomingMailTime - 'last_oncoming_mail_time'
  • IsDeleted - false if 'object_deleted' is blank, otherwise true
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.