Clay Icon

How to Stop Integration When Previous Column Throws Error

ยท
ยท

whats the best way to stop the following integration if the previous column throws an error?

  • Avatar of Stefan R.
    Stefan R.
    ยท
    ยท

    Add {{PreviousColumn}} in the next column as a condition. I believe this is enough, but feel free to check it out and let me know

  • Avatar of Stefan R.
    Stefan R.
    ยท
    ยท

    It basically means that the next column will run only for the rows where the previous column has already run successfully.

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท
  • Avatar of Stefan R.
    Stefan R.
    ยท
    ยท

    Is the text column after the Apollo enrichment related to the Apollo enrichment? If yes, trying using {{ApolloEnrichmentColumn}} != "" as a condition

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    tried that before. not working: !!{{Enrich Company}}?.organization?.short_description

  • Avatar of Stefan R.
    Stefan R.
    ยท
    ยท

    That's strange. I can't recreate the Apollo error in my own workspace. An idea I just had -> maybe try using the Description output from Apollo in a new Formula column. No need to do anything, just get the Description output from Apollo and put it in a new column. Afterwards try doing the empty column condition but this time using the formula column? I have no clue if this makes sense or if it's going to work but I think it's worth trying

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    thanks a lot! will do

  • Avatar of Clay T.
    Clay T.
    APP
    ยท

    Hey there Daniel thanks for reaching. Let us know if you are still having issues with your table.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Awesome breakdown, Stefan! and thank you for the message, Daniel!Yes, the easiest way to ask condition it to run only if it has results, or you can also prompt the AI to only run if it's not empty.The formula would look something like this: !!{{Apollo}}

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Or a variation of that depending on what field from Apollo you condition it by.

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    can confirm !!{{COLUMN NAME} works cheers