2

I've a problem so you will safe my life :-)

when I run the following command from aws-shell

cloudformation describe-stacks --query Stacks[*].[StackName,StackId,CreationTime,LastUpdatedTime,Parameters[?ParameterKey==\`PARAM_NAME1\`].ParameterValue,Parameters[?ParameterKey==\`PARAM_NAME2\`].ParameterValue] --output text

the result is splitted on 3 rows:

automation-X arn:aws:cloudformation:X X None
PARAM_VALUE1
PARAM_VALUE2

but my goal is to have only one row (like this)

automation-X arn:aws:cloudformation:X X None PARAM_VALUE1 PARAM_VALUE2

that is, having PARAM_VALUE1 and PARAM_VALUE2 on the first and only line.

can anyone help me?

I appreciate it, thank you in advance

I forgot to indicate that the result of the command are many lines (more than 1000) and each line is composed of 6 parameters

Angelo Pisaturo
  • 39
  • 7

1 Answers1

2

The expression 

Parameters[?ParameterKey==`PARAM_VALUE1`].ParameterValue

returns a projection that itself returns an array of ParameterValues. Even though that array only contains one item, the aws --output text mode still interprets it as a new line. To fix this, you need to convert the projection into a single value using a pipe | to stop the projection, then choose the first item in the array:

aws cloudformation describe-stacks --query 'Stacks[*].[StackName,StackId,CreationTime,LastUpdatedTime,Parameters[?ParameterKey==`PARAM_NAME1`].ParameterValue|[0],Parameters[?ParameterKey==`PARAM_NAME2`].ParameterValue|[0]]' --output text

You'll see the |[0] added to each parameter in the query.

Justin Howard
  • 5,504
  • 1
  • 21
  • 48