Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Transforms key-value object to tuples. All data fields which are not defined in schema will be lostUse the SCHEMA attribute to define:

  • the path of the input that should be part of the tuple. This could be a dot based path: e.g. root.id.value. This is only possible if the result is not a KeyValueObject! You can also use JSONPATH.
  • optional the name that should be use in the schema of the tuple (remark special charactes from Jsonpath like "$", "*", etc. are replaced automatically
  • the datatype of the element that is retrieved from the key value object. This could also be a key value object or List

WIth the type field you can set the type of the tuple.

Code Block
languagepql
#DEFINE SCHEMA [['timestamp.unixtimestamp', 'List(Integer)'],['timestamp.iso', 'String'],['track.name', 'String']]
tuple = KEYVALUETOTUPLE({schema=${SCHEMA}, KEEPINPUT = 'false', TYPE = 'type'}, receiverJSON)

...

Transforms tuples to key-value objects based on the tuples schema.

Code Block
languagepql
tupleToKeyValue = TUPLETOKEYVALUE({type='KEYVALUEOBJECT'}, receiverTuple)

Select

The select operator can be used for key value objects in the same way as for tuples.

...