Searching JSON Data in Columns Without AI: A How-To Guide

·

Is there any way to search a column’s JSON easily, without using the AI function? I tried exporting but it doesn’t export the data in the expanded cell, only what’s in the cell itself. Use-case:

I have all of the hiring data and I want to search for specific roles, how can I do this in this list enriched by PredictLeads?

3 comments

Clay
APP
·
·
Yes, you can search JSON data without AI. Click on the cell containing your PredictLeads hiring data to open the Cell Details panel, then use the search bar to filter for specific roles or keywords. For more advanced filtering of JSON objects by specific fields, you can use the Extract Values from Data action or formulas to search within the data structure. You can also take action on the list by hovering to the right of it in Cell Details and selecting Filter or find keywords to search for specific items using formulas.
Sources: Manage cell data | Documentation | Clay University Manage cell data | Documentation | Clay University
Muhammad S.
·
·
use formula
Clay
APP
·
·
To use formulas in Clay: 1. Add a new column and select Formula 2. Type your instructions in the AI Formula Generator box - use "/" to reference columns 3. Click Generate Formula - AI will create the appropriate code 4. Review the sample output and click Save Formula For your hiring data search, you can create formulas to extract specific roles or filter JSON data based on your criteria.
Sources: Formulas Formula generator | Documentation | Clay University Formula generator | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University