> For the complete documentation index, see [llms.txt](https://200ok.gitbook.io/200ok-documents/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://200ok.gitbook.io/200ok-documents/user-manual/built-in-functions/advanced/lookup.md).

# lookup

lookup() function is the Standard function available in 200OK.

**Description** : The fx\_lookup function retrieves the ID of a specific record within a given Salesforce object based on the provided field name-value pair. It simplifies the process of accessing records by directly returning the unique identifier.

**Syntax** : fx\_lookup(object name, field name-value)

**Example**  : fx\_lookup(Account, Name-Tester) returns the ID 'Encode:001Ec00000BZeFcIAL' corresponding to the 'Tester' record within the 'Account' object.

Here we go with simple scenario using the above function.

**Request Side** : 

<figure><img src="https://lh7-us.googleusercontent.com/c84n0pfk4v3UTWn8ROwhKh7Ddw1wilamIpNxT_XP4v4XP_HF6dU6bM_KxJVhiuduh4pxoBoDQ6UCM9P1p1y3I4MqNIO1ysHz8gO6fCdfGKXoT53a-QBraplxNWhDfDefgu4tnnnlljZ7hXdnTK_L8Hs" alt=""><figcaption></figcaption></figure>

**Response Side** :&#x20;

<figure><img src="https://lh7-us.googleusercontent.com/96SB1EvRrdjlP2Pd5g1Dpy95wQgaP94o6wN8iHWjmIwMqGceujsRRCBxAKaGJ-XONq865teLnbe5JWWnjK5NkpQHf9cT6QsHBdXIKJ7qPBUEHK2jJ4JX8I30O4CuMZuYgTSoNiepy2XfpetgGsSVhIw" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/c6r5NIi-h4Nu4wcB50Sjw8L9BC0NK1Dja0RMMqoPT18W9fkNVGU2KI7kNdzvi-I0V48HhRn_N-6fhR-qND_nCo5XdaHalUsrwC0GY6Lp7Brv_W9OACs0RmtWqgRdyoybClmtUOK1jD5B3OD8tjPW73I" alt=""><figcaption></figcaption></figure>