什么是正确的 JsonPath get() 格式，用于选择 JSON 对象数组中的字段值

Question

我正在放心地进行 API 发布调用并在正文中获得响应。然后，我需要获取此响应并选择特定的字段值并将它们存储为字符串，以便稍后与其他字符串对象进行比较。我编写了 jsonpath 来获取顶级字段值（如 id、状态、类型、国家等），但是当我必须进入返回的 json 数组中的一个对象时，我无法正确获取格式get() 方法。

以下是返回的 Json 示例：

{

  "id": "ABC123",

  "status": "NEW",

  "type": "PERSONAL",

  "country": "United States",

  "totalBalances": {},

  "availableBalances": {},

  "fields": [

    {

      "fieldType": "mobilephone",

      "value": "14216904425",

      "fieldId": "personalMobileNumber"

    },

    {

      "fieldType": "email",

      "value": "[e-mail]",

      "fieldId": "personalEmail"

    },

    {

      "fieldType": "STRING",

      "value": "John Doe",

      "fieldId": "individualName"

    }

  ]

}

这是我试图格式化以适应 get() 方法的 json 路径，但每次我都得到一个非法参数异常（java.lang.IllegalArgumentException：无效的 JSON 表达式）我试图让它工作。基本上我需要在数组中识别正确的对象并获取正确的字段值。在这种情况下，这是 fieldId 字段，我想要字段“值”值（John Doe），以便我可以将其保存到 String 对象：

JsonPath pathToAccountName = response.jsonPath();

String accountName = pathToAccountName.get("fields[?(@.fieldId=='individualName')].value")

我使用https://jsonpath.curiousconcept.com/来获取 VALID json 路径：

$.fields[?(@.fieldId=='individualName')].value

但是我尝试了一切将其转换为 get() 方法可以接受的东西，但没有运气。搜索这里的所有帖子和放心的技术文档也没有帮助。

Answer 1

Rest Assured 使用 Groovy 的 Gpath。因此，您的查询可能如下所示：JsonPath pathToAccountName = response.jsonPath();String value = jsonPath.getString("fields.find { it.fieldId == 'individualName' }.value");在这里您可以找到一些示例（它是关于处理 XML，但也适用于 JSON）： http: //groovy-lang.org/processing-xml.html

Answer 2

我需要知道如何获得这个输出 -JSON 文档 -{ "status": "E000", "customerId": "VjAxI2VhNzg5ZmJlLWIyNjAtNGZlOS1iZDNkLTdjMmU1MjA2ZmVhZA", "merchantId": "1", "cards": [ { "cardType": "DEBIT", "cardIssuer": "AXIS", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "ICICI Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "HDFC Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "ICICI Bank", "cardBrand": "VISA", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "DEBIT", "cardIssuer": "Punjab National Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "ICICI Bank", "cardBrand": "MASTERCARD", "nickName": null, "expired": null, "cardMigrationStatus": "DONE", "tur": null, "category": null } ], "status_mssg": null }我想要这个输出 - [ { "cardType": "DEBIT", "cardIssuer": "AXIS", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "ICICI Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "CREDIT", "cardIssuer": "HDFC Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null }, { "cardType": "DEBIT", "cardIssuer": "Punjab National Bank", "cardBrand": "MASTERCARD", "nickName": "", "expired": "false", "cardMigrationStatus": "OPEN", "tur": null, "category": null } ] 我正在使用这个 - jsonPathValidator.getString("$.cards[?(@.cardMigrationStatus == 'OPEN' && @.cardBrand == 'MASTERCARD')]");但没有得到输出。