Sync data in SQL to sf

[nvinay091]

Hi Team ,
This is an urgent requirement:
I have a SQL Table in which data gets on adding ( New rows are created )
I want to send that data to SalesForce object .
I don't want to check for any conditions , I just want to push the data to Sf.

Trigger should be : New row created in SQL server table
Action should be copy that to SalesForce to the Mapped fields.
I mean to create a row in SF.

Without checking any conditions ( is it present in sf previously or not .... No need to check )
Just send the data to sf ...


Please reply fast

[viswanathan-r]

https://app.workato.com/recipes/822962-new-updated-row-in-a-table-in-sql-server-will-upsert-opportunity-in-salesforce?community=true

[viswanathan-r]

https://app.workato.com/recipes/897589-sync-sql-server-records-to-sfdc-contacts?community=true

[vinay-narayana]

Hi Viswanathan R

That has a condition .... If contact id is present

and there is no need to update for me, only insert no upsert

That community library recipe will not work

[max-knutsson]

Instead of Upsert which requires a key, you can use "Create -YourObject- In Salesforce"