Skip to main content

API Overview


An API (Application Programming Interface) is a set of predefined interfaces that allows developers to send requests and retrieve data in a standardized way, without accessing source code or understanding the underlying implementation.

HAP currently provides two types of APIs: Organization APIs and Application APIs.

1. Organization APIs

Organization APIs provide access to organization-level data, including users, departments, reporting relationships, logs, and workflow to-dos.

Go to Org Admin > Integration > Misc. > Open API to view the organization's credentials (AppKey and SecretKey) and API documentation.

Organization open API documentation (HAP SaaS): https://apidoc.mingdao.com/en/

For HAP Server, organization administrators can access the documentation from the same location. The API debugging endpoint will automatically use the HAP Server domain.

2. Application APIs

Access the API Documentation

When an application is created, its corresponding APIs are generated automatically. Application administrators can view the API documentation and share it with developers.

Click the button next to the application name and select API Developer Docs.

Application Authorization

You can create multiple application authorizations based on your integration needs. Each authorization includes an AppKey, Sign, and configurable API permission scopes.

API V2 and API V3

Application APIs are available in two versions: API V2 and API V3.

  • API V2

    A ready-to-use API is automatically generated for each worksheet. Request examples are prefilled with parameters such as appKey, Sign, and worksheetId.

  • API V3

    API V3 introduces a redesigned API structure based on V2, with more intuitive endpoint paths and developer-friendly parameter names. The updated structure is also easier for AI tools to understand and use.

    Additional capabilities include:

    • Create, update, and delete worksheets APIs
    • Workflow APIs
    • Worksheet data aggregation APIs
    • Public query APIs (for querying users and departments)

    API V3 uses a unified structure across all applications. For details, refer to the API V3 documentation:

    https://apidoc.mingdao.com/application/en/

Field and View Information Table

Each worksheet includes detailed information about its fields and views.

  • Field Information Table

    Includes:

    • Field ID
    • Field Name
    • Type
    • Control Type ID
    • Description
  • View Information Table

    Includes:

    • View ID
    • View Name
    • View Type

Share and Test APIs

Use the options in the upper-right corner of the API documentation page to test and share APIs.

  • API V3

    The documentation can be shared directly:

    https://apidoc.mingdao.com/application/en/

  • API V2

    When sharing API:

    • Credential information is hidden.
    • Examples that reference credentials display placeholder values such as YOUR_APP_KEY and YOUR_SIGN.
    • You can configure an expiration date and password for the shared link.

Filter Generator

The Filter Generator allows you to generate filter code through a visual configuration interface.

Path:

Application API Documentation > Worksheet > Target Worksheet > Field Information Table > Filter Generator

API Rate Limits and Restrictions

API Rate Limits

API requests are currently rate-limited only by source IP address. No rate limits are applied at the application or user level.

Requests that exceed the rate limit or request body size limit will be rejected.

APIQPS per IP (Requests Per Second)Request Body Size Limit
Add Record (addRow)5016 MB
Batch Add Records (addRows)5016 MB
Edit Record (editRow)5016 MB
Batch Edit Records (editRows)5016 MB
Delete Record (deleteRow)5016 MB
Get Record Count (getFilterRowsTotalNum)50/
Get Record List (getFilterRows)50/
Other APIsUnlimited/
HAP ServerUnlimited25 MB
⚠️⚠️⚠️

1. If requests from the same IP exceed the rate limit, the API gateway returns HTTP status code 503 and the following response: {"error_code":90001,"success":false,"error_msg":"API rate limit exceeded"}.

If you encounter this error, consider the following approaches:

  • Implement retry logic to improve application resilience.
  • Add delays between requests, especially when processing requests in a loop (for example, Sleep(200ms)).

2. If the request body exceeds the size limit, the request is rejected directly and the API gateway returns HTTP status code 413: Request Entity Too Large.

If you need to process larger payloads, consider the following approaches:

  • Split the data – Divide large datasets into smaller batches and submit them separately.
  • Optimize the payload structure – Remove unnecessary fields and reduce the request size where possible.

Appendix

Error Codes

CodeDescription
0Failed
1Success
51Request rate limit exceeded
10000Access denied, IP restricted
10001Invalid parameter
10002Invalid parameter value
10005Insufficient permissions for the data operation
10006Data already exists
10007Data does not exist or has been deleted
10101Token not found
10102Invalid signature
10105User access token expired
10106User organization access token restricted
100005Duplicate field value
100006Option limit reached
100007Maximum number of attachments reached
430013Worksheet not found in the application
430014Insufficient worksheet field permissions
430017Insufficient application attachment quota
430018Draft record limit reached
430019Required field value is empty
430020Invalid subform data
430021Data does not meet business rules
430022Worksheet not found
90000Request limit exceeded
99999Data operation exception

API V3 Endpoint List

Online API documentation:

https://apifox.mingdao.com/get_app_info

No.CategoryEndpointDescription
1ApplicationGet Application InformationRetrieve groups, worksheets, and custom pages within an application
2WorksheetGet Worksheet ListRetrieve all worksheets in an application
3WorksheetGet Worksheet StructureRetrieve the complete worksheet structure, including fields and views
4WorksheetCreate WorksheetCreate a new worksheet and define its fields and layout
5WorksheetUpdate Worksheet StructureModify a worksheet structure, including adding, editing, or deleting fields
6WorksheetDelete WorksheetDelete a specified worksheet
7RecordGet Record ListRetrieve records with support for pagination, filtering, sorting, and views
8RecordGet Record DetailsRetrieve all field values for a specific record
9RecordCreate RecordCreate a new record and optionally trigger workflows
10RecordUpdate RecordUpdate field values in a specified record
11RecordDelete RecordDelete a specified record (supports both logical and permanent deletion)
12RecordBatch Create RecordsCreate multiple records in a single request
13RecordBatch Update RecordsUpdate multiple records in a single request
14RecordBatch Delete RecordsDelete multiple records in a single request
15RecordGet Related RecordsRetrieve related data from a specified relationship field
16RecordGet Record Pivot DataPerform worksheet data analysis with aggregated statistics
17RecordGet Record Sharing LinkGenerate an external sharing link for a record with optional password protection and expiration settings
18RecordGet Record LogsRetrieve change history logs for a record
19RecordGet Record DiscussionsRetrieve discussions associated with a record
20Option SetGet Option Set ListRetrieve all option sets and their options within an application
21Option SetCreate Option SetCreate a new option set, including option values, colors, and assigned values
22Option SetUpdate Option SetModify an option set name or option content
23Option SetDisable Option SetDisable (delete) a specified option set
24WorkflowGet Triggerable Workflow ListRetrieve workflows that can be triggered within an application
25WorkflowGet Triggerable Workflow DetailsRetrieve workflow details and input parameter definitions
26WorkflowTrigger WorkflowManually trigger a workflow
27RoleGet Role ListRetrieve all roles and member information within an application
28RoleCreate RoleCreate a role and configure permissions
29RoleGet Role DetailsRetrieve permissions and member information for a specified role
30RoleDelete RoleDelete a specified role
31RoleAdd Role MembersAdd users, departments, or other members to a role
32RoleRemove Role MembersRemove specified members from a role
33RoleRemove Member from All RolesRemove a user from all roles in the application
34Public QueryFind UsersFind users by exact name match (with masked phone numbers and email addresses)
35Public QueryFind DepartmentsFind departments by exact name match
36Public QueryGet Region InformationRetrieve administrative region information (province, city, district)

Was this document helpful?