Creating Selection Column via API fails

[EEngl52]

Steps to reproduce

1. Create a new table in OCS api viewer with api 2
2. Execute Post request for /ocs/v2.php/apps/tables/api/2/columns/selection
   This is my request body:

{
  "baseNodeId": 15,
  "title": "Type of project",
  "selectionOptions": [
  {
	"id": 0,
	"label": "Lab experiment"
  },
  {
	"id": 1,
	"label": "Field experiment"
  }
],
  "subtype": "multi",
  "baseNodeType": "table"
}

Expected behavior

a selection column should be created just like it works with other column types

Actual behavior

An Internal Server Error is thrown

Here's the logging:

{"reqId":"5pmCU5A3eBieludG6vsv","level":3,"time":"2025-12-05T10:21:39+01:00","remoteAddr":"XXX","user":"XXX","app":"no app in context","method":"POST","url":"/ocs/v2.php/apps/tables/api/2/columns/selection","message":"Invalid node ID","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.11.3","exception":{"Exception":"OCA\\Tables\\Errors\\InternalError","Message":"Invalid node ID","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/tables/lib/Middleware/PermissionMiddleware.php","line":60,"function":"checkPermission","class":"OCA\\Tables\\Middleware\\PermissionMiddleware","type":"->"},{"file":"/var/www/nextcloud/apps/tables/lib/Middleware/PermissionMiddleware.php","line":48,"function":"assertPermission","class":"OCA\\Tables\\Middleware\\PermissionMiddleware","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Middleware/MiddlewareDispatcher.php","line":73,"function":"beforeController","class":"OCA\\Tables\\Middleware\\PermissionMiddleware","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":106,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\MiddlewareDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/tables/lib/Middleware/PermissionMiddleware.php","Line":73,"message":"Invalid node ID","exception":[],"CustomMessage":"Invalid node ID"},"id":"6932b0f1a4fb2"}

Tables app version

1.0.1

Browser

140.3.0esr

Client operating system

Windows

Operating system

Linux

Web server

None

PHP engine version

PHP 8.2

Database

MySQL

Additional info

No response

[blizzz]

Hi @EEngl52 and thanks for reporting.

I understand you double check the baseNodeId and baseNodeType parameters, as well as the authenticated details?

There should not be any difference compared to creating Number, Text, DateTime or UserGroup columns.

[EEngl52]

yes, baseNodeId, baseNodeType and authentification are correct and I can also add other column types with these parameters to the very same table.

I just tried out the request above again, interestingly I got a different error message now:

{"reqId":"ugvIxeqH9tyZ4z2uKsOQ","level":3,"time":"2025-12-08T14:00:15+01:00","remoteAddr":"XXX","user":"XXX","app":"no app in context","method":"POST","url":"/ocs/v2.php/apps/tables/api/2/columns/selection","message":"OCA\\Tables\\Controller\\ApiColumnsController::createSelectionColumn(): Argument #3 ($selectionOptions) must be of type string, array given, called in /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 200 in file '/var/www/nextcloud/apps/tables/lib/Controller/ApiColumnsController.php' line 233","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.11.3","exception":{"Exception":"Exception","Message":"OCA\\Tables\\Controller\\ApiColumnsController::createSelectionColumn(): Argument #3 ($selectionOptions) must be of type string, array given, called in /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 200 in file '/var/www/nextcloud/apps/tables/lib/Controller/ApiColumnsController.php' line 233","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","Line":146,"Previous":{"Exception":"TypeError","Message":"OCA\\Tables\\Controller\\ApiColumnsController::createSelectionColumn(): Argument #3 ($selectionOptions) must be of type string, array given, called in /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 200","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"createSelectionColumn","class":"OCA\\Tables\\Controller\\ApiColumnsController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/tables/lib/Controller/ApiColumnsController.php","Line":233},"message":"OCA\\Tables\\Controller\\ApiColumnsController::createSelectionColumn(): Argument #3 ($selectionOptions) must be of type string, array given, called in /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 200 in file '/var/www/nextcloud/apps/tables/lib/Controller/ApiColumnsController.php' line 233","exception":[],"CustomMessage":"OCA\\Tables\\Controller\\ApiColumnsController::createSelectionColumn(): Argument #3 ($selectionOptions) must be of type string, array given, called in /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 200 in file '/var/www/nextcloud/apps/tables/lib/Controller/ApiColumnsController.php' line 233"},"id":"6936cc2d2491b"}

[joshtrichards]

selectionOptions must be a stringified / a JSON string, not an array. e.g.:

"selectionOptions": '[{"id":0,"label":"Lab experiment"},{"id":1,"label":"Field experiment"}]'

The OpenAPI entry for this appears to be missing. You can see it in the API v1 though.

[EEngl52]

Many thanks for the hint! It finally worked for me with this API call:

{
  "baseNodeId": 15,
  "title": "Type of project",
  "selectionOptions": "[{\"id\": 0, \"label\": \"Lab experiment\"},{\"id\": 1, \"label\": \"Field experiment\"}]",
  "subtype": "multi",
  "baseNodeType": "table"
}

[joshtrichards]

Glad to hear it!

P.S. Missing section of v2 docs should return soon via #2323