FTP transfer into Salesforce

[onchar]

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.

[Anonymous]

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

[TRF · Accepted solution]

@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).

[onchar]

Thank you.

I'll give that a try.

[onchar]

@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?

[TRF]

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).