There are names, trials A-C for those names, and 3 scores per trial.
I'm having trouble transforming this to come through as a table. When I try it comes through as a table with names as the columns and one row of nested objects for each name.
What I need in the end is Name as a column and highest score in any trial as one, but I could get there from any readable format.
Other solutions posted here have not helped. Does anyone know how this would work?
You can use a JS Transformer query type to write JS to manipulate your query data before passing it along to your table.
Tables accept either an array of objects or an object of arrays. Here's a quick example using your data to separate it into two columns.
const data = {{your_api_query.data}}
let final_data = [];
Object.keys(data).forEach(key => {
let new_obj = {}
new_obj['name'] = key
new_obj['high_score'] = data[key]
final_data.push(new_obj)
})
return final_data;
Note: I didn't write any logic to loop through the scores to find the highest one, but you can add that in! Let me know if you have any questions at all.
Hi An! That's definitely strange. If you click "Preview" on your transformer, do you see data? And if you click into the input field that you've highlighted in red, does it show an error message?
