how to throw error for record not found with customised message

[mrsibs]

Hi there,
In operation, there is a throws option with schema.currently im using Not Found option with schema message. how i want to display json formatted like example below for record not found:
{
"success" : false,
"title" : "record not found"
}

[chriskapp]

Hi @mrsibs in general you can create a custom schema at the schema panel and then use your custom schema as error response at this operation, then you also need to adjust your action so that it returns the described format.

[mrsibs]

hi there,
This is my schema :

{
"type": "object",
"properties": {
"success": {
"type": "boolean"
},
"title": {
"type": "string"
}
},
"required": ["success", "title"]
}

and i have set at operation like this:

THROW : NOT FOUND, SCHEMA : THROWERRORSCHEMA

In Action, im using SQL-UPDATE, how i want to adjust my action to return as prescribed format?

Thanks for the quick responses.

[chriskapp]

ok, now I understand the problem, the schema only describes the response data of the action, the SQL-Update action will always return a success and message property independent of the schema which you select s.
https://github.com/apioo/fusio-adapter-sql/blob/master/src/Action/SqlUpdate.php#L72

If you want to change the response you need to build a custom action, which returns this custom response.

[mrsibs]

hi there,

oh..can you guide me how to create custom action using sql update statement.

Really appreciated and thank you very much.

[chriskapp]

Sure, here is an example action to simply update a row from a table, I have also added this example to the markplace s.

<?php

use Fusio\Worker\ExecuteContext;
use Fusio\Worker\ExecuteRequest;
use Fusio\Engine\ConnectorInterface;
use Fusio\Engine\Response\FactoryInterface;
use Fusio\Engine\DispatcherInterface;
use Psr\Log\LoggerInterface;

return function(ExecuteRequest $request, ExecuteContext $context, ConnectorInterface $connector, FactoryInterface $response, DispatcherInterface $dispatcher, LoggerInterface $logger) {

    $connection = $connector->getConnection('System');

    $payload = $request->getPayload();

    $affected = $connection->update('my_table', [
        'name' => $payload->name,
    ], [
        'id' => $request->getArguments()->get('id')
    ]);

    return $response->build(200, [], [
        'success' => true,
        'affected' => $affected,
    ]);
};

[mrsibs]

wow excellent! thanks for the solution, i have tested and success.