I need to create a custom integration where we pass certain pieces of data from our 3rd party application into HubSpot. This will have two layers of data, 1 layer will be a few properties at the Company level in HubSpot (maybe just custom properties on the Company object -- external_account_id, Number of Portals, Number of Active Portals, etc.). Layer 2 is in a 1 to many relationship with the company, 1 company to many portals. These should be matching based on an external_account_id (also including a portal name, application_type, number of transactions, etc.) This does NOT need to be a public application, but I’m not sure if this type of integration is available via a private application in HubSpot. We need to push data periodically into HubSpot, but it will be for internal use. So it can be public if absolutely necessary, but does not need to be. I’ve included a mockup using HubSpot custom objects and properties to give a visual of what I’m trying to accomplish via scheduled api calls.
The left side properties are at the company level, key being the account id. When in a particular company in HubSpot, I should see the portals associated with it (potentially many) in the main part of the dashboard in tabular format. They are associated via account id. Even in my mock setup, I have manually added data for 3 portals, but only 2 show up that I had to manually associate to the company. They do not automatically populate based on the account_id. Any ideas on how to achieve this kind of “push integration” and AUTOMATICALLY associate them based on an account id would be greatly appreciated.



