Use external correspondance table

  • 166Views
  • Last Post 15 May 2019
Laurent Michel posted this 14 May 2019


I have a question regarding the possibility to use external correspondance table,

We have flow on ftp in CSV from ERP to Salesforce,

In this flow we have a code for customer activity 

We want to match the code with the designation of this activity

On salesforce our integrator ask us 1,5 day to do that so almost big

Question : is it possible to use on skyvia external csv just with correspondance and after make a lookup to complete designation on all account ? 

Thank you for your help !

Order By: Standard | Newest | Votes
Dmitriy Muzurov posted this 15 May 2019

Hi Laurent,

Thank you for submitting a ticket with us.

So, you are trying to import CSV from FTP connection to Salesforce.

Some field in this CSV file contains a code that should be matched with some field in the Salesforce object.

It is still not clear what is meant by "correspondence table".

Please provide more details.

We are looking forward to hearing from you.

Laurent Michel posted this 15 May 2019


Thank you for your answer,

Yes finnaly i find a solution with new skyvia csv + use custom object + external id on salesforce and import the correspondance betwin code on our csv and code designation on salesforce

You can close this ticket thank you