Thank you! Your answer was very useful. I created this API controller using your contribution:
const { createCoreController } = require(“@strapi/strapi”).factories;
module.exports = createCoreController(
“api::octuber-reports-2023.october-reports-2023”,
({ strapi }) => ({
async schema(ctx) {
try {
const prefixContentManager =
“plugin_content_manager_configuration_content_types”;
let contentID = ctx.request.query.api;
let sqlStatement =
“SELECT * FROM strapi_core_store_settings WHERE key = '” +
prefixContentManager +
“::” +
contentID +
“'”;
const result = await strapi.db.connection.context.raw(sqlStatement);
ctx.body = JSON.parse(result[0].value);
} catch (err) {
ctx.body = err;
}
},
})
);