how to read csv values using robot framework

Question

How to read particular value based on key using robotframework

I am trying to read particular value from csv by passing the key parameter

file.csv-> has below items
Param_Name,Param_Value
res_name,res123
id_name,123

 robotfile.csv->
 ReadCSV
    [Arguments]       ${paramname}
    @{list}=  read csv file to list  ${CURDIR}${/}file.csv
    ${dict1}=    Set Variable     ${list}
    :FOR    ${node}    IN    @{dict1}
    \    Log To Console    ${node[1]}['${paramname'}]


 ${Read_Name}=    ReadCSV        res_name

expected:res123 Actual: None

Joonas Köppä · Accepted Answer · 2019-09-18 12:44:12Z

2

I created the following example based on your needs. The keyword will first create a list with a res_name and id_name (you can substitute your own way of fetching a CSV list here) and then returns the wanted field value to you and prints it.

*** Settings ***
Library  String

*** Keywords ***
ReadCSV
    [Arguments]       ${FIELD}
    @{LIST}=  Create List  res_name,res123    id_name,123
    :FOR   ${ITEM}   IN   @{LIST}
    \  @{FIELDS}=  Split String  ${ITEM}  ,
    \  Return From Keyword If  '${FIELDS[0]}' == '${FIELD}'  ${FIELDS[1]}
    [return]

*** Test Cases ***
Read CSV values
    ${NAME}=  ReadCSV  res_name
    Log To Console  res_name: ${NAME}
    ${ID}=  ReadCSV  id_name
    Log To Console  id_name: ${ID}

edited Sep 18, 2019 at 12:44

answered Sep 18, 2019 at 12:38

Joonas Köppä

3661 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

how to read csv values using robot framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related