Data driven from excel having multiple sheets

🙋 Help
2

Hey @Lalit_sah, is there an API that these sheets can be fetched from? That could alleviate the problem of having to manually feed the collection run information.

One possible workflow that I can think of is as follows:

  1. Fetch all the required sheets from initial requests in CSV format.
  2. Convert the CSV data using the inbuilt csv-parse library to convert the data to a JSON format.
  3. Stringify the arrays of objects obtained from each sheet, save them to environment variables.
  4. Set up an iteration over these saved arrays using postman.setNextRequest in order to achieve complex iterations.