How to link Notes with Companies

Hi,

I’ve exported all Notes (see table of fields below) but I can’t find how to link them to Companies or Deals. When looking in Deals or Company Exports, can’t seem to find the field that allows me to link. Can anyone help?

id
hs_all_accessible_team_ids
hs_all_assigned_business_unit_ids
hs_all_owner_ids
hs_all_team_ids
hs_at_mentioned_owner_ids
hs_attachment_ids
hs_body_preview
hs_createdate
hs_body_preview_html
hs_body_preview_is_truncated
hs_created_by
hs_created_by_user_id
hs_engagement_source
hs_engagement_source_id
hs_follow_up_action
hs_gdpr_deleted
hs_lastmodifieddate
hs_merged_object_ids
hs_modified_by
hs_note_body
hs_object_id
hs_product_name
hs_queue_membership_ids
hs_timestamp
hs_unique_creation_key
hs_unique_id
hs_updated_by_user_id
hs_user_ids_of_all_notification_followers
hs_user_ids_of_all_notification_unfollowers
hs_user_ids_of_all_owners
hubspot_owner_assigneddate
hubspot_owner_id
hubspot_team_id
createdAt
updatedAt
archived
hubspot_owner_name

Hey @BartVerschueren,

You can actually export this out in the custom report builder. Simply make a report with the “Sales Activites” and “Companies” objects selected. Add both recordIDs to your table and any other custom fields you want (up to 25). And then hit export!

Here’s what the exported CSV looks like:

Hope this helps!

Wholy cow thanks a million Chris!