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.