Business API Design Specification - Update Filmproject

A Business API is a set of logical actions centered around a main data object. These actions can range from simple CRUD operations to complex workflows that implement intricate business logic.

While the term “API” traditionally refers to an interface that allows software systems to interact, in Mindbricks a Business API represents a broader concept. It encapsulates a business workflow around a data object, going beyond basic CRUD operations to include rich, internally coordinated actions that can be fully designed and customized.

This document provides an in-depth explanation of the architectural design of the updateFilmProject Business API. It is intended to guide backend architects and developers in maintaining the current design. Additionally, frontend developers and frontend AI agents can use this document to understand how to properly consume this API on the client side.

Main Data Object and CRUD Operation

The updateFilmProject Business API is designed to handle a update operation on the FilmProject data object. This operation is performed under the specified conditions and may include additional, coordinated actions as part of the workflow.

API Description

Update a film project. Only the owner or admin can update. Only admin can set approvalStatus=approved/rejected. Owner can withdraw (approvalStatus=withdrawn).

API Frontend Description By The Backend Architect

For editing project details (including withdrawal). ApprovalStatus can only be changed by admin (other than withdrawn by owner). Owner cannot submit direct publish/approve requests; always wait admin.

API Options

API Controllers

A Mindbricks Business API can be accessed through multiple interfaces, including REST, gRPC, WebSocket, Kafka, or Cron. The controllers listed below map the business workflow to a specific interface, enabling consistent interaction regardless of the communication channel.

REST Controller

The updateFilmProject Business API includes a REST controller that can be triggered via the following route:

/v1/filmprojects/:filmProjectId

By sending a request to this route using the service API address, you can execute this Business API. Parameters can be provided in multiple HTTP locations, including the URL path, URL query, request body, and request headers. Detailed information about these parameters is provided in the Parameters section.

MCP Tool

REST controllers also expose the Business API as a tool in the MCP, making it accessible to AI agents. This updateFilmProject Business API will be registered as a tool on the MCP server within the service binding.

API Parameters

The updateFilmProject Business API has 15 parameters that must be sent from the controller. Note that all parameters, except session and Redis parameters, should be provided by the client.

Business API parameters can be:

Regular Parameters

Name Type Required Default Location Data Path
filmProjectId ID Yes - urlpath filmProjectId
Description: This id paremeter is used to select the required data object that will be updated
title String No - body title
Description: Project title, unique per owner
description Text No - body description
Description: Project description (for details page/fulltext search)
synopsis Text No - body synopsis
Description: Short synopsis or tagline
budget Double No - body budget
Description: Estimated budget (USD)
cast String No - body cast
Description: List of major cast members (names)
genre String No - body genre
Description: Project genres/tags
isPublic Boolean No - body isPublic
Description: Project public visibility flag
approvalStatus Enum Yes - body approvalStatus
Description: Project approval/publication workflow status
mediaUrls String No - body mediaUrls
Description: Project demo reel/trailer/cover media URLs
featured Boolean No - body featured
Description: Platform feature flag (for promoted projects)
publishedAt Date No - body publishedAt
Description: Publication date
accessPolicy Enum No - body accessPolicy
Description: Access policy (open: any authorized user, restricted: need grant)
director String No - body director
Description: Director of the film project
fundingGoal Double No - body fundingGoal
Description: Funding goal amount (USD)

Parameter Transformations

Some parameters are post-processed using transform scripts after being read from the request but before validation or workflow execution. Only parameters with a transform script are listed below.

No parameters are transformed in this API.

AUTH Configuration

The authentication and authorization configuration defines the core access rules for the updateFilmProject Business API. These checks are applied after parameter validation and before executing the main business logic.

While these settings cover the most common scenarios, more fine-grained or conditional access control—such as permissions based on object context, nested memberships, or custom workflows—should be implemented using explicit actions like PermissionCheckAction, MembershipCheckAction, or ObjectPermissionCheckAction.

Login Requirement

This API requires login (loginRequired = true). Requests from non-logged-in users will return a 401 Unauthorized error. Login is necessary but not sufficient, as additional role, permission, or other authorization checks may still apply.

Ownership Checks

This Business API enforces ownership of the main data object before executing the operation.

Role and Permission Settings

Where Clause

Defines the criteria used to locate the target record(s) for the main operation. This is expressed as a query object and applies to get, list, update, and delete APIs. All API types except list are expected to affect a single record.

If nothing is configured for (get, update, delete) the id fields will be the select criteria.

Select By: A list of fields that must be matched exactly as part of the WHERE clause. This is not a filter — it is a required selection rule. In single-record APIs (get, update, delete), it defines how a unique record is located. In list APIs, it scopes the results to only entries matching the given values. Note that selectBy fields will be ignored if fullWhereClause is set.

The business api configuration has no selectBy setting.

Full Where Clause An MScript query expression that overrides all default WHERE clause logic. Use this for fully customized queries. When fullWhereClause is set, selectBy is ignored, however additional selects will still be applied to final where clause.

The business api configuration has no fullWhereClause setting.

