Layer7 API Management

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  Live API Creator: Problem of delimiter type on CSV data source

    Posted 11-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

    Posted 12-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.