Layer7 API Management

  • Private Community
Back to discussions
Expand all | Collapse all

Live API Creator: Problem of delimiter type on CSV data source

  • 1.  Live API Creator: Problem of delimiter type on CSV data source

    Posted Nov 30, 2018 10:37 PM

    In Live API Creator (version 5.1), there is delimiter type - delimited(|) for selection when create a new API using CSV data source. How does this delimiter type work exactly? I had tried with a CSV that the data is separated by character "|", however the result outcome is not what I expected. I will be grateful for any help you can provide.

     

    E.g.

    CSV:

    A|B|C|D

    1|2|3|4

     

    API output:

    {
    "A|B|C|D": "1|2|3|4",
    "@metadata": {
    "checksum": "A:388a5183b1e63201",
    "links": [
    ]
    }
    },



  • 2.  Re: Live API Creator: Problem of delimiter type on CSV data source
    Best Answer

    Broadcom Employee
    Posted Dec 04, 2018 09:08 PM

    This seems to be a limitation in the CData CSV driver version 2017. We are currently testing this scenario with a more recent version of the driver (2018), which allows different delimiters.

     

    See the CData documentation for details: http://cdn.cdata.com/help/RVC/jdbc/RSBCSV_p_FMT.htm 

    Compare with the 2018 version:  http://cdn.cdata.com/help/RVD/jdbc/RSBCSV_p_FMT.htm 

     

     

    If you feel adventurous, you could try the 2018 version of this driver, but please be advised that it has not been officially tested with Live API Creator. It will be supported in the next release of Live API Creator.