Target Lookups to Allow Expressions

  • 6Views
  • Last Post 09 August 2020
  • Topic Is Solved
0
votes
System Admin posted this 06 August 2020

When running a data import it would be incredibly useful to enable the use of Expressions in the Lookup functionality.

The explicit use case is when the data types do not match across databases.  Salesforce stores IDs as DT_WSTR, while Pipedrive stores IDs as DT_I4.  So with the type mismatch, you have to figure out workarounds to get the IDs to match up.  A simple data type cast would solve this in 1 line.

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 07 August 2020

Hello,

 

Yes, currently it is impossible to do, however, this functionality is on our roadmap. Thank you for your suggestion, we will definitely post here when any news is available.

 

Best regards,

Mariia

  • Supported by
  • System Admin
0
votes
System Admin posted this 08 August 2020

Thanks Mariia!  Any timeline on that roadmap?

Best Regards,
Matthew Reive
aka System Admin

0
votes
Mariia Zaharova posted this 09 August 2020

Hello Matthew,

 

Unfortunately, we cannot tell you any timeframe regarding this for now. We will definitely inform you if any news is available.

 

Best regards,

Mariia

Close