Notes REST API (POST & PUT) - Internal Server Errors for all Notes thrown when body array contains 9 or more items created by API

[skyfox675]

Bug Description

Hi Team,

After a while of debugging I found that when creating notes (or updating them) the maximum body length can be 8 items consisting of:

{
        "type": "heading",
        "props": {
            "textColor": "default",
            "backgroundColor": "default",
            "textAlignment": "left",
            "level": 3
        },
        "content": [
            {
                "type": "text",
                "text": "question",
                "styles": {}
            }
        ],
        "children": [
            {
                "type": "paragraph",
                "props": {
                    "textColor": "default",
                    "backgroundColor": "default",
                    "textAlignment": "left"
                },
                "content": [
                    {
                        "type": "text",
                        "text": "answer",
                        "styles": {}
                    }
                ],
                "children": []
            }
        ]
    }

This seems to be related to #6608

Example:
Exceeding 8 items:

[
{
"data": {
"updateNote": {
"id": "57447027-2348-4003-abdc-6d6f056da185",
"position": null,
"title": "api test 2",
"body": "[{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What's your first name?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"Nick","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What's your last name?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"Adams","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What's your email?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"[email protected]","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What's your phone number?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"0000000000","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What is this for?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"Business 💼","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What is your business name?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"Joe's crab shack 🦀","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What is the business phone number?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"0000000000","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What is the business email?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":"[email protected]","styles":{}}],"children":[]}]},{"type":"heading","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left","level":3},"content":[{"type":"text","text":"What's the address?","styles":{}}],"children":[{"type":"paragraph","props":{"textColor":"default","backgroundColor":"default","textAlignment":"left"},"content":[{"type":"text","text":["1234 Main Street #123","","New York","New York","12345","United States"],"styles":{}}],"children":[]}]}]",
"createdAt": "2024-10-05T03:59:06.807Z",
"updatedAt": "2024-10-05T04:29:30.635Z",
"deletedAt": null,
"createdBy": {
"source": "API",
"workspaceMemberId": null,
"name": "Formbricks.com via N8n"
}
}
}
}
]

Technical inputs

Version: v0.30.2
Hosting: Self-Hosted

[Apetree100122]

 { "type": "heading",       
"props": { "TextColor":
"default",
"Background Color": 
"default",
"Text_Alignment : "left", "level": 3 },       
"content": [ {  "type": "text",
"text": "question",               
"styles": {}],  \ "children": [ { "type":
"paragraph", "props": {  "textColor": "default",              
  "backgroundColor": "default",
       "textAlignment": "left"            
 },"content": [ { "type": "text",                      
"text": "answer",                 
"styles": {} } ],    
 "children": []
}

---

related to
https://github.com/twentyhq/twenty
Issue: #6608
Example:
Exceeding 8 items:

---

    [
{
 "data": {
"updateNote": {
 "id": "57447027-2348-4003-abdc-6d6f056da185",
 "position":
 null,
 "title": "api test 2",
 "body": 
"[{"type":"heading","props":{"textColor":
"default",
"background Color":
"default"
,"textAlignment":
"left","level":3},
"content":[{"type":
"text",
"text":
"Whats your first name?", 
"default","backgroundColor": 
"default","textAlignment":"left"}  
"content":[{"type":"text",   "1234 Main Street #123"," "  "New York","New York" 
 "12345","United States"], "styles":{],   "children":[]",- 
- "createdAt": "2024-10-05T03:59:06.807Z",     
-  
"updatedAt": "2024-10-05T04:29:30.635Z",
deletedAt": 
  [ ] 
"CreatedBy": [ ]   "source": "API",
 "Workspace
MemberId":  [ ]  
"name":    "Formbricks.com    @ via N8n"
}
] ;

[Bonapara]

@Weiko What do you think?

[skyfox675]

@Bonapara & @Weiko, Not sure what the LoE to resolve this is, but as a user I would be ok with a bodyAppend attribute on PATCH to add more items to an existing Note.

[FelixMalfait]

Closing as the new #9534 will solve this, new API - RICH_TEXT becomes a composite fields with 2 subfields (one with the complex format, one with simple markdown format)