REST connector - reading the results ([col_1] from CSV_source)

[morenoju]

Hi all,

I'm loading data iny dashboard using a REST connector with response type CSV. All the data is in a column as you can see in the screenshot.

I'm creating some variables in the load script using:

LET line1 = peek('col_1',0,'CSV_source');
LET line2 = peek('col_1',1,'CSV_source');
etc.

That way I can then use line1, line2, etc. in Text components in the dashboard.

Is using variables the way to proceed? How would you access the data from the response and use it in a dashboard? Curious about how other members of the community do this.

Thanks,

Juan