All i get is a list of âappidâ and a list of âplaytime_foreverâ but the two values, despite being in an array, have no correlation it seems. So i canât figure out if âappidâ: 654310 has âplaytime_foreverâ > 200 for example. I canât display the âplaytime_foreverâ for any specific âappidâ because they are not linked in any way.
Is there any way to have the data above be parsed into the database so i can actually use it?
Some people seems to suggest the use of google sheets or charts but i can only see payed plugin in the store for this. I mean i should not have to use a payed plugin just to properly use the data of APIs -_-
EDIT
the editor is set to public, really any help is appreciated am totally stuck with this database problem
It is inexplicable why Bubble does not properly handle arrays and subarrays from the API Connector. I keep trying to explain this, but they seem to not understand⌠or something.
Can you share a screenshot of the API connector where it shows it is parsing the result?
I havenât tried your example yet, but Iâve seen similar before, it should return a structure with games as a list of objects, that you can do something like:
responseâs games :filtered (playtime_forever > 0)
And then get the individual field values
responseâs games :filtered 's :first item 's appid
The whole result should be storable in the database if you create a data typeâs field of type : (select the API result as a type).
well i think am done with this bubble stuff
it just doesnât make any sense to me
like really, itâs easier for me to learn all these coding languages than to figure out what bubble wants from me, disgusting, sry my tone but am really pissed since i worked hours on end on this to fix it and tried so many different approaches.
I even tried the dexi.io app because i have the steamIDs and hours played on our forum saved in our mysql
so i can parse the data from that mysql to get a specific set of appids/games only from this list: http://united4games.com/most_played_steam_games/test.html
but i have the same problem again, i donât know how to get the data into the bubble database correctly and this is what i could come up with: https://i.imgur.com/WESABv0.png
i just need rows i can work with am going crazy because everything is there but i just canât figure it out.
So yeah, your help is much appreciated you give me hope that itâs still possible and that itâs just me being stupid, i really hope i am because then it would be a problem that could be solved after all
Very close there, the error does give a clue ⌠Youâve defined the field as a response game, so it would only accept one item of the response games list.
If instead, in the field definition you tick the âlistâ checkbox, it will accept the whole list.
You can also send the list to a repeating group, and inside each cell you can reference a gameâs appid, playtime_forever, playtime_2weeks.
Edit - a huge drawback of this approach is that the structure is frozen, to accept new fields in the games list objects requires re-initializing the API call, which then gives a new definition which can be saved in the database - Iâm unsure if it automatically updates it, hopefully it does.
Thatâs why Iâm a fan of keeping it as a JSON text.
What youâre seeing could be a list of texts displayed with commas, or a text with commas, you might find out more if you try to edit the row and the possible list field.
Not sure what you mean with âThatâs why Iâm a fan of keeping it as a JSON text.â because basically thatâs what am trying, since in JSON they are all in an array, so i thought i could do the same with rows, so one row is one array and is correlated to each other.
i already send the list to a group but that does not let me work with it, itâs just a huge list of all games and playhours that is nice to look at but i canât filter it properly.
On the API Connector, if you choose the return type to be âTextâ instead of JSON, Bubble doesnât do the parsing, doesnât setup those funky list structures, and you get the body as text, with the contents of the text in whatever form was sent.
This is often more useful if you are sending it back to another API, using it in Javascript, etc. The drawback is, Bubble doesnât have any JSON functions and it makes it harder to search/filter etc. But all this can be done on server or client scripts anyway.
Please tell me am missing something
shouldnât is just work, i get no errors, everything seems to work but it will have no data but only commas in the database
well i really donât understand this, i canât even get the repeating groups data i already see into the database
it just makes no sense to me, please someone help, there must be anyone that just knows whats going on i mean it canât be like this now, it seems so strange i canât believe it
Try using the API as a data source for the database, and the RG as a view element for either the database or the API.
On your RG data source you have a search for StreamDatas, but do you want to show a bunch of results, each one containing a list of game data, or the list of game data for a single StreamData?
You might need a nested repeating group ⌠Iâm a bit confused about your data structures now, the names seem to alter in every post
yeah because i try all kinds of things, right now :D:
login with steam on our forum > database mySQL > parsing only the game i need > pulling it into a website > extracting the data from the website with dex.io > accessing the parsed data from dex in bubble via their API > making a webhook on zapier and parsing the data there into rows > adding the rows into a google sheet via zapier: https://docs.google.com/spreadsheets/d/1JHs74jc_i_Q3mqw72Euzw8VAWjQ_2fvFSarPKyez74g/edit?usp=sharing
itâs crazy what i came up with i know, am just testing all kinds of approaches and this one is by far the most outrageous
edit. and yeah the API i can parse into the sheets and i get a nice list, but i canât seem to parse this nice list as i see it into the bubble database, that is where i got stuck.
So when i could figure out how to get the data i have in the nice RG into the bubble database as rows, i would not need anything else pretty much to get unstuck here
The button creates a new database row from the API result.
The first RG shows the API result.
The second RG shows each StreamData row.
The second RG shows the last saved API result in the database.
There was a problem with viewing the data, caused by privacy rules :
I hope that gets you over the hurdle and back on the track!
Edit - on your index page, the first RG data source is each StreamData row, which means each cellâs execution result is a list, but you are showing the fields as if it is one item.
It would make more sense to show the execution result list in its own RG, this can be done with selecting a single item of StreamData, or by nesting the RG in a StreamData RG.
https://codeless.pro/jobs/help-me-get-unstuck397
you give me hope that itâs still possible and that itâs just me being stupid, i really hope i am because then it would be a problem that could be solved after all 
