Forum Discussion

Apoorva6's avatar
Apoorva6
Frequent Contributor
8 years ago

Is there a way to read Rest service body from external source ?

Hi all,   Is there a way to read rest service body from an external source, preferably Excel ? My sample rest body (POST) is as below. I want to provide data from Excel sheet and I am using open so...
Apoorva6's avatar
Apoorva6
Frequent Contributor
Hi Rao. Thanks for reply. I need this for data driven test only. So that i can do the permutation and combination of data and feed to body.
nmrao's avatar
nmrao
Champion Level 3
8 years ago
In that case, below would be more clean approach.

Instead of putting json request in the table, put the json request into a file and use that file name in the data driven table file.
  • Apoorva6's avatar
    Apoorva6
    Frequent Contributor
    8 years ago

    Hi Rao,

     

    Thanks again for reply. I agree with you. However is there a way to pick each attribute from CSV / XLSX, and convert it to above jason format and trigger the request ? Why i need is, I want to try permutation and combination of all attributes.

     

    One example is if I have 5 jason name value pairs, then some field may be mandatory, some are optional and all attributes length will be defined. So I want to make all available combinations and inject it to request one after another. So is there a way to achieve it in open source ? 

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Would you show your data-driven script? Then it would be much easier.