I'm thinking about experimenting with replacing the filters in #FCLI with something more general purpose, inspired by #procmail recipes.

Procmail uses regular expressions on email headers (and bodies), so I wonder what the equivalent is for #JSON documents. Is this an #XPath like use case? I started looking for the JSON equivalent of XPath, and found #JSONPath, and then realised that XPath supports JSON natively nowadays.

JSON Path Expressions Extract Data?!

JSON_EXTRACT uses PATH syntax! The $ symbol means root, . means property access. This JSON path language will confuse you!

#sql #sqltricks #jsonextract #jsonpath #jsonunquote #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #jsonfunctions #advancedsql

https://www.youtube.com/watch?v=rlETEK19huU

JSON Path Expressions Extract Data?! #advancedsql

YouTube

#python
[Lapidary](https://pypi.org/project/lapidary/) 0.12.0 - Web API client

[Lapidary render](https://pypi.org/project/lapidary-render) 0.12.1 - OpenAPI client generator

#typescript
[Betterer-json](https://www.npmjs.com/package/betterer-json) 1.0.2 - json processing with #jsonpath and #JavaScript

#programming

Client Challenge

Stop wasting time scrolling through endless JSON.

Learn to use JSONPath to find the exact data you need, instantly. Our new guide shows you how.

#API #Developer #JSONPath #ProgrammingTips #APITestingGuides #TestingGuides #Guides

Read Mastering JSONPath: https://link.apiorbit.pro/JsonPath

For a detailed explanation of the syntax used - JSONpath - and the differences in uBlock Origin's implementation of it, see the multiline comment at https://github.com/gorhill/uBlock/blob/master/src/js/jsonpath.js#L23

#uBlockOrigin #JSONPath

uBlock/src/js/jsonpath.js at master · gorhill/uBlock

uBlock Origin - An efficient blocker for Chromium and Firefox. Fast and lean. - gorhill/uBlock

GitHub
AWS Step Functions で JSONata を使用するデータ変換方法と具体例の紹介 - Qiita

はじめにAWS Step Functionsは、サーバレスでワークフローの構築を容易にするサービスです。Step Functionsがリリースされた当初は、主に複数のAWS Lambdaの関数を…

Qiita

TIL: There is a compliance test suite for #JSONPath https://github.com/jsonpath-standard/jsonpath-compliance-test-suite

Is anybody up for maintaining a #ruby gem to implement this? I can give feedback, but I don't think I am up for the task.

GitHub - jsonpath-standard/jsonpath-compliance-test-suite: A Compliance Test Suite for the JSONPath Internet Draft

A Compliance Test Suite for the JSONPath Internet Draft - jsonpath-standard/jsonpath-compliance-test-suite

GitHub
betterer-json

Automated JSON editing tool. Latest version: 1.0.0, last published: 5 minutes ago. Start using betterer-json in your project by running `npm i betterer-json`. There are no other projects in the npm registry using betterer-json.

npm

I'm writing a simple script to make small adjustments in #json documents with #jsonPath and #javaScript .

Well it was simple until I wanted to add #yaml support and process a document with ISO formatted date-time strings.

How to force any YAML package to quote date-time strings without quoting all strings?

#programming #nodeJs

RFC 9535: JSONPath: Query Expressions for JSON

Le langage #JSONPath sert à désigner une partie d'un document #JSON. Il est donc utile pour, par exemple, extraire des valeurs qui nous intéressent.

#RFC

https://www.bortzmeyer.org/9535.html

Blog Stéphane Bortzmeyer: RFC 9535: JSONPath: Query Expressions for JSON