Forum Discussion

Occasional Contributor

5 years ago

Reading property values from excel datasource

Hi, I have an excel datasource and imported the properties based on the column headers. Now I want to validate the query parameter value from the incoming Rest service request against the datasource...

TanyaYatskovska

SmartBear Alumni (Retired)

5 years ago

Hi rahuldutta,

Could you please take a look at the following tutorial?

https://support.smartbear.com/readyapi/docs/testing/data-driven/tutorials/excel/index.html

If you are looking for a way to read Excel file from script, check out the following community discussions:

https://community.smartbear.com/t5/API-Functional-Security-Testing/Load-records-from-Datasource-Excel-into-SOAP-Request-as-multiple/m-p/134879

https://community.smartbear.com/t5/API-Functional-Security-Testing/Reading-from-excel-based-on-a-condition/m-p/116917

Recent Discussions

Accessing database connection string from groovy test step
14 hours ago
chirangv
Assert Step Not Executing All Assertions
7 days ago
HawkeyesTester
Include external files (XML) for JDBC connection
8 days ago
Kribbstar
JDBC database connection pooling
22 days ago
bcu_
JDBC "Some connection settings are not specified"
24 days ago
cvieth

Forum Discussion

Reading property values from excel datasource

Related Content

Error. Cannot read properties of undefined (reading 'includes')

TypeError: Cannot read property 'Navigate' of null

how can read the account number in json response and store it in datasource/properties?

Cannot read property of undefined.

Reading excel column into property, parsing REST response for property member

Recent Discussions

Accessing database connection string from groovy test step

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

JDBC database connection pooling

JDBC "Some connection settings are not specified"