using jq I want to output json object within a json object including the keys not just the value

Question

I have this stored as a file:

{
  "Targets": [
    {
      "Id": "xxx_hourly_cron",
      "Arn": "arn:aws:ecs:eu-west-2:000000000000:cluster/drupal-cluster",
      "RoleArn": "arn:aws:iam::000000000000:role/ecsEventsRole",
      "EcsParameters": {
        "TaskDefinitionArn": "arn:aws:ecs:eu-west-2:000000000000:task-definition/xxx-cron:55",
        "TaskCount": 1,
        "EnableECSManagedTags": false,
        "EnableExecuteCommand": false,
        "PropagateTags": "TASK_DEFINITION"
      }
    }
  ]
}

Using bash and jq I want to trim it down this this:

{
  "TaskDefinitionArn": "arn:aws:ecs:eu-west-2:000000000000:task-definition/xxx-cron:55",
  "TaskCount": 1,
  "EnableECSManagedTags": false,
  "EnableExecuteCommand": false,
  "PropagateTags": "TASK_DEFINITION"
}

I have tried this but it does not output the keys:

cat rule-target.json | jq '(.Targets[] .EcsParameters[])'

Andreas Louv · Accepted Answer · 2022-01-16 21:03:06Z

3

You are so close:

$ jq '.Targets[].EcsParameters' rule-target.json 
{
  "TaskDefinitionArn": "arn:aws:ecs:eu-west-2:000000000000:task-definition/xxx-cron:55",
  "TaskCount": 1,
  "EnableECSManagedTags": false,
  "EnableExecuteCommand": false,
  "PropagateTags": "TASK_DEFINITION"
}

As EcsParameters isn't an array, you shouldn't unwrap it ([]).

Usually it's a useless use of cat when doing cat file | cmd, many commands takes files as arguments:

cmd -flag -flag2 file1.txt file2.txt

and if they don't then you can redirect stdin:

cmd -flag -flag2 < file1.txt

edited Jan 16, 2022 at 21:03

answered Jan 16, 2022 at 21:00

Andreas Louv

47.3k14 gold badges109 silver badges126 bronze badges

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

1 Comment

Léa Gris Over a year ago

So many jq experts now. Your answer is optimal. Bravo!

larsks · Accepted Answer · 2022-01-16 20:59:49Z

1

I think you want:

jq '(.Targets[]|.EcsParameters)' rule-target.json

Which results in:

{
  "TaskDefinitionArn": "arn:aws:ecs:eu-west-2:000000000000:task-definition/xxx-cron:55",
  "TaskCount": 1,
  "EnableECSManagedTags": false,
  "EnableExecuteCommand": false,
  "PropagateTags": "TASK_DEFINITION"
}

answered Jan 16, 2022 at 20:59

larsks

318k50 gold badges474 silver badges482 bronze badges

Comments

Barbaros Özhan · Accepted Answer · 2022-01-16 21:05:13Z

1

You can use

jq '.Targets[] | .EcsParameters' rule-target.json

Demo

array wrappers seen in the current case remove the object wrappers

edited Jan 16, 2022 at 21:05

answered Jan 16, 2022 at 20:59

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Collectives™ on Stack Overflow

using jq I want to output json object within a json object including the keys not just the value

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related