#community-help

Importing JSON file into Database

TLDR andy needed information about adding a database to their search db using JSON files. Kishore Nallan explained that imported JSON files can have additional fields.

12mo

Join the chat

Dec 10, 2022 (12 months ago)

Photo of md5-8f2bc7de8159dde57045bf51154aed5b

andy

08:50 AM

i am looking to add another type of database to my search db today, does the json file i import need to match the schema exactly? if you see the 2 gotchas i wrote about, if the file has too many fields, it didnt work for me

Dec 12, 2022 (12 months ago)

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

02:10 AM

The json file imported must have all fields mentioned in the schema but can have additional fields which are simply stored and returned.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3005 threads (79% resolved)

Join Our Community

Similar Threads

Prioritizing JSONL Files in Imports by Adding a Ranking

andy sought advice on applying different importance levels for imported JSONL files. Kishore Nallan suggested ranking the files by creating a 'priority' field. andy implemented the advice successfully.

12mo

Handling Large JSON File for Typesense

Matt struggled with processing a large JSON file for Typesense. Kishore Nallan explained how to create a schema, convert to JSONL, and import the file. They also identified the necessary keys from the JSON.

8mo

Optimizing JSON Data Import and Search with PHP Library

Arumugam experienced slow search results and data import time with json and PHP library. Kishore Nallan advised trying import and provided guidance on integrating the function into a PHP application. The issue was resolved as the search results are now displayed faster.

24mo