> For the complete documentation index, see [llms.txt](https://docs.work-relay.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.work-relay.com/automations/functions-and-formulas/functions-library/sobject-functions.md).

# Sobject functions

<details>

<summary>SOBJECTTYPE</summary>

Returns API name of an object.

**Usage**:

{% code overflow="wrap" %}

```apex
SOBJECTTYPE(id)
```

{% endcode %}

*<mark style="color:cyan;">Replace</mark>* *<mark style="color:cyan;">`id`</mark>* *<mark style="color:cyan;">with the ID of an object.</mark>*

**Example:**

{% code overflow="wrap" %}

```apex
SOBJECT({Stub.Id})
```

{% endcode %}

Returns '**Stub\_\_c**'.

</details>

<details>

<summary>SOBJECTDESCRIBE</summary>

Retrieves metadata for an object. Returns object (JSON).

**Usage**:

{% code overflow="wrap" %}

```apex
SOBJECTDESCRIBE(object_api_name)
```

{% endcode %}

*<mark style="color:cyan;">Replace</mark>* *<mark style="color:cyan;">`object_api_name`</mark>* *<mark style="color:cyan;">with the API name of an object.</mark>*

**Example**:

{% code overflow="wrap" %}

```apex
JGET(SOBJECTDESCRIBE('Account'), 'LabelPlural')
```

{% endcode %}

Returns '**Accounts**'.

</details>

<details>

<summary>SOBJECTFIELDDESCRIBE</summary>

Retrieves metadata for an object field. Returns object (JSON).

**Usage**:

{% code overflow="wrap" %}

```apex
SOBJECTFIELDDESCRIBE(object_api_name, field_api_name)
```

{% endcode %}

*<mark style="color:cyan;">Replace:</mark>*

* *<mark style="color:cyan;">`object_api_name`</mark>* *<mark style="color:cyan;">with the API name of an object</mark>*
* *<mark style="color:cyan;">`field_api_name`</mark>* *<mark style="color:cyan;">with an API name of a field to retrieve metadata for</mark>*

**Example**:

{% code overflow="wrap" %}

```apex
JGET(SOBJECTFIELDDESCRIBE('Stub__c', 'Check__c'), 'Type')
```

{% endcode %}

Returns '**BOOLEAN**' (which is type of a Check\_\_c field).

</details>

<details>

<summary>RECORDTYPEID</summary>

Retrieves record type ID by its name for the specified object type. Returns ID.

**Usage**:

{% code overflow="wrap" %}

```apex
RECORDTYPEID(object_api_name, record_type_name)
```

{% endcode %}

*<mark style="color:cyan;">Replace:</mark>*

* *<mark style="color:cyan;">`object_api_name`</mark>* *<mark style="color:cyan;">with the API name of an object</mark>*
* *<mark style="color:cyan;">`record_type_name`</mark>* *<mark style="color:cyan;">with the name of record type</mark>*

**Example**:

{% code overflow="wrap" %}

```apex
RECORDTYPEID('Account', 'My_Record_Type')
```

{% endcode %}

Returns ID of record type of Account object.

</details>

<details>

<summary>SOQL</summary>

Executes a SOQL query. Returns JSON with the result of the query.

**Usage**:

{% code overflow="wrap" %}

```apex
SOQL(soql_string)
```

{% endcode %}

*<mark style="color:cyan;">Replace</mark>* *<mark style="color:cyan;">`soql_string`</mark>* *<mark style="color:cyan;">with the SOQL you wish to execute.</mark>*

**Example**:

{% code overflow="wrap" %}

```apex
SOQL('SELECT Name FROM Account WHERE Type={QUOTE}Prospect{QUOTE}')
```

{% endcode %}

Returns JSON Array of respective Accounts.

</details>
