Data display method, device, electronic device and storage medium

Abstract

The embodiments of the present application relate to the field of computer technology, and in particular to a data display method, device, electronic device and storage medium, which are used to solve the problem of not being able to conveniently perform interactive processing operations on data obtained from an API data source. The method is as follows: the terminal sends a first request message carrying query configuration information and operation configuration information to a processing server, and the processing server obtains API data from the API data source based on the first request message, and processes the API data based on the API fields and operation configuration information in the query configuration information, and returns the API data processing results to the terminal for display, wherein the API data source can be regarded as a database; in this way, the terminal can conveniently complete the setting of the query configuration information and the operation configuration information in the visual interface, and the processing server can perform corresponding processing on the API data based on the instructions of the terminal, thereby effectively improving the efficiency of data processing.

Description

Technical Field

[0001] The embodiments of the present application relate to the field of computer technology, and in particular to data display methods, devices, electronic devices, and storage media. Background Art

[0002] An Application Programming Interface (API) is a set of definitions, procedures, and protocols that enable communication between computer software. Consequently, APIs are widely used. Based on the ability to share data between different applications on a single or distributed platform, APIs can be categorized into four types: remote procedure call, standard query language, file transfer, and information delivery.

[0003] Under related technologies, a terminal can request relevant data from a data source equipped with an API (hereinafter referred to as the API data source) through a processing server. However, under related technologies, although the API has certain computing capabilities, it can only return data in a fixed format, such as tabular data. To ensure real-time display of data, the processing server can only return data in a fixed format to the terminal. Therefore, users cannot conveniently perform corresponding interactive processing operations (such as filtering, sorting, grouping, custom calculations, etc.) on the data based on their usage needs.

[0004] Therefore, a data display method and device are needed to solve the above problems. Summary of the Invention

[0005] The embodiments of the present application provide a data display method and apparatus to solve the problem of being unable to conveniently perform interactive processing operations on data obtained from an API data source.

[0006] The specific technical solutions provided in this application are as follows:

[0007] In a first aspect, a data display method includes:

[0008] In response to a first configuration operation triggered in the query configuration interface, query configuration information is obtained, where the query configuration information at least includes a link address of an application programming interface (API) data source and an API field to be queried;

[0009] In response to a second configuration operation triggered in the operation configuration interface, obtaining operation configuration information, wherein the operation configuration information is used to indicate a processing method of the API data;

[0010] Sending a first request message carrying the query configuration information and the operation configuration information to a processing server, so that the processing server obtains API data from the API data source based on the link address, and processes the API data based on the API field and the operation configuration information to obtain an API data processing result;

[0011] Receive the API data processing result returned by the processing server, and display the API data processing result in a display interface.

[0012] Optionally, the operation configuration information further includes a preset data display method, and the receiving of the API data processing result returned by the processing server and displaying the API data processing result in a display interface includes:

[0013] receiving the API data processing result returned by the processing server, where the API data processing result is returned by the processing server after processing based on the data presentation method;

[0014] The API data processing result is displayed in the display interface.

[0015] Optionally, the query configuration interface and the operation configuration interface are located on the same page, or are located on different pages respectively;

[0016] The display interface is located in the setting display area of the operation configuration interface.

[0017] In a second aspect, a data display method includes:

[0018] Receiving a first request message sent by a terminal that carries query configuration information and operation configuration information, where the query configuration information is obtained by the terminal in response to a first configuration operation triggered in a query configuration interface, the query configuration information at least including a link address of an application programming interface (API) data source and an API field to be queried; and the operation configuration information is obtained by the terminal in response to a second configuration operation triggered in the operation configuration interface, the operation configuration information being used to indicate a processing method for API data.

[0019] Acquire API data from the API data source based on the link address;

[0020] Processing the API data based on the API field and the operation configuration information to obtain an API data processing result;

[0021] The API data processing result is returned to the terminal so that the terminal displays the API data processing result in a display interface.

[0022] Optionally, the processing the filtered API data based on the operation configuration information includes:

[0023] Based on the operation configuration information, one or any combination of the following operations is performed on the filtered API data: filtering, sorting, grouping, and calculation.

[0024] Optionally, the condition field includes a key value in a dimension table; the dimension table is used to record the mapping relationship between each key value and each screening indicator, and the dimension table is an API dimension table or other type of dimension table.

[0025] Optionally, after obtaining the API data returned by the API data source and filtered based on the conditional field, and before processing the API data based on the API field and the operation configuration information, the method further includes:

[0026] The obtained API data is screened and tested based on the conditional fields.

[0027] Optionally, the operation configuration information further includes a data display method, and returning the API data processing result to the terminal includes:

[0028] Reprocessing the API data processing results based on the data display method;

[0029] The reprocessed API data processing result is returned to the terminal, so that the terminal displays the reprocessed API data processing result in a display interface.

[0030] Optionally, after returning the API data processing result to the terminal so that the terminal displays the API data processing result on a display interface, the method further includes:

[0031] receiving a second request message sent by the terminal and carrying screening configuration information, where the screening configuration information is set by the terminal based on the condition field in response to a third configuration operation triggered in the screening configuration interface;

[0032] Re-screening the API data processing result based on the screening configuration information to obtain a screening result;

[0033] The screening result is returned to the terminal so that the terminal displays the screening result in the display interface.

[0034] In a third aspect, a data display device includes:

[0035] A first configuration unit is configured to obtain query configuration information in response to a first configuration operation triggered in the query configuration interface, wherein the query configuration information at least includes a link address of an application programming interface (API) data source and an API field to be queried;

[0036] A second configuration unit is configured to obtain operation configuration information in response to a second configuration operation triggered in the operation configuration interface, wherein the operation configuration information is used to indicate a processing method of the API data;

[0037] a first processing unit, configured to send a first request message carrying the query configuration information and the operation configuration information to a processing server, so that the processing server obtains API data from the API data source based on the link address, and processes the API data based on the API field and the operation configuration information to obtain an API data processing result;

[0038] The second processing unit receives the API data processing result returned by the processing server and displays the API data processing result in a display interface.

[0039] Optionally, in response to a first configuration operation triggered in a query configuration interface, the query configuration information is obtained, and the first configuration unit is configured to:

[0040] In response to a first configuration operation triggered in the query configuration interface, obtaining a link address of the API data source, an API field to be queried, and a set condition field, wherein the condition field is used to indicate a data screening method to the API data source;

[0041] The query configuration information is generated based on the link address of the API data source, the API field to be queried, and the condition field.

[0042] Optionally, the operation configuration information further includes a preset data display mode, and the receiving API data processing result returned by the processing server is displayed on the display interface, and the second processing unit is configured to:

[0043] receiving the API data processing result returned by the processing server, where the API data processing result is returned by the processing server after processing based on the data presentation method;

[0044] The API data processing result is displayed in the display interface.

[0045] Optionally, after displaying the API data processing result in the display interface, the second processing unit is further configured to:

[0046] In response to a third configuration operation triggered in the screening configuration interface, obtaining screening configuration information, wherein the screening configuration information is set based on the condition field;

[0047] Sending a second request message carrying the screening configuration information to the processing server, so that the processing server re-screens the API data processing result based on the screening configuration information to obtain a screening result;

[0048] The filtering result returned by the processing server is received, and the filtering result is displayed in the display interface.

[0049] Optionally, the query configuration interface and the operation configuration interface are located on the same page, or are located on different pages respectively, and the second configuration unit is used to:

[0050] The display interface is located in the setting display area of the operation configuration interface.

[0051] In a fourth aspect, a data display device includes:

[0052] a receiving unit, configured to receive a first request message sent by a terminal and carrying query configuration information and operation configuration information, wherein the query configuration information is obtained by the terminal in response to a first configuration operation triggered in a query configuration interface, the query configuration information at least including a link address of an application programming interface (API) data source and an API field to be queried, and the operation configuration information is obtained by the terminal in response to a second configuration operation triggered in the operation configuration interface, the operation configuration information being used to indicate a processing method for API data;

[0053] A first processing unit, configured to obtain API data from the API data source based on the link address;

[0054] a second processing unit, configured to process the API data based on the API field and the operation configuration information to obtain an API data processing result;

[0055] The third processing unit is used to return the API data processing result to the terminal, so that the terminal displays the API data processing result in a display interface.

[0056] Optionally, the query configuration information further includes a condition field, where the condition field is used to indicate a data filtering method to the API data source. The API data is obtained from the API data source based on the link address, and the API data is processed based on the API field and the operation configuration information to obtain an API data processing result. The first processing unit is configured to:

[0057] Based on the link address, the condition field is sent to the API data source in the form of parameters;

[0058] Obtaining API data returned by the API data source and filtered based on the conditional field;

