How to read input data from an excel spreadsheet and pass it JSON payload in karate framework?

by

A few points:

  • I recommend you look at Karate’s built-in data-table capabilities, it is far more readable, integrates into your test-script and you won’t need to depend on other software. Refer these examples: call-table.feature and dynamic-params.feature
  • Next I would recommend using JSON instead of an Excel or CSV file, it is natively supported by Karate: call-json-array.feature
  • Finally, if you really wanted to, you can call any Java code and if you return data in a Map / List form, it will be ready for Karate to use. This example shows how to read a database via JDBC: dogs.feature. So although this is not built into Karate, just write a simple utility to read a CSV or Excel file and you can do pretty much anything Java can do.

EDIT: Karate now supports CSV files that can be used to even do data-driven testing: https://github.com/intuit/karate#csv-files

More Related Contents:

  1. How to add an option to Cucumber report to remove scenarios that have a certain tag
  2. In Karate how we can collaboratively work along with BA to automate business scenarios
  3. API Automation Testing : Is there any way to automate download scenario with content validation?
  4. Can we parameterize the request file name to the Read method in Karate?
  5. Karate: Is there a http-request hook in karate, that gets called automatically after every API call, and whose behaviour I can modify? [duplicate]
  6. How to rerun the failed scenarios using Cucumber?
  7. Does Karate DSL Framework have the capability to pass a POST Request as a url encoded format?
  8. Karate: Query Param values are getting encoded
  9. Karate – how to check if array contains values?
  10. Is it possible to use karate ‘match’ inside conditional statement?
  11. How to execute cucumber feature file parallel
  12. Karate framework retry until not working as expected
  13. How can we execute WebUI feature file against multiple browsers using parallel runner or distributed testing?
  14. Do Karate support .avro file as an input request?
  15. How to launch all Karate features setting up which browser to use as an external maven variable
  16. Is possible to execute curl in Karate tests?
  17. How to implement Basic Auth using Karate?
  18. Unable to upload zip file through karate framework
  19. Karate Tests Stuck on Running Forever
  20. Handling JWT bearer token from ADFS
  21. Capability of using Karate along with selenium webdriver
  22. Is there an option for us to customize and group the test scenarios in the statics section of the Karate Gatling Report?
  23. Does Karate supports Neo4j Database?
  24. How do you POST to a URL in Capybara?
  25. How to make HTTPS GET call with certificate in Rest-Assured java
  26. [karate][standalone] Error : could not find or read file
  27. How to handle requests with signatures on karate tests?
  28. iOS Tests/Specs TDD/BDD and Integration & Acceptance Testing
  29. Unable to obtain stable firefox connection in 60 seconds (127.0.0.1:7055)
  30. Karate UI: Locating text via CSS

Leave a Comment