Deleting Sales Force Records Prior to insert

[Anonymous]

Hello!  I am relatively new to Talend.  I have successfully created a job that pulls filtered data from our AS400 and inserts into a custom Sales Force object in my Sandbox environment.  Now I need to create a step that deletes all records in the Sales Force custom object before the insert.  I was able to find several posts regarding this topic however none had solutions. So far I have a tSalesforceOutput component with the Output Action = DELETE.  Next is a tLogRow component (so I have a list of the record Ids).  Then a tSalesforceInput component.     I can execute the job without error but no records are deleted in Sales Force.  

Any assistance would be greatly appreciated.

cjsigler

[TRF]

You need to use a tSalesforceInput component to select the id for the records you want to delete.
Then connect it to a tSalesforceOutput with DELETE operation selected.

[jlig]

As I'm still learning Talend,

1. How do I select the ID for the records to delete? 
2. How do I combine this "Delete job" to my working "Insert job" above?

Here is what I have so far:

[jlig]

Ok, it looks like the Delete is running fine & deleted all of the MBS records in the custom object! Thanks for the help with that part!

- Now just one last question.. How do I add this "Delete Job" to my "Insert Job"?

- I need the delete to run first, then after the custom object is empty, run the Insert.

[TRF]

Just connect the tSalesforceInput component of the "delete" subjob with the 1rst component of the "insert" subjob using an onSubjobOk trigger.
Also don't forget to kudo the posts that help you. Much more better, open new posts for your questions.

[TRF]

Sounds like your problem is solved.

Thank's to close the topic.

[jlig]

TRF, thanks again for the help.. this is an amazing tool when working between MySQL & Salesforce.

Here is my completed "DELETE then INSERT" job: