Ricerca nei Documenti JSON
Cerca ed estrai dati da file JSON nei tuoi flussi utilizzando ricerche testuali o basate su query con il componente Ricerca nei Documenti JSON.
Descrizione del componente
Come funziona il componente Ricerca nei Documenti JSON
The JSON Document Search component is a versatile tool designed to search and extract information from JSON documents within your AI workflow. It supports both traditional text-based searches and advanced pandas query expressions, enabling efficient querying of structured data stored in JSON format.
What Does This Component Do?
This component enables users to:
- Search through JSON documents, whether sourced from internal repositories or external URLs.
- Specify search criteria, such as case sensitivity, target columns, and result limits.
- Integrate search operations directly into AI process workflows, facilitating data-driven automation and analysis.
It is especially useful when you need to filter, query, or locate specific data points within complex JSON structures, making it a valuable asset in data preprocessing, validation, and information retrieval tasks.
Inputs
There is no input handle for this component.
Output
- Tool: The output of this component is a search tool that can be utilized by agents or in downstream workflow steps to retrieve relevant JSON data as per the configured search parameters.
Settings
| Option | Description | Default/Example |
|---|---|---|
| Cache TTL | Determines how long to cache the JSON file content. Options range from “No cache” to “1 year”. | 2 weeks |
| Case Sensitive | Whether the search distinguishes between uppercase and lowercase characters. | False |
| JSON Array Key | Specifies the key holding the array of objects to search. Leave empty if the root is already array. | (empty) |
| JSON Document ID | ID of the internal JSON document to use (if applicable). | (empty) |
| JSON File URL | URL to an external JSON file, used if not selecting from internal documents. | (empty) |
| Max Results | Maximum number of search results to return. | 5000 |
| Search Columns | Comma-separated list of columns to search in. Searches all columns if left empty. | (empty) |
| Tool Name | Custom name for this tool, for easier reference. | (empty) |
| Tool Description | Description to help agents or users understand the tool’s purpose. | (empty) |
| Verbose | Enables verbose output for debugging or detailed logs. | False |
How to Use This Component
- Select Source: Choose to load the JSON document from an internal source (via Document ID) or from an external URL.
- Configure Search: Define if the search is case sensitive, and specify columns if needed.
- Set Result Limit: Adjust the maximum number of results to fit your use case.
- Customize Tool: Optionally name and describe the tool for easier integration into agent workflows.
Why Use This Component?
- Automates Data Extraction: Quickly locate and extract relevant information from large or complex JSON files.
- Flexible Integration: Works with both internal and external JSON data sources.
- Customizable Search: Tailor searches with advanced options, such as limiting results, filtering columns, and controlling case sensitivity.
- Efficient Workflow: Caching reduces load times and redundant network requests for frequently accessed documents.
This component is ideal for any AI workflow requiring robust, flexible, and efficient access to structured JSON data, whether for analytics, data enrichment, or as part of a larger decision-making process.
Domande frequenti
- Cosa fa il componente Ricerca nei Documenti JSON?
Permette di cercare all'interno di file JSON utilizzando testo semplice o espressioni di query avanzate, facilitando l'estrazione di informazioni rilevanti da dati strutturati nei tuoi workflow.
- Posso utilizzare dati sia da fonti JSON interne che esterne?
Sì, puoi collegarti a documenti JSON interni oppure recuperare dati da URL esterni, rendendolo flessibile per varie fonti di dati.
- È possibile limitare il numero di risultati della ricerca?
Assolutamente. Puoi impostare il numero massimo di risultati da restituire, aiutandoti a controllare l'output e ottimizzare le prestazioni.
- Posso specificare in quali campi cercare?
Sì, puoi definire colonne o campi specifici su cui focalizzare la ricerca. Se lasci vuoto, la ricerca coprirà tutti i campi nei dati JSON.
- Supporta ricerche case sensitive?
Puoi scegliere se rendere le tue ricerche case sensitive o meno, dandoti flessibilità in base alle tue esigenze sui dati.
Prova Ricerca nei Documenti JSON
Integra i dati JSON nei tuoi workflow con il componente Ricerca nei Documenti JSON—cerca, filtra ed estrai informazioni facilmente.