I have two collections: workspaces and workspace_membership. The workspaces collection has a one-to-many relationship. When I attempt to add a member to the workspace document via the workspace_membership collection, I receive an error message:
Here’s the schema for the workspace_membership collection:
{
"$id": "workspace_membership",
"$createdAt": "2025-01-08T08:54:55.354+00:00",
"$updatedAt": "2025-01-08T08:54:55.354+00:00",
"$permissions": [],
"databaseId": "dbid123",
"name": "workspace_membership",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "user_id",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false
},
{
"key": "role",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false,
"elements": ["OWNER", "ADMIN", "MEMBER", "GUEST", "VIEWER"],
"format": "enum",
"default": null
},
{
"key": "status",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false,
"elements": ["INVITED", "ACTIVE", "EXPIRED", "REVOKED"],
"format": "enum",
"default": null
},
{
"key": "invited_at",
"type": "string",
"status": "available",
"error": "",
"required": false,
"array": false
},
{
"key": "accepted_at",
"type": "string",
"status": "available",
"error": "",
"required": false,
"array": false
},
{
"key": "workspace_id",
"type": "string",
"status": "available",
"error": "",
"required": true,
"array": false
}
],
"indexes": []
}
What should I do to resolve this issue and correctly link the member to the workspace document?
Note: This issue only occurs when I try to add a member to a workspace. All other relationships are working fine.
Recommended threads
- Delete all database collections
In the program I had just created, everything was correct and working properly until I encountered an error that showed that the program did not show the data. ...
- Issue with OAuth Callback Parameters in ...
I'm using the createOAuth2Token() function and I have the following questions: First, I would like to know if the redirect link is correct. Second, when I try ...
- Help with running queries in n8n (self-h...
Hi, I'm trying to query a collection using n8n and Postman. Does anyone have any thoughts on where I am going wrong? Thanks in advance for any help! https://...