[0059] Filtering the API data based on the API field;

[0060] The filtered API data is processed based on the operation configuration information to obtain an API data processing result.

[0061] Optionally, after obtaining the API data returned by the API data source and filtered based on the conditional field, and before processing the API data based on the API field and the operation configuration information, the second processing unit is further configured to:

[0062] The obtained API data is screened and tested based on the conditional fields.

[0063] Optionally, the operation configuration information further includes a data display method, and the API data processing result is returned to the terminal, and the third processing unit is configured to:

[0064] Reprocessing the API data processing results based on the data display method;

[0065] The reprocessed API data processing result is returned to the terminal, so that the terminal displays the reprocessed API data processing result in a display interface.

[0066] Optionally, after returning the API data processing result to the terminal so that the terminal displays the API data processing result on a display interface, the third processing unit is further configured to:

[0067] receiving a second request message sent by the terminal and carrying screening configuration information, where the screening configuration information is set by the terminal based on the condition field in response to a third configuration operation triggered in the screening configuration interface;

[0068] Re-screening the API data processing result based on the screening configuration information to obtain a screening result;

[0069] The screening result is returned to the terminal so that the terminal displays the screening result in the display interface.

[0070] Optionally, after receiving the first request message sent by the terminal and carrying the query configuration information and the operation configuration information, the receiving unit is further configured to:

[0071] Generate corresponding token information corresponding to the query configuration information, and save the token information in a cache, wherein the token information corresponds to a validity period;

[0072] After obtaining the API data returned by the API data source and filtered based on the conditional field, the method further includes:

[0073] Saving the API data to a storage area;

[0074] When a third request message carrying the query configuration information is received again from the terminal, acquiring the token information;

[0075] If it is determined that the validity period corresponding to the token information has not timed out, obtaining the API data from the storage area, and processing the API data based on the operation configuration information carried in the third request message to obtain a corresponding API data processing result;

[0076] Return the API data processing result corresponding to the third request message to the terminal.

[0077] Optionally, the processing of the filtered API data based on the operation configuration information, the second processing unit is configured to:

[0078] Based on the operation configuration information, one or any combination of the following operations is performed on the filtered API data: filtering, sorting, grouping, and calculation.

[0079] Optionally, the condition field includes a key value in a dimension table; the dimension table is used to record the mapping relationship between each key value and each screening indicator, and the dimension table is an API dimension table or other type of dimension table.

[0080] According to a fifth aspect, an electronic device includes:

[0081] a memory for storing executable instructions;

[0082] A processor is used to read and execute the executable instructions stored in the memory to implement the method as described in any one of the first aspect or the second aspect.

[0083] In a sixth aspect, a computer-readable storage medium is provided. When instructions in the computer-readable storage medium are executed by a processor, the processor is enabled to perform the method as described in any one of the first aspect or the second aspect.

[0084] In an embodiment of the present application, the terminal sends a first request message carrying query configuration information and operation configuration information to the processing server. Based on the first request message, the processing server obtains API data from the API data source, processes the API data based on the API fields and operation configuration information in the query configuration information, and returns the API data processing results to the terminal for display; in this way, the terminal can conveniently complete the setting of query configuration information and operation configuration information in the visual interface, and even if the API data source can only return API data in a fixed format, the processing server can also perform corresponding processing on the API data based on the instructions of the terminal, so that the terminal indirectly completes the interactive operation of the API data, thereby effectively improving the efficiency and flexibility of data processing, and can meet the rich and diverse usage requirements in different application scenarios, and improve system performance; and the processing server will send the API data processing results to the terminal's visual interface in real time for display, so that the terminal can obtain intuitive data feedback in a timely manner, which is convenient for subsequent further processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0085] Figure 1 This is a schematic diagram of the first application architecture for data display in the embodiments of this application;

[0086] Figure 2 A schematic diagram of a terminal querying API data from an API data source under related technologies;

[0087] Figure 3 This is a macroscopic diagram showing the data in the examples of this application;

[0088] Figure 4 This is a schematic diagram of an overview of the process of displaying data by a terminal in an embodiment of the present application;

[0089] Figures 5A-5E This is the first schematic diagram of the query configuration interface in the embodiment of this application;

[0090] Figure 6 This is an intention to create a new dimension in the embodiment of this application;

[0091] Figures 7A-7J This is a first schematic diagram of the operation configuration interface in the embodiment of the present application;

[0092] Figure 8A-8B This is a first schematic diagram of data display on the display interface of the terminal in an embodiment of the present application;

[0093] Figure 9A and 9C This is a schematic diagram of the screening configuration interface in the embodiment of this application;

[0094] Figure 9B and 9DThis is a schematic diagram showing the screening results in the examples of this application;

[0095] Figure 10 This is a schematic diagram of an overview of the data display process of the processing server in an embodiment of the present application;

[0096] Figure 11A and Figure 11B This is a schematic diagram showing the screening results in the examples of this application;

[0097] Figure 12 This is a schematic diagram of the API data query and screening process of the processing server in an embodiment of the present application;

[0098] Figure 13A This is a detailed flow chart showing the data in the examples of this application;

[0099] Figure 13B This is a second schematic diagram of the query configuration interface in an embodiment of the present application;

[0100] Figure 13C This is a second schematic diagram of the operation configuration interface in an embodiment of the present application;

[0101] Figure 13D This is a second schematic diagram of data display on the display interface of the terminal in an embodiment of the present application;

[0102] Figure 14 This is a schematic diagram of the terminal logic architecture in an embodiment of the present application;

[0103] Figure 15 This is a schematic diagram of the logical architecture of the processing server in the embodiment of the present application;

[0104] Figure 16 This is a schematic diagram of the physical architecture of a computer device in an embodiment of the present application. DETAILED DESCRIPTION

[0105] To make the objectives, technical solutions, and advantages of this application more clear, this application will be further described in detail below with reference to the accompanying drawings. Obviously, the embodiments described are only some of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making any creative efforts are within the scope of protection of this application.

[0106] To facilitate understanding of the embodiments of this application, several concepts are briefly introduced below:

[0107] API: Refers to a set of predefined functions. The purpose of setting up an API is to provide applications and developers with the ability to access a set of routines based on a certain software or hardware without requiring them to access the source code or understand the details of the internal workings.

[0108] Data table: A mapping of relational data sets.

[0109] In the embodiment of the present application, the data table is generated based on the relational data in the API data source.

[0110] For example, suppose a relational data is: Name: Xiaoming; Gender: Male; Education: High School; School: Guangming No. 1 Middle School. Based on the above data relationship, we can get the data table shown in Table 1:

[0111] Table 1

[0112] Name gender Education School Xiao Ming 1 SH GM1

[0113] Dimension table: It is information that explains or marks a column of data in a data table.

[0114] For example, for Table 1, dimension tables as shown in Table 2, Table 3, and Table 4 are set:

[0115] Table 2

[0116] Data table contents True value 1 male 0 female

[0117] Table 3

[0118] Data table contents True value MH junior high school SH high school C University

[0119] Table 4

[0120] Data table contents True value GM1 Guangming No. 1 Middle School GM2 Guangming No. 2 Middle School GM3 Guangming No.3 Middle School GM4 Guangming No. 4 Middle School

[0121] Field: In the embodiment of the present application, each row in the data table is called a "record", and each record contains all the information in this row. In the database, since there is no specific name for each record, the row number of a record is usually used to indicate which record it is.

[0122] A collection of fields constitutes a record. Each field describes a certain feature of a corresponding record, that is, a data item, and has a unique field identifier for computer recognition.

[0123] For example, in Table 1, "1", "SH", and "GM1" can all be referred to as fields.

[0124] Remote Dictionary Service (Redis): This is an open-source, log-based key-value database written in the American National Standards Institute (ANSI C) C language. It can be in-memory or persistent. It supports networking, offers APIs in multiple languages, and provides caching services.

[0125] API data source: A data collection that has an API and can provide data to the outside world.

[0126] Among them, API data source types include but are not limited to: databases, static tables, etc.

[0127] Caching: Querying data from API data sources is time-consuming for processing servers. Accessing data from API data sources consumes CPU and storage resources. Caching allows processing servers to quickly read and write data by storing data read from the API data source in a Redis database, reducing the number of reads and writes the processing server needs to perform over time.

[0128] Database: Simply put, it can be thought of as a digital filing cabinet—a place where electronic files are stored, where users can add, query, update, and delete data. A database is a collection of data stored in a specific way, shared by multiple users, with minimal redundancy, and independent of applications.

