---
title: Organization Read Local Data Block
description: "The Organization Read Local (OrganizationReadLocal) Data Block is a non-editable Interface block in Assette that pulls organization reference data directly from Assette's internal database. It returns the organizational fields `Code`, `Name`, `Domain`, and `Phone` for all active entries. This block…"
url: "https://learn.assette.com/docs/organization-read-local-data-block/"
updated: "2026-04-16"
category: Developers / Data Blocks / Data Blocks by Category / System Data Blocks
---

# Organization Read Local Data Block

The Organization Read Local (OrganizationReadLocal) Data Block is a non-editable Interface block in Assette that pulls organization reference data directly from Assette's internal database. It returns the organizational fields `Code`, `Name`, `Domain`, and `Phone` for all active entries. This block is read-only access and is used as a dependency for other Data Blocks that require foundational organization data for further processing or transformation, usually the [Organization Master Data Block](https://learn.assette.com/docs/organization-master-data-block/).

## General Info

| Field | Value |
| --- | --- |
| Name | OrganizationReadLocal |
| Block Category | Interface |
| Block Type | Local Database |
| Output Type | Data Table |
| Public Block | True |
| Editable | False |

## Dependencies

None

## Definition

```
{
    "type": "Values",
    "sql": "SELECT Code,Name,Domain,Phone FROM Organizations WHERE IsActive = 1 ORDER BY Name",
    "parameters": []
}
```

## Columns

| Column Name | Required | Description |
| --- | --- | --- |
| Code | Yes | Unique identifier for the organization |
| Name | Yes | Name of the organization |
| Domain | No | Website domain of the organization |
| Phone | No | Phone number associated with the organization |

## Example Request

```
{}
```

## Example Response

*The following code shows an example response using the default values of the Data Block. The response may be shortened for brevity.*

```
{
    "data": [
        {
            "Code": "Apple",
            "Name": "Apple",
            "Domain": "apple.com",
            "Phone": null
        },
        {
            "Code": "Assette",
            "Name": "Assette",
            "Domain": "assette.com",
            "Phone": null
        },
        {
            "Code": "Microsoft",
            "Name": "Microsoft",
            "Domain": "microsoft.com",
            "Phone": null
        }
    ],
    "errors": [],
    "success": true,
    "logs": [],
    "sources": []
}
```