Additional Clauses A list of conditionally applied MScript query fragments. These clauses are appended only if their conditions evaluate to true. If no condition is set it will be applied to the where clause directly.

The business api configuration has no additionalClauses setting.

Actual Where Clause This where clause is built using whereClause configuration (if set) and default business logic.

runMScript(() => ({$and:[{id:this.filmProjectId},{isActive:true}]}), {"path":"services[1].businessLogic[1].whereClause.fullWhereClause"})

Data Clause

Defines custom field-value assignments used to modify or augment the default payload for create and update operations. These settings override values derived from the session or parameters if explicitly provided.", Note that a default data clause is always prepared by Mindbricks using data property settings, however any property in the data clause can be override by Data Clause Settings.

An update data clause populates all update-allowed properties of a data object, however the null properties (that are not provided by client) are ignored in db layer.

Custom Data Clause Override No custom data clause override configured

Actual Data Clause

The business api will use the following data clause. Note that any calculated value will be added to the data clause in the api manager.

{
  title: this.title,
  description: this.description,
  synopsis: this.synopsis,
  budget: this.budget,
  cast: this.cast ? this.cast : 
                 ( this.cast_remove ? sequelize.fn('array_remove', sequelize.col('cast'), this.cast_remove) : (this.cast_append ? sequelize.fn('array_append', sequelize.col('cast'), this.cast_append) : undefined)) ,
  genre: this.genre ? this.genre : 
                 ( this.genre_remove ? sequelize.fn('array_remove', sequelize.col('genre'), this.genre_remove) : (this.genre_append ? sequelize.fn('array_append', sequelize.col('genre'), this.genre_append) : undefined)) ,
  isPublic: this.isPublic,
  approvalStatus: this.approvalStatus,
  mediaUrls: this.mediaUrls ? this.mediaUrls : 
                 ( this.mediaUrls_remove ? sequelize.fn('array_remove', sequelize.col('mediaUrls'), this.mediaUrls_remove) : (this.mediaUrls_append ? sequelize.fn('array_append', sequelize.col('mediaUrls'), this.mediaUrls_append) : undefined)) ,
  featured: this.featured,
  publishedAt: this.publishedAt,
  accessPolicy: this.accessPolicy,
  director: this.director,
  fundingGoal: this.fundingGoal,
}

Business Logic Workflow

[1] Step : startBusinessApi

Manager initializes context, prepares request and session objects, and sets up internal structures for parameter handling and milestone execution.

You can use the following settings to change some behavior of this step. apiOptions, restSettings, grpcSettings, kafkaSettings, sseSettings, cronSettings

[2] Step : readParameters

Manager reads parameters from the request or Redis, applies defaults, and writes them into context for downstream milestones.

You can use the following settings to change some behavior of this step. customParameters, redisParameters

[3] Step : transposeParameters

Manager executes parameter transform scripts and derives any helper values or reshaped payloads into the context.

[4] Step : checkParameters

Manager validates required parameters, checks ID formats (UUID/ObjectId), and ensures all preconditions for update are met.

[5] Action : fetchOwner

Action Type: FetchObjectAction

Fetch project owner details for permission check

class Api {
  async fetchOwner() {
    // Fetch Object on childObject user

    const userQuery = {
      $and: [
        {
          id: runMScript(() => this.filmProject?.ownerUserId, {
            path: "services[1].businessLogic[1].actions.fetchObjectActions[0].matchValue",
          }),
        },
        { isActive: true },
      ],
    };
    const { convertUserQueryToElasticQuery } = require("common");
    const scriptQuery = convertUserQueryToElasticQuery(userQuery);

    const elasticIndex = new ElasticIndexer("user");
    const data = await elasticIndex.getOne(scriptQuery);

    return data
      ? {
          id: data["id"],
          roleId: data["roleId"],
        }
      : null;
  }
}

[6] Step : checkBasicAuth

Manager performs login verification, role, and permission checks, enforcing tenant and access rules before update.

You can use the following settings to change some behavior of this step. authOptions

[7] Step : buildWhereClause

Manager constructs the WHERE clause used to identify the record to update, applying ownership and parent checks if necessary.

You can use the following settings to change some behavior of this step. whereClause

[8] Step : fetchInstance

Manager fetches the existing record from the database and writes it to the context for validation or enrichment.

[9] Action : validateApprovalStatus

Action Type: FunctionCallAction

Ensure only admin can approve/reject; owner can only withdraw.

class Api {
  async validateApprovalStatus() {
    try {
      return runMScript(
        () =>
          (() => {
            const prevStatus = this.filmProject.approvalStatus;
            const newStatus = this.input?.approvalStatus ?? prevStatus;
            const isAdmin = this.session.roleId === "admin";
            // Only admin can approve or reject
            if (
              (newStatus === "approved" || newStatus === "rejected") &&
              !isAdmin
            ) {
              return false;
            }
            // Only owner can withdraw, only from pending/approved
            if (newStatus === "withdrawn") {
              if (
                this.session.userId !== this.filmProject.ownerUserId &&
                !isAdmin
              ) {
                return false;
              }
            }
            // Pending can always be set by owner (i.e. editing reverts to pending)
            return true;
          })(),
        {
          path: "services[1].businessLogic[1].actions.functionCallActions[0].callScript",
        },
      );
    } catch (err) {
      console.error("Error in FunctionCallAction validateApprovalStatus:", err);
      throw err;
    }
  }
}

