Forum Discussion

nsinghal's avatar
nsinghal
New Contributor
11 months ago

Passing comma separated values for a property in Data driven test case

Hi,  I am creating a grid data driven test case using Ready API. For one of the properties, I have to pass multiple comma separated values for a particular property in my REST request. I am not g...
Data-Driven Testing
Scripting
  • nmrao's avatar
    nmrao
    11 months ago

    The above generates values without quotes. If that causes any trouble when API is called, then you can try below:

    "taxCodes": ["${= "${Properties#TaxCode}".split(',')*.trim().join(',"') }"],
  • nsinghal's avatar
    nsinghal
    11 months ago

    The later one as I required my text to be enclosed in double quotes. Just made a minor change in join method. Instead of join(',"') I used join('","') to close the double quotes for each string.

    ["${= "${API Data Driven Source#TaxCode}".split(',')*.trim().join('","')}"]

troyyerJP's avatar
troyyerJP
Contributor
11 months ago

I'm going to make an assumption that you need to pass into the request a string array
so currently if the data source input is 

TAX

then when it goes thru to the rest api it gets set as

"taxCodes" : ["TAX"]

but if the data source input is 

TAX,BMT

 then when it goes thru the rest api it gets set as

"taxCodes" : ["TAX,BMT"]

which would cause an error

so one hacky way to do it, is within the data source for records that have more that one value, put double quotes around the COMMA string

 for 2 values 

TAX","AMT

for 3 or more 

AMT","TAX","EXP

another way would be to put double quotes around each variable in the data source

 for 1 value records 

"TAX" 

 for 2 values 

"TAX","AMT"

for 3 or more 

"AMT","TAX","EXP"

then in your rest step you pass in the Datasource without the quotes

 "taxCodes" : [ ${Data Source#TaxCodes} ]

I think the above way would work

  • nmrao's avatar
    nmrao
    Champion Level 3
    11 months ago

    Nice hack as long as you have control over data source (with an additional work of adding quotes in the data source file with little confusion where to have quote and where not to have, by the way does such data accepted by the tool?). If the data source is coming from external parties and can't change, then it will be an issue.