jsonexportline function

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.