Discussions

 View Only
  • 1.  Automation to get data from a non-QuickBase API

    Posted 02-18-2020 19:02
    Can anyone help me understand how to create an automation (or other automated tool) to get data from an external (non-QuickBase) API on a schedule?

    For example, I would like to get daily weather data from the Dark Sky API. In order to use that API, you have to set up a free account to get your own API key. Once you have that, you can get daily weather data from that API using a URL that contains the date, lat/long and your API key as shown below (in this example it is for Feb 17, 2020, 11:00 AM at Boeing Field in Seattle) :

    https://api.darksky.net/forecast/your API key goes here/47.528340,-122.301837,2020-02-17T11:00:00?exclude=hourly,currently,monthly,flags,alerts

    Once per day, I would like my automation to create a new row in the Weather table of my app; make an API call to DarkSky for the previous calendar date; and fill in the new row in my Weather table with the date and the summary, temperatureHigh, temperatureLow and precipIntensity fields from the API call. 

    Any help appreciated!

    ------------------------------
    Robin Gold
    ------------------------------


  • 2.  RE: Automation to get data from a non-QuickBase API

    Posted 02-18-2020 21:07
    Robin,

    What you need is coming soon.  You have a short wait for Pipelines.   

    Alternatively you can do this with custom scripts, PHP or a similar language.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 3.  RE: Automation to get data from a non-QuickBase API

    Posted 02-19-2020 10:15
    Robin, if you're not on the QB Platform or Enterprise Plans, you may not get access to Pipelines (my understanding). If you don't want to write code, you can use external tools like Workato or Zapier to create your automation.

    ------------------------------
    Jonathan Heuer
    ------------------------------



  • 4.  RE: Automation to get data from a non-QuickBase API

    Posted 02-19-2020 10:35
    Robin, the short answer is that right today its not easy.  If you want to get a contact from me for some people who know how to do this, contact me off line and I can make a recommendation.  Hopefully Quick Base will improve Pipelines to dumb this down for the rest of us who are not coders and want to stay with native Quick Base.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Automation to get data from a non-QuickBase API

    Posted 02-19-2020 13:33
    Thank you all very much for the responses. Unfortunately we don't have any budget or authorization for additional third party applications or developers, so I will wait for pipelines to come out and hope that it will make these types of tasks straightforward.

    ------------------------------
    Robin Gold
    ------------------------------