JSON: Add more ACE

[XHXIAIEIN]

Reviewed guidelines

• I have read and understand the suggestion guidelines

Checked for duplicate suggestions

• I checked for existing similar suggestions

Summary

JSON is a very useful and powerful, but C3's vanilla JSON plugin missing some of necessary ACEs, which often causes us to get stuck in some places.

Possible workarounds or alternatives

You need to add a lot of extra steps, or use js to complete it. For experienced developers, this is pretty easy. But when we want to introduce the vanilla JSON plugin to newbies, this puts us in an awkward situation.

Proposed solution

I will add it below

Why is this idea important?

It is very useful for some data-driven games.

Additional remarks

No response

[XHXIAIEIN]

JSON expression: JSON.CurIndex

We need an expression like loopindex for use in a For each loop of a JSON object.

JSON.CurIndex

Currently, it is necessary to Add a new local variable externally to record it, which is very cumbersome.

[XHXIAIEIN]

JSON expression: JSON.KeyCount

Dictionary has the useful KeyCount expression, but the JSON object does not have it.

Add JSON.KeyCount(path) expressions like Object.keys(path).length. Return the number of keys in Path.

This is very useful for statistics and UI lists. For example, if you want to create objects based on the number of keys in the path. And assign index numbers to these objects.

Currently, you have to access the path via JSON: For each and create a local variable outside to count, which is very cumbersome.

[XHXIAIEIN]

JSON action: Stop Loop

We also need Stop Loop action.

When Loop in this structure, When you find a matching value, need a 'Stop loop' so that it does not traverse the entire file.

[XHXIAIEIN]

JSON condition: 'is Empty'

is Empty condition can be used to check whether the object at the path is empty.This is still very useful. For example, it is used to detect the quantity of UI, inventory, item, Achievement, Status Entry, etc.

"data": []
"data": {}
"data": ""

[XHXIAIEIN]

JSON expression: GetDefault

Dictionary has the useful GetDefault() expression, but the JSON object does not have it.

I would appreciate if JSON would also get this functionality as it is very handy.

GetDefault(key, valueIfMissing)

Return the value stored for a key, but if it is missing, return a different value instead. For example Dictionary.GetDefault("name", "guest") will return the value of the key "name" if it exists, otherwise it will return the string "guest".

[XHXIAIEIN]

JSON action: For Each(Ordered)

order any JSON array or object by their keys and/or by their values (ascending/descending), For example, it is very useful when you want to add sorting functionality to the UI.

for example:

[
    {"id": "7001", "name": "banana"},
    {"id": "1002", "name": "carrot"},
    {"id": "2024", "name": "apple"}
]

Order By "id"

{"id": "1002", "name": "carrot"},
{"id": "2024", "name": "apple"}
{"id": "7001", "name": "banana"},

Order By "id.name"

{"id": "2024", "name": "apple"}
{"id": "7001", "name": "banana"},
{"id": "1002", "name": "carrot"},