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.

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": []
}