基于“包含”进行的JsonPath表达式过滤?

5

我有一个样例Json响应如下:
我知道如何使用比较操作符,例如==>来筛选它。
例如,我可以使用$.books[?(@.pages > 460)]来检索大于460页的书籍,或者
类似地,使用$.books[?(@.pages != 352)]来检索不是352页的书籍。
但是如何过滤此Json,以检索标题包含“Java”子字符串或在2014年出版的书籍(实际上也是子字符串)呢?
示例Json如下:

{  
  "books": [  
    {  
      "isbn": "9781593275846",  
      "title": "Eloquent JavaScript, Second Edition",  
      "subtitle": "A Modern Introduction to Programming",  
      "author": "Marijn Haverbeke",  
      "published": "2014-12-14T00:00:00.000Z",  
      "publisher": "No Starch Press",  
      "pages": 472,  
      "description": "JavaScript lies at the heart of almost every modern web application, from social apps to the newest browser-based games. Though simple for beginners to pick up and play with, JavaScript is a flexible, complex language that you can use to build full-scale applications.",  
      "website": "https://eloquentjavascript.net/"  
    },  
    {  
      "isbn": "9781449331818",  
      "title": "Learning JavaScript Design Patterns",  
      "subtitle": "A JavaScript and jQuery Developer's Guide",  
      "author": "Addy Osmani",  
      "published": "2012-07-01T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 254,  
      "description": "With Learning JavaScript Design Patterns, you'll learn how to write beautiful, structured, and maintainable JavaScript by applying classical and modern design patterns to the language. If you want to keep your code efficient, more manageable, and up-to-date with the latest best practices, this book is for you.",  
      "website": "https://www.addyosmani.com/resources/essentialjsdesignpatterns/book/"  
    },  
    {  
      "isbn": "9781449365035",  
      "title": "Speaking JavaScript",  
      "subtitle": "An In-Depth Guide for Programmers",  
      "author": "Axel Rauschmayer",  
      "published": "2014-02-01T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 460,  
      "description": "Like it or not, JavaScript is everywhere these days-from browser to server to mobile-and now you, too, need to learn the language or dive deeper than you have. This concise book guides you into and through JavaScript, written by a veteran programmer who once found himself in the same position.",  
      "website": "https://speakingjs.com/"  
    },  
    {  
      "isbn": "9781491950296",  
      "title": "Programming JavaScript Applications",  
      "subtitle": "Robust Web Architecture with Node, HTML5, and Modern JS Libraries",  
      "author": "Eric Elliott",  
      "published": "2014-07-01T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 254,  
      "description": "Take advantage of JavaScript's power to build robust web-scale or enterprise applications that are easy to extend and maintain. By applying the design patterns outlined in this practical book, experienced JavaScript developers will learn how to write flexible and resilient code that's easier-yes, easier-to work with as your code base grows.",  
      "website": "https://chimera.labs.oreilly.com/books/1234000000262/index.html"  
    },  
    {  
      "isbn": "9781593277574",  
      "title": "Understanding ECMAScript 6",  
      "subtitle": "The Definitive Guide for JavaScript Developers",  
      "author": "Nicholas C. Zakas",  
      "published": "2016-09-03T00:00:00.000Z",  
      "publisher": "No Starch Press",  
      "pages": 352,  
      "description": "ECMAScript 6 represents the biggest update to the core of JavaScript in the history of the language. In Understanding ECMAScript 6, expert developer Nicholas C. Zakas provides a complete guide to the object types, syntax, and other exciting changes that ECMAScript 6 brings to JavaScript.",  
      "website": "https://leanpub.com/understandinges6/read"  
    },  
    {  
      "isbn": "9781491904244",  
      "title": "You Don't Know JS",  
      "subtitle": "ES6 & Beyond",  
      "author": "Kyle Simpson",  
      "published": "2015-12-27T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 278,  
      "description": "No matter how much experience you have with JavaScript, odds are you don’t fully understand the language. As part of the 'You Don’t Know JS' series, this compact guide focuses on new features available in ECMAScript 6 (ES6), the latest version of the standard upon which JavaScript is built.",  
      "website": "https://github.com/getify/You-Dont-Know-JS/tree/master/es6%20&%20beyond"  
    },  
    {  
      "isbn": "9781449325862",  
      "title": "Git Pocket Guide",  
      "subtitle": "A Working Introduction",  
      "author": "Richard E. Silverman",  
      "published": "2013-08-02T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 234,  
      "description": "This pocket guide is the perfect on-the-job companion to Git, the distributed version control system. It provides a compact, readable introduction to Git for new users, as well as a reference to common commands and procedures for those of you with Git experience.",  
      "website": "https://chimera.labs.oreilly.com/books/1230000000561/index.html"  
    },  
    {  
      "isbn": "9781449337711",  
      "title": "Designing Evolvable Web APIs with ASP.NET",  
      "subtitle": "Harnessing the Power of the Web",  
      "author": "Glenn Block, et al.",  
      "published": "2014-04-07T00:00:00.000Z",  
      "publisher": "O'Reilly Media",  
      "pages": 538,  
      "description": "Design and build Web APIs for a broad range of clients—including browsers and mobile devices—that can adapt to change over time. This practical, hands-on guide takes you through the theory and tools you need to build evolvable HTTP services with Microsoft’s ASP.NET Web API framework. In the process, you’ll learn how design and implement a real-world Web API.",  
      "website": "https://chimera.labs.oreilly.com/books/1234000001708/index.html"  
    }  
  ]  
}
4个回答

