Parse JSON

This component helps you extract specific information from complex JSON data. It’s like using a magnifying glass to find exactly what you need within a large, structured dataset. You provide the data and tell it what to look for, and it returns only the relevant information.

Relationship with JQ

This component uses a powerful query language called JQ to filter and extract data from JSON. JQ allows you to precisely specify which parts of your JSON data you want to keep, making it easy to work with even the most complex datasets. You don’t need to know JQ to use this component, but understanding basic JQ syntax can help you create more efficient queries.

Inputs

• Input: This is the JSON data you want to process. It can be from various sources within Nappai. This field is required.
• JQ Query: This is where you specify what information to extract from the JSON data using JQ. This is a text field where you write a simple JQ query. This field is required. (See examples below).

Outputs

The component produces a list of the extracted data. This output is ready to be used by other components in your Nappai workflow, such as sending it to a spreadsheet, database, or another processing component.

Usage Example

Let’s say your “Input” contains this JSON data:

{
  "name": "Example Product",
  "description": "This is a great product!",
  "price": 99.99,
  "details": {
    "color": "blue",
    "size": "large"
  }
}
And your "JQ Query" is:

`.name, .price`

The output "Filtered Data" will be:

```json
[
  "Example Product",
  99.99
]
This shows that the component successfully extracted the "name" and "price" fields.  More complex JQ queries can extract nested data or perform other manipulations.

## Templates
This component is used in the `AI-Powered Property Description Optimizer` template.

## Related Components

* **Google Sheet Writer:** Use this to write the extracted JSON data to a Google Sheet.
* **Extract Data:** Extract specific keys from the filtered data.
* **Filter Data:** Further filter the extracted data based on specific criteria.
* **AI Filter:** Filter data using natural language queries.


## Tips and Best Practices
- **Test your JQ Query:** Before using it in your workflow, test your JQ query with your sample JSON data to ensure it extracts the correct information.  There are online JQ testers available to help with this.
- **Keep it simple:** Start with simple JQ queries and gradually increase complexity as needed.
- **Use online resources:** Many online resources provide examples and tutorials on JQ syntax.

## Security Considerations
No specific security considerations for this component beyond standard data handling practices within Nappai.  Ensure your input JSON data does not contain sensitive information that should not be exposed.