How to create object fields from array content using JQ

Question

I have following object:

{
  "base": "/templates",
  "title": "Templates",
  "categories": {
    "category1": {
      "propertiesResources": {
        "resources": {
          "cliTemplate": {
            "type": "CLIENT",
            "path": "properties/cli.json",
            "roles": [
              "ROLE_SYSTEM_READ",
              "ROLE_SYSTEM_WRITE"
            ]
          },
          "viewerTemplate": {
            "type": "SERVER",
            "path": "properties/server.json",
            "roles": [
              "ROLE_CONFIGURATOR_READ",
              "ROLE_CONFIGURATOR_WRITE"
            ]
          }
        }
      }
    }
  }
}

As you can see the field roles is an array which contains list of roles. The roles are guaranteed to be in this order. What I need is to replace the field roles with two new fields: roleRead and roleWrite where this new fields will have corresponding values from the array.

{
  "base": "/templates",
  "title": "Templates",
  "categories": {
    "category1": {
      "propertiesResources": {
        "resources": {
          "cliTemplate": {
            "type": "CLIENT",
            "path": "properties/cli.json",
            "readRole": "ROLE_SYSTEM_READ",
            "writeRole": "ROLE_SYSTEM_WRITE"
          },
          "viewerTemplate": {
            "type": "SERVER",
            "path": "properties/server.json",
            "readRole": "ROLE_CONFIGURATOR_READ",
            "writeRole": "ROLE_CONFIGURATOR_WRITE"
          }
        }
      }
    }
  }
}

Using this command I was able to get half way there

.categories[][].resources[].roles|={"readRole": .[0], "writeRole": .[1]}

https://jqplay.org/s/QPRMdXR0Os

Inian · Accepted Answer · 2021-04-22 08:12:12Z

2

One way would be to add the objects together with the .roles array and delete it after

.categories[][].resources[] |= ( 
  . + { readRole: .roles[0], writeRole: .roles[1] } | del(.roles)
)

^{jqplay demo}

edited Apr 22, 2021 at 8:12

answered Apr 22, 2021 at 8:05

Inian

87.1k15 gold badges167 silver badges183 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create object fields from array content using JQ

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related