Run same Put with multiple variables

I have the Meraki API collection.
They have the PUT " PUT /networks/[networkId]/devices/[serial]" which allows me to change parameters like "name:“Test”. This works fine one at a time. I have been tasked with updating names of all devices in this network. Over 100 devices. I have an excel list of names with the serial. How can I use postman to update all my devices to match my excel sheet? This is the first of many sites I will have to do so this would be helpful in the long run if this is possible.

@smaniace Welcome to the Postman Community! :wave:

You can make use of the data file feature in the collection runner
You can export the excel sheet as a csv and run it in the collection runner.

Your put request will be making use of the variables.
It’d be something like this:

PUT /networks/{{networkId}}/devices/{{serial}}

If you’re not familiar with the concept of variables in postman, then you can go through the docs here to understand them better.

Let me know if you get stuck somewhere, will be happy to help.

Thanks for the response. Since I post I was able to use Runner and the .csv to do what I need. I used what you had below with{{networkId}}/devices/{{serial}}?name={{name}}.
This updated the network device like I wanted. I was hoping that this would work for more than 1 field I can’t seem to get this to work:{{netorkId}}/devices/{{serial}}?name={{name}}&address={{address}}

Any ideas on how to update more than 1 key at a time?


Must have been a typo because I was able to get it now. Thank you again.


1 Like