Sometimes you need to be able to format the response from your API endpoint in a specific way. Maybe you need to gather data from an external API and want to clean up the response to only include certain data points, or you want to rename the keys, or return an object instead of an array. Maybe you want to use a Lambda function so you can write JavaScript to manipulate your data. The possibilities are endless.

When getting started, it's helpful to visually parse the data that is originally returned, either from your own data, or from an external API. Watch this video to learn how to use Subpath to parse through the data visually:

The Output tab controls how the data is returned from the Query All Records function.

Customize:

Customize the fields included in the response of the function. By default all fields shown will be included. However, choose the customize response button to pick and choose which fields you'd like included. This is useful when you don't need all the fields but only a select few.

Addon:

Addons are a unique and powerful feature of Xano that are similar to Graph QL. They allow you to decorate the data of your primary table with data from other database tables.

For more information about Output options, see our full documentation at: https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/output-tab