Codeunit 5461 Json Impl.
src/System Application/App/Json/src/JsonImpl.Codeunit.al443 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Text.Json;using System;using System.Text;using System.Utilities;codeunit 5461 "Json Impl."{ Access = Internal; InherentEntitlements = X; InherentPermissions = X; var SourceWarningLength: Integer; JsonArrayDotNet: DotNet JArray; JsonObjectDotNet: DotNet JObject; LogLimitWarningTxt: Label 'The JSON input length (%1) exceeds the maximum suggested length (%2) for JSON processing.', Locked = true; internal procedure EmitLengthWarning(SourceLength: Integer; tag: Text; FormatString: Text) begin if SourceWarningLength <= 0 then SourceWarningLength := 10485760; // 10 * 1024 * 1024 = 10 MB if SourceLength > SourceWarningLength then Session.LogMessage(tag, StrSubstNo(FormatString, SourceLength, SourceWarningLength), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::All, 'resources', 'memory'); end; procedure InitializeCollectionFromString(JSONString: Text) begin Clear(JsonArrayDotNet); if JSONString <> '' then begin EmitLengthWarning(StrLen(JSONString), '0000QNC', LogLimitWarningTxt); JsonArrayDotNet := JsonArrayDotNet.Parse(JSONString) end else InitializeEmptyCollection(); end; procedure InitializeObjectFromString(JSONString: Text) begin Clear(JsonObjectDotNet); if JSONString <> '' then begin EmitLengthWarning(StrLen(JSONString), '0000QND', LogLimitWarningTxt); JsonObjectDotNet := JsonObjectDotNet.Parse(JSONString) end else InitializeEmptyObject(); end; procedure GetCollectionCount(): Integer begin exit(JsonArrayDotNet.Count); end; procedure GetCollectionAsText() Value: Text begin GetCollection().WriteTo(Value); end; procedure GetCollectionAsText(Indentation: Boolean) Value: Text var JsonConvert: DotNet JsonConvert; Formatting: DotNet Formatting; begin Value := GetCollectionAsText(); if Indentation then begin JsonArrayDotNet := JsonArrayDotNet.Parse(Value); Value := JsonConvert.SerializeObject(JsonArrayDotNet, Formatting.Indented) end; end; procedure GetCollection() JArray: JsonArray begin JArray.ReadFrom(JsonArrayDotNet.ToString()); end; procedure GetObjectAsText() Value: Text begin GetObject().WriteTo(Value); end; procedure GetObject() JObject: JsonObject begin JObject.ReadFrom(JsonObjectDotNet.ToString()); end; procedure GetObjectFromCollectionByIndex(Index: Integer; var JsonObjectTxt: Text): Boolean begin if not GetJObjectFromCollectionByIndex(Index) then exit(false); JsonObjectTxt := JsonObjectDotNet.ToString(); exit(true); end; procedure GetValueAndSetToRecFieldNo(RecordRef: RecordRef; PropertyPath: Text; FieldNo: Integer): Boolean var FieldRef: FieldRef; begin if IsNull(JsonObjectDotNet) then exit(false); FieldRef := RecordRef.Field(FieldNo); exit(GetPropertyValueFromJObjectByPathSetToFieldRef(PropertyPath, FieldRef)); end; procedure GetPropertyValueFromJObjectByName(propertyName: Text; var value: Variant): Boolean var JPropertyDotNet: DotNet JProperty; JTokenDotNet: DotNet JToken; begin Clear(value); if JsonObjectDotNet.TryGetValue(propertyName, JTokenDotNet) then begin JPropertyDotNet := JsonObjectDotNet.Property(propertyName); value := JPropertyDotNet.Value; exit(true); end; exit(false); end; procedure GetStringPropertyValueFromJObjectByName(propertyName: Text; var value: Text): Boolean var VariantValue: Variant; begin Clear(value); if GetPropertyValueFromJObjectByName(propertyName, VariantValue) then begin value := Format(VariantValue); exit(true); end; exit(false); end; procedure GetEnumPropertyValueFromJObjectByName(propertyName: Text; var value: Option): Boolean var StringValue: Text; begin if GetStringPropertyValueFromJObjectByName(propertyName, StringValue) then begin Evaluate(value, StringValue, 0); exit(true); end; exit(false); end; procedure GetBoolPropertyValueFromJObjectByName(propertyName: Text; var value: Boolean): Boolean var StringValue: Text; begin if GetStringPropertyValueFromJObjectByName(propertyName, StringValue) then begin Evaluate(value, StringValue, 2); exit(true); end; exit(false); end; procedure GetDecimalPropertyValueFromJObjectByName(propertyName: Text; var value: Decimal): Boolean var StringValue: Text; begin if GetStringPropertyValueFromJObjectByName(propertyName, StringValue) then begin Evaluate(value, StringValue); exit(true); end; exit(false); end; procedure GetIntegerPropertyValueFromJObjectByName(propertyName: Text; var value: Integer): Boolean var StringValue: Text; begin if GetStringPropertyValueFromJObjectByName(propertyName, StringValue) then begin Evaluate(value, StringValue); exit(true); end; exit(false); end; procedure GetGuidPropertyValueFromJObjectByName(propertyName: Text; var value: Guid): Boolean var StringValue: Text; begin if GetStringPropertyValueFromJObjectByName(propertyName, StringValue) then begin Evaluate(value, StringValue); exit(true); end; exit(false); end; procedure ReplaceOrAddJPropertyInJObject(propertyName: Text; value: Variant): Boolean var JPropertyDotNet: DotNet JProperty; OldPropertyDotNet: DotNet JProperty; OldValue: Variant; begin JPropertyDotNet := JsonObjectDotNet.Property(propertyName); if not IsNull(JPropertyDotNet) then begin OldPropertyDotNet := JsonObjectDotNet.Property(propertyName); OldValue := OldPropertyDotNet.Value; JPropertyDotNet.Replace(JPropertyDotNet.JProperty(propertyName, value)); exit(Format(OldValue) <> Format(value)); end; AddJPropertyToJObject(propertyName, value); exit(true); end; procedure AddJObjectToCollection(JSONString: Text): Boolean begin if JSONString <> '' then JsonObjectDotNet := JsonObjectDotNet.Parse(JSONString) else InitializeEmptyObject(); AddJObjectToCollection(); exit(true); end; procedure RemoveJObjectFromCollection(Index: Integer): Boolean begin if (GetCollectionCount() = 0) or (GetCollectionCount() <= Index) then exit(false); JsonArrayDotNet.RemoveAt(Index); exit(true); end; procedure ReplaceJObjectInCollection(Index: Integer; JSONString: Text): Boolean begin if not GetJObjectFromCollectionByIndex(Index) then exit(false); if JSONString <> '' then JsonObjectDotNet := JsonObjectDotNet.Parse(JSONString) else InitializeEmptyObject(); JsonArrayDotNet.RemoveAt(Index); JsonArrayDotNet.Insert(Index, JsonObjectDotNet); exit(true); end; local procedure GetJObjectFromCollectionByIndex(Index: Integer): Boolean begin if (GetCollectionCount() = 0) or (GetCollectionCount() <= Index) then exit(false); JsonObjectDotNet := JsonArrayDotNet.Item(Index); exit(not IsNull(JsonObjectDotNet)) end; local procedure GetPropertyValueFromJObjectByPathSetToFieldRef(propertyPath: Text; var FieldRef: FieldRef): Boolean var RecID: RecordId; Value: Variant; IntVar: Integer; DecimalVal: Decimal; GuidVal: Guid; DateVal: Date; BoolVal, Success : Boolean; JPropertyDotNet: DotNet JProperty; begin Success := false; JPropertyDotNet := JsonObjectDotNet.SelectToken(propertyPath); if IsNull(JPropertyDotNet) then exit(false); Value := Format(JPropertyDotNet.Value, 0, 9); case FieldRef.Type of FieldType::Integer, FieldType::Decimal: begin Success := Evaluate(DecimalVal, Value, 9); FieldRef.Value(DecimalVal); end; FieldType::Date: begin Success := Evaluate(DateVal, Value, 9); FieldRef.Value(DateVal); end; FieldType::Boolean: begin Success := Evaluate(BoolVal, Value, 9); FieldRef.Value(BoolVal); end; FieldType::GUID: begin Success := Evaluate(GuidVal, Value); FieldRef.Value(GuidVal); end; FieldType::Text, FieldType::Code: begin FieldRef.Value(CopyStr(Value, 1, FieldRef.Length)); Success := true; end; FieldType::Option: begin if not Evaluate(IntVar, Value) then IntVar := TextToOptionValue(Value, FieldRef.OptionCaption); if IntVar >= 0 then begin FieldRef.Value := IntVar; Success := true; end; end; FieldType::BLOB: if TryReadAsBase64(FieldRef, Value) then Success := true; FieldType::RecordID: begin Success := Evaluate(RecID, Value); FieldRef.Value(RecID); end; end; exit(Success); end; [TryFunction] local procedure TryReadAsBase64(var BlobFieldRef: FieldRef; Value: Text) var Base64Convert: Codeunit "Base64 Convert"; TempBlob: Codeunit "Temp Blob"; RecordRef: RecordRef; OutStream: OutStream; begin TempBlob.CreateOutStream(OutStream); Base64Convert.FromBase64(Value, OutStream); RecordRef := BlobFieldRef.Record(); TempBlob.ToRecordRef(RecordRef, BlobFieldRef.Number); end; local procedure TextToOptionValue(InputText: Text; OptionString: Text): Integer var IntVar: Integer; Counter: Integer; begin if InputText = '' then InputText := ' '; if Evaluate(IntVar, InputText) then begin if IntVar < 0 then IntVar := -1; if GetOptionsQuantity(OptionString) < IntVar then IntVar := -1; end else begin IntVar := -1; for Counter := 1 to GetOptionsQuantity(OptionString) + 1 do if UpperCase(GetSubStrByNo(Counter, OptionString)) = UpperCase(InputText) then IntVar := Counter - 1; end; exit(IntVar); end; local procedure GetOptionsQuantity(OptionString: Text): Integer var Counter: Integer; CommaPosition: Integer; begin if StrPos(OptionString, ',') = 0 then exit(0); repeat CommaPosition := StrPos(OptionString, ','); OptionString := DelStr(OptionString, 1, CommaPosition); Counter := Counter + 1; until CommaPosition = 0; exit(Counter - 1); end; local procedure GetSubStrByNo(Number: Integer; CommaString: Text) SelectedStr: Text var SubStrQuantity: Integer; Counter: Integer; CommaPosition: Integer; begin if Number <= 0 then exit; SubStrQuantity := GetOptionsQuantity(CommaString); if SubStrQuantity + 1 < Number then exit; repeat Counter := Counter + 1; CommaPosition := StrPos(CommaString, ','); if CommaPosition = 0 then SelectedStr := CommaString else begin SelectedStr := CopyStr(CommaString, 1, CommaPosition - 1); CommaString := DelStr(CommaString, 1, CommaPosition); end; until Counter = Number; end; local procedure AddJPropertyToJObject(propertyName: Text; value: Variant) var JObjectDotNet: DotNet JObject; JPropertyDotNet: DotNet JProperty; ValueText: Text; begin case true of value.IsDotNet: begin JObjectDotNet := value; JsonObjectDotNet.Add(propertyName, JObjectDotNet); end; value.IsInteger, value.IsDecimal, value.IsBoolean: begin JPropertyDotNet := JPropertyDotNet.JProperty(propertyName, value); JsonObjectDotNet.Add(JPropertyDotNet); end; else begin ValueText := Format(value, 0, 9); JPropertyDotNet := JPropertyDotNet.JProperty(propertyName, ValueText); JsonObjectDotNet.Add(JPropertyDotNet); end; end; end; local procedure AddJObjectToCollection() begin JsonArrayDotNet.Add(JsonObjectDotNet.DeepClone()); end; local procedure InitializeEmptyCollection() begin JsonArrayDotNet := JsonArrayDotNet.JArray(); end; local procedure InitializeEmptyObject() begin JsonObjectDotNet := JsonObjectDotNet.JObject(); end;}