How to quote strings in csv files

daniele.sartiano
daniele.sartiano Newcomer
in DSS

Hi,
is there a way to obtain a csv file with string fields quoted?
Currently, we receive the csv files without quotes, so it is hard to detect if a field is string or number.

Regards.

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @daniele.sartiano,

    there is no parameter to set this, be it in the user preferences or template setup parameters.

    How to programmatically identify response data field types ?

    If you using scheduled requests you are creating templates, and the response to an API request to create a template contains the data type of every single field you chose. For a string it is:

    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"

    You can see that here in the DSS REST tutorial 10.

    If you are using On Demand requests, you can use a GET call to retrieve the complete list of all available data fields (the entire universe, not limited to those you want). The response contains the data type for every data field. For a string it is:

    "FormatType": "Text"

    You can see an example for that here in DSS REST tutorial 2 (and other examples in the following REST tutorials).

    Using a programmatic approach you could therefore determine the data type for every single data field.

    Hope this helps.

Categories