[0129] A Database Management System (DBMS) is a computer software system designed for managing databases, typically providing basic functions such as storage, retrieval, security, and backup. DBMSs can be categorized by the database model they support, such as relational or Extensible Markup Language (XML); by the type of computer they support, such as server clusters or mobile phones; by the query language they use, such as Structured Query Language (SQL) or XQuery; by performance priorities, such as maximum scale or maximum speed; or by other classification methods. Regardless of the classification method used, some DBMSs can cross categories, for example, supporting multiple query languages simultaneously.

[0130] Cloud computing is a computing model that distributes computing tasks across a resource pool consisting of a large number of computers, enabling various application systems to access computing power, storage space, and information services as needed. The network that provides these resources is called the "cloud." To users, these resources appear infinitely scalable and can be accessed at any time, used on demand, expanded at any time, and paid for on a pay-per-use basis.

[0131] As a provider of cloud computing infrastructure, a cloud computing resource pool (referred to as a cloud platform, generally referred to as an Infrastructure as a Service (IaaS) platform) is established. Various types of virtual resources are deployed in the resource pool for external customers to choose and use. The cloud computing resource pool mainly includes: computing devices (virtualized machines, including operating systems), storage devices, and network devices.

[0132] Based on logical functional divisions, the Platform as a Service (PaaS) layer can be deployed on top of the IaaS layer, and the Software as a Service (SaaS) layer can be deployed on top of the PaaS layer. SaaS can also be deployed directly on top of IaaS. PaaS is a platform for software execution, such as databases and web containers. SaaS is a variety of business software, such as web portals and text messaging apps. Generally speaking, SaaS and PaaS are layers above IaaS.

[0133] With the development of society, human social activities generate a large amount of data, and these data can only be fully utilized after analysis and processing. Figure 2 As shown, related technologies require the pre-collection of large amounts of data to form a data source. To facilitate reading and writing, related technologies can read data from a data source through an API. This type of data source is hereinafter referred to as an API data source. The terminal sends a request to the API data source to view data. The API data source can only return the corresponding data to the terminal in real time according to a pre-set format (tabular data). Therefore, users cannot conveniently perform interactive processing operations on the data based on actual needs.

[0134] In view of this, in order to solve the above problems, in the embodiments of the present application, refer to Figure 3As shown, the terminal responds to the operations triggered in the query configuration interface and the operation configuration interface, and sends a request message carrying the query configuration information and the operation configuration information to the processing server. The processing server obtains API data from the API data source based on the API address link in the query configuration information, and processes the API data accordingly based on the API fields in the query configuration information and the operation configuration information to obtain the API data processing results. Finally, the processing server returns the API data processing results to the terminal, and the terminal realizes data display in the display interface.

[0135] The preferred embodiments of the present application are further described in detail below with reference to the accompanying drawings.

[0136] In specific implementation, the process of displaying data through the terminal can be applied to a variety of application scenarios. Figure 1 As shown, in an application scenario, the system architecture for realizing data display includes a processing server 101, a terminal 102, and an API data source 103. The terminal 102 can establish a connection with the processing server 101 through a network 100 (such as a wired network or a wireless network), and the processing server 101 can establish a connection with the API data source 103 through a network 100 (such as a wired network or a wireless network). Figure 1 The example is only an example of an application architecture to implement the embodiment of the present invention. The embodiment of the present application is not limited to the above Figure 1 Describes the application structure.

[0137] It should be noted that the processing server involved in the documents of this application can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), and big data and artificial intelligence platforms. The terminal can be a smart phone, tablet computer, laptop computer, desktop computer, smart speaker, smart watch, etc., but is not limited to this. The terminal and the processing server can be directly or indirectly connected through wired or wireless communication, and this application does not limit this.

[0138] Based on the above design concept, refer to Figure 4 As shown, in the embodiment of the present application, the detailed process of the terminal implementing data display is as follows:

[0139] Step 400: The terminal obtains query configuration information in response to a first configuration operation triggered in the query configuration interface.

[0140] Specifically, the terminal can present a query configuration interface in response to a configuration trigger operation, and present various configuration boxes in the query configuration interface, and obtain query configuration information in response to a first configuration operation triggered in each configuration box, wherein the query configuration information at least includes the link address of the API data source and the API field to be queried; further, the query configuration information can also include a condition field, which is used to indicate the data filtering method to the API data source.

[0141] For example: See Figure 5A As shown, in response to the first configuration operation, the terminal obtains the input API link address "http: / / test / lianjie" in the configuration box corresponding to "API link", and obtains the input three options "Name", "Score" and "Birthday" in each configuration box corresponding to "Field Details" as the API fields to be queried.

[0142] As an embodiment, if no information is entered in the configuration box corresponding to the condition parameter, the terminal may generate corresponding query configuration information based on the API link address and the API field to be queried in response to the operation of clicking the "Confirm" button.

[0143] For example: See Figure 5B As shown, in response to the first configuration operation, the terminal obtains the input API link address "http: / / test / lianjie" in the configuration box corresponding to "API link", obtains the input three options "name", "score" and "birthday" in each configuration box corresponding to "field details" as the API fields to be queried, and obtains the input relevant information as the condition field in the configuration box corresponding to "condition parameters". The terminal can respond to the operation of clicking the "Confirm" button and generate corresponding query configuration information based on the API link address, the API field to be queried and the condition field.

[0144] See Figure 5B As shown, in specific implementations, conditional fields can include, but are not limited to, the following three forms: time, value, and associated dimension. Each form serves as a filter for API data set for the API data source. The following describes each of these three forms.

[0145] See Figure 5C As shown, as an embodiment, assuming that the condition field is expressed as "time", and the corresponding time-related information includes "1997", it indicates that the API data source filters out API data generated in 1997.

[0146] See Figure 5DAs shown, as an embodiment, assuming that the condition field is expressed as "numeric value" and the corresponding numeric value related information is "less than 60", the representation indicates that the API data source filters out API data with a value of the "score" field less than 60.

[0147] See Figure 5E As shown, as an embodiment, it is assumed that the condition field is expressed as "associated dimension", and the corresponding associated dimension related information is: the Key value of the dimension table is 4, the name of the dimension table is "surname table", and after query, the real value corresponding to the Key value of the dimension table is 4 is "Li", which indicates that the API data source filters out the API data whose real value of the "name" field contains the word "Li".

[0148] As shown in Table 5, the dimension table records the mapping relationship between each key value (Key) and each real value (Value), and these real values can be used as screening indicators.

[0149] Table 5

[0150]

[0151]

[0152] The dimension table associated with the condition field needs to be configured in advance. For example, see Figure 6 As shown, in response to the configuration operation triggered in the dimension table configuration interface, the terminal obtains the dimension table configuration information in the dimension table configuration interface, and generates and saves the corresponding dimension table based on the dimension table configuration information; wherein the dimension table configuration information at least includes the key value, the real value and the name of the dimension table (such as the surname table).

[0153] Optionally, in an embodiment of the present application, the preset configured dimension table may be an API dimension table (i.e., a dimension table that needs to be called through an API), or other types of dimension tables, such as an EXCEL table, which is not limited here.

[0154] Step 410: The terminal obtains operation configuration information in response to the second configuration operation triggered in the operation configuration interface.

[0155] Specifically, the terminal can present an operation configuration interface in response to a configuration trigger operation, and present various configuration boxes in the operation configuration interface, and obtain operation configuration information in response to a second configuration operation triggered in each configuration box, wherein the operation configuration information is used to indicate the processing method of the API data, including but not limited to any one or any combination of the following processing operations: filtering, sorting, grouping and calculation, etc.; further, the operation configuration information can also include a data display method, and the data display method is used to indicate to the processing server how to display the API data processing results.

[0156] For example: See Figure 7A As shown, in response to the second configuration operation, the terminal can obtain different processing methods for API data in the configuration box corresponding to "Dimension", in the configuration box corresponding to "Value", and in the configuration box corresponding to "Condition"; wherein, optionally, the terminal can respond to the second configuration operation and use any one or any combination of these three configuration boxes to obtain the processing method for API data. This is not limited here. In the embodiment of the present application, only the use of three configuration boxes by the terminal is used as an example for introduction.

[0157] As an example, see Figure 7B and Figure 7C As shown, in response to the second configuration operation, the terminal obtains the input "binding parameters: 2020.08, 2020.09" in the configuration box corresponding to "Dimension", which indicates that the API data returned by the processing server for the API data source is grouped according to the "Birthday" fields "2020.08" and "2020.09".

[0158] As an example, see Figure 7D As shown, in response to the second configuration operation, the terminal obtains the input "Sum" in the configuration box corresponding to the "Numerical Value", which indicates that the processing server is instructing the API data returned by the API data source to sum the API data in the "Score" field to calculate the total score.

[0159] As an example, see Figure 7E As shown, in response to the second configuration operation, the terminal obtains the input "sort" in the configuration box corresponding to the "value", which indicates that the processing server is instructed to sort the API data in the "score" field based on the API data returned by the API data source.

