James K.

i think i was able to debug the prompt that was misformating the array

no i did try sculptor and it was hallucinating fields in the send to data setup and send to data also gives an error saying input a valid list when i try to use the array

there is no cell action "Turn items into rows" available anymore

thank you. please do

this is good for now, I need time to dig deeper

can you provide more specific information about using webhooks in hubspot and salesforce?

not really. I need some solution other than setting a reminder for myself to go check every few days

https://app.clay.com/workspaces/365813/workbooks/wb_0szi7baEFUFF9UveQr4/tables/t_0szi8hwHTXPQDsm9NiS/views/gv_0szo6av9HEyapdcy7mA

I figured out a work around. I forgot that when you setup the source, you specific a uniqueness field. It appears that limits the import from reimporting those records no matter what is in the table or what the auto-dedupe rules are for the table. My solution was to setup a new source using the same report, but without any uniqueness field specified. The result was that the records I wanted to have imported (and had previously deleted) came in without an issue. The bad news is that the import source still pulled in 2K rows which the table auto deduped 1998 of them. The daily run will likely continue to pull in 2K rows every time it runs which seems like a waste of processing and api calls.