• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Bug Reports Recipe Bugs
b

bframe

started a topic over 1 year ago

lookup() causes internal error when searching the first column

When attempting to do a search on a lookup table using lookup('00000', col1:{datapill}) when the datapill doesn't exist, the formula will return a null response and proceed through the recipe if searching any column except the first. 


When a lookup() finds no corresponding entries when searching the first column, the entire recipe will fail and that step errors out with an 'Internal error' message and no further detail.


The lookup table was created using a CSV import.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count