How to get row data.

Vizualinx

1 month ago
How do I filter a list of items from an API to get the row that matches an id I have saved in a variable?
(What formula do I need?)
Armand

1 month ago
Here's how I do something like that. The ones with the blue mark are what you need.

The top one is a variable, but can just as easily be a list of items from an API call. In the Item node you select which of the columns you want to use the Equals node and what is View in my image will be whatever value you compare the Items column value too.

I hope that makes sense 🙂
In my case the output is several rows, but if you have a column with unique values, then the output should be one row.
@Armand
Here's how I do something like that. The ones with the blue mark are what you need.

The top one is a variable, but can just as easily be a list of items from an API call. In the Item node you select which of the columns you want to use the Equals node and what is View in my image will be whatever value you compare the Items column value too.

I hope that makes sense 🙂
Vizualinx

1 month ago
Thank you so much!
but it returns a bull, i want to get the row data. sounds more like i am missing something
Armand

1 month ago
can you share a screenshot?
@Armand
can you share a screenshot?
Vizualinx

1 month ago
it works now. i redid it and it worked. probably a bug.
Thanks!! 🙏🏻
@Vizualinx
it works now. i redid it and it worked. probably a bug.
Thanks!! 🙏🏻
Armand

1 month ago
Great!

Stop scrolling. Start building.