Category: APIs


  • Hubspot Deals and Line Items in Power BI

    There is allegedly a Hubspot connector for Power BI however I have never got it to work. Even if it does I suspect it would not allow access to deal line items which are buried deep in the Hubspot API. Deal line items are when you create a Deal and add Products which may be…

  • Connecting to Google Maps API from an Excel function

    I have two postcodes in two columns in Excel. I want the distance between the two in a third column. There are a couple of approaches. One could try and get the longitude and latitude from the postcodes and then calculate an as-the-crow-flies distance mathematically. You could try pasting them into co-pilot and asking it…

  • Updating Hubspot from Power Automate

    The connector from Power Automate to Hubspot is not reliable in my experience. Fortunately Power Automate allows us to build a HTTP request from scratch. To do this you need a Hubspot API key. In Power Automate choose the HTTP step: This is how to set it up for a POST request to add a…

  • Using emails and Power Automate as a simple API

    Sometimes you might have a website or service without an API but which has some sort of emailing facility. For example, an online form that sends a standard email response. With Power Automate you can extract whatever data you wish from that email and do what you like with it (update a database for instance).…