LoadJsonFile

Takes two parameters, PathToFile, Options

Usage:

FileName, JsonOptions
FileName, [""]

Description:

Given a local file name path, it is parsed into the WorkQuery using JsonStream. The file used with this function should be of a .json extension. The options available in JsonStream are the same as LoadJsonFile.

This command checks for a BOM at the start of the file, and if found, it applies BomToUtf8$ to the data during the loading process. In contrast to other load file commands, such as LoadTabFile, if no BOM is found, it is assumed to be UTF-8. If these conversions are not desired, use a combination of LoadFile$ and JsonStream instead. If the source file is known to be ANSI instead of UTF-8, use a combination of LoadFile$, AnsiToUtf8$, and JsonStream instead

Example:

LoadJsonFile "Private/someData.json"