Skip to main content
Importing, exporting, and converting data has always been a necessary function of client applications. Standard moves this to the backend as it has direct access to the data. These same simple queries can run as the API for your app or Standard code by returning results as JSON, XML, and CSV.

​
Importing from Disk

The import query can import records into a Standard provided the file location. This query supports auto-uploading from JSON, XML, and CSV files:
Standard automatically detects the file format from the file extension. Make sure your file’s column headers or JSON keys match the constraint names defined in your Standard.

​
Exporting to Disk

Export records from any Standard table to a file on disk using the >> operator:
For example, export all vehicle records to a CSV file:
You can combine export queries with filter conditions to export only a subset of records — for example, exporting only Honda vehicles or records modified after a certain date.