# Update db data with API **URL:** \ **Category:** Database\ **Created:** [October 15, 2020, 1:26am UTC](https://forum.bubble.io/t/update-db-data-with-api/116270 "2020-10-15T01:26:04Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![JTF](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jtf/32/74300_2.png) [@JTF](https://forum.bubble.io/u/JTF)\ **Post date:** [October 15, 2020, 1:26am UTC](https://forum.bubble.io/t/update-db-data-with-api/116270/1 "2020-10-15T01:26:04Z")
Hello - looking for some help with an API/db question. I’ve tried and tried to figure this out; I’ve scoured the Forum and found related posts (below) but none had replies. I’ve Googled, YouTubed, NuCode, and more. Any input would be awesome. I have an API for sports games that has nested values for the games. The data in the API updates two different ways: 1. Each game has a game number, the first game listed is game 0, then game 1, etc. After game 0 concludes, game 1 becomes game 0 in the data, game 2 becomes game 1, etc. 2. Data about a specific game updates throughout the week; for instance game 0 might have a point spread of 5 today, but tomorrow it’ll be 6. Once a game is over, it’s gone from the API too Here is a snapshot of the json ![07766BFD-667D-42EE-ABFD-41EE33DD1BD6_1_201_a](https://us1.discourse-cdn.com/bubble/original/3X/4/7/47a5474300cf288e05f20e44579eb4d05faba802.jpeg) I can get the first run into the database for the games. When I run it again afterwards, it just makes duplicate entries. I need a way to run (several) times and have it look up the game by like the gameUID, and then just change certain fields, or something similar. Any help/tips would be so appreciated. JTF > [@Update data in bubble database from api](http://forum.bubble.io/t/update-data-in-bubble-database-from-api/34322): > > I currently have an api workflow that takes the output of an api and writes a record to the bubble database for each symbol (key) that it finds… No problem… I want to run this same api periodically but instead of adding again the record that is already there, I want it to just update certain information for that symbol record… How do I do this? The api returns 200 “records/symbols” which can change… if it comes across the same symbol I want to just update some fields on that record; but if it co… ---
**Author:** ![tayloryouno](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@tayloryouno](https://forum.bubble.io/u/tayloryouno)\ **Post date:** [October 31, 2020, 2:49am UTC](https://forum.bubble.io/t/update-db-data-with-api/116270/2 "2020-10-31T02:49:52Z")
Seconded… I need this functionality too I’ll keep looking into it, but What’s up with the silence on this topic? Is it not possible with bubble, or are we overlooking something obvious? ---
**Author:** ![JTF](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jtf/32/74300_2.png) [@JTF](https://forum.bubble.io/u/JTF)\ **Post date:** [October 31, 2020, 12:40pm UTC](https://forum.bubble.io/t/update-db-data-with-api/116270/3 "2020-10-31T12:40:37Z")
I gave up on that api and am using a different, significantly more expensive, api now Would love to know and be able to switch back if it’s figured out ---
**Author:** ![tayloryouno](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@tayloryouno](https://forum.bubble.io/u/tayloryouno)\ **Post date:** [November 1, 2020, 2:09pm UTC](https://forum.bubble.io/t/update-db-data-with-api/116270/4 "2020-11-01T14:09:10Z")
i’ll be working on it for my project… i’ll try to check back in if i get things running ✔