Hey everyone,
I am trying to get data from the contacts table into a microsoft fabric lakehouse. I first created a public app with all the scopes it would need to access I got the credentials and successfully created a linked service in Azure Data Factory to hubspot. I then created a dataset for the contacts table, following which created a copy activty to copy all the data to my lakehouse table. I followed this documentation
https://learn.microsoft.com/en-us/azure/data-factory/connector-hubspot?tabs=data-factory
I am only getting the firstname, lastname and emails. All of the other columns are null. Quite a few are missing as well, despite being present in the mapping. How do I get the complete data?