Database resource return data like this: { "date": [ "2023-04-08", "2023-04-09", "2023-04-10" ], "dl": [ "3", "8", "9" ], } How do I make them return data like this instead: [ {"date": "2023-04-08", "dl": "3"}, {"date": "2023-04-09", "dl": "8"}, {"date": "202…

Hey @erusev ! I wonder if the formatDataAsArray() method would also be helpful for you :slight_smile: https://docs.retool.com/reference/javascript-api-methods-array-object#formatdataasarray [image]

Making database resources return data as indexed arrays

💬 App Building

victoria April 25, 2023, 1:12pm 4

Hey @erusev! I wonder if the formatDataAsArray() method would also be helpful for you

https://docs.retool.com/reference/javascript-api-methods-array-object#formatdataasarray

1 Like

Topic		Replies	Views
Convert sql query output from JSON to indexed array 💬 Queries and Resources javascript , sql	5	3365	June 10, 2024
Formatting JSON API response into an array for table 💬 App Building table	7	5518	February 9, 2024
Cross DB on a single query 💬 Queries and Resources resource-connection , sql	5	2203	December 14, 2023
How do I transform an array into new columns for a table? 💬 Queries and Resources	8	1279	March 11, 2024
Postgres query returns object of arrays instead of array of objects 💬 Queries and Resources	2	2273	March 26, 2024

Making database resources return data as indexed arrays

Related topics