Exception when using Collection Runner

🙋 Help
1

Hello new to POSTMAN and i’m trying to run a collection runner from a CSV file. I have saved the file as UTF-8 encoded (unix csv?). I’m posting a request to a URL using application/json. Here is a snippet

“SSN”: {{ssn}},
“FirstName”: {{first}},
“LastName”: {{last}},

The files seems to be formatted correctly, i do not see any illegal characters etc…

I receive the following error. I added x;s to mask data. but the ERROR appears in the middle of the name

{
“Exceptions”: {
“Exception”: [{
“Code”: -3,
“Message”: "Bad Request: Error - syntax error "
Bad value " [line 6, file offset 123]
“SSN”: xxxxxx,
“FirstName”: x * ERROR * xxxxx,
“LastName”: xxxxx,
"
}]
}
}

Looking at the request packet in POSTMAN, it is pulling the data correctly from the file. The error is the same for all 30 records.

2

Hey @emon22,

Just taking a quick guess based on the request body that you have, I take it that the FirstName and LastName keys are string values?

Could you give the request another try but wrap those two in keys in quotes…for example - "FirstName":"{{first}}".

I’m not sure what the other property is that you have, is that also a string or a number?

Failing that, you could open the Postman Console and check the request body of the failing requests to see whats getting sent across.

3

YAAASSSS, that was it!! They are all string values, thanks so much!

1 Like