cancel
Showing results for 
Search instead for 
Did you mean: 

Sync data in SQL to sf

nvinay091
Deputy Chef I
Deputy Chef I

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

7 REPLIES 7

viswanathan-r
Deputy Chef I
Deputy Chef I

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

viswanathan-r
Deputy Chef I
Deputy Chef I

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


vinay-narayana
Deputy Chef I
Deputy Chef I

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
Workato employee
Workato employee

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