I am running into some trouble when using API Connector to query a database that contains baseball games by requesting games that have a user’s role, and in my case each user may have multiple roles stored as an array of comma separated values. (ex. [pitcher, left_fielder]). The repeating group inside of Bubble will not display any data if I “insert dynamic data” into the API call from the repeating group settings because the user’s role is an array with multiple values.
In other words, because “pitcher, left_fielder” is not a role, the repeating group shows nothing…whereas if “pitcher”, and “left_fielder” are separately called for the repeating group, it will display the desired data for each role. I need to display data for all existing roles. How can I “insert dynamic data” of an array from Bubble with mutliple values into API Connector to display ballgames that have open positions for EVERY role a user may have?
What I really need bubble to do, is something similar to PHP’s in_array() function. Is there anyway to achieve this without using blockspring?