Details

    • Type: New Feature
    • Status: New
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: V4.01_CS01
    • Fix Version/s: None
    • Component/s: Vocabularies
    • Labels:
      None
    • Proposal:
      Hide

      Create a type definition Core.JSON, similar to Core.LocalDateTime:

      • type Edm.Stream
      • annotated with Core.AcceptableMediaTypes, listing application/json

      Create a new JSON vocabulary containing terms and functions specific to JSON stream properties.

      Term JSON.Schema to allow referencing a JSON Schema describing/restricting the values of a JSON stream property.

      Functions: tbd.

       

      Show
      Create a type definition Core.JSON , similar to Core.LocalDateTime : type Edm.Stream annotated with Core.AcceptableMediaTypes , listing application/json Create a new JSON vocabulary containing terms and functions specific to JSON stream properties. Term JSON.Schema to allow referencing a JSON Schema describing/restricting the values of a JSON stream property. Functions: tbd.  
    • Resolution:
      Show
      https://github.com/oasis-tcs/odata-vocabularies/pull/52/files  

      Description

      "JSON properties" are stream properties whose value is of media type application/json or one of its subtypes. They were introduced with ODATA-1177.

      As outlined in OData Extension for JSON Data we need query capabilities on these properties.

      Requirements:

      1. Address parts of the JSON stream values in common expressions, e.g. in $filter, $compute, $orderby
      2. Specify a JSON Schema that describes/restricts the JSON stream values

      The first requirement can e.g. be solved via bound functions on JSON stream properties, e.g.

      • extract/compute an OData value (primitive, complex, collection) from a JSON stream
      • special case: extract/compute a JSON stream from a JSON stream
      • special case: extract/compute a Boolean value from a JSON stream

      These functions can be inspired by (or be direct wrappers for) the SQL/JSON functions

      Google BigQuery Standard SQL has similar JSON functions JSON_EXTRACT and JSON_EXTRACT_SCALAR that use the same path syntax to address parts of the JSON value.

      PostgreSQL has its own set of JSON Functions and Operators.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              handl Ralf Handl
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: