jsonexportline(
jsonexportline()

The jsonexportline( function exports the current database record in JSON format.

Parameters

No parameters.

Description

This function exports the current database record in JSON format. (JSON is a data interchange format that is used by many web API’s. See http://www.json.org for more information.)

Panorama has two data types that are not directly supported by JSON – dates and binary. Dates are exported as text, using the pattern `YYYY-MM-DDT00-00-00Z`. Here are some examples:

    June 9, 2016 ☞ 2016-06-09T00-00-00Z
    December 15, 2017 ☞ 2017-12-15T00-00-00Z
    March 1, 1987 ☞ 1987-03-01T00-00-00Z

Binary data is exported as text, encoded in Base64 format. For more information on Base64 encoding see https://en.wikipedia.org/wiki/base64.

See Also

- databaseexportjson -- exports selected records in the current database in JSON format to a text file.
- exportjson -- exports the current database in JSON format.
- exportline( -- generates a tab delimited line of data containing all the fields in the current record.
- importjson -- imports a JSON array into the current database.
- importjsonline -- imports a JSON record into the current record.
- jsonexport( -- converts a Panorama dictionary or data array into JSON.
- jsonimport( -- converts JSON into a Panorama dictionary or data array.
- jsonscriptstring( -- converts text into a JSON string literal
- newdatabasewithjson -- creates a new database using a JSON file.
- tsvtojson( -- converts tab separated text into JSON formatted text.

History

Version | Status | Notes
10.0 | New | New in this version.