downloading reports in view using codeSOLVE
Aug 26, 2020 10:06 AM
I am able to download this report which is shown in the image by clicking on "Table actions" and then "Export view". I want to download the same report using some code in a csv or excel format because I need to perform some operations to that data and I want to refresh my data on a daily/weekly basis. So, I cannot go to hubspot link again and again and download the report manually. Thanks in advance for the help.
Solved! Go to Solution.
Aug 29, 2020 3:45 AM
Hello. Below is the process I would take to achieve what you are trying to do.
1. open up your existing .csv file in a code editor and take note of the formatting with commas.
2. Next use the HubSpot contacts API to pull your contacts with the properties you need https://developers.hubspot.com/docs/api/crm/contacts
3. format that output to match the csv template you exported in step 1
Additional resources if you are new the using the API
Located in Michigan, USA
Strategic marketing consultant and skilled web designer specializing in the manufacturing industry to increase revenue through driving website leads and brand awareness.