The add-in offers three basic configurations to model object arrays as tables, described in the following sections. The add-in will parse the JSON document and identify the object arrays. Or, set JSONPath to specify the object arrays you want to model as tables.

• 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 JSON document. Nested object arrays are returned as JSON strings.