DoubleYouGTT / hubspot

R package 📦 for working with Hubspot 👩‍💼👨‍💼 data
https://itsalocke.com/hubspot/
Other
10 stars 8 forks source link
crm-integration hubspot hubspot-api r r-package rstats

hubspot

Access Hubspot CRM data in R

Project Status: WIP - Initial development is in progress, but there
has not yet been a stable, usable release suitable for the
public. Travis build
status Locke Data
Slack Codecov test
coverage

The goal of hubspot is to enable access to Hubspot CRM data. It uses the Hubspot API.

All functions are named following a hs_<endpointname>_raw()/hs_<endpointname>_tidy(), with hs_<endpointname>_tidy() offering at least one view: e.g. get a nested list of deals data with hs_deals_raw() and transform it to a tibble of associations, properties history, properties or stages history using hs_deals_tidy().

Refer to the online reference to see what endpoints are supported at the moment. Feel free to suggest new “getters” (hs_<endpointname>_raw()) and tidier options (view of hs_<endpointname>_tidy()) in the issue tracker.

Example

library("hubspot")

deal_props <- hs_deal_properties_tidy()
head(deal_props)
#> [1] "amount_in_home_currency"    "days_to_close"             
#> [3] "hs_analytics_source"        "hs_analytics_source_data_1"
#> [5] "hs_analytics_source_data_2" "hs_campaign"