[0160] As an example, see Figure 7F As shown, in response to the second configuration operation, the terminal obtains the input "earlier than June" in the configuration box corresponding to "Condition", indicating that the processing server is instructed to filter out API data earlier than June in the "Birthday" field for the API data returned by the API data source.

[0161] As an example, see Figure 7G As shown, in response to the second configuration operation, the terminal receives the input "Binding Parameter: 1997" in the configuration box corresponding to "Dimension," the input "Sum" in the configuration box corresponding to "Value," and the input "First Quarter and Second Quarter" in the configuration box corresponding to "Condition." This representation instructs the processing server to filter out data from the received API data that contains "1997" in the "Birthday" field and is earlier than June of that year, and then sums the API data in the "Score" field of this data.

[0162] After obtaining the corresponding information input from the above configuration boxes, the terminal can respond to the operation of clicking the "Finish" button and generate corresponding operation configuration information based on the operation processing method obtained from any one or any combination of the above three configuration boxes.

[0163] For example, see Figure 7G and Figure 7H As shown in the figure, as an embodiment, multiple configuration sub-interfaces can be embedded in the operation configuration interface. In response to clicking the "Data Source Management" button, the following sub-interfaces can be entered: Figure 7G The first sub-interface shown in FIG, and in response to clicking the "Page Design" button, you can enter the Figure 7H The second sub-interface shown is used to configure the data display method. All types of configuration operations responded to by the terminal in the first sub-interface and the second sub-interface can be regarded as second configuration operations.

[0164] So, if Figure 7I and Figure 7J As shown, in response to the second configuration operation, the terminal obtains the input "first quarter and second quarter" in the configuration box corresponding to "Condition" in the first sub-interface, and in the second sub-interface, in response to the operation of clicking the "line chart" component, obtains the input data display method "line chart", then the terminal can respond to the operation for clicking the "Finish" button and generate corresponding operation configuration information based on "first quarter and second quarter" and "line chart".

[0165] On the other hand, as an embodiment, the query configuration interface and the operation configuration interface may also be located on the same page, or on different pages, which is not limited here.

[0166] Step 420: The terminal sends a first request message carrying query configuration information and operation configuration information to the processing server, so that the processing server obtains API data from the corresponding API data source based on the obtained link address, and processes the API data based on the obtained API fields and operation configuration information to obtain API data processing results.

[0167] As an embodiment, the first request message sent by the terminal to the processing server may carry query configuration information and operation configuration information.

[0168] For example, the Uniform Resource Locator (URL) information carried in the first request message is as follows:

[0169] http: / / newgephp7.dev.gri.oa.com / server / api / data / test?params[0][field_name]=table_id¶ms[0][type]=IN¶ms[0][value]=["surname table"]&paging[total]=0.

[0170] Among them, [0] represents the order of the condition fields. If there are other condition fields, the numbers in the brackets increase in order of natural numbers; [field_name] = table_id indicates that the condition field name is table_id, [type] = IN indicates that the filter type of the condition field is IN, among which the filter types used to limit string and dimension type fields are: =, IN; the filter types used to limit numeric and date type fields are: >, <, > =, < =, =,! =, between; [value] indicates that the name of the associated dimension table is "surname table"; paging [page] indicates the number of pages of the returned API data, and paging [size] indicates the number of rows per page of the returned API data.

[0171] Furthermore, the specific operations performed by the processing server will be described in detail in subsequent embodiments and will not be described here in detail.

[0172] Step 430: The terminal receives the API data processing result returned by the processing server and displays the API data processing result in a display interface.

[0173] As an embodiment, if the operation configuration information generated by the terminal does not include a data display method, the processing server can return the API data processing results to the terminal based on a default data display method (such as a data table), and the terminal will present the API data processing results in the display interface according to the default data display method.

[0174] As an embodiment, if the operation configuration information generated by the terminal includes a data display method, the processing server can return the API data processing results to the terminal based on the set data display method (such as a line chart), and the terminal will present the API data processing results in the display interface according to the set data display method.

[0175] In a specific implementation, the display interface can be located in the setting display area in the operation configuration interface, or in the setting display area outside the operation configuration interface, such as: displayed in the form of a floating window, displayed in the form of a newly created web page, etc.; in the embodiment of the present application, the setting display area located in the operation configuration interface is used as an example for illustration, but is not limited to this.

[0176] For example, see Figure 8A As shown, if the data display method indicated by the terminal in the operation configuration information is "bar chart", the processing server will process the API data in the form of a "bar chart" and return the processed API data to the terminal, and the terminal will display it in the form of a bar chart.

[0177] Furthermore, if the operation configuration information includes two different types of data display methods, the processor can process the API data according to the two different data display methods respectively, and return the API data processing results to the terminal. The terminal can use different data display methods to display the API processing results in the same display interface.

[0178] For example, see Figure 8B As shown, the processing server processes the API data in two ways, "bar chart" and "line chart", and returns the API processing results to the terminal. The terminal can display the same API data processing results in two ways, namely line chart and bar chart.

[0179] Based on the above process, if the initially displayed API data processing results cannot meet the usage requirements, the terminal can also set a filter to instruct the processing server to further filter the obtained API data processing results.

[0180] In a specific implementation, the terminal responds to the third configuration operation triggered in the filtering configuration interface, and the terminal obtains the filtering configuration information, which is set based on the condition field. The terminal then sends a third request message carrying the filtering configuration information to the processing server, so that the processing server re-filters the API data processing results based on the filtering configuration information to obtain the filtering results, and the terminal receives the filtering results returned by the processing server and displays the filtering results in the display interface.

[0181] In a specific implementation, if the condition field included in the query configuration information in the first configuration information is a value or a time, the screening configuration information may be set based on the value or time in the above condition field.

[0182] For example, see Figure 9A and Figure 9BAs shown, if the condition field included in the query configuration information in the first configuration information is "time", and "time" is set to "1997-2000" in the query configuration information, the terminal can respond to the third configuration operation, and further set the filtering configuration information to "1998" based on "time" in the filtering configuration interface, and the terminal responds to the operation of clicking the "Finish" button, sending a second request message carrying the filtering configuration information to the processing server, so that the processing server re-filters the API data processing results based on the filtering configuration information, obtains the filtering results, and returns the filtering results to the terminal, and the terminal will display the filtering results in the display interface, as shown in FIG. Figure 9B shown.

[0183] In a specific implementation, if the condition field included in the query configuration information in the first configuration information is a key value in a dimension table, the screening configuration information is set based on a mapping relationship of the same dimension table.

[0184] For example: See Figure 9C and Figure 9D As shown, if the condition field contained in the query configuration information in the first configuration information is a key value corresponding to the surname table, and the condition field in the query configuration information is set to the key value "1 and 4" in the surname table, then the terminal can respond to the third configuration operation, and in the filtering configuration interface, further set the filtering configuration information to the key value "1" based on the mapping relationship in the surname table. After querying, the real value corresponding to the data with the key value of 1 in the surname table is "Zhao". Then, in response to the operation of clicking the "Finish" button, the terminal sends a second request message carrying the filtering configuration information to the processing server, so that the processing server re-filters the API data processing results based on the filtering configuration information, obtains the filtering results, and returns the filtering results to the terminal, and the terminal will display the filtering results in the display interface, as shown in the following figure. Figure 9D shown.

[0185] In a specific implementation, when the terminal receives the preliminary API data processing result returned by the processing server, the API data processing result will be displayed in real time on the display interface to facilitate subsequent further processing.

[0186] Furthermore, when the terminal receives the screening results returned by the processing server, it will also display the screening results in real time on the display interface, thereby presenting a data linkage effect to facilitate subsequent further processing.

[0187] Based on the above terminal operation process, refer to Figure 10 As shown, accordingly, in the embodiment of the present application, the detailed process of the processing server to realize data display is as follows:

[0188] Step 1000: The processing server receives a first request message sent by a terminal carrying query configuration information and operation configuration information. The above-mentioned query configuration information is obtained by the corresponding terminal in response to a first configuration operation triggered in the query configuration interface. The query configuration information at least includes the link address of the API data source and the API field to be queried. The operation configuration information is obtained by the corresponding terminal in response to a second configuration operation triggered in the operation configuration interface. The operation configuration information is used to indicate the processing method of the API data.

[0189] In a specific implementation, the query configuration information may further include a condition field, and the operation configuration information may further include a data display method. The specific implementation method has been described in detail in step 400 and step 410 and will not be repeated here.

[0190] Furthermore, after receiving the first request message sent by the terminal carrying query configuration information and operation configuration information, the processing server will also generate corresponding token information corresponding to the query configuration information carried by the first request message, and save the token information in the cache, where each token information corresponds to a valid period, and the query configuration information includes an API field, or includes an API field and a condition field.

