Update Task

  • 58Views
  • Last Post 29 April 2022
0
votes
Hari Vendra posted this 26 April 2022

Hi Team,

I hope you're doing good.

I've created an Update task to create a record in it already exists in the system - Salesforce to Salesforce.

I want it to update the fields only if the fields are blank. However, I see that it is being overwritten. Could you help at the earliest possible, please?

Here's the package link: https://app.skyvia.com/#/104956/packages/161218 

Thank you for all your support and understanding.

Thank you,

Regards,

Hari Vendra

salesforce update
Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 28 April 2022

Hello Hari, 

Skyvia works this way, it overwrites the values of the mapped fields when performing the update operation. It does not check the target values. 
Please make sure the Id field mapping is correct. As we can see, the column PDM_ID__c is not mapped and, together with that, it is used as the Lookup key column for the Id field mapping. 


Best regards,

Olena

Technical Support Engineer




 

0
votes
Hari Vendra posted this 28 April 2022

Hi Olena,

Thank you for your response.

The idea is to update the accounts where they're matched along with the billing address as well so we don't end up creating duplicates. Hence, we did a check where it matched and populated the account id of the source against the PDM ID field manually so that when we run an update, Skyvia should update the fields where it is blank - I did a double-check and the lookup is fine

From the above email, I understand that Skyvia overwrites the values of mapped fields when performing the update operation rather than updating the fields where it is blank? 

Please let me know if what i said understand is correct.

Thank you,

Hari Vendra

 

0
votes
Olena Romanchuk posted this 29 April 2022

Hello Hari, 

It is correct. 
Skyvia determines what record to update by the ID/ Primary key. 
Currently the lookup retrieves the Account.Id from the target record where the target PDM_ID__c  value equals the source Account.Id value. Skyvia updates the records which Ids were retrieved by this lookup.

Best regards,

Olena

Technical Support Engineer

 



 



New Ticket
Categories
Popular Tags
Close