How to get all call engagements with customer/company included

Developer Support APIs & Integrations
1

TL;DR
I want a list of call engagements with the columns:
‘hs_call_body’:
‘hs_call_duration’:
‘hs_call_from_number’:
hs_createdate’:
‘hs_lastmodifieddate’
‘hs_object_id’:
‘hubspot_owner_id’
‘hubspot_user/company_id’
I currently run the following query:

url = "https://api.hubapi.com/crm/v3/objects/calls/"
querystring = {"properties":["hs_call_callee_object_type_id","hubspot_owner_id","hs_call_duration","hs_call_from_number","hs_call_body"],"archived":"false","limit":"50"}

r = requests.request("GET", url, headers=headers, params=querystring)

This does not give me any foreign key I can use to join this data with the data base I have.
I need to have either hubspot_user_id or hubspot_company_id in this list. I know you can get this by using the association endpoint, but that only returns 1 call engagement and I want all call engagements/all from last year.
Hope anyone can help,
Thanks!

2

Alright, so after playing around I found the answer.
This query will fix it:

url = "https://api.hubapi.com/crm/v3/objects/calls/"
querystring = {"properties":["hs_call_callee_object_type_id","hubspot_owner_id","hs_call_duration","hs_call_from_number","hs_call_body"],"associations":"company","archived":"false","limit":"50"}

r = requests.request("GET", url, headers=headers, params=querystring)