[0191] For example, let's assume that the query configuration includes both API fields and condition fields. Assume the query configuration information carried by the first request message includes "name," "grades," and "birthday" as API fields, and the dimension table key value 4 as the condition field. The processing server will then record the corresponding token information for this query configuration information as api_data_token = 1, store the token information in the cache, and set the token information validity period to 5 minutes.

[0192] Step 1010: The processing server obtains API data from the API data source based on the link address.

[0193] In a specific implementation, when executing step 1010, the processing server may adopt, but is not limited to, two implementation methods:

[0194] The first method: If the query configuration information only contains API fields but not condition fields, the processing server will send the API fields to the API data source, and the API data source will return the full amount of API data.

[0195] As an embodiment, when receiving the full amount of API data returned by the API data source, the processing server will create a relational database management system (Mysql) data table, save the full amount of API data in the Mysql data table, and save the Mysql data table to the storage area specified by the processing server (such as a local database), and then filter the full amount of API data based on the API field.

[0196] For example, assume that the MySQL data table created by the processing server based on the full amount of API data returned by the API data source is as shown in Table 6:

[0197] Table 6

[0198] Name gender grade class score Birthday Zhao Yi male Grade 11 Class 1 50 1995 Qian Er female Second year of high school Class 2 60 1996 Sun San male Senior Year Class 3 70 1997 Li Si female Senior Year Class 4 80 1998

[0199] The second method: If the query configuration information contains both API fields and condition fields, the processing server will send the condition fields as parameters to the API data source. The API data source will filter the API data based on the condition fields and return the filtered API data.

[0200] In this way, before the processing server obtains the API data, the API data source will filter the API data based on the conditional fields indicated by the terminal, thereby effectively reducing the API data transmission volume, improving data transmission efficiency, and alleviating API transmission pressure.

[0201] As an embodiment, when receiving the filtered API data returned by the API data source, the processing server may optionally first filter and detect the obtained API data based on the conditional field. After determining that the API data is API data filtered by the API data source based on the conditional field, the processing server creates a Mysql data table, saves the filtered API data in the Mysql data table, and saves the Mysql data table to the storage area specified by the processing server (such as a local database), and then filters the filtered API data again based on the API field.

[0202] For example, assume that the API data source returns filtered API data based on the key values "1 and 4" in the dimension table "Surname Table" set in the condition field. The mapping relationship of the dimension table "Surname Table" is as shown in Table 7 below:

[0203] Table 7

[0204] True value Key Values Zhao 1 money 2 Sun 3 plum 4

[0205] After passing the screening test, the MySQL data table created by the processing server based on the filtered API data returned by the API data source is shown in Table 8:

[0206] Table 8

[0207] Name gender grade class score Birthday Zhao Yi male Grade 11 Class 1 50 1995 Li Si female Senior Year Class 4 80 1998

[0208] Step 1020: The processing server processes the API data based on the API fields and operation configuration information to obtain an API data processing result.

[0209] In a specific implementation, when executing step 1020, the processing server may adopt, but is not limited to, two implementation methods:

[0210] The first method: If the query configuration information only contains API fields but not condition fields, and the operation configuration information only contains the API data processing method but not the data display method, the processing server will first filter the full amount of API data returned from the API data source based on the API fields, and then process the filtered API data according to the API data processing method (such as filtering, grouping, sorting, calculation, etc.), and then return the API data processing results to the terminal based on the default data display method (such as data table).

[0211] For example: still taking the full amount of API data shown in Table 6 as an example, assuming that the query configuration information obtained by the processing server contains the API fields of "name", "grade", "birthday" and "gender", and assuming that the operation configuration information obtained by the processing server contains an instruction to "add" the "grade" field, then the processor in the processing server will generate a corresponding SQL query instruction based on each API field and the instruction to "add" the "grade" field, and send the SQL query instruction to the local database. In this way, the local database will filter the full amount of API data stored in Table 6 based on each API field, and "add" the "grade" field, and return the corresponding API data processing result to the processor, as shown in Table 9:

[0212] Table 9

[0213] Name gender score Birthday Zhao Yi male 50 1995 Qian Er female 60 1996 Sun San male 70 1997 Li Si female 80 1998 Total score 260

[0214] Furthermore, since the operation configuration information does not include a data display method, the processing server returns the API data processing result to the terminal according to the data display method of the data table.

[0215] The second method: If the query configuration information contains both API fields and condition fields, and the operation configuration information contains both API data processing methods and data display methods, the processing server will first re-filter the filtered API data returned from the API data source based on the API fields, and then process the filtered API data according to the API data processing method (such as filtering, grouping, sorting, calculation, etc.), and then return the API data processing results to the terminal based on the indicated data display method (such as a bar chart).

[0216] For example: Still taking the filtered API data shown in Table 8 as an example, assuming that the query configuration information obtained by the processing server contains the API fields of "name", "grade", "birthday" and "gender", and assuming that the operation configuration information obtained by the processing server contains an instruction to "add" the "grade" field, the processor in the processing server will generate a corresponding SQL query instruction based on the various API fields and the instruction to "add" the "grade" field, and send the SQL query instruction to the local database. In this way, the local database will re-filter the API data after the conditional field filtering saved in Table 8 based on the various API fields, and "add" the "grade" field, and return the corresponding API data processing results to the processor, as shown in Table 10:

[0217] Table 10

[0218] Name gender score Birthday Zhao Yi male 50 1995 Li Si female 80 1998 Total score 130

[0219] Furthermore, since the operation configuration information already includes the data display method, the processing server returns the API data processing result to the terminal according to the preset bar chart data display method.

[0220] In actual applications, there are two other situations: 1. The query configuration information includes both API fields and condition fields, while the operation configuration information only includes the API data processing method but not the data display method; 2. The query configuration information only includes API fields but not the condition fields, while the operation configuration information includes both the API data processing method and the data display method.

[0221] The two situations can be solved by adaptively adjusting the first and second methods above, and will not be described in detail here.

[0222] On the other hand, in the specific implementation, for the same API data, if different data display methods are required to be used for display, as an embodiment, the processing server needs to first copy the API data, and establish corresponding data tables for each copy of the API data for storage, and then perform corresponding processing on each copy of the API data, and return the obtained processing results of each API data to the terminal using corresponding data display methods; in this way, data blocking can be effectively avoided when performing read and write operations on each data table.

[0223] Step 1030: The processing server returns the API data processing result to the terminal, so that the terminal displays the API data processing result in a display interface.

[0224] Specifically, the processing server returns the processed API data to the terminal, so that the terminal displays the API data processing results on the display interface.

[0225] The specific display method adopted by the terminal has been described in detail in step 430 and will not be repeated here.

[0226] Based on the above embodiment, further, if the API data processing results initially displayed cannot meet the usage requirements, the processing server will receive a second request message sent by the terminal carrying filtering configuration information. The second request message is set by the terminal in the filtering configuration interface. The specific implementation method has been introduced in detail in step 430 and will not be repeated here.

[0227] After receiving the second request message, the processing server filters the obtained API processing results again based on the second request message, obtains the filtered results, and returns the filtered results to the terminal so that the terminal displays the filtered results in the display interface.

[0228] For example: See Figure 11A As shown, it is assumed that the terminal displays the preliminary API data processing results (as shown in Table 10) in the form of a bar chart, wherein it is assumed that the query configuration information in the first request message corresponding to Table 10 contains the condition fields corresponding to the key values 1 and 4 of the surname table.

[0229] The second request message sent by the terminal to the processing server carries the filtering configuration information obtained in the filtering configuration interface in response to the second configuration operation. The filtering configuration information and the query configuration information in the first request message are set based on the same condition field, and the specific content is: the key value "1" corresponding to the surname table.

[0230] Then, the processing server will filter the API data processing results again based on the filtering configuration information, obtain the corresponding filtering results, as shown in Table 11, and return the filtering results to the terminal, and the terminal will display the filtering results in the display interface, as shown in Table 11. Figure 11B shown.

[0231] Table 11

[0232] Name gender score Birthday Zhao Yi male 50 1995 Total score 50

[0233] In a specific implementation, after obtaining the screening results, the processing server immediately returns the screening results to the terminal, so that the terminal can display the screening results in real time on the display interface.

[0234] From the above process, we can see that Figure 12 As shown, in the embodiment of the present application, the API data query process of the processing server is logically divided into three layers:

[0235] First layer: The processing server obtains API data from the API data source. The corresponding API data is set with API fields and condition fields. The API data is returned to the processing server after being filtered by the API data source based on the condition fields.

[0236] Furthermore, after returning the preliminary API data processing result, the processing server may also obtain the API dimension table and other type dimension tables set by the terminal as screening configuration information.

