Array to string conversion Help

[Chackmool]

I am trying to make a simple insert to a database. To generare a short random number I am using

{{UUID.split('-').top(1)}}

But when I make the insert in the database I get this error.

{
"code": 0,
"file": "/Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/db/Connection.php",
"line": 141,
"message": "Array to string conversion",
"trace": "#0 [internal function]: exception_error_handler(8, 'Array to string...', '/Applications/M...', 141, Array)\n#1 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/db/Connection.php(141): PDOStatement->bindParam(1, 'Array', 2)\n#2 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/modules/dbupdater.php(164): lib\\db\\Connection->execute('INSERT INTO `qr...', Array, false, 'qrControl')\n#3 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/App.php(223): modules\\dbupdater->insert(Object(stdClass), 'insert', Array)\n#4 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/App.php(195): lib\\App->execSteps(Object(stdClass))\n#5 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/App.php(163): lib\\App->execSteps(Array)\n#6 /Applications/MAMP/htdocs/huatul.co/www/dmxConnectLib/lib/App.php(113): lib\\App->exec(Array, false)\n#7 /Applications/MAMP/htdocs/huatul.co/www/dmxConnect/api/test.php(8): lib\\App->define(Array)\n#8 {main}"
}

Here is what I have.

I have tried JOIN or to Array formatter without success.

Any help is welcome.

[Teodor]

@Chackmool

{{UUID.split('-').top(1)}}

This expression does not return a string, it returns an array with a single item:

"insertValue": [
"82e3dc62"
]

To get the value as a string you need to do:

{{UUID.split('-').top(1)[0]}}

this will return:

"insertValue": "82e3dc62"

which you can insert.

[Chackmool]

The formatter To String how it works?

[Teodor]

I explained this already in my reply:

@Teodor

To get the value as a string you need to do:

{{UUID.split('-').top(1)[0]}}

[Chackmool]

I mean that what is this formatter?

By the way I find a bug there I will open a new ticket.

[bpj]

@Teodor

{{UUID.split('-').top(1)[0]}}

This could be simplified to

{{UUID.split('-')[0]}}