The Extract JSON Key feature allows users to extract specific values from JSON-formatted data stored in a dataset of JSON data type column. By specifying the key (header) of the JSON data, the system retrieves and populates a new column with the corresponding values.

​
1. Select a Dataset

Before configuring retrieval, ensure you have selected a dataset. If no dataset is available, follow the steps to Add Dataset on the Future AGI platform.

​
2. Accessing the JSON Extraction Interface

To configure JSON key extraction, navigate to your dataset and click the + Add Columns button in the top-right menu. Scroll down to the Dynamic Columns section and select Extract JSON Key to open the setup panel.

​
3. Configuring JSON Key Extraction

  • Name: Assign a meaningful name to the new column where the extracted data will be stored.

  • Column: Select the dataset column of JSON data type that contains structured key-value pairs.

  • Enter JSON Path: Provide the exact key (header) name from the JSON structure. The system will retrieve the corresponding value from each row and populate it in the new column.

    • Example JSON for one of the row of JSON datatype column:

      {
  "name": "John Doe",
  "age": 30,
  "city": "New York"
}

    • If the user enters "age" as the JSON key, the new column will extract and display the value from each row containing similar JSON data.

  • Concurrency: Define how many rows should be processed simultaneously.

After configuring the settings, click Test to preview the extracted values. If the results appear accurate, click Create New Column to finalise the extraction. The newly created column will dynamically update with values retrieved from the specified JSON key.

​
Best Practices for JSON Extraction

  • Ensure the selected column contains valid JSON data with consistent formatting.
  • Use precise key names as they appear in the JSON structure to avoid extraction errors.
  • Select concurrency settings based on dataset size to balance speed and performance.
Extracting EntitiesExecuting Custom Code