Below I'll explain the concept. It very well may be an obvious answer in general, though there are a couple specifics I want to make clear.
Some businesses have "Databases Warehouses" the store all records AND aggregate data for the purpose of creating enterprise-level reporting and metrics. Others may be smaller scale but using tools like Snowflake instead of the old-school methodology of storing data in CSV files on their local offline devices.
If I were to work with a business who is using 3 tools for business management, I'd like to pull data from those tools in to a single view in whatever structure those tools have the data, and then take the data to create some output.
Here's an example:
ABC Construction uses Stripe (payments), Close (CRM) and HelpScout (support). The goal would be to retrieve data from all 3 tools, including as many data points as they'll offer, so that I can build a single place to display ROI, Metrics, Goals, Volume, and Milestones as we define with ABC Construction.
Rather than try to query directly from those 3 tools, I'd much rather use Xano to store the data as records are created/updated, and pull from Xano to create the visual metrics (think Charts, tables, etc.)
The basic question is does Xano allow me to create a database that stores records based on whatever we receive inbound, without pre-determining the fields/structure? This could mean 3 or 50 fields from Stripe, for example. And then once we receive a few records, we can either modify what Stripe sends or simply choose to ignore 7 of the 50 fields.
If that is possible, is there some education on how to go about this with Xano?