Import Structured Data
Import JSON, CSV, or Excel datasets for structured queries.
With structured data you can import tabular or machine-readable datasets into Respeak - for example product catalogs, customer databases, or inventory lists. Your expert can then search through this data and use it to answer questions.
How to Get to the Structured Data Section
Open your expert, go to Settings > Knowledge, and click the Structured button.
Supported Formats
Respeak supports JSON (.json, multiple files can be uploaded at once), JSONL (.jsonl, one record per line), Excel (.xlsx, .xls), and CSV (.csv). The maximum file size is 100 MB per file; for multiple JSON files the combined limit is 500 MB.
Workflow: From File to Knowledge Base
Importing structured data involves several steps:
Upload a file
In the overview, click Add New Configuration and select one or more files. For JSON files, you can specify whether the data is stored directly as an array or nested inside a specific property - Respeak shows examples of both formats. Then click Analyze File.
Detect and map fields
After the analysis, Respeak displays the detected fields - the columns or properties in your data - each with its field name, detected data type, and sample values. You can now configure the fields: choose which field should serve as the Title, as the ID, as the Date, and as the Version. Also determine which fields should be searchable via semantic search (Embed Fields) and which should be available as filters (Filterable Fields).
Save the configuration
Click Create Configuration to save your settings. The configuration is activated automatically and can be used for imports right away.
Import Data
Once an active configuration exists, you can import data:
Start the import
Open the menu (three dots) for the desired configuration and select Import Data. Choose the files you want to import - the file format must match the configuration.
Set options and run
Optionally enable Skip Duplicate Records to avoid re-importing records that already exist. Click Start Import. After the import you will see a summary showing the number of successful and failed records.
Analytics and Statistics
For each configuration, analytics features are available: View Sample Data lets you preview the detected records. View Analytics shows the import history with details for each import, including success rate, processing time, and any errors.
Manage Configurations
In the overview you can see all your configurations along with their status, statistics, and last update date. You can search for configurations using the search bar, filter by status (Active, Inactive, Suggestion, etc.), sort by various criteria, toggle configurations on or off, adjust field mappings after the fact, or delete a configuration along with all associated data.