topic FTP transfer into Salesforce in Talend Studio

FTP transfer into Salesforce

onchar — Sat, 16 Nov 2024 04:53:11 GMT

I have a requirement to pick up a file from FTP location and do an upsert into Salesforce. Chances are there is a possibility of updating at least two objects in Salesforce. Is this something anyone of you have experienced?

I am looking to know if it is possible, and also what is the best way to go about this as far as best practices, file formatting issues, or any nuances i need to be aware of. Please let me know when able.

Thanks all.

Re: FTP transfer into Salesforce

Anonymous — Tue, 27 Aug 2019 15:04:34 GMT

Hi,

Did you try to use tFTPList, tFTPGet and tSalesForceOutput using Key value selection in schema to do your use case?

When it comes to queries related to Salesforce, @TRF will be the first name coming to my mind.

But your query is bit generic in nature and may not be able to cover within the scope of a community post. If you ask specific query related to your problem with sample data, Community members will be eager to help you.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: FTP transfer into Salesforce

TRF — Thu, 29 Aug 2019 08:56:13 GMT

@nthampi thank's so much for your comment!

@onchar, you cannot update 2 salesforce objects at once, you need to use 2 tSalesforceOutput component in your job and update each object at a time.

Is that the question? Else, give more details with sample data (input and expected result).

Re: FTP transfer into Salesforce

onchar — Thu, 29 Aug 2019 13:24:57 GMT

Thank you.

I'll give that a try.

Re: FTP transfer into Salesforce

onchar — Thu, 05 Sep 2019 05:22:05 GMT

@TRF
I have a salesforce query and wondering how i can update my schema and SOQL to query a field in Account which is related to Object B. For example field X__c in Account has a lookup to Object B, and i 'd like to pull the value from a field in Object B, say AFieldInObjB__c. How would i set this up?

Re: FTP transfer into Salesforce

TRF — Thu, 05 Sep 2019 07:35:16 GMT

For the SOQL query:
SELECT Id, Name, Account_r.X__c FROM ObjectB__c
Here "Account_r.X__c" refer to "field X__c" available through the relationship "Account" defined with field "Account__c" of "ObjectB__c".
The tSalesforceInput component must contain the fields Id, Name and Account__r_X__c (notice _ instead of . to respect Java namming rules + __r instead of __c to represent the relationship).