This content comes from an automatic translation.
  • Exporting the query content
  • Exporting a single record
  • Array items
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
HExportJSON (Function)
In french: HExporteJSON
ODBCNative Connectors (Native Accesses)Not available with these kinds of connection
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
// Export all customers
HExportJSON(CUSTOMER, "C:\TEMP\Customer.json", hExpCreation)
<Result> = HExportJSON(<Data file> [, <JSON file> [, <Items to export>]] [, <Options> [, <Progress Bar>]])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Data file>: Character string (with or without quotes)
Name of data file used. If this name is not specified, HExportJSON handles the last data file used by the last function for HFSQL management (starting with the letter H).
<JSON file>: Optional character string
Full path of JSON file to generate.
<Items to export>: Optional character string
List of names of items to export. The names are delimited by single quotes and they are separated by commas or CR characters. The names of composite key items, binary items and binary memo items are ignored.
If this parameter corresponds to an empty string (""), all the items of the data file (except for the composite keys, binary keys and binary memo keys) are exported.
<Options>: Optional constant
Specifies the creation mode of JSON file:
hExpCreationIf the JSON file already exists, it is overwritten. An error occurs if this option is not specified and if the JSON file exists.
hExpBreakableThe export can be interrupted by pressing the Esc key on the keyboard.
If the export is interrupted, the JSON file is valid and it only contains the records exported before the interruption.
(default value)
Standard operating mode.
<Progress Bar>: Optional field name or window name
Name of Progress Bar control or name of window used to show the progress of file creation.

Exporting the query content

To export the query content, you must initialize the query (HExecuteQuery) before using HExportJSON.

Exporting a single record

To export a single record to a JSON string, use HRecordToJSON.

Array items

If one of the exported items is an array item, each element of the array item is exported in a new level:
"Item1":Data of item 1,
"Item2":Data of item 2,
[Data element 1, Data element 2, ...]

Reminder: Composite key, binary memo or binary items are ignored.
Business / GUI classification : Business Logic
Component : wd250hf.dll
Minimum version required
  • Version 21
This page is also available for…
How to export HExportJSON into Buffer
Is there a way to export from data source into JSON buffer variable instead a physical file?
16 Dec. 2019
Video HexportJson



HExportJSON(empresa, "C:\TEMP\empresa.json", "", hExpCreation,PROGBAR_BARRA_PROGRESSO)

17 Mar. 2019