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 there Sean sorry for the delay taking a look.

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    I think these need to be added in the headers

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Quick question are you looking for emails too, since that column seems to be missing from your body input.

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    Yes looking for emails and phone numbers

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Alright that column seems to be missing from your json body input. Which email column are you using for the API.

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    No input email, only looking to get an output with emails

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Ah ok thank you for clarifying

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Hey Sean R. yep just took a look. There were a few formatting errors (Get instead of post request and some extra quotation marks). Additionally it does seem you need to add those additional headers (Just the first 2 and the last). I just created a duplicate of your HTTP API column for you to adjust, can you add the name and password then try running?

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    Thank you, I added the key name and password but still getting the errors

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Sean! took a quick look and looks like it failed to parse the body. I'll see if I can spot the issue

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    Thank you

  • Avatar of Sean R.
    Sean R.
    ·
    ·
  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Hey Sean R. looks to be working now! Had to re-enter the JSON body + Arturo made a formula column to combine city and state instead of doing it in the body

  • Avatar of Sean R.
    Sean R.
    ·
    ·

    Awesome, thank you!