Reading property values from excel datasource

[rahuldutta]

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 property and return another property value from the same sheet and same row. Is there a way to do this?

Thanks,

Rahul

[TanyaYatskovska]

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-Exce...

https://community.smartbear.com/t5/API-Functional-Security-Testing/Reading-from-excel-based-on-a-con...