Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

columns

An array of the columns that make up the actual spreadsheet. The columns are typically the same as the layout you submitted. However, the system will eliminate any data columns to which the current user does not have access. For example, if the user can see English and French content, a layout column for Spanish will be dropped automatically. The authorized columns depend on the access rights, see Rights (Object).

See Spreadsheet Column (Object) for the properties of each item.

Example with a French translation column:

Code Block
[
  {
      "index": 0,
      "fkey": "1~fr~0",
      "fkeyLayout": "1~#0~0",
      "ftype": 1,
      "fqualifier": 0,
      "name": "Français",
      "loc": "fr",
      "loc_rtl": false,
      "loc_cmplx": false,
      "loc_ea": false
  },
  { ... }
]
object[]
layout

An object with the layout that was used to configure the spreadsheet. The layout consists of an optional name and a list of columns. See Spreadsheet Layout (Object) for the properties of this objectdetails.

Example:

Code Block
{
  "name": null,
  "columns": [
    { "fkey": "1~en~0" },
    { "fkey": "1~fr~0" }
  ]
}
 object
allfields

A list of all columns to which a user has access. This list can for example be used to let a user add more columns to the spreadsheet. You would then build a new layout.

Each array item ressembles the properties of the Spreadsheet Column (Object) and includes these properties:

  • fkey
  • ftype
  • fqualifier
  • loc: The locale
  • loct: The print name of the language
  • name: The print name of the column.

 

object[]
lasteditors

All available "last editors". The "last editor" specifies the source or origin of a translation: Human edit, pre-translation, machine translation etc.

See example below.

 

...