How to sort a json file by keys and values of those keys in jq

We’re building a website using the Pentaho CTools library, which has a graphical dashboard editor which writes out JSON-format files for part of the dashboard.

I’d like to apply a transform to these files before check-in to git in order to sort them by key and then by the value of certain keys. The purpose is to make diffs easier, since the editor has a habit of rearranging all of the json fields.

For example, we might have something like this:

{
  "components": {
    "rows": [
      {
        "id": "CHARTS",
        "name": "Charts",
        "parent": "UnIqEiD",
        "properties": [
          {
            "name": "Group",
            "type": "Label",
            "value": "Charts"
          }
        ],
        "type": "Label",
        "typeDesc": "<i>Group</i>"
      },
      {
        "id": "kjalajsdjf",
        "meta_cdwSupport": "true",
        "parent": "CHARTS",
        "properties": [
          {
            "name": "name",
            "type": "Id",
            "value": "Value1"
          },
          {
            "name": "title",
            "type": "String",
            "value": "Value2"
          },
          {
            "name": "listeners",
            "type": "Listeners",
            "value": "[]"
          },
...

We are able to jq --sort-keys (http://stedolan.github.io/jq/) to sort all of the keys, but I’m struggling to find out how to use the sort_by function to then sort certain specific elements by the value of certain keys (so, in the example above, sorting by properties.name for example. Any ideas?

Related Posts:

  1. Select objects based on value of variable in object using jq
  2. How to install JQ on Mac on the command line?
  3. How to remove the quotes when reading a variable in jq in shell?
  4. Can comments be used in JSON?
  5. Can comments be used in JSON?
  6. Angular: ‘Cannot find a differ supporting object ‘[object Object]’ of type ‘object’. NgFor only supports binding to Iterables such as Arrays’
  7. Grabbing the current viewer count for youtube live streaming
  8. Use of PUT vs PATCH methods in REST API real life scenarios
  9. What is the easiest way to convert an Excel spreadsheet with tabular data to JSON? [closed]
  10. uncaught syntaxerror unexpected token U JSON
  11. Representing null in JSON
  12. Fastest JSON reader/writer for C++
  13. Representing null in JSON
  14. YAML equivalent of array of objects in JSON
  15. Parsing a JSON string in Ruby
  16. Are multi-line strings allowed in JSON?
  17. Remove properties from objects (JavaScript)
  18. Python/Json:Expecting property name enclosed in double quotes
  19. Why do i need `typings.json` file in an Angular 2 project?
  20. Best way to save data in Unity game
  21. Javascript Object push() function
  22. How do you represent a JSON array of strings?
  23. Using Wikipedia API on custom wikis like Bulbapedia
  24. How to import a JSON file in ECMAScript 6?
  25. UnicodeDecodeError: ‘utf8’ codec can’t decode byte 0x80 in position 3131: invalid start byte
  26. How to parse Excel (XLS) file in Javascript/HTML5
  27. XSLT equivalent for JSON
  28. RestClientException: Could not extract response. no suitable HttpMessageConverter found
  29. Is there a query language for JSON?
  30. Why do i need `typings.json` file in an Angular 2 project?
  31. How do I make a JSON object with multiple arrays?
  32. An error occurred while installing json (1.8.1), and Bundler cannot continue – Rails
  33. JSON and escaping characters
  34. [npm notice created a lockfile as package-lock.json. You should commit this file
  35. using wp_remote_get instead of file_get_contents [duplicate]
  36. Show popular post in another php website via WP REST JSON API
  37. What are the Oembed Links For?
  38. Get Image URL instead of Attachment Id in Rest API
  39. What is /wp-json?
  40. Import JSON feed to WordPress
  41. Include custom post meta value in fetched JSON
  42. Unset data in custom post type WordPress API (wp-json)
  43. How to retrieve wp_ json_encode data from custom WordPress database table
  44. How to use the new WordPress 4.4 JSON API?
  45. Importing JSON feed should the content be sanitized?
  46. WP REST API – Retrieve content from page
  47. Create filtered list of posts using JSON data
  48. wordpress API for android app
  49. Android authentication
  50. WordPress JSON API returns normal site page in html. How do I get it to give me JSON?
  51. Create multiple posts with WP REST API at once
  52. Passing Meta array in wp-rest api
  53. Have WordPress generate a JSON of the content
  54. Inserting custom post meta value using WP-REST API
  55. Adding JSON Structured Data to WordPress
  56. WP REST API format response
  57. esc_attr() corrupts json values
  58. JSON API plugin, Get posts by category return no post
  59. Pre insert data when adding new custom post fire a json error
  60. Generate/save JSON or XML file from JSON script
  61. Cannot parse results from wp_remote_get
  62. WordPress Unexpected token < in JSON at position 0
  63. Update the values ​of a json file in wordpress [closed]
  64. How to send s2member plugin’s wordpress user data in json format to a url in php [closed]
  65. Create and Update a Json file
  66. How to display json_encode via $wpdb
  67. Why is json_decode failing?
  68. How to get a custom entry field label with Gravity Forms?
  69. JSON API not showing full content
  70. JSON-LD: creating an AggregateOffer from many shortcode
  71. Strange “lea” prefix on wp-json
  72. How to display partial values of JSON Encode values
  73. Retrieving a JSON feed of my posts and displaying thumbnails
  74. uneven behaviour create a post in using json api with white spaces
  75. XML to Json code issue
  76. WordPress restrict access to rest only
  77. Import JSON feed into WordPress Post (wp_insert_post) every 24 hours
  78. Sending a post request with JSON content type
  79. A special character I am trying to include in a page keeps getting rejected with error “Updating failed. The response is not a valid JSON response.”
  80. wp-json how to fetch image link?
  81. Automatically import content to wordpress from a json file
  82. JSON api oembed youtube
  83. Wrong encoding of dynamic block properties problem
  84. i am using api add post in wordpress
  85. Add binary or json animation to wordpress site
  86. Run hook in functions.php from page link
  87. JSON Schema Output Object rather than Array
  88. Add custom schema to post
  89. How can cookie/session authentication be used in wp-json fetch request?
  90. Get the name of the post type
  91. Pull Content from JSON file (Same Server)
  92. Dynamic data table from external json feed
  93. return content section as json in wp rest api v1
  94. Remove a field from json in wp rest api v1
  95. Get JSON from self hosted wordpress site
  96. how build custom json api controller for all registered users
  97. WP REST API get all posts (or customs posts) for a React app
  98. How do i save this python code to text file.? [closed]
  99. Custom Backend data for map to JSON file?
  100. Fatal error in custom end point in WP-JSON

Leave a Comment