[0237] Among them, the condition field can be set based on the API dimension table or other types of dimension tables, and the filtering configuration information is generated based on the above condition field; therefore, the processing server obtains the filtering configuration information based on the API dimension table or other types of dimension tables.

[0238] In the embodiment of the present application, the example of simultaneously obtaining the filtering configuration information based on the API dimension table and other types of dimension tables is taken as an example.

[0239] For example, see Figure 12 As shown, in the first layer, the API data source returns the API data filtered based on the conditional fields "key value A and key value B" to the processing server, and the processing server saves the API data. At the same time, the processing server also saves the API fields and conditional fields indicated by the terminal, as well as the API dimension tables and other types of dimension tables used to set the conditional fields.

[0240] Second layer: The processing server uses the API field indicated by the terminal to filter the obtained API data, and the processing server can also further filter the initially returned API processing results based on the filtering configuration information further indicated by the terminal, wherein the filtering configuration information is set based on the condition field.

[0241] For example, see Figure 12 As shown, assuming that the API fields are field A and field B, the processing server will perform preliminary screening of the API data based on the API fields to obtain preliminary API data processing results, wherein the preliminary API data processing results include API data corresponding to key value A, key value B, key value C, and key value D.

[0242] Assuming that the preliminary API processing results cannot meet the usage requirements, the processing server further obtains the filtering configuration information indicated by the terminal, which specifically includes: the condition field set based on the API dimension table: key value A, the condition field set based on other types of dimension tables: key value B, then the processing server will further filter the preliminary API processing results according to the condition field set based on the API dimension table and the condition field set based on other types of dimension tables to obtain the final filtering results, in which the filtering results only include API data corresponding to key value A and key value B.

[0243] The third layer: The processing server processes the preliminary API data results based on the data display method set in the operation configuration information, and processes the screening results obtained after re-screening.

[0244] For example: Still see Figure 12 As shown, based on the data display method set in the operation configuration information, the processing server processes the above screening results and outputs the processed screening results.

[0245] On the other hand, as an embodiment, after executing the above step 1000, since the corresponding token information has been saved corresponding to the query configuration information carried by the first request message, if the terminal again sends a third request message carrying the same query configuration information (such as the same API field and condition field) to the processing server, the token information of the third request message is obtained; if it is determined that the valid time corresponding to the token information has not timed out, the corresponding API data is obtained from the corresponding storage area, and the above API data is processed based on the operation configuration information carried in the third request message to obtain the corresponding API data processing result; finally, the processing server returns the API data processing result corresponding to the third request message to the terminal.

[0246] For example, if the processing server has already saved the corresponding token information api_data_token=1 corresponding to the query configuration information carried in the first request message: using "name", "grades", and "birthday" as API fields, and the dimension table key value of 4 as the condition field, and set the validity period of the token information to 5 minutes, then if the terminal sends a third request message carrying the same query configuration information (using "name", "grades", and "birthday" as API fields, and the dimension table key value of 4 as the condition field) to the processing server again, the processing server obtains the token information api_data_token=1 of the third request message;

[0247] If the interval between the terminal sending the first request message and sending the third request message is 2 minutes, the local database processes the API data associated with the token information based on the new operation configuration information carried in the third request message, obtains a corresponding new API data processing result, and returns the new API data processing result to the terminal;

[0248] If the time interval between the terminal sending the first request message and sending the third request message is 6 minutes, the processing server obtains new API data from the API data source based on the query configuration information carried in the third request message, and processes the new API data based on the new operation configuration information carried in the third request message to obtain the corresponding new API data processing results.

[0249] See Figure 13A As shown, the following uses a specific application scenario to further explain the interaction process between the terminal and the processing server in the above embodiments in detail:

[0250] Assume that the API data in the API data source is as shown in Table 12:

[0251] Table 12

[0252] Name gender grade class score Birthday Zhao Yi male Grade 11 Class 1 50 1995 Qian Er female Second year of high school Class 2 60 1996 Sun San male Senior Year Class 3 70 1997 Li Si female Senior Year Class 4 80 1998

[0253] Assume that the one-dimensional table "Surname Table" is set as shown in Table 13:

[0254] Table 13

[0255] True value Key Values Zhao 1 money 2 Sun 3 plum 4

[0256] Step 1300: The terminal sends a first request message to the processing server.

[0257] Specifically, the first request message includes query configuration information and operation configuration information.

[0258] See Figure 13B As shown, the query configuration information includes:

[0259] API fields: "Name", "Grade", "Gender", "Birthday".

[0260] Condition field: dimension table "Surname Table", key values are "2 and 3".

[0261] See Figure 13C As shown, the operation configuration information includes "addition".

[0262] Step 1301: The processing server generates corresponding token information based on the API field and the condition field in the first request message.

[0263] Specifically, the token information is api_data_token=1 and is saved for 5 minutes.

[0264] Step 1302: The processing server sends the condition field to the API data source in the form of parameters.

[0265] For example, the processing server sends the key values "2 and 3" to the API data source as parameters.

[0266] Step 1303: The API data source filters the API data based on the conditional fields.

[0267] Specifically, based on the condition field, the API data source filters the API data in Table 12 to obtain filtered API data, wherein the filtered API data is shown in Table 14:

[0268] Table 14

[0269] Name gender grade class score Birthday Qian Er female Second year of high school Class 2 60 1996 Sun San male Senior Year Class 3 70 1997

[0270] Step 1304: The API data source returns the filtered API data to the processing server.

[0271] Step 1305: The processing server further filters the returned API data based on the API field.

[0272] Specifically, when the processing server receives the filtered API data returned by the API data source, it creates a MySQL data table, saves the filtered API data in the MySQL data table, and saves the MySQL data table to a storage area specified by the processing server (e.g., a local database). Then, it instructs the local database to re-filter the filtered API data based on the API fields. The re-filtered API data is shown in Table 15:

[0273] Table 15

[0274] Name gender score Birthday Qian Er female 60 1996 Sun San male 70 1997

[0275] Step 1306: The processing server processes the filtered API data based on the API data processing method indicated in the operation configuration information.

[0276] Specifically, assuming that the operation configuration information indicates that the processing method of the API data is "addition", the processing server instructs the local database to perform "addition" processing on the API data after the second screening. The obtained API processing results are shown in Table 16:

[0277] Table 16

[0278]

[0279]

[0280] Step 1307: The processing server processes the API data after the operation based on the data display method indicated in the operation configuration information to obtain the API data processing result.

[0281] Assuming that the data display method is "bar chart" and "line chart", the processing server re-processes the API data processing results based on the corresponding data display method.

[0282] Step 1308: The processing server returns the API data processing result to the terminal.

[0283] Step 1309: The terminal displays the API data processing result.

[0284] For details, see Figure 13D As shown, the terminal will display the API data processing results in two ways: "bar chart" and "line chart".

[0285] Step 1310: The terminal sends a second request message to the processing server.

[0286] Specifically, the second request message carries the filtering configuration information. It is assumed that the filtering configuration information is the key value "2" of the dimension table "surname table".

[0287] Step 1311: The processing server filters the API data processing result again based on the filtering configuration information in the second request message to obtain a filtering result.

[0288] Specifically, the screening results are shown in Table 17:

[0289] Table 17

[0290] Name gender score Birthday Qian Er female 60 1996

[0291] Step 1312: The processing server returns the obtained screening results to the terminal.

[0292] Step 1313: The terminal displays the screening results.

[0293] Specifically, the display effect is the same as step 1309 and will not be repeated here.

[0294] Step 1314: The terminal sends a third request message to the processing server.

[0295] Specifically, the third request message carries the same query configuration information as in the first request message and new operation configuration information, where the query configuration information includes:

[0296] API fields: "Name", "Grade", "Gender", "Birthday".

[0297] Condition field: The key value of the dimension table "Surname Table" is "2 and 3".

[0298] The new operation configuration information includes "sort".

[0299] And the time interval between the terminal sending the third request message and sending the first request message is 2 minutes.

[0300] Step 1315: The processing server obtains corresponding token information based on the API field and condition field carried in the third request message, determines that the validity period corresponding to the token information has not timed out, and obtains corresponding API data.

[0301] Specifically, the so-called API data associated with the token information refers to the API data returned by the API data source in step 1304 after filtering the condition fields included in the query configuration information carried in the first request message.

[0302] Step 1316: The processing server processes the API data based on the new operation configuration information carried in the third request message to obtain a corresponding new API data processing result.

[0303] Specifically, based on the API data processing method "sort" indicated in the new operation configuration information, the processing server processes the contents in Table 15 accordingly to obtain a new API data processing result, wherein the new API data processing result is shown in Table 18:

[0304] Table 18

