---
title: Organization Add Data Block
description: "*⚠️ Warning: Running this Data Block with a value will insert the values into Assette. Use only when you intend to persist new organization records.* See The Organization Add (OrganizationAdd) Data Block in Assette is a user-editable Transform block that…"
url: "https://learn.assette.com/docs/organization-add-data-block/"
updated: "2025-05-13"
category: Developers / Data Blocks / Data Blocks by Category / System Data Blocks
---

# Organization Add Data Block

*⚠️ Warning: Running this Data Block with a value will insert the values into Assette. Use only when you intend to persist new organization records.* See

The Organization Add (OrganizationAdd) Data Block in Assette is a user-editable Transform block that facilitates the insertion of new organization records into both the local database and Salesforce. It performs key validations—checking for required parameters and ensuring uniqueness of `Code` and `Domain` fields after filtering common URL prefixes. This block is typically used by administrators or automated workflows to add new clients or institutions to the organization master list.

## General Info

| Field | Value |
| --- | --- |
| Name | OrganizationAdd |
| Block Category | Transform |
| Block Type | Python |
| Output Type | Data Table |
| Public Block | True |
| Editable | Editable |

## Definition

```
#Organization Add Block
def fn_replace_domain(DomainReplaceList,domain_string):
    if len(DomainReplaceList)>0:
        for val in DomainReplaceList:
            if val in domain_string:
                domain_string = str(domain_string).replace(val,"")
    return domain_string

def fn_is_code_domain_exists(OrganizationList,Code,Domain,DomainReplaceList):
    global fn_replace_domain
    IsCodeExists = False
    IsDomainExists = False
    if len(OrganizationList)>0:
        for org in OrganizationList:
            domain_string = fn_replace_domain(DomainReplaceList,(org.get("Domain") or ""))
            if (org.get("Code") or "")==Code:
                IsCodeExists = True
            if str(domain_string).lower()==str(Domain).lower():
                IsDomainExists = True
            if IsCodeExists and IsDomainExists:
                break
    return IsCodeExists,IsDomainExists

InsertParams = {}
RequiredParamsList = ["Code","Name","Domain"]
DomainReplaceList = ["https://www.","http://www.","http://www","https://","http://"]
replaced_domain = ""
if len(params) > 0:
    for key, value in params.items():
        if str(key).lower() =="domain":
            replaced_domain = fn_replace_domain(DomainReplaceList,value)
        if value:
            InsertParams[key] = value

if (InsertParams.get("Domain") or "") !="":
    InsertParams["Domain"] = replaced_domain

#Validate
Output = []
MissingParamList = []
IsValidRequest = True
if len(RequiredParamsList)>0:
    for key in RequiredParamsList:
        if (InsertParams.get(key) or "")=="":
            MissingParamList.append(key)
if len(MissingParamList)>0:
    IsValidRequest = False
    comma_separated_string = ", ".join(MissingParamList)
    response["errors"] = ["The following parameters have not been provided: " + comma_separated_string]

#Check Parameters existence.
if IsValidRequest:
    ReadOutput = read("OrganizationMaster",{})
    IsCodeExists,IsDomainExists = fn_is_code_domain_exists((ReadOutput.get("data") or []),(InsertParams.get("Code") or ""),(InsertParams.get("Domain") or ""),DomainReplaceList)
    if IsCodeExists:
        IsValidRequest = False
        if(len(response.get("errors") or [])>0):
            response["errors"].append("Code: "+ (InsertParams.get("Code") or "") +" already exists")
        else:
            response["errors"] = ["Code: "+ (InsertParams.get("Code") or "") +" already exists"]
    if IsDomainExists:
        IsValidRequest = False
        if(len(response.get("errors") or [])>0):
            response["errors"].append("Domain: "+ (InsertParams.get("Domain") or "") +" already exists")
        else:
            response["errors"] = ["Domain: "+ (InsertParams.get("Domain") or "") +" already exists"]

if IsValidRequest:
    Output = read("OrganizationAdd",InsertParams)
    if "data" in Output.keys():
        Output = Output.get("data") or []

response["data"] = Output
```

## Columns

| Column Name | Required | Description |
| --- | --- | --- |
| Id | No | Internal text identifier (if returned) |
| Code | Yes | Unique text-based identifier for the organization |
| Name | Yes | Full name of the organization |
| Domain | Yes | Website domain, used to ensure uniqueness |
| Phone | No | Optional phone contact information |

## Request Parameters

| Parameter Name | Display Name | Data Type |
| --- | --- | --- |
| Code | Code | Text |
| Name | Name | Text |
| Domain | Domain | Text |
| Phone | Phone | Text |

## Example Request

```
{
    "Code": "Telos Brothers",
    "Name": "Telos Brothers",
    "Domain": "telosbrothers.com",
    "Phone": ""
}
```

## Example Response

*The following code shows an example response when the insert is successful.*

```
{
    "data": [
        {
            "rows": 1
        }
    ],
    "errors": [],
    "success": true,
    "logs": [],
    "sources": []
}
```