--- title: How to view HubSpot engagement information in an APEX application description: Configure and utilise RESTful web services and utilise reporting tools in APEX to produce reports that can't be generated in the original solution. image: https://content.dsp.co.uk/hubfs/APEX%20Engagment%20Table.png --- [![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk) [![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk) - Services - Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - Managed Services - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services) - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services) - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services) - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services) - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services) - Licensing and SAM - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services) - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam) - Application Services - [Application Development](https://www.dsp.co.uk/software-development) - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation) - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex) - [Application Extensions](https://www.dsp.co.uk/software-customisation) - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution) - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services) - [Development Training](https://www.dsp.co.uk/oracle-apex-training) - Data Science - [AI Strategy](https://www.dsp.co.uk/ai-strategy) - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai) - [Agentic AI](https://www.dsp.co.uk/agentic-ai) - [Data Management for AI](https://www.dsp.co.uk/data-management) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning) - Cloud Migration and Management - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment) - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation) - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration) - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services) - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management) - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure) - Integration and APIs - [API Management](https://www.dsp.co.uk/api-development-services) - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services) - Disaster Recovery and Security - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions) - [Security Compliance](https://www.dsp.co.uk/data-security) - [Cloud Security](https://www.dsp.co.uk/cloud-security)   ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg) #### Getting to know us - [About us](https://www.dsp.co.uk/about) - [What we do](https://www.dsp.co.uk/what-we-do) - [Leadership](https://www.dsp.co.uk/dsp-product-leads) - [Careers](https://www.dsp.co.uk/careers) - Technologies - Oracle Cloud Infrastructure - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services) - [IaaS](https://www.dsp.co.uk/iaas) - [PaaS](https://www.dsp.co.uk/paas-security) - Oracle Database - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting) - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services) - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - Oracle Engineered Systems - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy) - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance) - Oracle Applications - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services) - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services) - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services) - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services) - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services) - Microsoft - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - Google - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner) - Multicloud and Database Hyperscaler - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner) - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning) - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws) - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud) - Open Source Database - [PostgreSQL](https://www.dsp.co.uk/postgresql-services) - [MySQL](https://www.dsp.co.uk/mysql-services) - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql) #### Managed Services - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services) - [MySQL](https://www.dsp.co.uk/mysql-support) #### Application Services - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - [Microsoft](https://www.dsp.co.uk/microsoft-partnership) - [ISV Services](https://www.dsp.co.uk/isv-support-and-services) #### Cloud Services - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database) - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud) #### Data Science - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services) - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services) - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations) #### Technology Solutions - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner) - [Data Security](https://www.dsp.co.uk/data-security) - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery) - Industries - [Finance](https://www.dsp.co.uk/finance) - [Healthcare](https://www.dsp.co.uk/healthcare-it-services) - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport) - [Higher Education](https://www.dsp.co.uk/higher-education) - [Public Sector](https://www.dsp.co.uk/public-sector) - [Manufacturing](https://www.dsp.co.uk/manufacturing) - [Retail](https://www.dsp.co.uk/retail) - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services) ### Recent case study: #### Oracle EBS Cloud Deployment Consolidating and Migrating assets into Oracle Cloud Infrastructure. [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)   #### Most Visited Pages - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing) - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/) - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration) - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services) - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### - - [SQL Server Support](https://www.dsp.co.uk/sql-server-support) - [Oracle Support](https://www.dsp.co.uk/oracle-support) - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy) - [New Application Development](https://www.dsp.co.uk/oracle-apex-services) - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop) - Resources - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download) - [ISG](https://www.dsp.co.uk/isg-oracle-report) - [Blogs](https://www.dsp.co.uk/blogs) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - [Events](https://www.dsp.co.uk/events) - [Webinars](https://www.dsp.co.uk/webinars) - [Insights](https://www.dsp.co.uk/insights) - [Technical Resources](https://www.dsp.co.uk/technical-resources) ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.   [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305) #### Resources - [Blogs](https://www.dsp.co.uk/blogs) - [Webinars](https://www.dsp.co.uk/webinars) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - About - [About DSP](https://www.dsp.co.uk/about) - [What We Do](https://www.dsp.co.uk/what-we-do) - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board) - [Careers](https://www.dsp.co.uk/careers) - [Project Harar](https://www.dsp.co.uk/project-harar) - [Customer Area](https://www.dsp.co.uk/contact-us) - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/) - [Customer Resources](https://www.dsp.co.uk/welcome) - [Contact us](https://www.dsp.co.uk/contact-us) # How to view HubSpot engagement information in an APEX application [ Paul Jones ](https://content.dsp.co.uk/author/paul-jones) 23-Aug-2021 09:46:00 ### Contents [13-Oct-2014 22:15:27 Trigger Dynamic Action from JavaScript ](https://content.dsp.co.uk/trigger-dynamic-action-javascript) [18-Aug-2022 09:12:25 How to get the most out of APEX Advisor ](https://content.dsp.co.uk/how-to-get-the-most-out-of-apex-advisor) [21-Dec-2017 10:07:04 Options For Loading Excel Data Into APEX Applications ](https://content.dsp.co.uk/options-loading-excel-data-apex-applications) This is a relatively short blog to remind everyone how easy it is to configure and utilise RESTful web services provided by other (SaaS) systems. They allow you to get the data from them into your Oracle Database, then utilise the power of the out-of-the-box reporting tools in APEX to add value and produce reports with information that it may not be possible to generate in the original solution. We were recently engaged by an organisation whose primary CRM solution is [HubSpot](https://www.hubspot.com/). HubSpot is a very powerful marketing software which can monitor and track engagement and sales with clients and customers. The organisation already used Oracle Cloud and had an [Oracle Autonomous Database](https://www.oracle.com/uk/autonomous-database/) ([APEX Development service workload type](https://content.dsp.co.uk/apex/oracle-heralds-a-new-dawn-for-apex)). Therefore, the infrastructure was already in place to host the application and managing the environment would be quick and easy going forward. They had started to build APEX applications to quickly replace existing spreadsheets and other processes at the organisation. --- Find out how we can help you build solutions using Oracle APEX, with our award winning [application development and consultancy services](https://www.dsp.co.uk/oracle-apex-services). [![Book a meeting with an Oracle APEX expert](https://no-cache.hubspot.com/cta/default/3321273/5db1aa70-8710-434d-9e0b-6b1c26541a0c.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/5db1aa70-8710-434d-9e0b-6b1c26541a0c) --- They also needed to create a report in HubSpot which told them how often they’d engaged with different companies over X timeframe, broken down by engagement type. They had already tried building this report directly in HubSpot but it hadn’t quite met their expectations. HubSpot has an API (see [here](https://legacydocs.hubspot.com/docs/overview) for a link to the documentation for the one utilised). *Note:* At the time of writing HubSpot’s APIs are in the [midst of transition](https://developers.hubspot.com/blog/building-the-next-generation-of-hubspots-apis?_ga=2.66500009.6034034.1628513203-1716049457.1625671313) from v2 to v3. For this reason and because it remains stable and fully supported, and in order to complete the project as quickly as possible, we utilised v2 of the API. The team also have experience of a previous integration on v2. Also, for this initial exercise and Proof-of-Concept we utilised an [API Key](https://knowledge.hubspot.com/integrations/how-do-i-get-my-hubspot-api-key) for authentication. For security it is better to use OAuth/[OAuth2](https://legacydocs.hubspot.com/docs/methods/oauth2/oauth2-overview). As with any integration with a web service to retrieve data, we’ve found that the best place to start is by using a standard REST client to become familiar with the calls and to confirm that it is working as we expect it to. The best option for this is [Postman](https://www.postman.com/) which allows you to save and build collections of the different calls and test them: [![APEX Engagement Table](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20Engagment%20Table.png?width=1506&name=APEX%20Engagment%20Table.png)](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20Engagment%20Table.png?width=2259&name=APEX%20Engagment%20Table.png) As mentioned at the beginning, the information we were trying to gather was ‘number of engagements per organisation’. To find this information using this API requires the following calls: - [Get All Companies](https://legacydocs.hubspot.com/docs/methods/companies/get-all-companies?zorseWidget) (To get the full list of companies). Note: to get additional properties returned you need to add ‘&properties=*property name*’ query params. - [Get Associations for a CRM object](https://legacydocs.hubspot.com/docs/methods/crm-associations/get-associations?zorseWidget) (To get all the associated engagement IDs for a company) Note: the ObjectID required is 7 for the ‘company to engagement’ join. - [Get an Engagement](https://legacydocs.hubspot.com/docs/methods/engagements/get_engagement?zorseWidget) (To get the details of the engagement, e.g. it’s type) There used to be a [Get Associated Engagements](https://legacydocs.hubspot.com/docs/methods/engagements/get_associated_engagements?zorseWidget) API which returned the details of all engagements for an organisation. This would have meant just two API calls, however this endpoint has been deprecated. Once you have established and tested the calls you need to retrieve the data. To do this the next decision is how you are going to get this data in your APEX application in order to then report on it. You have two options: - Connect and configure them declaratively in the APEX builder using REST Data Sources (formerly called Web Source Modules). - Write a PL/SQL package which utilises calls to [APEX_WEB_SERVICE](https://docs.oracle.com/en/database/oracle/application-express/21.1/aeapi/APEX_WEB_SERVICE.html) to retrieve the data and then use the [APEX_JSON](https://docs.oracle.com/en/database/oracle/application-express/21.1/aeapi/APEX_JSON.html) API to parse the results. Which approach you take will depend mainly on factors such as which version of APEX you are using, how nested the data is within the API calls (i.e. how many layers you will have to go through), potential API call limits, where your previous experience/preference lies and the type of approach you want to take i.e. dynamic, up to date information or a more synchronised approach. On that last point of synchronisation, up until recently if you wanted the data synchronised to local tables, you would have been required to go down the PL/SQL route. However, synchronisation to local tables is now possible when configured as REST Data Sources. See [here](https://blogs.oracle.com/apex/synchronize-data-from-rest-services-to-local-table-with-no-code-at-all) for more information. With the three nested calls needed to retrieve the information required, wanting to reduce the number of API calls, prior experience and the information didn’t need to be up to date by the second. We decided in this instance to implement a PL/SQL package which would be called on a DB schedule once a day to refresh/update the information on which to report. The calls to the different web services using APEX_WEB_SERVICE were implemented in a package (you can click on the file below for an example of calling [Get All Companies](https://legacydocs.hubspot.com/docs/methods/companies/get-all-companies?zorseWidget), parsing the results and merging in to a local table). The procedure also deals with the manner of pagination of the results which HubSpot utilises. The only things you would have to add is to declare the base URL as g_base_url in the package specification, and either supply your API key to the procedure or update it to use OAUTH2. ``` PROCEDURE get_companies(p_api_key IN VARCHAR2) ISlc_data CLOB;lj_rows apex_json.t_values;ln_row_count PLS_INTEGER; lv_has_more VARCHAR2(5) := 'false';lv_offset NUMBER;ln_company_id company.id%type;lv_is_deleted company.deleted%type;lv_company_name company.company_name%type;lv_company_type company.company_type%type;lv_relationship company.relationship%type;lv_website company.website%type;lv_finance_ref company.finance_ref%type; BEGINLOOPif lv_has_more = 'false' thenlc_data := apex_web_service.make_rest_request(p_url => g_base_url || '/companies/v2/companies/paged?hapikey=' || p_api_key || '&properties=name&properties=organisation_type&properties= relationship&properties=website&properties=finance_ ref&limit=100',p_http_method => 'GET');else lc_data := apex_web_service.make_rest_request(p_url => g_base_url || '/companies/v2/companies/paged?hapikey=' || p_api_key || '&properties=name&properties=organisation_type&properties= relationship&properties=website&properties=finance_ ref&limit=100&offset=' || lv_offset,p_http_method => 'GET');end if;SELECT jt."has-more", jt.offsetINTO lv_has_more, lv_offsetFROM JSON_TABLE(TREAT ( lc_data AS JSON) , '$[*]' columns ("has-more" VARCHAR2(5),offset NUMBER)) jt;apex_json.parse(lj_rows,lc_data);ln_row_count := apex_json.get_count(p_path => 'companies',p_values => lj_rows);IF ln_row_count > 0 THENFOR x IN 1 .. ln_row_countLOOPln_company_id := apex_json.get_varchar2(p_path => 'companies[%d].companyId',p0 => x,p_values => lj_rows);lv_is_deleted := apex_json.get_varchar2(p_path => 'companies[%d].isDeleted',p0 => x,p_values => lj_rows);lv_company_name := apex_json.get_varchar2(p_path => 'companies[%d].properties.name.value',p0 => x,p_values => lj_rows);lv_company_type := apex_json.get_varchar2(p_path => 'companies[%d].properties.organisation_type.value',p0 => x,p_values => lj_rows);lv_relationship := apex_json.get_varchar2(p_path => 'companies[%d].properties.relationship.value',p0 => x,p_values => lj_rows);lv_website := apex_json.get_varchar2(p_path => 'companies[%d].properties.website.value',p0 => x,p_values => lj_rows);lv_finance_ref := apex_json.get_varchar2(p_path => 'companies[%d].properties.finance_ref.value',p0 => x,p_values => lj_rows);IF ln_company_id IS NOT NULL THENMERGE INTO company hUSING (SELECT ln_company_id company_id,lv_is_deleted deleted,lv_company_name company_name,lv_company_type company_type,lv_relationship relationship,lv_website website,lv_finance_ref finance_refFROM dual) dON (h.id = d.company_id)WHEN MATCHED THENUPDATESET h.company_name = d.company_name,h.company_type = d.company_type,h.relationship = d.relationship,h.website = d.website,h.deleted = d.deleted,h.finance_ref = d.finance_refWHEN NOT MATCHED THENINSERT(id,company_name,company_type,relationship,website,finance_ref,deleted)VALUES(d.company_id,d.company_name,d.company_type,d.relationship,d.website,d.finance_ref,d.deleted);END IF;END LOOP;END IF;EXIT WHEN lv_has_more = 'false';END LOOP;COMMIT;END get_companies; ``` Two very similar procedures were then built to call [Get Associations for a CRM object](https://legacydocs.hubspot.com/docs/methods/crm-associations/get-associations?zorseWidget) for every company we had already stored, to create our many-to-many join table. Then [Get an Engagement](https://legacydocs.hubspot.com/docs/methods/engagements/get_engagement?zorseWidget) was called for each engagement for which we did not already have the information and then inserted into an engagement table. The final step to get the report was to create an Interactive Report over the data and then utilise a [Pivot](https://docs.oracle.com/en/database/oracle/application-express/21.1/aeeug/managing-pivot-reports.html) function to format the data as required. We also added a couple of filters to the report which when changed, utilise a dynamic action to refresh the report for a particular time frame. [![APEX Engagement table](https://content.dsp.co.uk/hs-fs/hubfs/Engagement%20table.png?width=1645&name=Engagement%20table.png)](https://content.dsp.co.uk/hs-fs/hubfs/Engagement%20table.png?width=1645&name=Engagement%20table.png) And that’s it, we had our report which showed the required information. ### Summary With the recent enhancements to the declarative ways of integrating with APIs such as [Synchronisation](https://blogs.oracle.com/apex/synchronize-data-from-rest-services-to-local-table-with-no-code-at-all), the ability to [Synchronize Parent-Child REST Sources](https://blogs.oracle.com/apex/synchronize-parent-child-rest-sources) and also [APEX Automations](https://blogs.oracle.com/apex/automate-your-business-process-in-oracle-apex-202), we’re almost at the cross over phase between changing from utilising PL/SQL packages running on a schedule and doing everything for integrations more declaratively. Providing it’s feasible for the next integration we work on, we’ll be sure to use these and report back on any findings. Get integrating! --- **Need some help with your APEX applications? Speak to the experts today.** **[![Book a meeting with an Oracle APEX expert](https://no-cache.hubspot.com/cta/default/3321273/5db1aa70-8710-434d-9e0b-6b1c26541a0c.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/5db1aa70-8710-434d-9e0b-6b1c26541a0c)** --- **Author**: [Paul Jones](https://content.dsp.co.uk/apex/author/paul-jones) **Job Title**: Oracle APEX Development Consultant **Bio**: Paul is a Development Consultant at DSP-Explorer. Paul has a BSc in Computing from the University of Leeds and is now building on considerable experience in development and support using Oracle PL/SQL and Oracle E-Business Suite (EBS). Paul is employing APEX to provide quality, bespoke software solutions both internally and to a range of organisations. ---   [APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [Hubspot](https://content.dsp.co.uk/topic/hubspot) [13-Oct-2014 22:15:27 Trigger Dynamic Action from JavaScript ](https://content.dsp.co.uk/trigger-dynamic-action-javascript) [18-Aug-2022 09:12:25 How to get the most out of APEX Advisor ](https://content.dsp.co.uk/how-to-get-the-most-out-of-apex-advisor) [21-Dec-2017 10:07:04 Options For Loading Excel Data Into APEX Applications ](https://content.dsp.co.uk/options-loading-excel-data-apex-applications) [Previous 7 New Features of APEX 21.1 You Should Know About ](https://content.dsp.co.uk/7-new-features-of-apex-21.1-you-should-know-about) [Next Oracle Cloud Infrastructure Overview ](https://content.dsp.co.uk/oracle-cloud-infrastructure-overview) #### Contact Sales Enquiries [+44 (0) 203 880 1686](tel:+4420%2038801686) Technical Support +44 (0) 330 058 8367 [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk) #### Follow us #### Office Locations [**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D) [Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842) [**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) ** [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)** [Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) #### About Us DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies. ![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png) ![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png) ![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg) Registered Office: 30 City Road, London, EC1Y 2AB. Company Registration Number: 03898451 ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "dateModified" : "2024-10-01", "datePublished" : "2024-10-01", "headline" : "How to view HubSpot engagement information in an APEX application", "image" : [ "https://www.dsp.co.uk/hubfs/APEX%20Engagment%20Table.png" ], "mainEntityOfPage" : { "@id" : "https://content.dsp.co.uk/how-to-view-hubspot-engagement-information-in-an-apex-application", "@type" : "WebPage" } } ```