Hey team, can you please check row one, why it's showing invalid input while using WTOT? https://app.clay.com/workspaces/446766/workbooks/wb_hotPK3UwwV7T/tables/t_dNVYzXJrxgtN/views/gv_YgwcSjmZTAwS
The "invalid input" error in Write to Other Table (WTOT) is likely due to incorrect JSON formatting in your input. Here's how to troubleshoot: 1. Check your JSON body formatting: • Ensure all text values are in double quotes • Verify commas separate your key-value pairs correctly • Remove any extra spaces or hidden characters • Make sure there are no trailing commas 2. If you're using dynamic column values: • Text values need quotes around the dynamic column tag • Numbers don't need quotes (unless they have leading zeros) • Create a Formula column first if combining plain text with dynamic valuesIf the issue persists, verify that your Clay API key is properly configured under Settings > Connections > Clay. Sources: HTTP API with JWT authentication | Documentation | Clay University Write to table integration overview | Documentation | Clay University HTTP API integration overview | Documentation | Clay University
If you're still seeing an "invalid input" error with Write to Other Table after checking JSON formatting, the issue might be related to your Clay API key configuration. Here's how to resolve it: 1. Go to Settings > Connections 2. Search for Clay in the connections list 3. Verify your Clay API key is properly configuredOnce you've corrected the API key configuration, the write-to-table operation should work as expected.Before trying again, make sure you have: ** Selected a valid destination table ** Correctly mapped your columns * Double-checked that all referenced columns and tables exist Source: Write to table integration overview | Documentation | Clay University
Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Hey there Faheem thanks for reaching out, taking a look at your table, the reason you are getting this error is because the result was not standardized for each row. The first row had the list as "Selected individuals clay" while the other row was "Selected individuals Clay" where the "C" in both rows was different. Have fixed this issue, so now all that is needed is to rerun the Write to table column again. And to also remove the rows from the destination table as well. https://downloads.intercomcdn.com/i/o/w28k1kwz/1363630066/b96f6df143a0474ace15e0d739ac/image.png?expires=1738617300&signature=e716e90cad5983a4dff717af48872e1ff0a397f98e531de7163c4e7c89b9224a&req=dSMhFc99nYFZX%2FMW1HO4zVWHVWFqM3jPqwSAor2zwLgxiiGnjbGGS0ScbrCM%0AxQm%2B%0A
Thank you!
Hey LuisArturo in the same table can you please check row 7, It's showing run condition not match for every enrichment and that is correct but when I look into "Clay Find People Free" table we have 3 contacts from this company, I checked everything I don't know where from they are coming. Can you please take a look?
Hey there Faheem, was taking a look at this and I saw what is going on here. When it comes to the Clay Find People search, the conditional formulas for the column do not actually do anything, this is something that the team is still looking into removing from this option. That is why you still received leads even though the column says "Run Condition not met". https://downloads.intercomcdn.com/i/o/w28k1kwz/1363760892/b4370ae016fda4a39afeb33de4ac/image.png?expires=1738625400&signature=cf178ae2969e495401d894372144afd7559b50826a77b294b2da95208d4b7142&req=dSMhFc54nYlWW%2FMW1HO4zYsdQJu7n%2FEzoiNIMYtB%2FdWd0be6AFgrNDKlnlrL%0Ajg1s%0A
Got it, thanks for letting me know!
.png){kind=logo}
