topic Re: Deleting Sales Force Records Prior to insert in Talend Studio

Deleting Sales Force Records Prior to insert

Anonymous — Sat, 16 Nov 2024 09:44:00 GMT

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

Re: Deleting Sales Force Records Prior to insert

TRF — Thu, 25 May 2017 18:05:10 GMT

Hi,

You must know Salesforce Id for records you want to delete.

So, you need a tSalesforceInput to select these Id, then using tSalesforceOutput (or tSalesforceOutput if lot of records) you can delete the selected records. Just be careful to have Id as the only field in the schema for both components.

Here is the minimal job design for such a case:

tSalesforceInput --> tSalesforceOutput

Can you share your job?

Re: Deleting Sales Force Records Prior to insert

Anonymous — Thu, 25 May 2017 18:11:02 GMT

So it sounds like I have my components backwards. Not sure how to share the job so here is an image.

Re: Deleting Sales Force Records Prior to insert

TRF — Thu, 25 May 2017 18:13:39 GMT

Right, can you also share the schema for bot tSalesforceInput and Output components?
Also, does the tSalesforceInput select at least 1 record?

Re: Deleting Sales Force Records Prior to insert

Anonymous — Thu, 25 May 2017 18:20:04 GMT

Like this?

Re: Deleting Sales Force Records Prior to insert

Anonymous — Thu, 25 May 2017 18:24:21 GMT

That worked!! I had my components backwards! Thanks so much!!

Re: Deleting Sales Force Records Prior to insert

Anonymous — Thu, 25 May 2017 18:25:57 GMT

Re: Deleting Sales Force Records Prior to insert

TRF — Thu, 25 May 2017 18:27:11 GMT

That's what I was going to tell you.

For best practice allways design your jobs from left to right and top to down.

Re: Deleting Sales Force Records Prior to insert

jlig — Fri, 02 Feb 2018 20:12:38 GMT

cjsigler, I'm trying to create a Delete job like yours, but not sure what I'm doing wrong?

I created a setup like yours:
When I click run, I get the following error:
Am I missing something here? Do I need to use the tMap component too?

Re: Deleting Sales Force Records Prior to insert

jlig — Fri, 02 Feb 2018 20:31:44 GMT

My insert query/job works fine which uploads data from MySQL to my custom Salesforce object (see below):

- But how do I combine/add in the Delete option?

- I need to alter my job below to first do the Delete

- Then complete the Insert job

Re: Deleting Sales Force Records Prior to insert

TRF — Fri, 02 Feb 2018 21:42:42 GMT

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.

Re: Deleting Sales Force Records Prior to insert

jlig — Fri, 02 Feb 2018 22:35:10 GMT

As I'm still learning Talend,

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

Here is what I have so far:

Re: Deleting Sales Force Records Prior to insert

jlig — Fri, 02 Feb 2018 22:45:49 GMT

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.

Re: Deleting Sales Force Records Prior to insert

TRF — Sat, 03 Feb 2018 09:40:56 GMT

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.

Re: Deleting Sales Force Records Prior to insert

TRF — Mon, 05 Feb 2018 14:23:03 GMT

Sounds like your problem is solved.

Thank's to close the topic.

Re: Deleting Sales Force Records Prior to insert

jlig — Mon, 05 Feb 2018 14:34:02 GMT

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

Here is my completed "DELETE then INSERT" job: