Clay Icon

Fixing invalid input syntax for type integer: NaN Error in Smartlead

·
·

Getting this error while trying to remove lead from campaign with smartlead even though i’m pushing the lead ID i pulled from the lookup lead in smartlead column - {“error”:“invalid input syntax for type integer: “NaN”“} how to fix this?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    It seems you're encountering an error when trying to remove a lead from a Smartlead campaign. To help resolve this, let's first ensure you're using the correct Lead ID. Here's what you can do: 1. Use the "Lookup Lead in Campaign" action first to get the correct Lead ID. 2. Make sure the Lead ID you're using is a valid integer, not "NaN" (Not a Number). 3. Double-check that you're inputting the Lead ID correctly in the "Remove Lead from Campaign" action. If you're still encountering the error, could you please copy and paste the full JSON response you're receiving? This will help us troubleshoot further.

  • Avatar of Kaushik K.
    Kaushik K.
    ·
    ·
    {"error":"invalid input syntax for type integer: "NaN""}

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The "NaN" error suggests the Lead ID isn't being recognized as a valid integer. To fix this: 1. Ensure you're using the correct Lead ID from the "Lookup Lead in Campaign" action. 2. Verify the Lead ID is a valid integer, not "NaN" or empty. 3. Double-check you're inputting the Lead ID correctly in the "Remove Lead from Campaign" action. If the issue persists, please copy and paste the full JSON response you're receiving so we can troubleshoot further.

  • Avatar of Kaushik K.
    Kaushik K.
    ·
    ·

    in the lookup output, it’s adding “Found” at the end of the email which is probably changing the lead id or campaign id to not being an integer

  • Avatar of Kaushik K.
    Kaushik K.
    ·
    ·

    how to fix this?

  • Avatar of Kaushik K.
    Kaushik K.
    ·
    ·

    talk to a person

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey - Do you mind sending the link (url) to the table so we can take a look?

    (52 kB)
    Image