JSON

Type

Defines a named type for records and tables, for ParseJSON and user-defined functions.

Syntax

Type(TypeSpecification)

Examples

  1. BookType := Type({ Title: Text, Author: Text, Published: Number });

    A record type, defined in App.Formulas

  2. ParseJSON(varJson, BookType).Title

    Typed JSON: no Text() conversion needed

Maker notes

  • Define types in App.Formulas. Tables use square brackets: Type([ BookType ]).
Official documentation on Microsoft Learn

↑ ↓ moveEnter open