Skip to content

Add json type (Fsharp.Data.JsonValue) to Csv column type inference option as addition over string #1781

Description

@jkone27

Seems the CsvProvider parses json strings in a peculiar way,

All quotes disappear from json, making it a kind of serialised object representation not compatible with usual JsomValue or so?

at least checking with some log exports, it’s often useful to parse such export for troubleshooting or data recovery in case of incidents p, would be nice if CsvProvider could expose types so that it can be combined in use with JsonProvider. For example being able to load a column using JsonProvidedType.Root constructor accepting JsonValue

ColumnName=json extension could be useful to add to the type provider signature?

Here some workaround that was ok for some cases but is probably quite broken (didn’t put much effort into this but it did what I needed) - https://gist.github.com/jkone27/e2688005e1f3ed95d4a7d24933e68bc0#file-csvproviderjsonishparse-fsx

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions