Using request body filled from csv file as variable

🙋 Help
, , , ,
1

Hi,
I have a request:
https://{{host}}/api/?key={{key}}&type=op&cmd={{username}}{{user-ip}}{{user-hostname}}

I want to fill variables {{username}}, {{user-ip}}, {{user-hostname}} using csv file which I run.
After running it Request body json is correctly filled with data

image
image1348Ă—747 28.2 KB

Now I want to take this
“username” : *****
“user-ip”: *****
“user-hostname”:******
and put it into my request as variables in brackets {{ }}

I’d tried this script but I get this error…

image
image1917Ă—1167 267 KB

image
image2541Ă—1613 213 KB

Can you help me with this?

2

First of all the response in the last screenshot is XML, not JSON, so you will need to parse it using pm.rseponse.text() instead of pm.response.json().

However, I’m not really understanding what you are doing with the variables.

You seem to be mixing request and response elements.

Your initial request is using query parameters

https://{{host}}/api/?key={{key}}&type=op&cmd={{username}}{{user-ip}}{{user-hostname}}

But your first screenshot from the collection runner is is showing a JSON body?

Can you share a screenshot of the actual request itself. Including the body and params tab and any scripts you have?

It can’t be query parameters and a JSON body. Its either one or the other.

In the final screenshot, it looks like you are trying to set the userName in the tests tab. The tests tab runs after the request. If the request needs the userName, then logically this can’t be correct.

1 Like
3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.