Fetching a variable inside a list in ROBOT Framework

Question

Suppose the below is my response body

body={
  "message": {
    "Code": 26181,
    "rollnos": [
      {
        "ID": 1439173,
        "date_input": "2022-01-31 14:09:30.206748",
      }
    ],
    "start_date": "2022-01-31 00:00:00",
  }
}

I want to set the ID value in a variable. I have tried the below but it did not work out.

  ${json_response}=  set variable    ${xyz.json()}
  
  ${temp}=  Set Variable    ${json_response['message']}
  
  ${value_1}=  Set Variable    ${temp['rollnos']}
  
  ${register_id} =  Set Variable    ${value_1["ID"]

Where have I gone wrong in this?

Dan Constantinescu · Accepted Answer · 2022-01-31 15:53:08Z

If you have body already as a dictionary you can use only the last 4 lines from the test example. I have included also the transformation from string to dictionary in case you need it:

*** Settings ***
Library  Collections

Resource          robot/resources/environment_resources.robot

*** Variables ***
${body_temp}    {"message": {"Code": "26181", "rollnos": [{"ID": "1439173", "date_input": "2022-01-31 14:09:30.206748"}],"start_date": "2022-01-31 00:00:00"}}

*** Keywords ***
Converting a JSON File
    ${body}    evaluate  json.loads($body_temp)    json
    [Return]  ${body}

*** Test Cases ***
Example
    # Get body as dict
    ${body}=  converting a json file

    # Get the ID
    ${message} =    Get From Dictionary     ${body}    message
    ${rollnos} =    Get From Dictionary     ${message}    rollnos

    ${id} =   Get From Dictionary     ${rollnos}[0]    ID

    # Log the ID
    Log To Console    ID:${id}

halfer · Accepted Answer · 2024-12-29 21:49:49Z

1

Where have I gone wrong in this?

You are treating ${temp['rollnos']} as a dictionary, but it is a list of dictionaries.

Instead of this:

${value_1}=  Set Variable    ${temp['rollnos']}

${register_id} =  Set Variable    ${value_1["ID"]

Do this, to get the ID of the first item in the dictionary:

${value_1}=  Set Variable    ${temp['rollnos'][0]}
#                                             ^^^
${register_id} =  Set Variable    ${value_1["ID"]}

edited Dec 29, 2024 at 21:49

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jan 31, 2022 at 22:38

Bryan Oakley

389k53 gold badges582 silver badges739 bronze badges

Comments

Helio · Accepted Answer · 2022-01-31 15:33:07Z

-1

Well, when you say:

but it did not work out.

You don't mention what were the error messages.

This is my interpretation of your code:

  ${json_response}=  set variable    ${xyz.json()}
  # ${json_response} is now a dictionary with content: body=&{message}
  # So the next step would be: 
  ${temp}=  Set Variable    ${json_response['body']['message']}
  # And now we have: &{temp} = { Code:26181, &{rollnos}, ...
  # The next code will be correct
  ${value_1}=  Set Variable    ${temp['rollnos']}
  
  ${register_id} =  Set Variable    ${value_1['ID']

But you got the value of ID, and you wanted to Set it, so that is another question.

answered Jan 31, 2022 at 15:33

Helio

3,7821 gold badge17 silver badges29 bronze badges

2 Comments

Bryan Oakley Over a year ago

This looks like it has the same mistake as the OP: you're treating the 'rollnos' value as a dictionary but it's a list of dictionaries.

Helio Over a year ago

Yes, you are right. Thanks.

Collectives™ on Stack Overflow

Fetching a variable inside a list in ROBOT Framework

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related