Array To Inline

[Yasin_Hassanien]

Hi,

Does anyone succeed to convert an array resulting from an API column to the inline list component?

Thanks

[eltintero]

this?

Transpose Columns to an Inline List: The Miracle Method

Not sure if this is better, but if you have to set up columns for new items, wouldn’t it cost less columns to achieve this by the following method? I’m only using a screenshot of the table from your video to get the badges name for my example. [image] Use an If Then Else column, if Badges is Non-Smoker then you return the user’s Non-Smoker boolean, you continue that until Hydrates Regularly. Then you can still do an inline list and filter that by is true/is not true. Would it work?

[Yasin_Hassanien]

Nope that doesn’t do it

[gvalero]

Hola,

It’s more a trick than a procedure but worked for me.

Here you can see it A Google Sheet working as a REST API: good or bad idea? 💣

[Yasin_Hassanien]

I tried the method you did but it splits only the values but the inline list component can’t read it to show as a list

[gvalero]

Hola de nuevo,

Some screenshots will help a little.

Do you have your JSON paylod (API answer) converted to array? Something like this:

Step 1

Step 2

Step 3

Bye

[Yasin_Hassanien]

I successfully split the array and resulted to the last screenshot but the issue when I try to map it to an inline list its not working

[Yasin_Hassanien]

Have you successfully mapped into an inline list ?

[gvalero]

Have you successfully mapped into an inline list ?

Yes!

The next steps are:

Step 4
Put your new array in another table (where your Inline list will point out) using a Single Value column

Step 5

Create so many columns as parameters your API call has. In my case, I have 6 parameters. These columns must be Single Value type using your array column as main source (step 4) and its Row parameter must be pointing out some position (item) of your array.

If your JSON payload has the same schema/items always, that Row parameter can be a static number otherwise, you have to create some logic to retrieve the right array position and find the desired value (what I did).

I hope it helps you at least to know what to do.

Feliz noche!

[ThinhDinh]

As @gvalero pointed out, you can’t simply use an array resulting from a string in an inline list. You must have rows attached to each of them.

[Yasin_Hassanien]

So I will have it as a static row then map them via single column

Well it works this way but in this case we wouldn’t be able to create a dynamic row, am I getting it right?

[ThinhDinh]

As long as your API result is dynamic then it will be dynamic.

[Yasin_Hassanien]

I don’t thing you got my concern

I have to manually create an empty rows with numbers in order to connect them via single value

The issue is in this case I won’t be able to expand them since there is no function in glide can do that

Say I got a row limit in an empty sheet to view the array in which has 100 row

What if my array got a 110 resulted data ?

[ThinhDinh]

You’re right that the rows count is not dynamic and you have to pre-create that, as much as you can.

As I have explained above, you’re trying to create rows out of a JSON payload. Glide needs to have rows attached to each item in the JSON to have a details view for each of them. You can’t just have rows from an array out of the blue.