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...
nmrao's avatar
nmrao
Champion Level 3
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.