deals <- hs_deals_raw(properties = deal_props, max_iter = 1)
Click to see the deals nested list ``` r $`931633510` $`931633510`$portalId [1] 62515 $`931633510`$dealId [1] 931633510 $`931633510`$isDeleted [1] FALSE $`931633510`$associations $`931633510`$associations$associatedVids list() $`931633510`$associations$associatedCompanyIds list() $`931633510`$associations$associatedDealIds list() $`931633510`$associations$associatedTicketIds list() $`931633510`$properties $`931633510`$properties$hs_closed_amount_in_home_currency $`931633510`$properties$hs_closed_amount_in_home_currency$value [1] "0" $`931633510`$properties$hs_closed_amount_in_home_currency$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_closed_amount_in_home_currency$source [1] "CALCULATED" $`931633510`$properties$hs_closed_amount_in_home_currency$sourceId NULL $`931633510`$properties$hs_closed_amount_in_home_currency$versions $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]] $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$name [1] "hs_closed_amount_in_home_currency" $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$value [1] "0" $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$sourceVid list() $`931633510`$properties$hs_closed_amount_in_home_currency$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$dealname $`931633510`$properties$dealname$value [1] "Example deal" $`931633510`$properties$dealname$timestamp [1] 1.565734e+12 $`931633510`$properties$dealname$source [1] "CRM_UI" $`931633510`$properties$dealname$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$dealname$versions $`931633510`$properties$dealname$versions[[1]] $`931633510`$properties$dealname$versions[[1]]$name [1] "dealname" $`931633510`$properties$dealname$versions[[1]]$value [1] "Example deal" $`931633510`$properties$dealname$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$dealname$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$dealname$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$dealname$versions[[1]]$sourceVid list() $`931633510`$properties$hs_all_accessible_team_ids $`931633510`$properties$hs_all_accessible_team_ids$value [1] "" $`931633510`$properties$hs_all_accessible_team_ids$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_all_accessible_team_ids$source [1] "CRM_UI" $`931633510`$properties$hs_all_accessible_team_ids$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_accessible_team_ids$versions $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]] $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$name [1] "hs_all_accessible_team_ids" $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$value [1] "" $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hs_all_accessible_team_ids$versions[[1]]$sourceVid list() $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]] $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$name [1] "hs_all_accessible_team_ids" $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$value [1] "112117" $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$source [1] "CRM_UI" $`931633510`$properties$hs_all_accessible_team_ids$versions[[2]]$sourceVid list() $`931633510`$properties$amount $`931633510`$properties$amount$value [1] "100" $`931633510`$properties$amount$timestamp [1] 1.565734e+12 $`931633510`$properties$amount$source [1] "CRM_UI" $`931633510`$properties$amount$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$amount$versions $`931633510`$properties$amount$versions[[1]] $`931633510`$properties$amount$versions[[1]]$name [1] "amount" $`931633510`$properties$amount$versions[[1]]$value [1] "100" $`931633510`$properties$amount$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$amount$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$amount$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$amount$versions[[1]]$sourceVid list() $`931633510`$properties$closedate $`931633510`$properties$closedate$value [1] "1564783118291" $`931633510`$properties$closedate$timestamp [1] 1.565734e+12 $`931633510`$properties$closedate$source [1] "CRM_UI" $`931633510`$properties$closedate$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$closedate$versions $`931633510`$properties$closedate$versions[[1]] $`931633510`$properties$closedate$versions[[1]]$name [1] "closedate" $`931633510`$properties$closedate$versions[[1]]$value [1] "1564783118291" $`931633510`$properties$closedate$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$closedate$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$closedate$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$closedate$versions[[1]]$sourceVid list() $`931633510`$properties$num_associated_contacts $`931633510`$properties$num_associated_contacts$value [1] "0" $`931633510`$properties$num_associated_contacts$timestamp [1] 1.566463e+12 $`931633510`$properties$num_associated_contacts$source [1] "CALCULATED" $`931633510`$properties$num_associated_contacts$sourceId NULL $`931633510`$properties$num_associated_contacts$versions $`931633510`$properties$num_associated_contacts$versions[[1]] $`931633510`$properties$num_associated_contacts$versions[[1]]$name [1] "num_associated_contacts" $`931633510`$properties$num_associated_contacts$versions[[1]]$value [1] "0" $`931633510`$properties$num_associated_contacts$versions[[1]]$timestamp [1] 1.566463e+12 $`931633510`$properties$num_associated_contacts$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$num_associated_contacts$versions[[1]]$sourceVid list() $`931633510`$properties$hs_all_team_ids $`931633510`$properties$hs_all_team_ids$value [1] "" $`931633510`$properties$hs_all_team_ids$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_all_team_ids$source [1] "CRM_UI" $`931633510`$properties$hs_all_team_ids$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_team_ids$versions $`931633510`$properties$hs_all_team_ids$versions[[1]] $`931633510`$properties$hs_all_team_ids$versions[[1]]$name [1] "hs_all_team_ids" $`931633510`$properties$hs_all_team_ids$versions[[1]]$value [1] "" $`931633510`$properties$hs_all_team_ids$versions[[1]]$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_all_team_ids$versions[[1]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_team_ids$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hs_all_team_ids$versions[[1]]$sourceVid list() $`931633510`$properties$hs_all_team_ids$versions[[2]] $`931633510`$properties$hs_all_team_ids$versions[[2]]$name [1] "hs_all_team_ids" $`931633510`$properties$hs_all_team_ids$versions[[2]]$value [1] "112117" $`931633510`$properties$hs_all_team_ids$versions[[2]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_all_team_ids$versions[[2]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_team_ids$versions[[2]]$source [1] "CRM_UI" $`931633510`$properties$hs_all_team_ids$versions[[2]]$sourceVid list() $`931633510`$properties$createdate $`931633510`$properties$createdate$value [1] "1565733501511" $`931633510`$properties$createdate$timestamp [1] 1.565734e+12 $`931633510`$properties$createdate$source [1] "CRM_UI" $`931633510`$properties$createdate$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$createdate$versions $`931633510`$properties$createdate$versions[[1]] $`931633510`$properties$createdate$versions[[1]]$name [1] "createdate" $`931633510`$properties$createdate$versions[[1]]$value [1] "1565733501511" $`931633510`$properties$createdate$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$createdate$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$createdate$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$createdate$versions[[1]]$sourceVid list() $`931633510`$properties$hs_is_closed $`931633510`$properties$hs_is_closed$value [1] "false" $`931633510`$properties$hs_is_closed$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_is_closed$source [1] "CALCULATED" $`931633510`$properties$hs_is_closed$sourceId NULL $`931633510`$properties$hs_is_closed$versions $`931633510`$properties$hs_is_closed$versions[[1]] $`931633510`$properties$hs_is_closed$versions[[1]]$name [1] "hs_is_closed" $`931633510`$properties$hs_is_closed$versions[[1]]$value [1] "false" $`931633510`$properties$hs_is_closed$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_is_closed$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_is_closed$versions[[1]]$sourceVid list() $`931633510`$properties$hs_is_closed$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$amount_in_home_currency $`931633510`$properties$amount_in_home_currency$value [1] "100" $`931633510`$properties$amount_in_home_currency$timestamp [1] 1.565734e+12 $`931633510`$properties$amount_in_home_currency$source [1] "CALCULATED" $`931633510`$properties$amount_in_home_currency$sourceId NULL $`931633510`$properties$amount_in_home_currency$versions $`931633510`$properties$amount_in_home_currency$versions[[1]] $`931633510`$properties$amount_in_home_currency$versions[[1]]$name [1] "amount_in_home_currency" $`931633510`$properties$amount_in_home_currency$versions[[1]]$value [1] "100" $`931633510`$properties$amount_in_home_currency$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$amount_in_home_currency$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$amount_in_home_currency$versions[[1]]$sourceVid list() $`931633510`$properties$amount_in_home_currency$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$hs_deal_stage_probability $`931633510`$properties$hs_deal_stage_probability$value [1] "0.59999999999999997779553950749686919152736663818359375" $`931633510`$properties$hs_deal_stage_probability$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_deal_stage_probability$source [1] "CALCULATED" $`931633510`$properties$hs_deal_stage_probability$sourceId NULL $`931633510`$properties$hs_deal_stage_probability$versions $`931633510`$properties$hs_deal_stage_probability$versions[[1]] $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$name [1] "hs_deal_stage_probability" $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$value [1] "0.59999999999999997779553950749686919152736663818359375" $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$sourceVid list() $`931633510`$properties$hs_deal_stage_probability$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$days_to_close $`931633510`$properties$days_to_close$value [1] "0" $`931633510`$properties$days_to_close$timestamp [1] 1.565734e+12 $`931633510`$properties$days_to_close$source [1] "CALCULATED" $`931633510`$properties$days_to_close$sourceId NULL $`931633510`$properties$days_to_close$versions $`931633510`$properties$days_to_close$versions[[1]] $`931633510`$properties$days_to_close$versions[[1]]$name [1] "days_to_close" $`931633510`$properties$days_to_close$versions[[1]]$value [1] "0" $`931633510`$properties$days_to_close$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$days_to_close$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$days_to_close$versions[[1]]$sourceVid list() $`931633510`$properties$days_to_close$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$pipeline $`931633510`$properties$pipeline$value [1] "default" $`931633510`$properties$pipeline$timestamp [1] 1.565734e+12 $`931633510`$properties$pipeline$source [1] "CRM_UI" $`931633510`$properties$pipeline$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$pipeline$versions $`931633510`$properties$pipeline$versions[[1]] $`931633510`$properties$pipeline$versions[[1]]$name [1] "pipeline" $`931633510`$properties$pipeline$versions[[1]]$value [1] "default" $`931633510`$properties$pipeline$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$pipeline$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$pipeline$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$pipeline$versions[[1]]$sourceVid list() $`931633510`$properties$hubspot_team_id $`931633510`$properties$hubspot_team_id$value [1] "" $`931633510`$properties$hubspot_team_id$timestamp [1] 1.565735e+12 $`931633510`$properties$hubspot_team_id$source [1] "CRM_UI" $`931633510`$properties$hubspot_team_id$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hubspot_team_id$versions $`931633510`$properties$hubspot_team_id$versions[[1]] $`931633510`$properties$hubspot_team_id$versions[[1]]$name [1] "hubspot_team_id" $`931633510`$properties$hubspot_team_id$versions[[1]]$value [1] "" $`931633510`$properties$hubspot_team_id$versions[[1]]$timestamp [1] 1.565735e+12 $`931633510`$properties$hubspot_team_id$versions[[1]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hubspot_team_id$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hubspot_team_id$versions[[1]]$sourceVid list() $`931633510`$properties$hubspot_team_id$versions[[2]] $`931633510`$properties$hubspot_team_id$versions[[2]]$name [1] "hubspot_team_id" $`931633510`$properties$hubspot_team_id$versions[[2]]$value [1] "112117" $`931633510`$properties$hubspot_team_id$versions[[2]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hubspot_team_id$versions[[2]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hubspot_team_id$versions[[2]]$source [1] "CRM_UI" $`931633510`$properties$hubspot_team_id$versions[[2]]$sourceVid list() $`931633510`$properties$hubspot_owner_id $`931633510`$properties$hubspot_owner_id$value [1] "71" $`931633510`$properties$hubspot_owner_id$timestamp [1] 1.565734e+12 $`931633510`$properties$hubspot_owner_id$source [1] "CRM_UI" $`931633510`$properties$hubspot_owner_id$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$hubspot_owner_id$versions $`931633510`$properties$hubspot_owner_id$versions[[1]] $`931633510`$properties$hubspot_owner_id$versions[[1]]$name [1] "hubspot_owner_id" $`931633510`$properties$hubspot_owner_id$versions[[1]]$value [1] "71" $`931633510`$properties$hubspot_owner_id$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hubspot_owner_id$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$hubspot_owner_id$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hubspot_owner_id$versions[[1]]$sourceVid list() $`931633510`$properties$hs_closed_amount $`931633510`$properties$hs_closed_amount$value [1] "0" $`931633510`$properties$hs_closed_amount$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_closed_amount$source [1] "CALCULATED" $`931633510`$properties$hs_closed_amount$sourceId NULL $`931633510`$properties$hs_closed_amount$versions $`931633510`$properties$hs_closed_amount$versions[[1]] $`931633510`$properties$hs_closed_amount$versions[[1]]$name [1] "hs_closed_amount" $`931633510`$properties$hs_closed_amount$versions[[1]]$value [1] "0" $`931633510`$properties$hs_closed_amount$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_closed_amount$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_closed_amount$versions[[1]]$sourceVid list() $`931633510`$properties$hs_closed_amount$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$hs_lastmodifieddate $`931633510`$properties$hs_lastmodifieddate$value [1] "1565735453314" $`931633510`$properties$hs_lastmodifieddate$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_lastmodifieddate$source [1] "CALCULATED" $`931633510`$properties$hs_lastmodifieddate$sourceId NULL $`931633510`$properties$hs_lastmodifieddate$versions $`931633510`$properties$hs_lastmodifieddate$versions[[1]] $`931633510`$properties$hs_lastmodifieddate$versions[[1]]$name [1] "hs_lastmodifieddate" $`931633510`$properties$hs_lastmodifieddate$versions[[1]]$value [1] "1565735453314" $`931633510`$properties$hs_lastmodifieddate$versions[[1]]$timestamp [1] 1.565735e+12 $`931633510`$properties$hs_lastmodifieddate$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_lastmodifieddate$versions[[1]]$sourceVid list() $`931633510`$properties$hs_lastmodifieddate$versions[[2]] $`931633510`$properties$hs_lastmodifieddate$versions[[2]]$name [1] "hs_lastmodifieddate" $`931633510`$properties$hs_lastmodifieddate$versions[[2]]$value [1] "1565733538147" $`931633510`$properties$hs_lastmodifieddate$versions[[2]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_lastmodifieddate$versions[[2]]$source [1] "CALCULATED" $`931633510`$properties$hs_lastmodifieddate$versions[[2]]$sourceVid list() $`931633510`$properties$hs_lastmodifieddate$versions[[3]] $`931633510`$properties$hs_lastmodifieddate$versions[[3]]$name [1] "hs_lastmodifieddate" $`931633510`$properties$hs_lastmodifieddate$versions[[3]]$value [1] "1565733537449" $`931633510`$properties$hs_lastmodifieddate$versions[[3]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_lastmodifieddate$versions[[3]]$source [1] "CALCULATED" $`931633510`$properties$hs_lastmodifieddate$versions[[3]]$sourceVid list() $`931633510`$properties$hubspot_owner_assigneddate $`931633510`$properties$hubspot_owner_assigneddate$value [1] "1565733537449" $`931633510`$properties$hubspot_owner_assigneddate$timestamp [1] 1.565734e+12 $`931633510`$properties$hubspot_owner_assigneddate$source [1] "CRM_UI" $`931633510`$properties$hubspot_owner_assigneddate$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$hubspot_owner_assigneddate$versions $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]] $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$name [1] "hubspot_owner_assigneddate" $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$value [1] "1565733537449" $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hubspot_owner_assigneddate$versions[[1]]$sourceVid list() $`931633510`$properties$dealstage $`931633510`$properties$dealstage$value [1] "presentationscheduled" $`931633510`$properties$dealstage$timestamp [1] 1.565734e+12 $`931633510`$properties$dealstage$source [1] "CRM_UI" $`931633510`$properties$dealstage$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$dealstage$versions $`931633510`$properties$dealstage$versions[[1]] $`931633510`$properties$dealstage$versions[[1]]$name [1] "dealstage" $`931633510`$properties$dealstage$versions[[1]]$value [1] "presentationscheduled" $`931633510`$properties$dealstage$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$dealstage$versions[[1]]$sourceId [1] "dadams@hubspot.com" $`931633510`$properties$dealstage$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$dealstage$versions[[1]]$sourceVid list() $`931633510`$properties$hs_createdate $`931633510`$properties$hs_createdate$value [1] "1565733537449" $`931633510`$properties$hs_createdate$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_createdate$source [1] "CONTACTS" $`931633510`$properties$hs_createdate$sourceId [1] "CRM_UI" $`931633510`$properties$hs_createdate$versions $`931633510`$properties$hs_createdate$versions[[1]] $`931633510`$properties$hs_createdate$versions[[1]]$name [1] "hs_createdate" $`931633510`$properties$hs_createdate$versions[[1]]$value [1] "1565733537449" $`931633510`$properties$hs_createdate$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_createdate$versions[[1]]$sourceId [1] "CRM_UI" $`931633510`$properties$hs_createdate$versions[[1]]$source [1] "CONTACTS" $`931633510`$properties$hs_createdate$versions[[1]]$sourceVid list() $`931633510`$properties$hs_object_id $`931633510`$properties$hs_object_id$value [1] "931633510" $`931633510`$properties$hs_object_id$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_object_id$source [1] "CALCULATED" $`931633510`$properties$hs_object_id$sourceId NULL $`931633510`$properties$hs_object_id$versions $`931633510`$properties$hs_object_id$versions[[1]] $`931633510`$properties$hs_object_id$versions[[1]]$name [1] "hs_object_id" $`931633510`$properties$hs_object_id$versions[[1]]$value [1] "931633510" $`931633510`$properties$hs_object_id$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_object_id$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_object_id$versions[[1]]$sourceVid list() $`931633510`$properties$hs_projected_amount $`931633510`$properties$hs_projected_amount$value [1] "59.99999999999999777955395074968691915273666381835937500" $`931633510`$properties$hs_projected_amount$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_projected_amount$source [1] "CALCULATED" $`931633510`$properties$hs_projected_amount$sourceId NULL $`931633510`$properties$hs_projected_amount$versions $`931633510`$properties$hs_projected_amount$versions[[1]] $`931633510`$properties$hs_projected_amount$versions[[1]]$name [1] "hs_projected_amount" $`931633510`$properties$hs_projected_amount$versions[[1]]$value [1] "59.99999999999999777955395074968691915273666381835937500" $`931633510`$properties$hs_projected_amount$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_projected_amount$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_projected_amount$versions[[1]]$sourceVid list() $`931633510`$properties$hs_projected_amount$versions[[1]]$sourceMetadata [1] "" $`931633510`$properties$hs_all_owner_ids $`931633510`$properties$hs_all_owner_ids$value [1] "71" $`931633510`$properties$hs_all_owner_ids$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_all_owner_ids$source [1] "CRM_UI" $`931633510`$properties$hs_all_owner_ids$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_owner_ids$versions $`931633510`$properties$hs_all_owner_ids$versions[[1]] $`931633510`$properties$hs_all_owner_ids$versions[[1]]$name [1] "hs_all_owner_ids" $`931633510`$properties$hs_all_owner_ids$versions[[1]]$value [1] "71" $`931633510`$properties$hs_all_owner_ids$versions[[1]]$timestamp [1] 1.565734e+12 $`931633510`$properties$hs_all_owner_ids$versions[[1]]$sourceId [1] "PermissionsUpdater" $`931633510`$properties$hs_all_owner_ids$versions[[1]]$source [1] "CRM_UI" $`931633510`$properties$hs_all_owner_ids$versions[[1]]$sourceVid list() $`931633510`$properties$hs_projected_amount_in_home_currency $`931633510`$properties$hs_projected_amount_in_home_currency$value [1] "59.99999999999999777955395074968691915273666381835937500" $`931633510`$properties$hs_projected_amount_in_home_currency$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_projected_amount_in_home_currency$source [1] "CALCULATED" $`931633510`$properties$hs_projected_amount_in_home_currency$sourceId NULL $`931633510`$properties$hs_projected_amount_in_home_currency$versions $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]] $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$name [1] "hs_projected_amount_in_home_currency" $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$value [1] "59.99999999999999777955395074968691915273666381835937500" $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$timestamp [1] 1.571769e+12 $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$source [1] "CALCULATED" $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$sourceVid list() $`931633510`$properties$hs_projected_amount_in_home_currency$versions[[1]]$sourceMetadata [1] "" $`931633510`$imports list() $`931633510`$stateChanges list() ```


