通过Keboola向Clever Maps添加数据运行addMetadata出现报错如何解决

你执行addMetadata操作时报错的核心原因是提交的元数据字段不符合Clever Maps的命名校验规则，校验正则为^[a-z][a-z0-9_-]*$，具体要求如下：

• 首字符必须是小写英文字母
• 后续字符仅支持小写英文字母、数字、下划线_、短横线-三类字符
• 不允许出现大写字母、中文、空格、其他特殊符号

• 打开你提交的JSON元数据文件，定位到ref.properties数组
• 按照报错提示的下标逐一检查对应column/name字段，比如报错$.ref.properties[41].column对应数组第42个元素的column字段（数组下标从0开始计数）
• 把所有不符合规则的字段名修改为满足要求的格式，常见违规情况包括：首字符为数字/大写字母、字段包含空格、包含中文、包含./&/@等特殊字符
• 若字段名是从Keboola同步而来，需要先在Keboola侧完成字段名的格式调整，再执行元数据提交操作

你提交的报错详情如下：

Error description=Field '$.ref.properties[41].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[20].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[37].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[33].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[38].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[21].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[3].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[6].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[26].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[32].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[8].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[23].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[4].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[35].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[33].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[39].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[28].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[1].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[3].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[17].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[27].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[19].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[4].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[10].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[22].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[40].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[21].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[32].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[0].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[24].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[15].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[29].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[14].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[40].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[25].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[29].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[36].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[5].column' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[7].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[28].name' must match ^[a-z][a-z0-9_-]*$, Field '$.ref.properties[37].column' must match 

内容的提问来源于stack exchange，提问作者Petra T