[10] Action : enforceTransitionRule

Action Type: ValidationAction

Block illegal approvalStatus transitions by non-admins

class Api {
  async enforceTransitionRule() {
    if (this.checkAbsolute()) return true;

    const isValid = runMScript(() => this.isApprovalTransitionValid === true, {
      path: "services[1].businessLogic[1].actions.validationActions[0].validationScript",
    });

    if (!isValid) {
      throw new ForbiddenError(
        "You don't have permission to change approval status this way.",
      );
    }
    return isValid;
  }
}

[11] Step : checkInstance

Manager performs instance-level validations, including ownership, existence, lock status, or other pre-update checks.

[12] Step : buildDataClause

Manager prepares the data clause for the update, applying transformations or enhancements before persisting.

You can use the following settings to change some behavior of this step. dataClause

[13] Step : mainUpdateOperation

Manager executes the update operation with the WHERE and data clauses. Database-level events are raised if configured.

[14] Step : buildOutput

Manager assembles the response object from the update result, masking fields or injecting additional metadata.

[15] Step : sendResponse

Manager sends the response back to the controller for delivery to the client.

[16] Step : raiseApiEvent

Manager triggers API-level events, sending relevant messages to Kafka or other integrations if configured.

Rest Usage

Rest Client Parameters

Client parameters are the api parameters that are visible to client and will be populated by the client. Note that some api parameters are not visible to client because they are populated by internal system, session, calculation or joint sources.

The updateFilmProject api has got 15 regular client parameters

Parameter Type Required Population
filmProjectId ID true request.params?.[“filmProjectId”]
title String false request.body?.[“title”]
description Text false request.body?.[“description”]
synopsis Text false request.body?.[“synopsis”]
budget Double false request.body?.[“budget”]
cast String false request.body?.[“cast”]
genre String false request.body?.[“genre”]
isPublic Boolean false request.body?.[“isPublic”]
approvalStatus Enum true request.body?.[“approvalStatus”]
mediaUrls String false request.body?.[“mediaUrls”]
featured Boolean false request.body?.[“featured”]
publishedAt Date false request.body?.[“publishedAt”]
accessPolicy Enum false request.body?.[“accessPolicy”]
director String false request.body?.[“director”]
fundingGoal Double false request.body?.[“fundingGoal”]

REST Request

To access the api you can use the REST controller with the path PATCH /v1/filmprojects/:filmProjectId

  axios({
    method: 'PATCH',
    url: `/v1/filmprojects/${filmProjectId}`,
    data: {
            title:"String",  
            description:"Text",  
            synopsis:"Text",  
            budget:"Double",  
            cast:"String",  
            genre:"String",  
            isPublic:"Boolean",  
            approvalStatus:"Enum",  
            mediaUrls:"String",  
            featured:"Boolean",  
            publishedAt:"Date",  
            accessPolicy:"Enum",  
            director:"String",  
            fundingGoal:"Double",  
    
    },
    params: {
    
        }
  });

REST Response

The API response is encapsulated within a JSON envelope. Successful operations return an HTTP status code of 200 for get, list, update, or delete requests, and 201 for create requests. Each successful response includes a "status": "OK" property. For error handling, refer to the “Error Response” section.

Following JSON represents the most comprehensive form of the filmProject object in the respones. However, some properties may be omitted based on the object’s internal logic.

{
	"status": "OK",
	"statusCode": "200",
	"elapsedMs": 126,
	"ssoTime": 120,
	"source": "db",
	"cacheKey": "hexCode",
	"userId": "ID",
	"sessionId": "ID",
	"requestId": "ID",
	"dataName": "filmProject",
	"method": "PATCH",
	"action": "update",
	"appVersion": "Version",
	"rowCount": 1,
	"filmProject": {
		"id": "ID",
		"title": "String",
		"description": "Text",
		"synopsis": "Text",
		"budget": "Double",
		"cast": "String",
		"genre": "String",
		"projectType": "Enum",
		"projectType_idx": "Integer",
		"ownerUserId": "ID",
		"studioId": "ID",
		"isPublic": "Boolean",
		"approvalStatus": "Enum",
		"approvalStatus_idx": "Integer",
		"mediaUrls": "String",
		"featured": "Boolean",
		"publishedAt": "Date",
		"accessPolicy": "Enum",
		"accessPolicy_idx": "Integer",
		"director": "String",
		"fundingGoal": "Double",
		"isActive": true,
		"recordVersion": "Integer",
		"createdAt": "Date",
		"updatedAt": "Date",
		"_owner": "ID"
	},
	"ownerUser": {
		"roleId": "String"
	}
}