deal_stages <- hs_deals_tidy(deals, view = "properties")
deal_stages
#> # A tibble: 1 x 25
#>   dealId hs_closed_amoun… dealname hs_all_accessib… amount closedate          
#>    <dbl>            <dbl> <chr>    <chr>             <dbl> <dttm>             
#> 1 9.32e8                0 Example… ""                  100 2019-08-02 23:58:38
#> # … with 19 more variables: num_associated_contacts <dbl>,
#> #   hs_all_team_ids <chr>, createdate <dttm>, hs_is_closed <chr>,
#> #   amount_in_home_currency <dbl>, hs_deal_stage_probability <dbl>,
#> #   days_to_close <dbl>, pipeline <chr>, hubspot_team_id <chr>,
#> #   hubspot_owner_id <dbl>, hs_closed_amount <dbl>, hs_lastmodifieddate <dttm>,
#> #   hubspot_owner_assigneddate <dttm>, dealstage <chr>, hs_createdate <dttm>,
#> #   hs_object_id <dbl>, hs_projected_amount <dbl>, hs_all_owner_ids <dbl>,
#> #   hs_projected_amount_in_home_currency <dbl>

Installation

remotes::install_github("lockedata/hubspot")

Authorization for Hubspot APIs

The Hubspot API accepts authorization via

OAuth 2.0 is the recommended method. However, this package supports both.

Note that if you do nothing the package will use the “demo” API token but this won’t give you access to your own Hubspot data. So you’ll need to spend a little time on setup:

If you have both saved an API key via hubspot_key_set() and a token via hubspot_token_create(), priority will be given to using the OAuth 2.0 token. If you don’t want that, explicitely pass NULL as value for the token_path argument of all functions.

Find more details on each method in the vignette about authorization.

Contributions welcome!

Wanna report a bug or suggest a feature? Great stuff! For more information on how to contribute check out our contributing guide.

Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms.