how to get the second element of json

Question

I have this JSON

[
  ["pimenta & guedes", "Rodrigo"],
  ["24", "29"],
  ["32", "10"],
  ["77", "5"],
  ["Cartao", ""]
]

How can I get the second element, Rodrigo?

I am using Robot Framework and I have tried this command :

${FILECONTENT}=    Get File    c:/aa/webdemo-master2/login_tests/sample.txt
#Log to console    ${FILECONTENT}
${JSON}=  evaluate  json.loads($FILECONTENT)  json
Log to console  ${JSON}
Log  Hello, my name is ${JSON[0]}

But the result is (Hello, my name is ['pimenta & guedes', 'Rodrigo'])

But I would like to get (Hello, my name is Rodrigo)

Thanks in advance.

Does this answer your question? [Json handling in ROBOT](https://stackoverflow.com/questions/35262216/json-handling-in-robot) — forkdbloke, Dec 12 '19 at 05:37

score 5 · Answer 1 · answered Dec 12 '19 at 03:04

5

Your JSON is a two dimensional array. ${JSON[0][1]} should give you what you are looking for.

answered Dec 12 '19 at 03:04

Nabin

166
3
11

hy Nabin.. I tryed (Log Hello, my name is ${JSON[0][1]}) but it produce this error : FAIL Invalid log level 'Rodrigo'. – Eduardo Dec 12 '19 at 10:45

how to get the second element of json

1 Answers1