Ticket #29661
Question
How do I call a JSON lookup retrieval that uses multiple sequence fields? I don't see that information in the documentation here: https://www.mrc-productivity.com/techblog/?p=10092
Answer
Informed customer the syntax is as follows: examples: ------- ${Lookup("DICTIONARY.I00001s", row.KEY2, row.KEY1, "FIELD_TO_RETURN")} - two sequence fields in the JSON lookup retrieval -------- ${Lookup("DICTIONARY.I00001s", row.KEY3, row.KEY2, row.KEY1, "FIELD_TO_RETURN")} - three sequence fields in the JSON lookup retrieval
Asked on October 31, 2019