efficy Enterprise CRM icon

efficy Enterprise CRM

Calls the efficy Enterprise JSON API API

Actions28

Tool → Get Lookup Key From Value

AI-generated

Summary

Resolve a display value in a specified lookup table to its corresponding key integer using the Efficy Enterprise CRM API.

Inputs

  • Lookup Table Name (required) — Name of the lookup table to search in (e.g., LK_COUNTRY).
  • Field Name (required) — Field name in the lookup table whose key you want to retrieve.
  • Value (required) — Display value to resolve to its corresponding lookup key integer.
  • Search In Translations — Optional boolean to indicate whether to also search across translated values.
  • Return Full Response — Optional flag to return the complete API response array instead of just the first result.

Output shape

a single JSON object representing either the first lookup key record found or the full API response array if requested.

If 'Return Full Response' is set to true, the output contains the complete response array from the Efficy API; otherwise, it returns only the first lookup result object. On error, the node may return an error object depending on the workflow 'continue on fail' setting.

Examples

Example 1: Convert a Country Name to Its Lookup Key

Set 'Lookup Table Name' to 'LK_COUNTRY', 'Field Name' to 'COUNTRY', and 'Value' to 'Belgium'. Optionally, enable 'Search In Translations' if needed, and leave 'Return Full Response' as false to get the first matching lookup key.

Links

Discussion