Using field ID instead of ID for SQL-Update class action

[mrsibs]

Hi there,

I want to create API using SQL-Update class action with PUT method. Currently im using fusio 5.1.10.

Is there a way to use database field name (example stock_id) for SQL-Update class action instead of "id"?

If possible, i dont want to rename existing field name stock_id to id.

Thank you for your reply.

[chriskapp]

Hi @mrsibs in general the SQL-Update action dynamically detects the primary key from your table and uses this column, so there should be no need to rename your column s.
https://github.com/apioo/fusio-adapter-sql/blob/master/src/Action/SqlUpdate.php#L61

The table infos are cached so you maybe need to clear your cache.

[mrsibs]

hi,
i have restarted mariadb service but still got error:
Id not available in /...../vendor/fusio/adapter-sql/src/Action/SqlManipulationAbstract.php on line 109

[chriskapp]

ok, can you give me the CREATE TABLE statement of your table and the JSON config from your action so that I can try to reproduce the error locally?

[mrsibs]

sure..

CREATE TABLE inventori (
idinventori varchar(10) NOT NULL,
kat_inventori varchar(15) DEFAULT NULL,
PRIMARY KEY (idinventori),
UNIQUE KEY idinventori (idinventori)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;

{
"id": 16,
"status": 1,
"name": "stockitem_update",
"class": "Fusio.Adapter.Sql.Action.SqlUpdate",
"async": false,
"config": {
"connection": "7",
"table": "inventori",
"mapping": []
},
"date": "2025-03-01T08:30:26Z"
}

[chriskapp]

so it looks like everything works as expected s.

I have created your table and simply an entry with test/test and then I could update the value.
One thing which is important is that the path at your operation contains an :id fragment which is required by the SqlUpdate action, but this is only the uri fragment key and does not specify the primary key s.

[mrsibs]

hi, my issue resolved after i add :id at the path at my operation..thank you very much @chriskapp ..