AWS CLI DynamoDB with shell variable

Question

I am trying to put a variable in the AWS CLI DynamoDB command for add a row in a table:

aws dynamodb put-item --table-name table_name --item '{"id_proceso": {"N": "1"}, "fecha_proceso": {"S": "20210707170486"}, "status": {"S": "OK"}, "fecha_termino": {"S": "fecha_termino_var"  } }' --region us-east-1

Where fecha_termino_var it should be a variable. example: fecha_termino_var=(date +'%Y/%m/%d %H:%M:%S')

but I have tried various ways but I have not managed to do it, is there any way to enter a variable in a aws cli command line?

The goal it is to add a row, which will contain a variable of the date in real time.

I've tried various ways but it just adds the variable type, in this case "date", or just the variable name in text plain "fecha_termino_var".

I'm working in a shell (.sh) to do this.

Failed image adds:

" without success" its not specific. Exactly what is happening? Why do you have space in $ {date}? Why do you use single quotes? — Marcin
– Marcin, Commented Jul 9, 2021 at 3:26
what date=(date +'%Y/%m/%d %H:%M:%S') is supposed to do? Can you explain? You are overwriting date with date? — Marcin
– Marcin, Commented Jul 9, 2021 at 3:27
without success I mean that sometimes it inserts the row but only the text or it gives syntax error — Sebastián
– Sebastián, Commented Jul 9, 2021 at 3:28
"date" is just an example to save the date inside that column, it doesn't necessarily have to have the same variable name. the goal is to save a variable within the command line — Sebastián
– Sebastián, Commented Jul 9, 2021 at 3:29
This is date=(date +'%Y/%m/%d %H:%M:%S') wrong. Is this bash? What do you think it does? — Marcin
– Marcin, Commented Jul 9, 2021 at 3:32

Marcin · Accepted Answer · 2021-07-09 04:27:49Z

1

Your screenshot shows that you are missng " infront of fecha_termino. So it should be:

, "fecha_termino":

not:

, fecha_termino":

Update:

The full correct command is:

aws dynamodb put-item --table-name mcp_control_proceso --item '{"id_proceso": {"N": "1"}, "fecha_proceso": {"S": "20210707170487"}, "status": {"S": "OK"}, "fecha_termino": {"S": "'"${fecha_termino_var}"'"} }' --region us-east-1

edited Jul 9, 2021 at 4:27

answered Jul 9, 2021 at 3:42

Marcin

241k16 gold badges315 silver badges368 bronze badges

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

12 Comments

Sebastián Over a year ago

thanks for the answer, after this fix it adds the row, but in another way like "$fecha_termino" prnt.sc/19n297b

Marcin Over a year ago

@Sebastián This is due to single quotes. Check my first comment "Why do you use single quotes? " Don't use single quotes to wrap your string. It does not resolve veriables.

Sebastián Over a year ago

How it should be? The code I added last one it's: "fecha_termino": {"S": "$fecha_termino" }

Marcin Over a year ago

@Sebastián Sorry, I don't know. Your real code is different than in the question. Its difficult to speculate what actually you are actually using.

Sebastián Over a year ago

sorry, already fixed, I just want to insert a variable inside variable, "data": {"S": "$variable"} but it seems to be very difficult

|

Collectives™ on Stack Overflow

AWS CLI DynamoDB with shell variable

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related