Need to verify the body value from CSV file

jayaveljays · January 11, 2021, 6:06am

Hi team, below is my response body & test code

I need to verify the “grossPremiumPrice” value from Csv file, since quoatation is missing for the price in the body (659.56,). i am getting an error saying value is mismatch. how to add value in the csv file when there is quoatation is missing in the body value

[
{
“endDate” : “2021-10-01”
grossPremiumPrice" : 659.56,
}]

my request test :

pm.test(“grossPremiumPrice matches the csv value”, function (){
pm.expect(response.grossPremiumPrice).eql(’${pm.iterationData.get(“grossPremiumPrice”)}’);
});

praveendvd · January 11, 2021, 8:17am

You can use Number function to convert string to number ,

${Number(pm.iterationData.get(“grossPremiumPrice”))}

You can also define the row as number in csv instead of text . This will remove double quotes from number in csv

So that you don’t have to convert the value to number explicitly

. Also note, you can access data values simply as

data['grossPremiumPrice'] instead of pm.iterationData.get

jayaveljays · January 11, 2021, 9:51am

@praveendvd
Hi Praveen, thanks for your reply. i tried that still getting below error.

AssertionError: expecyed 659.56 to deeply equal to ‘659.56’

bpricilla · January 11, 2021, 10:12am

Hi @jayaveljays this is because you are comparing a number Vs string.

May be we can try using toString();

something like in the below link:

praveendvd · January 11, 2021, 1:15pm

Please add the code you used , as @bpricilla mentioned it’s comparing number vs string , you haven’t used Number(data[‘grossPremiumPrice’])