Delphi DLL

JSON Paths that need Double Quotes

See more JSON Examples

This example explains and demonstrates the situations where parts within a JSON path need to be enclosed in double-quotes. Delphi DLL

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, JsonObject;

...

procedure TForm1.Button1Click(Sender: TObject);
var
json: HCkJsonObject;

begin
// Imagine we have the following JSON:

// 	{ 
// 	  "Meta Data": { 
// 	    "1: Symbol": "MSFT",
// 	    "2: Indicator": "Relative Strength Index (RSI)",
// 	    "3: Last Refreshed": "2017-07-28 09:30:00",
// 	    "4: Interval": "15min",
// 	    "5: Time Period": 10,
// 	    "6: Series Type": "close",
// 	    "7: Time Zone": "US/Eastern Time"
// 	  },
// 	  "Technical Analysis: RSI": { 
// 	    "2017-07-28 09:30": { 
// 	      "RSI": "38.6964"
// 	    },
// 	    "2017-07-27 16:00": { 
// 	      "RSI": "50.0088"
// 	    } 
// 	} 

// The path to the RSI valud 38.6964 is Technical Analysis: RSI.2017-07-28 09:30.RSI

// Whenever a path part contains a SPACE or "." char, that part must be enclosed
// in double quotes.  For example:

json := CkJsonObject_Create();
CkJsonObject_LoadFile(json,'qa_data/json/rsi.json');

Memo1.Lines.Add('RSI: ' + CkJsonObject__stringOf(json,'"Technical Analysis: RSI"."2017-07-28 09:30".RSI'));

// output is 38.6964

CkJsonObject_Dispose(json);

end;