Support Questions
Find answers, ask questions, and share your expertise

LookupRecord with DatabaseLookupService

New Contributor

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)



; ;