1

In Karate, we are parameterizing with the below values. Do we have any option of passing the table as external file in karate.

And table tablename
     | name | age | id |
     | abc  | 02  | 01 |
     | def  | 03  | 02 |

And def values = { "name": '(#name)', "age": '(#age)', "id" : '(#id)' }

Expecting below in karate framework.

And table <tablefile.xls>
And def values = { "name": '(#name)', "age": '(#age)', "id" : '(#id)' }
James Z
  • 12,209
  • 10
  • 24
  • 44
Preethi Ravi
  • 91
  • 1
  • 2
  • 10

1 Answers1

0

There are multiple ways, the most recommended is to use JSON for maintaining test data.

Please take a look at this answer for details: https://stackoverflow.com/a/49031155/143475

EDIT: Since OP is insisting on Excel, please refer to this other answer where this is explained in detail: https://stackoverflow.com/a/47954946/143475

If I were you I would NOT use Excel and at least use CSV. In my opinion table or set is far easier to maintain than Excel and you can do it as part of your test feature file itself.

Peter Thomas
  • 54,465
  • 21
  • 84
  • 248
  • Can i consider that reading Excel / .csv file as "NOT AVAILABLE" in karate. Because we have payload of 50 fields. And it is easy when we have it in excel for filling the test data. – Preethi Ravi Apr 09 '18 at 11:33
  • @PreethiRavi I just edited my answer. So can we consider your capability to write a simple Java utility to read an Excel (or CSV) file into JSON as "NOT AVAILABLE" :) – Peter Thomas Apr 09 '18 at 11:58
  • May i use "examples" in "Scenario Outline" on the Feature File to pass the xls sheet as file name. Examples:{'datafile':'resources/testdata.xls'} – Preethi Ravi Apr 11 '18 at 03:41