Using json middleware and mapping

[informsnca]

Hi there.

I am trying to rename columns and get some columns to output json, but i cant get it to work.

This is my configs: 'tables' => 'e506b823df49_survey_513632,demo', 'middlewares' => 'cors,errors,basicAuth,json', 'controllers' => 'records,geojson,openapi,status', 'customControllers' => '', 'customOpenApiBuilders' => '', 'cacheType' => 'TempFile', 'cachePath' => '', 'cacheTime' => 10, 'debug' => false, 'basePath' => '', 'openApiBase' => '{"info":{"title":"PHP-CRUD-API","version":"1.0.0"}}', 'json.tables' => 'demo', 'json.columns' => 'two', 'mapping' => 'demo2=demo3,wp_posts.one=demo2.ones',

And this is my json structure: {"records":[{"one":"{"depth": false, "model": "TRX-120", "width": 100, "height": null}","two":"{"depth": false, "model": "TRX-120", "width": 100, "height": null}","3":0,"4":null,"5":null,"key":0}]}

What am i doing wrong?

[mevdschee]

What is the request you are doing and what is the expected output? Also, what is the table structure you are using (SQL create statement)?

[informsnca]

I am using SQL. I am trying both to rename the table columns with this line: 'mapping' => 'demo2=demo3,wp_posts.one=demo2.ones', And i am trying to use the JSON middleware to get this structure turned into propper json: {"depth": false, "model": "TRX-120", "width": 100, "height": null}

Regarding the JSON middleware, i have both tried to make the fields a JSON field and a text field in the database :)

[mevdschee]

'mapping' => 'demo2=demo3,wp_posts.one=demo2.ones',

It seems you are renaming the table twice. I think that that is not supported.