[0305] Name gender score Birthday 1 Qian Er female 60 1996 2 Sun San male 70 1997

[0306] Step 1317: The processing server returns the new API data processing result to the terminal.

[0307] Step 1318: The terminal displays the new API data processing results.

[0308] Specifically, the display effect is the same as step 1309 and will not be repeated here.

[0309] Based on the same inventive concept, see Figure 14 As shown, in an embodiment of the present application, a data display device (eg, a terminal) is provided, comprising at least: a first configuration unit 1410 , a second configuration unit 1420 , a first processing unit 1430 and a second processing unit 1440 .

[0310] The first configuration unit 1410 is configured to obtain query configuration information in response to a first configuration operation triggered in the query configuration interface, where the query configuration information at least includes a link address of an application programming interface (API) data source and an API field to be queried;

[0311] A second configuration unit 1420 is configured to obtain operation configuration information in response to a second configuration operation triggered in the operation configuration interface, where the operation configuration information is used to indicate a processing method for the API data;

[0312] The first processing unit 1430 is configured to send a first request message carrying query configuration information and operation configuration information to a processing server, so that the processing server obtains API data from an API data source based on a link address, and processes the API data based on the API fields and the operation configuration information to obtain an API data processing result.

[0313] The second processing unit 1440 receives the API data processing result returned by the processing server and displays the API data processing result in a display interface.

[0314] Optionally, in response to a first configuration operation triggered in the query configuration interface, query configuration information is obtained, and the first configuration unit 1410 is configured to:

[0315] In response to a first configuration operation triggered in the query configuration interface, a link address of the API data source, an API field to be queried, and a set condition field are obtained, where the condition field is used to indicate a data screening method to the API data source;

[0316] Generate query configuration information based on the link address of the API data source, the API field to be queried, and the condition field.

[0317] Optionally, the operation configuration information further includes a preset data display method. The second processing unit 1440 receives the API data processing result returned by the processing server and displays the API data processing result in the display interface.

[0318] Receive the API data processing results returned by the processing server. The API data processing results are returned by the processing server after processing based on the data display method;

[0319] The API data processing results are displayed in the display interface.

[0320] Optionally, after displaying the API data processing result in the display interface, the second processing unit 1440 is further configured to:

[0321] In response to a third configuration operation triggered in the screening configuration interface, obtaining screening configuration information, where the screening configuration information is set based on the condition field;

[0322] Sending a second request message carrying the screening configuration information to the processing server, so that the processing server re-screens the API data processing result based on the screening configuration information to obtain a screening result;

[0323] Receive the filtering results returned by the processing server and display the filtering results in the display interface.

[0324] Optionally, the query configuration interface and the operation configuration interface are located on the same page, or are located on different pages respectively, and the second configuration unit 1420 is used to:

[0325] The display interface is located in the setting display area of the operation configuration interface.

[0326] Based on the same inventive concept, see Figure 15 As shown, in an embodiment of the present application, a data display device (eg, a processing server) is provided, which includes at least: a receiving unit 1510, a first processing unit 1520, a second processing unit 1530 and a third processing unit 1540.

[0327] Receiving unit 1510 is configured to receive a first request message sent by a terminal and carrying query configuration information and operation configuration information, wherein the query configuration information is obtained by the terminal in response to a first configuration operation triggered in the query configuration interface, and the query configuration information includes at least a link address of an application programming interface (API) data source and an API field to be queried; and the operation configuration information is obtained by the terminal in response to a second configuration operation triggered in the operation configuration interface, and the operation configuration information is used to indicate a processing method for the API data.

[0328] The first processing unit 1520 is configured to obtain API data from the API data source based on the link address;

[0329] The second processing unit 1530 is configured to process the API data based on the API field and the operation configuration information to obtain an API data processing result;

[0330] The third processing unit 1540 is configured to return the API data processing result to the terminal, so that the terminal displays the API data processing result in a display interface.

[0331] Optionally, the query configuration information further includes a condition field, which is used to indicate a data filtering method to the API data source. The API data is obtained from the API data source based on the link address, and the API data is processed based on the API field and the operation configuration information to obtain an API data processing result. The first processing unit 1520 is configured to:

[0332] Based on the link address, the conditional fields are sent to the API data source in the form of parameters;

[0333] Get API data returned by the API data source based on the conditional fields;

[0334] Filter API data based on API fields;

[0335] The filtered API data is processed based on the operation configuration information to obtain API data processing results.

[0336] Optionally, after obtaining the API data filtered based on the conditional fields returned by the API data source, and before processing the API data based on the API fields and the operation configuration information, the second processing unit 1530 is further configured to:

[0337] Filter and detect the obtained API data based on conditional fields.

[0338] Optionally, the operation configuration information further includes a data display method, and the API data processing result is returned to the terminal. The third processing unit 1540 is configured to:

[0339] Reprocess the API data processing results based on the data display method;

[0340] The reprocessed API data processing result is returned to the terminal so that the terminal can display the reprocessed API data processing result in a display interface.

[0341] Optionally, after returning the API data processing result to the terminal so that the terminal displays the API data processing result on a display interface, the third processing unit 1540 is further configured to:

[0342] receiving a second request message carrying screening configuration information sent by the terminal, where the screening configuration information is set by the terminal based on the condition field in response to a third configuration operation triggered in the screening configuration interface;

[0343] Re-filter the API data processing results based on the filtering configuration information to obtain filtering results;

[0344] The screening results are returned to the terminal so that the terminal can display the screening results on the display interface.

[0345] Optionally, after receiving the first request message carrying the query configuration information and the operation configuration information sent by the terminal, the receiving unit 1510 is further configured to:

[0346] Generate corresponding token information corresponding to the query configuration information and save the token information in the cache, wherein the token information corresponds to a validity period;

[0347] After obtaining the API data returned by the API data source based on the conditional fields, it also includes:

[0348] Save API data to the storage area;

[0349] When receiving the third request message carrying the query configuration information sent by the terminal again, obtaining the token information;

[0350] If it is determined that the validity period corresponding to the token information has not timed out, obtaining the API data from the storage area, and processing the API data based on the operation configuration information carried in the third request message to obtain a corresponding API data processing result;

[0351] Return the API data processing result corresponding to the third request message to the terminal.

[0352] Optionally, the second processing unit 1530 processes the filtered API data based on the operation configuration information, and is configured to:

[0353] Based on the operation configuration information, perform one or any combination of the following operations on the filtered API data: filtering, sorting, grouping, and calculation.

[0354] Optionally, the condition field includes a key value in a dimension table; the dimension table is used to record the mapping relationship between each key value and each filtering indicator, and the dimension table is an API dimension table or another type of dimension table.

[0355] Based on the same inventive concept, see Figure 16 As shown, the embodiment of the present application further provides a computer device 1600, which can be an electronic device such as a smart phone, a tablet computer, a laptop or a PC. Figure 16As shown, the computer device 1600 includes a display unit 1640, a processor 1680, and a memory 1620, wherein the display unit 1640 includes a display panel 1641 for displaying information input by the user or information provided to the user and various object selection pages of the computer device 1600. In the embodiment of the present application, it is mainly used to display pages, shortcut windows, etc. of applications installed in the computer device 1600. Optionally, the display panel 1641 can be configured in the form of a liquid crystal display (LCD) or an organic light-emitting diode (OLED). The above-mentioned computer device 1600 can execute any of the methods executed by the terminal or processing server in the above-mentioned various embodiments.

[0356] The processor 1680 is configured to read a computer program and then execute the method defined by the computer program. For example, the processor 1680 reads a social application, thereby running the application on the computer device 1600 and displaying the application page on the display unit 1640. The processor 1680 may include one or more general-purpose processors and may also include one or more digital signal processors (DSPs) to perform related operations to implement the technical solutions provided in the embodiments of the present application.

[0357] The memory 1620 generally includes internal memory and external memory. The internal memory can be a random access memory (RAM), a read-only memory (ROM), and a cache (CACHE), etc. The external memory can be a hard disk, an optical disk, a USB disk, a floppy disk or a tape drive, etc. The memory 1620 is used to store computer programs and other data. The computer program includes an application corresponding to the application, etc. Other data may include data generated after the operating system or the application is run, and the data includes system data (such as configuration parameters of the operating system) and user data. In the embodiment of the present application, program instructions are stored in the memory 1620, and the processor 1680 executes the program instructions stored in the memory 1620 to implement any method of execution of the terminal or processing server discussed above.

