ADO.NET Provider for REST

Build 20.0.7654

Parsing Hierarchical Data

The provider offers three basic configurations to model nested data in XML and JSON as tables. See the following sections for examples of parsing objects and arrays.

  • Flattened Documents Model: Implicitly join nested object arrays into a single table.
  • Relational Model: Model object arrays as individual tables containing a primary key and a foreign key that links to the parent document.
  • Top-Level Document Model: Model a top-level view of a document. Nested object arrays are returned as aggregates.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654