Dev MCP 26.6.1 createRecordType failing
Dev MCP 26.6.100
Appian Cloud 26.6
When attempting to createRecordType, it fails.
Is it possible dataSourceName isn’t listed as a required field in the docs, so Claude’s not attempting to populate it?
Command
appian - createRecordType (MCP)(name: "DDQ Ref Request Status", pluralName: "DDQ Ref Request Statuses", sourceType: "DATABASE", appUuid: "_a-0000f064-1c7f-8000-9bed-011c48011c48_284991", dataSourceUuid: "_a-0000f064-1c7f-8000-9bed-011c48011c48_285094", schema: "DDQ", tableName: "DDQ_REF_REQUEST_STATUS", createTable: true, description: "Reference table of DDQ Request statuses (D-49).", fields: [{"fieldName":"id","fieldType":"INTEGER","isPrimaryKey":true},{"fieldName":"code","fieldType":"TEXT","length":50},{"fieldName":"value","fieldType":"TEXT","length":100},{"fieldName":"sortOrder","fieldType":"INTEGER"},{"fieldName":"createdBy","fieldType":"USER"},{"fieldName":"createdOn","fieldType":"DATETIME"},{"fieldName":"modifiedBy","fieldType":"USER"},{"fieldName":"modifiedOn","fieldType":"DATETIME"},{"fieldName":"isActive","fieldType":"BOOLEAN"}])
Error: API error (HTTP 400): 'dataSourceName' is required because more than one data source is available. Valid values are: '_a-0000ed5d-ecad-8000-9bba-011c48011c48_89360' (IE Interview Exercise Connected System), '_a-0000ed5d-ecad-8000-9bba-011c48011c48_89896' (IE3 Connected System), '_a-0000ed5d-ecad-8000-9bba-011c48011c48_89820' (IE2 Connected System Interview Test Excercise), '_a-0000ee97-26c4-8000-9bc3-011c48011c48_130880' (NEM Connected System), '_a-0000ee97-26c4-8000-9bc3-011c48011c48_131436' (DOD Connected Sysem), '_a-0000eed0-b775-8000-9bc7-011c48011c48_143502' (AIA Connected System), '_a-0000eee6-419f-8000-9ba4-011c48011c48_16109' (CIE MariaDB Connected System), '_a-0000efb8-8771-8000-9bdb-011c48011c48_232946' (DRA Connected System), '_a-0000efc3-218f-8000-9c42-011c48011c48_2990251' (PMH MariaDB Connected System), '_a-0000f064-1c7f-8000-9bed-011c48011c48_285094' (DDQ MariaDB Data Source), 'jdbc/AIA' (jdbc/AIA), 'jdbc/CMGT' (jdbc/CMGT), 'jdbc/TM' (jdbc/TM), 'jdbc/Appian' (jdbc/Appian). Not every data source permits table creation, so the correct one has to be named. GET /data-sources lists them with their database types
Here’s what Claude said about it::
That's exactly where it fails — HTTP 400, 'dataSourceName' is required, even though I passed the exact data source UUID it lists as a valid value. This confirms the same tool defect I hit on the first table: createRecordType's dataSourceUuid parameter isn't reaching the underlying API when the site has multiple data sources (which this shared environment does — 14+). Let me confirm nothing partial got left behind.