efficy Enterprise CRM icon

efficy Enterprise CRM

Calls the efficy Enterprise JSON API API

Actions28

Tool → Get Lookup Value From Key

AI-generated

Summary

Resolve a lookup key integer to its corresponding display value within a specified lookup table and field in the efficy Enterprise CRM.

Inputs

  • Lookup Table Name (required) — The name of the lookup table to query, e.g., 'LK_COUNTRY'.
  • Field Name (required) — The specific field in the lookup table to retrieve the display value from, e.g., 'COUNTRY'.
  • Key (required) — The integer key whose associated display value will be resolved and returned.
  • Options — Additional options including whether to return the full API response array (boolean: 'Return Full Response').

Output shape

A JSON object containing the resolved lookup display value. If 'Return Full Response' is enabled, returns the complete API response array; otherwise, returns the first context result object.

The output JSON structure depends on the 'Return Full Response' option. Errors from the API are thrown unless workflow is set to continue on failure, in which case error details are returned per item.

Examples

Example 1: Retrieve country name by its internal lookup key.

Set 'Lookup Table Name' to 'LK_COUNTRY', 'Field Name' to 'COUNTRY', and provide the integer key for the country required.

Links

Discussion