I am going to use only some of the information that returns from an API call, and don't need the other.
The API call returns the name of several users (for example 10 users). However I do also get other information for each user (email, adress, etc.). I want only to store the names for all the users in a variable.
The information from the API call is return as an object, with
0 -> name, email, adress
1 -> name, email, adress
2 -> name, email, adress
3 -> name, email, adress
... and so on.
However, I only want the names to be stored in a variable (named userNames) as a string: name 0, name 1, name 2, name 3
Any ideas on what formulas I can use to get this? Or how I manage to just extract the names from the API call?