Skip to main content

API schema for EasyManage ERP

User

easymanage get all api schema

Cursor

I'll help you get the API schema for the easymanage system. Let me retrieve all the available API schemas.

Here's the complete API schema for the easymanage system:

EasyManage API Schema Overview​

Base URL: http://127.0.0.1:9080

Main Entity Tables​

The API provides CRUD operations for 5 main entities:

  1. SalesOrderMaster - Sales order header information
  2. SalesOrderDetail - Sales order line items
  3. Item - Product/item catalog
  4. GdnMaster - Goods Delivery Note header
  5. GdnDetail - Goods Delivery Note line items

Available Operations​

Each entity supports these standard operations:

Create Operations​

  • POST /emdbrest/{entity}/Create - Create new records

Read Operations​

  • GET /emdbrest/{entity}/ViewAll - Get all records
  • GET /emdbrest/{entity}/ViewAllPaged - Get paginated records
  • GET /emdbrest/{entity}/SelectWhere - Search and filter records
  • GET /emdbrest/{entity}/Query - Query by ID
  • GET /emdbrest/{entity}/GetOne - Get single record
  • GET /emdbrest/{entity}/FindOne - Find by ID

Update Operations​

  • PUT /emdbrest/{entity}/Update - Update existing records

Delete Operations​

  • DELETE /emdbrest/{entity}/Delete - Delete records

Join Operations​

The API also provides join operations for related data:

  1. SalesOrderMaster + SalesOrderDetail (1-to-Many relationship)

    • /emdbrest/SalesOrderMaster/SalesOrderMasterSalesOrderDetail1Multi/*
    • /emdbrest/SalesOrderMaster/SalesOrderMasterSalesOrderDetail5000114/*

  2. SalesOrderDetail + Item (Many-to-One relationship)

    • /emdbrest/SalesOrderDetail/SalesOrderDetailItem5000112/*

Key Data Models​

SalesOrderMaster​

  • Contains customer information, order details, pricing, and delivery information
  • Key fields: salesOrderMasterId, salesOrderNo, custName, orderStatus, basicTotal, etc.

SalesOrderDetail​

  • Line items for sales orders
  • Key fields: salesOrderDetailId, salesOrderMasterId, lineNameShort, lineQuantity, linePrice, etc.

Item​

  • Product catalog with inventory information
  • Key fields: itemId, itemNameShort, itemQuantity, itemPrice, hsnCode, etc.

GdnMaster​

  • Goods delivery note headers
  • Key fields: gdnMasterId, gdnNo, gdnDate, gdnStatus, salesOrderNo, etc.

GdnDetail​

  • Goods delivery note line items
  • Key fields: gdnDetailId, gdnMasterId, lineQuantity, linePrice, salesOrderQty, etc.

Common Parameters​

  • Pagination: page (default: 0), size (default: 10)
  • Search: searchBy (required string)
  • Sorting: sortBy (optional string, default: "")
  • ID Lookups: Entity-specific ID parameters (e.g., salesOrderMasterId, itemId)

This API provides a comprehensive REST interface for managing sales orders, inventory items, and delivery notes in the EasyManage system.