3

正如@gregsdennis所说,目前这完全取决于具体的实现。

在给定的JSONPath实现中,

  1. 此功能不存在
  2. 存在contains()函数或类似函数,例如Jawways语法:$..[?(@.title contains 'Java')]
  3. 有一个允许子字符串匹配的正则表达式特性,例如Jayway的Jsonpath有一个=~正则表达式过滤器:$..[?(@.title =~ /.*Java.*?/)]
  4. 进入脚本评估以进行过滤(JavaScript,大多数其他宿主语言都没有),例如Goessner和任何JS实现: $..[?(@.title && @.title.includes('Java'))]
    注意: includes()是ES6函数,实际的JSONPath语法也有些独特。

Christoph Burgmer维护了一个很好的JSONPath比较表。


谢谢! 我在 https://jsonpath.com/ JSONPath Online Evaluator 上尝试了这个,发现只有 $..[?(@.title && @.title.includes('Java'))] 能够正确工作! $..[?(@.title =~ /.Java.?/)] 的输出是错误的。输出数量甚至比输入还多。 $..[?(@.title contains 'Java')] 看起来是错误的表达式。输出显示“无匹配项”。 - Prophet
1
@Eliyahu 很高兴能帮助您。脚本评估示例在上面的求值器中起作用,因为该站点使用了JSONPath-Plus(它是从Goessner's JS派生而来),并在JavaScript下进行编写(https://github.com/ashphy/jsonpath-online-evaluator/blob/ebc361377d1f72a43d96bbde6318792ddc3d00a8/package.json)。您可以在此处尝试其他实现方式 https://jsonpath.herokuapp.com/,例如Jayway的。 - wp78de

1
如果您想使用Rest Assured提取值,可以使用以下代码部分获取所需的值。
 .get("/endpooint")
      .then()
      .extract()
      .path("books.find{it.title =~ 'Java'}");

1

原始的JSON Path不能做到这一点,但根据您使用的实现方式,它可能得到支持。

我们目前正在编写正式规范。其中一个未解决的问题是我们想要的表达式支持广度。欢迎添加评论。一旦规范被定义和发布,我想大多数实现都会更新以遵守规范。


谢谢您的回答。对我来说,这样一个基本且有用的功能仍然没有得到支持听起来很奇怪。 - Prophet
1
这与它不受支持的问题不太相关,更多的是因为没有正式的规范来支持它。这意味着实现者需要超出已接受的定义(即博客文章)来创建此功能。 - gregsdennis

0

您可以这样在jsonpath中使用LIKE:

$..[?(@.title like_regex '.*Java.*')]

网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接