Documentation referenced:
- Ruby Snippets by Workato: https://docs.workato.com/en/connectors/ruby-snippets-by-workato.html
- Available Ruby methods: https://docs.workato.com/en/developing-connectors/sdk/sdk-reference/ruby_methods.html#lookup
I'm trying to understand how I might be able to use lookup() within the ruby snippet. The documentation implies that you should be able to, but whenever I try, I receive this error:
Lookup Tables are not initialized. Init data by calling LookupTable.from_file or LookupTable.load_data code.rb
The line I have in the snippet is quite simple:
#...
plans_by_supplier.each do |supplier, lines|
vendor = lookup("Supplier Vendor Table", site: supplier)["vendor"]
# ... other stuff here
plans << {
vendor: vendor
}
end
#...
At the end of the day what I'm trying to do is be able to find the value associated to a given key and return that field for each key in an array.
I know it can be done in a regular formula, but that would require looping through multiple layers of arrays to get to the fields I want, resulting in 100s of tasks.
I'm happy to hear other suggestions to solve my issue, or any context for if this should work, if it would work with data_tables instead.. etc?
