in this example (using @Jici 's editor, hope he does not mind ), we retrieve the data API as a list. but what if I want to manipulate the data of the NBA players list that I retrieve? E.g. I want the Players league standard → heightMeters, to be:
0 if heightMeters <=2
1 if heightMeters > 2
i.e. if I now have a text element with the dynamic expression “Current cell’s Get players league Standard’s heightMeters” it gives me either 0 or 1.
The conditions can be even more complex, e.g. depending on the value of another data field (e.g. if Players league standard → heightInches > 70 then heightMeters…)
hmm actually I want to modify for the database rather than for the display.
I.e. I want to assign points to a certain playerID based on its positionID and other characteristics. (e.g. if player is a defender (positionID = 1) and he scores a goal (goal_scored = 1) then he receives a certain amount of points.)
I could do this the other way where I store the API data in a database (see picture), and then I add the extra “points” columns, but, as you correctly explain here, this method is much slower and takes more space I guess in the backend.
So, if I want the API data in a table, so that I can later manipulate them, the only solution is to create a new database table that where each row is a API data?
But, sometimes this solution does not work, since, due to high volume of data, I get the “Operation timed out – app too busy” and the data practically fails to be transferred to the database. is there a workaround to this? @Jici