We have a client requirement wherein the data stored in an MS excel sheet needs to be read and extracted instead of a database without any web-service in between the gateway and the Excel sheet. Is this feasible from the gateway? If yes, then do we have any built in assertions or any work around to implement this. Thanks!
CA has a product called Live API Creator that can extract data from various data sources and create a Rest API that allows manipulation / consumption of that data. Not sure if Excel is in the latest release, I think its a future. If the spreadsheet could be saved as CSV, then it will work today.
Thank You Samuel.
Following up on Sam's reply, Live API Creator provides an API project sample that does exactly this....it's documented here:
CSV Import - 3.0 Live API Creator
As provided, the solution will support CSV files, but can be modified to support Excel directly with a quick library swap. If you're interested in evaluating Live API Creator, there's a free trial available from http://trials.ca.com/. We can provide assistance on this use case as you get up and running.
Thanks Jaime. This documents really helps