Forum Discussion

Santhosh_P's avatar
Santhosh_P
Contributor
9 years ago

I have a framework building related question.

I use REST with XML

I have the following:

 

1> An excel sheet with input data (each row is a test case) to the service with different sheets as "states". (Attached the sheet- InputDataSheet.xlsx)

2> Another excel sheet with a template of the XMLs  which is common in for all the states for 7 endpoints. (Attached the sheet- XMLTemplate.xlsx)

 

Endpoints:

1> StateDetails

2> Eligibility

so on... 7 endpoints.

 

I need to do the following:

1> Fetch only those test cases with "Run"(first column) says "Yes" from excel sheet (InputDataSheet.xlsx).

2> Fetch xmls from "XMLTemplate.xlsx" for each endpoint one by one in the order specified in "TestFlow" column.

3> All state specific xml nodes and additional questions to be inserted into the xml template (for which i have the function)

4> Execute each endpoint in the order specified in "TestFlow" column.