Layer7 API Management

  • Private Community
Back to discussions
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?

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

    Broadcom Employee
    Posted Aug 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 Aug 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?

    Broadcom Employee
    Posted Aug 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

    Broadcom Employee
    Posted Aug 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?

    Broadcom Employee
    Posted Aug 30, 2016 08:00 AM

    Thanks Jaime. This documents really helps