Layer7 API Management

Expand all | Collapse all

Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?

Jump to Best Answer
  • 1.  Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?

    Posted 08-21-2016 04:40 AM

    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!



  • 2.  Re: Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?

    Posted 08-23-2016 11:39 PM

    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.



  • 3.  Re: Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?

    Posted 08-30-2016 07:59 AM

    Thank You Samuel.



  • 4.  Re: Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?
    Best Answer

    Posted 08-30-2016 12:29 AM

    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.



  • 5.  Re: Can we read and extract the data from a MS Excel spread sheet in CSV format through the API Gateway policies?

    Posted 08-30-2016 08:00 AM

    Thanks Jaime. This documents really helps