Hi, collegues! We have stucked at this issue. Our incoming JSON { GUID: 123432, UserName: "John Silver", Department: "Headquarters" } And lookup table in the Oracle database consits of two columns: id, desc. What we want to achive is get the id from that table by provided description from json (for instance Department field). After LookupRecord processor with following key settings: Result RecordPath => /Department Record Result Contents => Insert Record Fields Record Update Strategy => Use Property User-definet propery: key => /Department We get JSON as follow: { GUID: 123432, UserName: "John Silver", Department: "MapRecord[{ID = 7107070}]" } What we are doing wrong or probably not in correct way? Really appreciate for any clue)
... View more
