使用Postman调用OmniIndex API查询为何仅返回部分数据？

问题详情 #

通过Postman调用OmniIndex API检索存储文件数据时，加密字段均被替换为Data has been redacted.，完整响应如下：

{
    "results": [
        {
            "author": "Data has been redacted.",
            "context": "",
            "context2": "",
            "directory": "Data has been redacted.",
            "filecreateddate": "2023-05-19 13:54:47",
            "fileextension": "pdf",
            "filemodifieddate": "2023-05-19 14:03:34",
            "filename": "Data has been redacted.",
            "filesize": "1860991",
            "fullpath": "Data has been redacted.",
            "sentiment": "",
            "sentiment2": ""
        }
    ]
}

使用的请求JSON（不含凭证）：

{
    "analyticQuery": "SELECT authorowners, context, context2, sentiment, sentiment2, directoryowners, 
filecreateddate, filemodifieddate, fileextension, filenameowners, filesize, fullpathowners FROM WHERE
 hash='AFD0C8D2B777D056F2D23D4A4FB7D18BD238533317F6B3F9EF0589FB5784B8B3'",
    "password": "",
    "unitName": "",
    "user": "",
    "server": ""
}

排查与解决建议 #

• 修正查询字段名：请求的analyticQuery中使用的authorowners、directoryowners、filenameowners、fullpathowners，和响应返回的实际字段author、directory、filename、fullpath不匹配。API可能因字段名无法映射，返回脱敏数据。将查询中的字段替换为响应里的对应名称，重新发起请求。
• 校验凭证与权限：确保user、password、unitName、server参数填写正确，且当前账号拥有该文件的解密访问权限。OmniIndex的脱敏逻辑通常触发于权限不足或凭证无效。
• 修复SQL语法错误：查询语句中FROM WHERE存在语法问题，正确结构应为FROM [目标表名] WHERE，需补充对应的存储表名（参考OmniIndex官方文档确认表名）。语法错误会导致API处理异常，返回默认脱敏结果。
• 检查解密配置参数：若存储文件时设置了特殊解密规则，查看API文档是否需要额外参数（如解密密钥标识）来触发解密逻辑，确保请求中包含必要的解密相关参数。

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