To substitute data in a template, use indicators {d.}. Indicators {d.} are substituted for data from your JSON dataset in Ninox.

The following values can be substituted:

• a string

• a number

• a date

When data is an array of objects, access each object directly using the square bracket notation [] and the reserved word i, which represents the ith item of the array.

Zero-based arrays are used:

• the first item of an array is [i=0] or [0],

• the second item of an array is [i=1] or [1],

etc.

Data

Filter an array with attributes of objects instead of the reserved word i.

Data

Access properties of the parent object with 2 points .. (or more) when you need to print a parent property using filters in nested arrays.

Data

  {
  "country": "USA",
  "movies": [
    { "name": "Inception", "year": 2010 },
    { "name": "Matrix", "year": 1999 },
    { "name": "BTTF", "year": 1985 }
  ]
}

Data

{
  "firstname": "John",
  "lastname": "Doe"
}

Multiple filters are accepted, even using a sub-object (depth-limited, a filter cannot go deeper in the object tree).

Data

[
  { "name": "Matrix"        , "year": 1999, "meta": { "type": "SF"    } },
  { "name": "The Green Mile", "year": 1999, "meta": { "type": "Drama" } }
]

To access the last element of a list, assign a negative index [i=-1] as a filter.

To access the second to last element, use [i=-2].

Data

[
  { "name": "Inception", "year": 2010 },
  { "name": "Matrix", "year": 1999 },
  { "name": "BTTF", "year": 1985 }
]

Use aliases to simplify the maintenance of your report avoiding code repetition or to insert markers somewhere in the document where special characters like square brackets [] are not allowed, e.g., in worksheet names.

Aliases can be used to:

• write {#... = ...} to define an alias

• write {$...} to use this alias

Data

{
  "name": "Cars",
  "wheels": 4
}

To access sub-objects contained within a dataset (i.e., go deeper in the object tree), use the dot . notation.

Data

{
  "firstname": "John",
  "type": {
    "id": 1,
    "name": "human"
  }
}

Aliases accept an unlimited number of parameters between parentheses, like a function in many languages. Start each parameter with $.

Data