Objective: Create an API endpoint that aggregates transaction data to compute and display the total spending per customer. Ensure that the data is sorted by customer ID in ascending order and presented as a structured array of objects in the image above, each detailing the customer's ID and their total transaction amount.
Note: Make sure to upload the CSV files provided and set up your tables as described in challenge #6. This is essential for everything else we'll be doing.
Expected Result: An array of objects formatted like the example provided on the image above, where each object displays the customer_id and the corresponding aggregate transaction amount.
Install the snippet to get started: https://www.xano.com/snippet/XwN5GThxchallenge_id: 7