Does a Json string with spine_db.DatabaseMapping() get automatically parsed to a time_series in spineDb editor?

[JamesOngICL]

I have a quick question on relationship_parameter_values in spine. For instance, if I have this json_template variable that I use in python3 (whereby data is a dictionary key and I can load a specific parameter value into it according to a time series I want to define).

json_template = {
    "type": "time_series",
    "data":[18.43296333, 17.97232443, 17.97232443, 17.97232443],
    "index":  {"start":"2015-01-01T00:00",
    "resolution":"1D",
    "ignore_year":False,
    "repeat":False,
},

}
After using the json.dumps(json_template ) I get json_template as a json object.

However, I just want to ask if everything is defined correctly will spinetoolbox databases recognize the template like below as a string in plain value?

{"type": "time_series", "data": [18.43296333, 17.97232443, 17.97232443, 17.97232443], "index": {"start": "2015-01-01T00:00", "resolution": "1D", "ignore_year": false, "repeat": false}}

Or is there supposed a built in parser that takes these parameters and defines a time-series parameter value automatically?

[JamesOngICL]

It is automatically defined ^^ However, the API format should be understood

[soininen]

We use the JSON format internally within the database and it is subject to change (and such change has been discussed a number of times already). While it is currently possible to feed JSON directly into Database editor, it isn't guaranteed to work in the future.

I recommend inputting data via Parameter value editors ("build-in parser") or Importer project items. If you want to use Python, have a look at the spinedb_api.parameter_value module. You can create time series using theTimeSeriesFixedResolution and TimeSeriesVariableResolution classes which can then be converted to the correct JSON format (or whatever format we may use in the future) by to_database(). All in all, I recommend avoiding working directly with JSON here.