Can you use upsert to insert only new records?

  • 35Views
  • Last Post 20 July 2018
  • Topic Is Solved
0
votes
Cody Saunders posted this 19 July 2018

I am using the free plan and was wondering, if I wanted to schedule imports to salesforce from a databse using upsert, only the records that were inserted/updated would count towards the ammount of records I have available, correct? 

1
votes
Pavel Triapsha posted this 20 July 2018

Hello,

For Upsert, every Source row either inserted (if a null value is provided for Id mapping) or updated (if a not null value is provided for the Id mapping). And the number of records successfully inserted/updated in the target objects or tables is counted. For each package run, you can find the number of records used in the package Run History.

In order to save your daily record limit, you can import only recently added data.

Please refer to (Workaround for Relational Databases paragraph): 

https://skyvia.com/resources/docs/importing_recently_added.htm

 

Regards,

Pavel

  • Supported by
  • Cody Saunders
Close