Clay Icon
  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫢 Don't worry, only admins will be able to open your table πŸ˜‰

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey JP! Will take a look and see if this can be mapped out!

  • Avatar of John P.
    John P.
    Β·
    Β·

    Thanks Arturo! Hope you like a challenge, looks like a tricky one!

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Yup! It looks like it only returns a list after running a search, right? Not sure if our extension can or has the capability to expand each record.Any specific certification to test it out on?

  • Avatar of John P.
    John P.
    Β·
    Β·

    Cyber Essentials please

  • Avatar of John P.
    John P.
    Β·
    Β·

    Hi Arturo O. , what do you think - is this achievable, if not with Clay extension, some other technique?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Sorry for the delay, JP. Will try to dig a bit deeper to see if it allows us to map out a recipe and update you on it tomorrow!

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Also, it looks like it asks for a very specific query, if there are more than 30 or so results it doesn't display them and says to make it more specific. Any ideas on how much more specific it has to be or what that query would look like?

  • Avatar of John P.
    John P.
    Β·
    Β·

    Thanks - yes it needs at least 3 characters to initiate the search, then capped at about 30 results. We don't really know what the queries would like until we know what's in the database, so it's a bit of chicken and egg.

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Β­@John Phillips, I was able to map out a recipe after a bit but it's very limited. It's unable to catch the expandable list as separate columns but it can apparently store it all in one cell. Couldn't test out with other words because didn't know how to narrow it down to about 30 results only, but was able to create this one by searching for "commerce"

  • Avatar of John P.
    John P.
    Β·
    Β·

    Thanks Arturo! I think you've done all that could be done πŸ™‚ It's a tricky one for sure, they aren't keen on being scraped.