Silverpop Engage Connector - upsert only if field is blank in existing record

[monique_trulson]

We've got several actions set to trigger various emails in Silverpop, with several data sources mapped to the appropriate columns in the Silverpop database as a result, and in most cases we use insert/upsert. My email manager asked today if there is any way to have the connector only upsert if the field in that record is empty (a simplified example - UPDATE table_name SET username = 'Anonymous' WHERE username IS NULL OR username = '') - control the upsert at the data mapping level rather than the audience level - which I don't see, but I thought I'd ask! Thanks! Monique

[dan_george]

Hi Monique, The vendor would have to provide the ability to do this with their API so we are looking into this and will respond once we have more information.

[dan_george · Accepted solution]

Hi Monique, Quick answer is that Silverpop's native API doesn't allow such thing. However, we researched the request and our initial review makes us think this is doable, though it requires custom work to support. We have submitted the required request to Engineering and need to meet to discuss the true level or effort and then prioritize. We'll follow up once we have more information.

[monique_trulson]

Thanks so much! =)