The invention discloses a configuration and execution method and system of a web API, and a medium. The disclosed configuration and execution method of a web API includes obtaining a name or a uniqueidentifier of the web API, a web field name involved in the web API, and an operation type of the web API.; obtaining the database and/or datasheet and data field names involved in the web API; storing the mapping between a name or unique identifier, type of operation, web field name, and data field name to complete the interface configuration of the web API. The disclosed technical scheme can generate an API only by configuring a database, so the efficiency of software and service providers to implement the API are improved, and also the maintenance cost of the API in the later period is reduced.