[0358] In addition, the computer device 1600 may also include a display unit 1640 for receiving input digital information, character information or contact touch operations / contactless gestures, and generating signal inputs related to user settings and function control of the computer device 1600. Specifically, in an embodiment of the present application, the display unit 1640 may include a display panel 1641. The display panel 1641, such as a touch screen, can collect user touch operations on or near it (such as operations performed by a player using a finger, stylus, or any other suitable object or accessory on or on the display panel 1641) and drive corresponding connected devices according to a pre-set program. Optionally, the display panel 1641 may include two parts: a touch detection device and a touch controller. The touch detection device detects the user's touch direction and detects the signal generated by the touch operation, and transmits the signal to the touch controller; the touch controller receives the touch information from the touch detection device and converts it into touch point coordinates, which are then sent to the processor 1680. It can also receive commands sent by the processor 1680 and execute them.

[0359] The display panel 1641 can be implemented using various types such as resistive, capacitive, infrared, and surface acoustic wave. In addition to the display unit 1640, the computer device 1600 can also include an input unit 1630, which can include but is not limited to one or more of a physical keyboard, function keys (such as volume control keys, power keys, etc.), a trackball, a mouse, and a joystick. Figure 16 In the figure, the input unit 1630 includes an image input device 1631 and other input devices 1632 as an example.

[0360] In addition to the above, computer device 1600 may also include a power supply 1690 for powering other modules, an audio circuit 1660, a near-field communication module 1670, and an RF circuit 1610. Computer device 1600 may also include one or more sensors 1650, such as an accelerometer, a light sensor, a pressure sensor, etc. Audio circuit 1660 specifically includes a speaker 1661 and a microphone 1662. For example, a user can use voice control. Computer device 1600 can capture the user's voice through microphone 1662, control the device based on the user's voice, and play a corresponding prompt tone through speaker 1661 when prompting the user.

[0361] Based on the same inventive concept, an embodiment of the present application provides a computer-readable medium. When the instructions in the above-mentioned computer-readable storage medium are executed by a processor, the above-mentioned processor can execute any one of the methods executed by the terminal or processing server in the above-mentioned embodiments.

[0362] Alternatively, the computer-readable medium may be a non-transitory computer-readable storage medium, for example, the non-transitory computer-readable storage medium may be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.

[0363] Based on the same inventive concept, embodiments of the present application provide a computer program product or computer program, which includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform any of the methods performed by the terminal and processing server in each of the above embodiments.

[0364] The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable signal medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or component, or any combination thereof. More specific examples of readable storage media (a non-exhaustive list) include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof.

[0365] The program product of the embodiment of the present application may be a portable compact disc read-only memory (CD-ROM) and include program code, and can be run on a computing device. However, the program product of the present application is not limited thereto. In this document, a readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with a command execution system, device, or device.

[0366] A readable signal medium may include a data signal transmitted in baseband or as part of a carrier wave, which carries readable program code. Such a transmitted data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A readable signal medium may also be any readable medium other than a readable storage medium that can transmit, propagate, or transfer a program for use by or in conjunction with a command execution system, apparatus, or device.

[0367] The program code embodied on the readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0368] Although the preferred embodiments of the present application have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present application.

[0369] Obviously, those skilled in the art may make various changes and modifications to this application without departing from the spirit and scope of this application. Thus, if these modifications and variations of this application fall within the scope of the claims of this application and their equivalents, this application is intended to include these modifications and variations.

Claims

1. A data display method, characterized in that: include: In response to a first configuration operation triggered in the query configuration interface, obtaining a link address of an application programming interface (API) data source, an API field to be queried, and a set condition field, and generating query configuration information based on the link address of the API data source, the API field to be queried, and the condition field, wherein the condition field is used to indicate a data screening method to the API data source; In response to a second configuration operation triggered in the operation configuration interface, obtaining operation configuration information, the operation configuration information being used to indicate a processing method for API data in the same data table and at least one data display method for the processing result, the processing method being configured in a first sub-interface of the operation configuration interface, and the at least one data display method being configured in a second sub-interface of the operation configuration interface; Sending a first request message carrying the query configuration information and the operation configuration information to a processing server, so that the processing server obtains API data from the API data source based on the link address, and processes the API data based on the API field and the operation configuration information to obtain an API data processing result; Receive the API data processing result returned by the processing server, and display the API data processing result in a display interface according to the at least one data display method.

2. The method according to claim 1, wherein After displaying the API data processing result in the display interface according to the at least one data display method, the method further includes: In response to a third configuration operation triggered in the screening configuration interface, obtaining screening configuration information, wherein the screening configuration information is set based on the condition field; Sending a second request message carrying the screening configuration information to the processing server, so that the processing server re-screens the API data processing result based on the screening configuration information to obtain a screening result; The filtering result returned by the processing server is received, and the filtering result is displayed in the display interface.

3. A data display method, characterized in that: include: Receiving a first request message sent by a terminal and carrying query configuration information and operation configuration information, wherein the query configuration information is obtained by the terminal in response to a first configuration operation triggered in a query configuration interface, the query configuration information includes at least a link address of an application programming interface (API) data source, an API field to be queried, and a set condition field, the condition field being used to instruct the API data source on a data screening method; the operation configuration information is obtained by the terminal in response to a second configuration operation triggered in the operation configuration interface, the operation configuration information being used to indicate a processing method for API data in the same data table and at least one data display method for the processing results, the processing method being configured in a first sub-interface of the operation configuration interface, and the at least one data display method being configured in a second sub-interface of the operation configuration interface; Based on the link address, the condition field is sent to the API data source in the form of parameters; Obtaining API data returned by the API data source and filtered based on the conditional field; Filtering the API data based on the API field; Processing the filtered API data based on the operation configuration information to obtain an API data processing result; The API data processing result is returned to the terminal, so that the terminal displays the API data processing result in a display interface according to the at least one data display method.

4. The method according to claim 3, wherein After receiving the first request message sent by the terminal carrying the query configuration information and the operation configuration information, the method further includes: Generate corresponding token information corresponding to the query configuration information, and save the token information in a cache, wherein the token information corresponds to a validity period; After obtaining the API data returned by the API data source and filtered based on the conditional field, the method further includes: Saving the API data to a storage area; When a third request message carrying the query configuration information is received again from the terminal, acquiring the token information; If it is determined that the validity period corresponding to the token information has not timed out, obtaining the API data from the storage area, and processing the API data based on the operation configuration information carried in the third request message to obtain a corresponding API data processing result; Return the API data processing result corresponding to the third request message to the terminal.

5. A data display device, characterized in that: include: a first configuration unit configured to, in response to a first configuration operation triggered in the query configuration interface, obtain a link address of an application programming interface (API) data source, an API field to be queried, and a set condition field, and generate query configuration information based on the link address of the API data source, the API field to be queried, and the condition field, wherein the condition field is used to indicate a data screening method to the API data source; a second configuration unit, configured to obtain, in response to a second configuration operation triggered in the operation configuration interface, operation configuration information, the operation configuration information being used to indicate a processing method for API data in the same data table and at least one data display method for the processing result, the processing method being configured in a first sub-interface of the operation configuration interface, and the at least one data display method being configured in a second sub-interface of the operation configuration interface; a first processing unit, configured to send a first request message carrying the query configuration information and the operation configuration information to a processing server, so that the processing server obtains API data from the API data source based on the link address, and processes the API data based on the API field and the operation configuration information to obtain an API data processing result; The second processing unit receives the API data processing result returned by the processing server, and displays the API data processing result in a display interface according to the at least one data display method.

6. A data display device, characterized in that: include: a receiving unit, configured to receive a first request message sent by a terminal and carrying query configuration information and operation configuration information, wherein the query configuration information is obtained by the terminal in response to a first configuration operation triggered in a query configuration interface, the query configuration information at least including a link address of an application programming interface (API) data source, an API field to be queried, and a set condition field, the condition field being used to indicate a data screening method to the API data source; the operation configuration information is obtained by the terminal in response to a second configuration operation triggered in the operation configuration interface, the operation configuration information being used to indicate a processing method for API data in the same data table and at least one data display method for the processing results, the processing method being configured in a first sub-interface of the operation configuration interface, and the at least one data display method being configured in a second sub-interface of the operation configuration interface; A first processing unit is configured to send the condition field in a parameter form to the API data source based on the link address, and obtain API data returned by the API data source that is filtered based on the condition field; a second processing unit, configured to filter the API data based on the API field, and process the filtered API data based on the operation configuration information to obtain an API data processing result; The third processing unit is used to return the API data processing result to the terminal, so that the terminal displays the API data processing result in a display interface according to the at least one data display method.

7. An electronic device, characterized in that: include: a memory for storing executable instructions; A processor, configured to read and execute the executable instructions stored in the memory to implement the method according to any one of claims 1 to 4.

8. A computer-readable storage medium, characterized in that When the instructions in the computer-readable storage medium are executed by a processor, the processor is enabled to perform the method according to any one of claims 1 to 4.

Images