How to avoid object parsing into dictionary in workflow, Liquid JSON Filter Expand Dictionary

[hyzx86]

How to avoid object parsing into dictionary in workflow.
And the Json filter of Liquid cannot be expanded into JSON.

I have an object like this：

but the workflow always converts it into a dictionary.
Is it because the conversion priority of dictionary is higher than that of object? Is there any way to avoid converting objects into dictionaries?

Thanks!.

[hyzx86]

@sebastienros Or do we need to use Jint to implement a JSJSON Filter?
my code is not work, that still is a dictionary...

          var engine = new Engine();
                    var dictResult = engine.SetValue("input", input)
                        .Evaluate("return JSON.stringify(input)");
                    return new ValueTask<FluidValue>(new StringValue(dictResult.ToString()));

[hyzx86]

It seems that there is no effect..

 {"Count":52,"Keys":["Created_Date","Delivery_Number","Delivery_Item","Reference_Doc","Material","Sales_text_line1","Delivery_Quantity","Sales_Unit","Shipping_point","Plant","Soldto_Code","Soldto_Name_3","Route","PO_Number","Shipto_Name_3","City","Sales_office","User_name","Ship-to-party","Ship_to_Address","Customer_material","Gross_weight","Weight_Unit","Markfor_Code","Markfor_Name","Volume","Volume_Unit","Payer_Code","Payer_Name_3","Route_description","Ship-to-party_Name","Reference_Item","order_quantity","open_quantity","document_date","addl._Data_B-GI_date","delivery_priority","terms_of_payment","Sales_Document","Credit_account","Credit_value","Credit_exposure","Credit_limit","Created_By","STAT","STATUS","delivery_text","SHIP_TO_contact_person_NAME","ship_to_contact_person_TEL","token","transactionId","apiKey"]}

[hyzx86]

debug view

[sebastienros]

Interestingly this one has nothing to do with the json filter in liquid, but JSON.Stringify in Jint .... and I released a fix for this one yesterday on NuGet. sebastienros/jint#996

[sebastienros]

I'd like to understand how to repro and fix the first issue though with the json filter. Can you provide me with the type of object that was passed in Order?

[hyzx86]

The order just like this

{
        "Created_Date": "2021-10-13T00:00:00",
        "Delivery_Number": "145163194",
        "Delivery_Item": "10",
        "Reference_Doc": "189300886",
        "Material": "66253124583",
        "Sales_text_line1": "xVBE",
        "Delivery_Quantity": 1,
        "Sales_Unit": "PC",
        "Shipping_point": "2049",
        "Plant": "2049",
        "Soldto_Code": "20402307",
        "Soldto_Name_3": "xxxx",
        "Route": "CNZ001",
        "PO_Number": "RDMJ20210811",
        "Shipto_Name_3": "大xxx",
        "City": "xxx",
        "Sales_office": "CNNE",
        "User_name": "Q0312395",
        "Ship-to-party": "xxx",
        "Ship_to_Address": "xxxx",
        "Customer_material": "A-BA0153",
        "Gross_weight": 41000.4,
        "Weight_Unit": "G",
        "Markfor_Code": xxx,
        "Markfor_Name": "xxxxx",
        "Volume": 0,
        "Volume_Unit": "",
        "Payer_Code": "xxx",
        "Payer_Name_3": "xxxx",
        "Route_description": "1048197 -xxxxx",
        "Ship-to-party_Name": "xxxxx",
        "Reference_Item": "1",
        "order_quantity": 15,
        "open_quantity": 2,
        "document_date": "2021-08-11T00:00:00",
        "addl._Data_B-GI_date": "2021-09-28T00:00:00",
        "delivery_priority": 2,
        "terms_of_payment": "CN35",
        "Sales_Document": "189300886",
        "Credit_account": "20136991",
        "Credit_value": "",
        "Credit_exposure": "",
        "Credit_limit": "",
        "Created_By": "",
        "STAT": "",
        "STATUS": "",
        "delivery_text": "",
        "SHIP_TO_contact_person_NAME": "",
        "ship_to_contact_person_TEL": ""
    }

[sebastienros]

But what dotnet type is that if you debug? I'd like to create a unit test.

[hyzx86]

the data is from a DataTable but，before use Jint ，I have Serialize the datatable to Json strings.

so the orginal data schema just like an array:

[
{ ...order }
]

my service method GetExcelDataFromConfigAsync:

            var data= ReadDataFromExcel(xxx);
            var engine = _scriptingManager.GetScriptingEngine("js");
            var scope = engine.CreateScope(_scriptingManager.GlobalMethodProviders.SelectMany(x => x.GetMethods()), ShellScope.Services, null, null);
            var jsScope = scope as JavaScriptScope;
            var result = jsScope.Engine
                    .Execute("var excelTable = " + JsonConvert.SerializeObject(data) + ";")
                    .Evaluate(script)?.ToObject();

the above script variable like this:

const orders = excelTable.map(order => {
    return {
        orderUdf: {
            OrderLines: [
                {
                    ERP_ORDER_LINE: order["Reference_Doc"], 
                    PACKAGE_COUNT: order["Delivery_Quantity"],
                    PACKAGE_COUNT_UOM: "件",
                    WEIGHT: order["Gross_weight"], 
                    VOLUME: order.Volume, 
                    OL_UDF4: order["Sales_Unit"],
                    OL_UDF5: order["PO_Number"]
                }
            ],
            ORDER_ID: `${order["Delivery_Number"]}-${order["Delivery_Item"]}`,
            C_ORDER_NO: order["Reference_Doc"],
            ORDER_RELEASE_TYPE_PSC: "普通单", 
            UDF19: order.Plant,
            UDF20: order.Route,
            UDF_N1: order["Delivery_Quantity"],
            UDF_N2: order["open_quantity"],
            CREATED_BY: order["User_name"],
            CREATED_DATE: order["Created_Date"],//SAP导出的Excel中DN creation date  ：Created Date
        },
        token: "xxxxxx",
        transactionId: "xxx",
        apiKey: "xxx"
    }
})

my workflow task will call this method

 var array = await _excelAppService.GetExcelDataFromConfigAsync(FilePath, ExcelConfigId);
                if (!string.IsNullOrEmpty(ExtraScripts.Expression))
                {
                    var injectResult = new WorkflowExpression<object>(

                        $@"
                            var TEMP_STR ='{Newtonsoft.Json.JsonConvert.SerializeObject(array)}';
                           var {PropertyName}=JSON.parse(TEMP_STR);
                            " + ExtraScripts.Expression

                        );
               
                    var result = await _expressionEvaluator.EvaluateAsync(injectResult, workflowContext);
                    workflowContext.Properties[PropertyName] = result;
                }
                else
                {
                    workflowContext.Properties[PropertyName] = array;
                }

[hyzx86]

From this screenshot, the js execution results are as expected.

The Log in the Task
{{Workflow.Properties["mydata"] | json }}
The output is just the dictionary structure

In Script Task I use JS Script output is also normal

log("Error", mydata)

[hyzx86]

Here is my workflow：

[hyzx86]

[hyzx86]

I found a solution