Hi all! When doing an upsert on vendor records, if...
# suitetalkapik
Kristopher Wood
05/31/2022, 7:07 PMHi all! When doing an upsert on vendor records, if I include an address and the vendor already exists, it duplicates the address even if it's identical to one that already exists. What's the right way to NOT duplicate addresses on vendor upserts?
b
battk
05/31/2022, 7:29 PMnone really
battk
05/31/2022, 7:29 PMif your client is the only thing managing addresses, then you may be able to get away with using replace all
👍 1
battk
05/31/2022, 7:30 PMotherwise you need the internal id of the addressbook line to update an existing address
battk
05/31/2022, 7:30 PMwhich basically means you need to lookup and store that information
battk
05/31/2022, 7:31 PMwhich means its not really an upsert but an update
k
Kristopher Wood
05/31/2022, 7:31 PMI'm using Boomi to bring them over from Salesforce
Kristopher Wood
05/31/2022, 7:31 PMI'll have to ask the accounting team if they need to keep existing addresses in NS that are different from SF
Kristopher Wood
05/31/2022, 7:32 PMGood advice, thanks!
b
battk
05/31/2022, 7:32 PMreplace all is an oppressive solution
battk
05/31/2022, 7:32 PMits the equivalent to deleting all the existing addresses and adding new ones
k
Kristopher Wood
05/31/2022, 7:33 PMTrue but SF is the source of truth in this case so it should always match anyway, right?
Kristopher Wood
05/31/2022, 7:33 PMI suppose I could do a get vendor addresses in Boomi first but it'll be easier to replace them