Workaround Available

Transformation step for the Salesforce Connector

  • 15 June 2021
  • 3 replies
  • 12 views

Userlevel 2

In the Salesforce Connector 2.0 I can only use source and target, it would be nice to have a transformation step as well where minor corrections can be made. For instance adding case fields or additional filters.

We have this option in the “Freshdesk” connector where I use a transformation step to translate the built in Priority names in Freshdesk to our reporting standard P1-P5

 


3 replies

Userlevel 7
Badge +2

@DavidT thank you for posting it here, please expect a delay in replying to your request.

Userlevel 7
Badge +1

Hi @DavidT - there is a work around for this in the Rules Engine. You can create a rule to pull the data from GS and then add any transformation or merges to the data afterwards.

Rules can run every 2 hours with a cron expression where as connector jobs can run every hour. That’s a slight limitation but there is a lot more features for transforming the data. 

Userlevel 7
Badge +2

Hi @DavidT - there is a work around for this in the Rules Engine. You can create a rule to pull the data from GS and then add any transformation or merges to the data afterwards.

Rules can run every 2 hours with a cron expression where as connector jobs can run every hour. That’s a slight limitation but there is a lot more features for transforming the data. 

@jean.nairon thanks for posting the workaround! 

@DavidT sorry, as of today we don’t have anything on the road-map. I would say to go with @jean.nairons workaround. 

Reply