I am busy with an app in Thunkable X that gets data from google sheets. I parse a URL link to the Web_Api which is a csv export from Google sheets, this is how the URL look,
When i get the data from the URL it stores the data as a string seperated by “,”. And i keep getting a string back like this,
But I would like to read the data in as an Array with rows and columns, not just a row as currently. My goal is to get the email for a specific Username. I used the “Make list from text” function and seperate with “,” but it then creates a list with all the cells separately and i find it difficult to get the email for a specified username.
This is what i currently have with my blocks, but what can i add to in order to load all the data as an array as i can see it in Google sheets and loop through the records and columns,
In classic Thnkable you can use something like this but not in Thunkable x