Clay Icon

Filtering JSON Columns for Job Titles in Find Companies Table

ยท
ยท

Hi! When working with a JSON-like column (that includes multiple fields, for example up to 10 open jobs), what's the best way to filter one field within this column? Specifically, I'm working with a Find Companies table, and I want to filter it to companies hiring for a given position. I'm struggling to filter on "Title" within the "Find Open Jobs" column Table here https://app.clay.com/workspaces/195674/tables/t_MpVxUrcraPPA/views/gv_Kg3off7wMovb

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To filter for companies hiring specific positions, you can use the "Filter for Job Title" parameter when setting up your Find Open Jobs search. Simply enter the specific job titles you want to filter for, separated by commas (e.g., "Engineer, Marketing, Accountant").For more accurate results, it's recommended to:1. First select relevant departments 2. Then add your specific job title filters 3. Optionally, you can also filter by: โ€ข Days since posted โ€ข Location-specific jobs โ€ข Job description keywords Sources: Find Open Jobs with PredictLeads Find Active Job Openings with Companies, People, Jobs

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Laurent B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback Laurent B.!

  • Avatar of Arturo O.
    Arturo O.
    ยท
    ยท

    Hey Laurent, thanks for reaching out. Happy to help! There should be a way to filter using formulas, depending on what the goal is, you could ask it to check for certain words and return true/false, or return the words, url to the job post, etc. Feel free to share more if you have something specific in mind, and would like some additional eyes on setting that up. https://downloads.intercomcdn.com/i/o/w28k1kwz/1324950927/c42f727588ff757fde102fb0e029/chrome_IztsSWKgzF.png?expires=1736276400&signature=9ff5c28e8a6ae1f71342d944db95b77c56bb180f154eb8f0215b3b91edb7d730&req=dSMlEsB7nYhdXvMW1HO4zSO%2Bfrx8jOCdXXojmtjuKA12DW4tcoRYhIHRPzaK%0Altfp%0A

  • Avatar of Laurent B.
    Laurent B.
    ยท
    ยท

    thank you!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Laurent B.
    Laurent B.
    ยท
    ยท

    is there a good way of using claygents (argon) via API? I'd like to integrate it to a python script

  • Avatar of Arturo O.
    Arturo O.
    ยท
    ยท

    Hey Laurent! Thanks for reaching out with this inquiry. Curious about this and what this could look like, could you elaborate on how you were looking to integrate it to use a python script or were you referring to having the code written within the prompt so it would run the task accordingly? I've not seen this before, but would like to know more before if that's not it!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.