# Saving External API Data to Bubble Database **URL:** \ **Category:** Tips\ **Created:** [December 12, 2015, 3:14pm UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799 "2015-12-12T15:14:09Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![bam](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@bam](https://forum.bubble.io/u/bam)\ **Post date:** [December 12, 2015, 3:14pm UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/1 "2015-12-12T15:14:09Z")
I posted this as a reply in another thread but think it will be found easier here. For all trying to save external API data to the Bubble database, as Bubble doesn’t have their actual API released yet. So I found a workaround for this that works great. What I did was create input boxes for each “thing” you want to pull from an external API. So if you’re trying to pull an address and a title, create two input boxes where each will have the external API data as “initial value”. Then you can create the workflow to “Thing”=“InputWhatever’sValue” You can disable the input on the input boxes and hide them. Now when you submit your form or action, it will pull from the external API, place it into the input box, and then save to your database. Easy fix for copying outside info into your Bubble database. ---
**Author:** ![macro101](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/macro101/32/306_2.png) [@macro101](https://forum.bubble.io/u/macro101)\ **Post date:** [December 13, 2015, 5:09pm UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/2 "2015-12-13T17:09:31Z")
Love it! Thanks @bam ---
**Author:** ![supernaturally](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/supernaturally/32/8307_2.png) [@supernaturally](https://forum.bubble.io/u/supernaturally)\ **Post date:** [September 2, 2016, 7:31am UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/3 "2016-09-02T07:31:20Z")
The issue I am having is that Bubble is storing all of the API database’s items into one single row inside of a “Thing” (the separated rows are now just separated by commas). In other words, the Bubble Thing has only one row: “APIcolumn1\_itema, APIcolumn1\_itemb, APIcolumn1\_itemb, etc.” The next column (or item) in Bubble’s Thing is “APIcolumn2\_itema, APIcolumn2\_itemb, APIcolumn2\_itemb, etc.” Hopefully this makes sense, and understand the problem I am having. I just need to replicate the table from the external database. ---
**Author:** ![patrick.gouraud](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/patrick.gouraud/32/9339_2.png) [@patrick.gouraud](https://forum.bubble.io/u/patrick.gouraud)\ **Post date:** [January 25, 2017, 7:39pm UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/4 "2017-01-25T19:39:30Z")
Hi @bam. I just tried this and i fear this method does not work anymore. Any suggestion to achieve the very same result now ? ---
**Author:** ![codefree](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/codefree/32/220802_2.png) [@codefree](https://forum.bubble.io/u/codefree)\ **Post date:** [January 14, 2019, 6:38pm UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/5 "2019-01-14T18:38:45Z")
It still works, like it should. thanks @bam ---
**Author:** ![lioktabriansyah](https://avatars.discourse-cdn.com/v4/letter/l/8e7dd6/32.png) [@lioktabriansyah](https://forum.bubble.io/u/lioktabriansyah)\ **Post date:** [July 7, 2022, 12:35am UTC](https://forum.bubble.io/t/saving-external-api-data-to-bubble-database/799/6 "2022-07-07T00:35:07Z")
Please help how to get the API updated every second without using “Do every seconds” I tried to use the workflow backend but it only runs once Example API : [https://data.gateapi.io/api2/1/ticker/btc\_usdt](https://data.gateapi.io/api2/1/ticker/btc_usdt)