Objective: Create an API endpoint that aggregates transaction data to calculate the total spending for each customer and also enriches the response with additional details, including the customer's name, email, zip code, and spending category. Ensure that the data is sorted by transaction amount in descending order and formatted as in the example in the image above.
Note: Make sure to upload the CSV files provided and set up your tables as described in challenge #6. Completing challenges #7 and #8 are also required to complete this challenge.
Expected Result: An array of objects formatted like the example provided in the image above, where each object displays the customer ID, transaction amount, the customer's name, email, zip code, and spending category.
Install the snippet to get started: https://www.xano.com/snippet/XwN5GThxchallenge_id: 9