CN112287009A - Interface calling and interface data warehousing method, device, equipment and storage medium - Google Patents
Interface calling and interface data warehousing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112287009A CN112287009A CN202011207423.2A CN202011207423A CN112287009A CN 112287009 A CN112287009 A CN 112287009A CN 202011207423 A CN202011207423 A CN 202011207423A CN 112287009 A CN112287009 A CN 112287009A
- Authority
- CN
- China
- Prior art keywords
- interface
- information
- parameter
- data
- file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000012795 verification Methods 0.000 claims abstract description 139
- 230000004044 response Effects 0.000 claims abstract description 51
- 238000006243 chemical reaction Methods 0.000 claims abstract description 41
- 238000012545 processing Methods 0.000 claims abstract description 10
- 230000008676 import Effects 0.000 claims description 34
- 238000004458 analytical method Methods 0.000 claims description 28
- 238000004140 cleaning Methods 0.000 claims description 19
- 238000003780 insertion Methods 0.000 claims description 7
- 230000037431 insertion Effects 0.000 claims description 7
- 238000005538 encapsulation Methods 0.000 claims description 6
- 238000007405 data analysis Methods 0.000 claims description 5
- 238000003032 molecular docking Methods 0.000 abstract description 17
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000012360 testing method Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 6
- 238000013500 data storage Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 210000001503 joint Anatomy 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
- G06F9/4482—Procedural
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of big data, and discloses a method, a device, equipment and a storage medium for interface calling and interface data warehousing, which are used for improving the interface docking efficiency. The interface calling and interface data warehousing method comprises the following steps: carrying out file verification on the interface file to be imported to obtain a verification result; when the verification result is that the verification is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information; determining interface information to be called from the cached parameter information according to the interface calling request, and calling the interface to obtain response data; acquiring interface return parameter data from the response data, and performing parameter conversion processing on the interface return parameter data according to the interface parameter information; and updating the processed return parameter data to a preset relational database to obtain an updating result. In addition, the invention also relates to a block chain technology, and the interface parameter information can be stored in the block chain node.
Description
Technical Field
The invention relates to the field of incremental updating of big data technology, in particular to a method, a device, equipment and a storage medium for interface calling and interface data warehousing.
Background
The interface service standardization refers to that the interface service standardization is realized by providing a uniform interface and a standard input parameter format and then analyzing the input parameters by using uniform analysis logic without developing some interfaces with similar functions as a service party. Repeated redundant code interfacing is avoided and is easily managed and maintained.
However, as the consumer side, because the interface parameters are provided by the server side, it is difficult to achieve uniform interface interfacing in the face of various interface parameter formats. Under the general condition, a business party needs to complete development on each supplier, can obtain a test effect in a test environment after joint debugging and integrated testing, and determines a calling result after a function is formally on-line, so that the problems of long interface docking period and low interface docking efficiency are caused.
Disclosure of Invention
The invention provides a method, a device, equipment and a storage medium for interface calling and interface data storage, which are used for reducing the interface docking period and improving the interface docking efficiency.
In order to achieve the above object, a first aspect of the present invention provides an interface calling and interface data warehousing method, including: when an interface file import request is received, acquiring an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file; when the verification result is that verification is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information; when an interface calling request is received, determining interface information to be called from the cached parameter information according to the interface calling request, and carrying out interface calling according to the interface information to be called to obtain response data; acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data; and updating the processed return parameter data to a preset relational database to obtain an updating result, and sending the updating result to a terminal.
Optionally, in a first implementation manner of the first aspect of the present invention, when an interface file import request is received, obtaining an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, where the interface file to be imported is a spreadsheet excel format file, including: when an interface file import request is received, performing parameter analysis on the interface file import request to obtain the interface file to be imported and the service identification information, wherein the interface file to be imported is a spreadsheet excel format file; intercepting a file extension from the interface file to be imported, and judging whether the file extension exists in a preset suffix list or not, wherein the preset suffix list comprises xls and xlsx; if the file extension name does not exist in a preset suffix list, determining that the verification result is verification failure; and if the file extension name exists in a preset suffix list, determining that the verification result is successful.
Optionally, in a second implementation manner of the first aspect of the present invention, when the verification result is that the verification is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information, where the analyzing includes: when the verification result is that verification is successful, reading an excel text stream from the interface file to be imported; analyzing the excel text stream line by line through the POI to obtain header field information and interface parameter information, wherein the interface parameter information comprises interface basic information, interface input parameter information and interface output parameter information; acquiring a header field verification rule, and performing field verification on the header field information according to the header field verification rule to obtain a verification result; if the verification result is verification failure, generating prompt information, and sending the prompt information to a terminal so that the terminal prompts a target user to correct the interface file to be imported; and if the verification result is that the verification is successful, performing data format conversion on the interface basic information, the interface input parameter information and the interface output parameter information to obtain converted parameter information, and updating the converted parameter information into a preset database, wherein the preset database comprises a preset memory database and a preset relation database.
Optionally, in a third implementation manner of the first aspect of the present invention, when receiving an interface call request, determining interface information to be called from the cached parameter information according to the interface call request, and performing interface call according to the interface information to be called to obtain response data, where the method includes: when an interface calling request is received, analyzing the interface calling request to obtain target service identification information and a value of an interface parameter to be called; inquiring cached parameter information from the preset memory database according to the target service identification information to obtain an inquiry result, and judging whether the inquiry result is a null value or not; when the query result is not a null value, reading the interface basic information and the interface input parameter information from the query result; and setting interface information to be called based on the interface input parameter information and the interface parameter value to be called, and carrying out interface calling according to the interface basic information and the interface information to be called to obtain response data.
Optionally, in a fourth implementation manner of the first aspect of the present invention, the obtaining interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data includes: analyzing the response data to obtain interface return parameter data, and matching the interface return parameters according to the interface output parameter information to obtain a matching result; when the matching result is that the matching is successful, reading a data cleaning rule corresponding to each interface output parameter and a corresponding parameter conversion rule from the interface output parameter information; and performing parameter cleaning and parameter conversion on the interface return parameter data according to the data cleaning rule corresponding to each interface output parameter and the corresponding parameter conversion rule to obtain processed return parameter data.
Optionally, in a fifth implementation manner of the first aspect of the present invention, the updating the processed return parameter data to a preset relational database to obtain an update result, and sending the update result to a terminal includes: reading a preset database table name and a plurality of field names from a preset memory database, and performing SQL statement processing on the processed return parameter data, the database table name and the plurality of field names based on a Structured Query Language (SQL) grammar rule to generate a target insert statement; and executing the target insertion statement, writing the processed return parameter data into a preset relational database to obtain an update result, and sending the update result to a terminal.
Optionally, in a sixth implementation manner of the first aspect of the present invention, after the updating the processed returned parameter data to a preset relational database to obtain an update result, and sending the update result to a terminal, the interface calling and interface data entering method further includes: performing data encapsulation on the interface calling request, the response data and the updating result to obtain encapsulated interface operation information, and recording the encapsulated interface operation information into a preset operation log; and carrying out data analysis on the preset operation log at regular time to obtain an information analysis report, and pushing the information analysis report to a terminal, wherein the information analysis report is used for indicating the accuracy of storing the response data to a preset relational database after an interface is called.
A second aspect of the present invention provides an interface calling and interface data warehousing apparatus, including: the system comprises an acquisition module, a verification module and a verification module, wherein the acquisition module is used for acquiring an interface file to be imported and service identification information based on an interface file import request and performing file verification on the interface file to be imported to obtain a verification result when the interface file import request is received, and the interface file to be imported is a spreadsheet excel format file; the analysis module is used for analyzing the interface file to be imported through the POI to obtain interface parameter information when the verification result is successful, and caching the interface parameter information according to the service identification information to obtain cached parameter information; the calling module is used for determining interface information to be called from the cached parameter information according to the interface calling request and calling an interface according to the interface information to be called to obtain response data when the interface calling request is received; the conversion module is used for acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data; and the updating module is used for updating the processed return parameter data to a preset relational database to obtain an updating result and sending the updating result to the terminal.
Optionally, in a first implementation manner of the second aspect of the present invention, the obtaining module is specifically configured to: when an interface file import request is received, performing parameter analysis on the interface file import request to obtain the interface file to be imported and the service identification information, wherein the interface file to be imported is a spreadsheet excel format file; intercepting a file extension from the interface file to be imported, and judging whether the file extension exists in a preset suffix list or not, wherein the preset suffix list comprises xls and xlsx; if the file extension name does not exist in a preset suffix list, determining that the verification result is verification failure; and if the file extension name exists in a preset suffix list, determining that the verification result is successful.
Optionally, in a second implementation manner of the second aspect of the present invention, the parsing module is specifically configured to: when the verification result is that verification is successful, reading an excel text stream from the interface file to be imported; analyzing the excel text stream line by line through the POI to obtain header field information and interface parameter information, wherein the interface parameter information comprises interface basic information, interface input parameter information and interface output parameter information; acquiring a header field verification rule, and performing field verification on the header field information according to the header field verification rule to obtain a verification result; if the verification result is verification failure, generating prompt information, and sending the prompt information to a terminal so that the terminal prompts a target user to correct the interface file to be imported; and if the verification result is that the verification is successful, performing data format conversion on the interface basic information, the interface input parameter information and the interface output parameter information to obtain converted parameter information, and updating the converted parameter information into a preset database, wherein the preset database comprises a preset memory database and a preset relation database.
Optionally, in a third implementation manner of the second aspect of the present invention, the invoking module is specifically configured to: when an interface calling request is received, analyzing the interface calling request to obtain target service identification information and a value of an interface parameter to be called; inquiring cached parameter information from the preset memory database according to the target service identification information to obtain an inquiry result, and judging whether the inquiry result is a null value or not; when the query result is not a null value, reading the interface basic information and the interface input parameter information from the query result; and setting interface information to be called based on the interface input parameter information and the interface parameter value to be called, and carrying out interface calling according to the interface basic information and the interface information to be called to obtain response data.
Optionally, in a fourth implementation manner of the second aspect of the present invention, the conversion module is specifically configured to: analyzing the response data to obtain interface return parameter data, and matching the interface return parameters according to the interface output parameter information to obtain a matching result; when the matching result is that the matching is successful, reading a data cleaning rule corresponding to each interface output parameter and a corresponding parameter conversion rule from the interface output parameter information; and performing parameter cleaning and parameter conversion on the interface return parameter data according to the data cleaning rule corresponding to each interface output parameter and the corresponding parameter conversion rule to obtain processed return parameter data.
Optionally, in a fifth implementation manner of the second aspect of the present invention, the update module is specifically configured to: reading a preset database table name and a plurality of field names from the preset memory database, and performing SQL statement processing on the processed return parameter data, the database table name and the plurality of field names based on a Structured Query Language (SQL) grammar rule to generate a target insertion statement; and executing the target insertion statement, writing the processed return parameter data into a preset relational database to obtain an update result, and sending the update result to a terminal.
Optionally, in a sixth implementation manner of the second aspect of the present invention, the interface calling and interface data entering device further includes: the recording module is used for carrying out data encapsulation on the interface calling request, the response data and the updating result to obtain encapsulated interface operation information and recording the encapsulated interface operation information into a preset operation log; and the analysis module is used for carrying out data analysis on the preset operation log at regular time to obtain an information analysis report and pushing the information analysis report to the terminal, and the information analysis report is used for indicating the accuracy of storing the response data to a preset relational database after an interface is called.
A third aspect of the present invention provides an interface calling and interface data warehousing device, including: a memory and at least one processor, the memory having instructions stored therein; and the at least one processor calls the instruction in the memory to enable the interface calling and interface data warehousing equipment to execute the interface calling and interface data warehousing method.
A fourth aspect of the present invention provides a computer-readable storage medium having stored therein instructions, which, when run on a computer, cause the computer to execute the above-described interface calling and interface data warehousing method.
According to the technical scheme, when an interface file import request is received, an interface file to be imported and service identification information are obtained based on the interface file import request, and file verification is carried out on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file; when the verification result is that verification is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information; when an interface calling request is received, determining interface information to be called from the cached parameter information according to the interface calling request, and carrying out interface calling according to the interface information to be called to obtain response data; acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data; and updating the processed return parameter data to a preset relational database to obtain an updating result, and sending the updating result to a terminal. In the embodiment of the invention, the online interface calling test is realized by importing the interface document, the verification efficiency of a business party is greatly accelerated, the interface information is cached after the interface document is imported, then when the interface is called, the input parameters and the calling interface are automatically assembled according to the cached interface information to obtain the interface return value, and the interface return value is directly put in storage after being automatically analyzed. And a new interface is docked without repeatedly developing codes, so that the interface docking period is shortened, and the interface docking efficiency is improved.
Drawings
FIG. 1 is a diagram of an embodiment of an interface call and interface data warehousing method according to an embodiment of the present invention;
FIG. 2 is a diagram of another embodiment of an interface call and interface data warehousing method according to an embodiment of the present invention;
FIG. 3 is a diagram of an embodiment of an interface calling and interface data warehousing apparatus according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of another embodiment of an interface calling and interface data warehousing apparatus according to an embodiment of the present invention;
fig. 5 is a schematic diagram of an embodiment of an interface call and interface data warehousing device in the embodiment of the present invention.
Detailed Description
The embodiment of the invention provides an interface calling and interface data storage method, device, equipment and storage medium, which are used for automatically assembling input parameters and calling interfaces according to cached interface information to obtain interface return values, automatically analyzing the interface return values and directly storing the interface return values in a storage mode, and improving interface docking efficiency.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," or "having," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
For convenience of understanding, a specific flow of the embodiment of the present invention is described below, and referring to fig. 1, an embodiment of an interface calling and interface data entering method in the embodiment of the present invention includes:
101. when an interface file import request is received, acquiring an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file.
The interface file to be imported includes interface parameter information, the interface parameter information includes table names and field names (multiple fields), and field cleaning processing and format conversion rules can be added. The interface file to be imported is in an electronic spreadsheet excel format, and each interface parameter is a line of interface data. And the interface file to be imported corresponds to the service identification information. Specifically, when the server receives the interface file import request, the server analyzes the interface file import request according to a preset interface data format to obtain the interface file to be imported and the service identification information, the server performs file verification on the interface file to be imported to obtain a verification result, the verification result includes a verification success and a verification failure, the server may use 1 to indicate the verification success, the server may use 0 to indicate the verification failure, and the specific example is not limited herein. Further, when the verification result is that the verification is successful, the server executes step 102.
It should be noted that the preset interface data format may be a preset data assembly format, for example, the preset interface data format is a JS Object Notation (JSON) data exchange format, and may also be other data formats, which is not limited herein.
It is to be understood that the execution subject of the present invention may be an interface calling and interface data entering device, and may also be a terminal or a server, which is not limited herein. The embodiment of the present invention is described by taking a server as an execution subject.
102. And when the verification result is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information.
The POI is a document analyzer, and after the server acquires the interface file uploaded by the terminal, the server stores the interface parameter information in the interface file in a storage mode through the POI. The interface file to be imported is in a standard and universal interface document template format (standard interface document), the standard interface document mainly comprises 3 worksheets, the first worksheet fills in interface basic information, and the interface basic information comprises an interface number, an interface name, a URL (uniform resource locator), an interface source and an access type. And filling interface input parameter information by the second sheet, wherein the interface input parameter information comprises field identification, field name, field type, maximum length, necessity of filling, database table name, database field name and cleaning rule. And filling the output parameter information of the interface by the third sheet, wherein the information is used for indicating each field information of the output parameters and the corresponding parameter data cleaning rule.
Further, the server analyzes data of the interface file to be imported according to the content of a preset worksheet sheet through the POI to obtain interface parameter information; and the server caches the interface parameter information into a preset memory database according to the service identification information to obtain cached parameter information.
103. And when an interface calling request is received, determining interface information to be called from the cached parameter information according to the interface calling request, and calling the interface according to the interface information to be called to obtain response data.
Specifically, when the server receives an interface calling request, the server sets a query statement according to the interface calling request; the server executes the query statement, and reads the interface information to be called from the cached parameter information; the server calls an interface based on the interface information to be called to obtain response data, wherein the response data includes an interface calling status code, for example, the interface calling status code is 200, which can be used to indicate that the interface calling is successful, and the server executes step 104; the interface calling state code is 500, and can be used for indicating that the interface calling fails, the server generates calling failure information and sends the calling failure information to the terminal, so that the terminal displays the calling failure information in real time.
104. And acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to the interface output parameter information in the interface parameter information to obtain processed return parameter data.
When the server triggers and calls the external interface, the server first obtains the interface information from a preset memory database, wherein the interface information comprises an interface address, a request mode, input parameter information, output parameter information and the like; then the server assembles the values of the fields into input parameters according to the input parameter information, wherein the input parameters can be in a JSON data format; then the server calls according to the initiating interface to obtain response data; when the server detects that the response data is not null, the server reads the interface return parameter data from the response data. Further, the server performs parameter verification on the interface return parameter data according to the interface output parameter information in the interface parameter information to obtain a verification result, and when the verification result is successful, the server performs parameter conversion on the interface return parameter data to obtain processed return parameter data.
105. And updating the processed return parameter data to a preset relational database to obtain an updating result, and sending the updating result to the terminal.
Specifically, the server assembles a database insert statement according to the processed return parameter data, assembles an interface return value into an insert statement according to a database table name and a field name mapped in the interface information, executes a database insert command, and updates the processed return parameter data to a preset relational database to obtain an update result, wherein the update result comprises successful update and failed update. Further, the interface parameter information is stored in the blockchain database, which is not limited herein.
In the embodiment of the invention, the online interface calling test is realized by importing the interface document, the verification efficiency of a business party is greatly accelerated, the interface information is cached after the interface document is imported, then when the interface is called, the input parameters and the calling interface are automatically assembled according to the cached interface information to obtain the interface return value, and the interface return value is directly put in storage after being automatically analyzed. And a new interface is docked without repeatedly developing codes, so that the interface docking period is shortened, and the interface docking efficiency is improved.
Referring to fig. 2, another embodiment of the interface calling and interface data warehousing method according to the embodiment of the present invention includes:
201. when an interface file import request is received, acquiring an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file.
And the verification result comprises verification success and verification failure. Optionally, when the server receives the interface file import request, the server performs parameter analysis on the interface file import request to obtain an interface file to be imported and service identification information, wherein the interface file to be imported is a spreadsheet excel format file; the method comprises the steps that a server intercepts a file extension from an interface file to be imported, and judges whether the file extension exists in a preset suffix list or not, wherein the preset suffix list comprises xls and xlsx; if the file extension name does not exist in the preset suffix list, the server determines that the verification result is verification failure, further, the server generates prompt information and sends the prompt information to the terminal, and the prompt information is used for indicating that the file format has errors; if the file extension exists in the preset suffix list, the server determines that the verification result is successful, and further, the server executes step 202.
It should be noted that the server may also check the file size of the interface file to be imported, and specifically, the server determines whether the file size of the interface file to be imported is smaller than a preset threshold; if the size of the file to be imported into the interface file is smaller than the preset threshold, the server determines that the verification result is successful, and executes step 202.
202. And when the verification result is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information.
It can be understood that the server analyzes excel data through the POI, and the data processing efficiency is improved. Optionally, when the verification result is that the verification is successful, the server reads the excel text stream from the interface file to be imported; the method comprises the steps that a server analyzes an excel text stream line by line through a point of interest (POI) to obtain header field information and interface parameter information, wherein the interface parameter information comprises interface basic information, interface input parameter information and interface output parameter information; the server acquires a header field check rule and performs field verification on header field information according to the header field check rule to obtain a verification result; if the verification result is that the verification fails, the server generates prompt information and sends the prompt information to the terminal so that the terminal prompts a target user to correct the interface file to be imported; and if the verification result is successful, the server performs data format conversion on the interface basic information, the interface input parameter information and the interface output parameter information to obtain converted parameter information, and updates the converted parameter information into a preset database, wherein the preset database comprises a preset memory database and a preset relation database.
It should be noted that the preset memory database may be redis, and the preset relationship database may be mysql, which is not limited herein. If the interface input parameter information has a multi-layer structure, the hierarchy expansion is connected with ". multidata" as its field identification, such as header. Specifically, the server analyzes the structure of the interface file to be imported through the POI, searches attributes such as field identification, field names and the like, searches a specified column in each line in the excel in a traversing manner, and stores the parameter information of each cell in a preset memory database and a preset relation database respectively after the parameter information of each cell is obtained.
203. And when an interface calling request is received, determining interface information to be called from the cached parameter information according to the interface calling request, and calling the interface according to the interface information to be called to obtain response data.
The cached parameter information is pre-stored in a preset memory database, optionally, when the server receives an interface calling request, the server analyzes the interface calling request to obtain target service identification information and a parameter value of an interface to be called; the server inquires cached parameter information from a preset memory database according to the target service identification information to obtain an inquiry result, and the server judges whether the inquiry result is a null value; when the query result is not a null value, the server reads the interface basic information and the interface input parameter information from the query result; the server sets interface information to be called based on the interface input parameter information and the interface parameter value to be called, and carries out interface calling according to the interface basic information and the interface information to be called to obtain response data.
Further, when the query result is a null value, reading the interface basic information, the interface input parameter information and the interface output parameter information corresponding to the interface to be called from the preset relational database, and updating the interface basic information, the interface input parameter information and the interface output parameter information corresponding to the interface to be called into the memory data to obtain the interface information to be called. The server adopts the preset memory database to read data, so that the data reading efficiency is improved.
204. And acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to the interface output parameter information in the interface parameter information to obtain processed return parameter data.
The processed return parameter data is parameter data processed by the server according to the configured cleaning rule, for example, the server performs storage format conversion on the interface return parameter data of which the data type is a date type or a numerical value type.
Optionally, the server analyzes the response data to obtain interface return parameter data, and matches the interface return parameter according to the interface output parameter information to obtain a matching result; when the matching result is that the matching is successful, the server reads the data cleaning rule corresponding to each interface output parameter and the corresponding parameter conversion rule from the interface output parameter information; and the server performs parameter cleaning and parameter conversion on the interface return parameter data according to the data cleaning rule corresponding to the output parameter of each interface and the corresponding parameter conversion rule to obtain processed return parameter data.
205. And updating the processed return parameter data to a preset relational database to obtain an updating result, and sending the updating result to the terminal.
It should be noted that, the server stores the interface information after importing the interface document, then automatically assembles the input parameters when calling the interface, and finally automatically analyzes the processed return parameter data and stores the analyzed return parameter data in the preset database. The server adopts the method to butt joint a new interface, so that redevelopment is not needed, the efficiency of the quick access of the interface is improved, the calling can be initiated after the interface document is uploaded, the interface calling result is obtained, and the interface butt joint efficiency is improved.
Optionally, the server reads a preset database table name and a plurality of field names from a preset memory database, and performs SQL statement processing on the processed return parameter data, the database table name and the plurality of field names based on a Structured Query Language (SQL) syntax rule to generate a target insert statement; and the server executes the target insertion statement, writes the processed return parameter data into a preset relational database, obtains an update result, and sends the update result to the terminal.
206. And performing data encapsulation on the interface calling request, the response data and the updating result to obtain encapsulated interface operation information, and recording the encapsulated interface operation information into a preset operation log.
Specifically, the server acquires a plurality of preset parameter field names, performs data value mapping and filling on an interface calling request, response data and an updating result according to the preset parameter field names to form a plurality of key value pairs, and performs data encapsulation processing on the plurality of key value pairs to obtain encapsulated interface operation information; and the server acquires the current moment and records the packaged interface operation information into a preset operation log according to the current moment. The preset operation log may be a file or a data table, and is not limited herein.
207. And performing data analysis on the preset operation log at regular time to obtain an information analysis report, and pushing the information analysis report to the terminal, wherein the information analysis report is used for indicating the accuracy of storing the response data to the preset relational database after the interface is called.
Specifically, the server acquires service identification information through a preset timing task; the server determines at least one interface calling request according to the service identification information, and analyzes the updating result according to the at least one interface calling request to obtain an information analysis report; the server calls a preset push interface to push the information analysis report to the terminal, and the information analysis report is used for indicating the accuracy of storing the response data to the preset relational database after the interface is called. Further, when the accuracy is smaller than the preset threshold, the server sends early warning information to the terminal, so that the terminal prompts target personnel to check corresponding interface information according to the early warning information, and the accuracy of interface docking is improved.
In the embodiment of the invention, the online interface calling test is realized by importing the interface document, the verification efficiency of a business party is greatly accelerated, the interface information is cached after the interface document is imported, then when the interface is called, the input parameters and the calling interface are automatically assembled according to the cached interface information to obtain the interface return value, and the interface return value is directly put in storage after being automatically analyzed. And a new interface is docked without repeatedly developing codes, so that the interface docking period is shortened, and the interface docking efficiency is improved.
The above description of the interface calling and interface data entering method in the embodiment of the present invention, and the following description of the interface calling and interface data entering device in the embodiment of the present invention refer to fig. 3, where an embodiment of the interface calling and interface data entering device in the embodiment of the present invention includes:
the obtaining module 301 is configured to, when receiving an interface file import request, obtain an interface file to be imported and service identification information based on the interface file import request, and perform file verification on the interface file to be imported to obtain a verification result, where the interface file to be imported is a spreadsheet excel format file;
the parsing module 302, configured to, when the verification result is that the verification is successful, parse the interface file to be imported through the point of interest POI to obtain interface parameter information, and cache the interface parameter information according to the service identification information to obtain cached parameter information;
the calling module 303, when receiving the interface calling request, is configured to determine interface information to be called from the cached parameter information according to the interface calling request, and perform interface calling according to the interface information to be called to obtain response data;
the conversion module 304 is configured to obtain interface return parameter data from the response data, perform parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information, and obtain processed return parameter data;
the updating module 305 is configured to update the processed return parameter data to the preset relational database, obtain an update result, and send the update result to the terminal.
Further, the interface parameter information is stored in the blockchain database, which is not limited herein.
In the embodiment of the invention, the online interface calling test is realized by importing the interface document, the verification efficiency of a business party is greatly accelerated, the interface information is cached after the interface document is imported, then when the interface is called, the input parameters and the calling interface are automatically assembled according to the cached interface information to obtain the interface return value, and the interface return value is directly put in storage after being automatically analyzed. And a new interface is docked without repeatedly developing codes, so that the interface docking period is shortened, and the interface docking efficiency is improved.
Referring to fig. 4, another embodiment of the interface invoking and interface data warehousing apparatus according to the embodiment of the present invention includes:
the obtaining module 301 is configured to, when receiving an interface file import request, obtain an interface file to be imported and service identification information based on the interface file import request, and perform file verification on the interface file to be imported to obtain a verification result, where the interface file to be imported is a spreadsheet excel format file;
the parsing module 302, configured to, when the verification result is that the verification is successful, parse the interface file to be imported through the point of interest POI to obtain interface parameter information, and cache the interface parameter information according to the service identification information to obtain cached parameter information;
the calling module 303, when receiving the interface calling request, is configured to determine interface information to be called from the cached parameter information according to the interface calling request, and perform interface calling according to the interface information to be called to obtain response data;
the conversion module 304 is configured to obtain interface return parameter data from the response data, perform parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information, and obtain processed return parameter data;
the updating module 305 is configured to update the processed return parameter data to the preset relational database, obtain an update result, and send the update result to the terminal.
Optionally, the obtaining module 301 may be further specifically configured to:
when an interface file import request is received, performing parameter analysis on the interface file import request to obtain an interface file to be imported and service identification information, wherein the interface file to be imported is a spreadsheet excel format file;
intercepting a file extension from an interface file to be imported, and judging whether the file extension exists in a preset suffix list or not, wherein the preset suffix list comprises xls and xlsx;
if the file extension name does not exist in the preset suffix list, determining that the verification result is verification failure;
and if the file extension name exists in the preset suffix list, determining that the verification result is successful.
Optionally, the parsing module 302 may be further specifically configured to:
when the verification result is that the verification is successful, reading the excel text stream from the interface file to be imported;
analyzing the excel text stream line by line through the POI to obtain header field information and interface parameter information, wherein the interface parameter information comprises interface basic information, interface input parameter information and interface output parameter information;
acquiring a header field check rule, and performing field verification on header field information according to the header field check rule to obtain a verification result;
if the verification result is verification failure, generating prompt information, and sending the prompt information to the terminal so that the terminal prompts a target user to correct the interface file to be imported;
and if the verification result is successful, performing data format conversion on the interface basic information, the interface input parameter information and the interface output parameter information to obtain converted parameter information, and updating the converted parameter information into a preset database, wherein the preset database comprises a preset memory database and a preset relation database.
Optionally, the invoking module 303 may be further specifically configured to:
when an interface calling request is received, analyzing the interface calling request to obtain target service identification information and a parameter value of an interface to be called;
inquiring cached parameter information from a preset memory database according to the target service identification information to obtain an inquiry result, and judging whether the inquiry result is a null value or not;
when the query result is not a null value, reading interface basic information and interface input parameter information from the query result;
and setting interface information to be called based on the interface input parameter information and the interface parameter value to be called, and calling an interface according to the interface basic information and the interface information to be called to obtain response data.
Optionally, the conversion module 304 may be further specifically configured to:
analyzing the response data to obtain interface return parameter data, and matching the interface return parameters according to the interface output parameter information to obtain a matching result;
when the matching result is that the matching is successful, reading a data cleaning rule corresponding to each interface output parameter and a corresponding parameter conversion rule from the interface output parameter information;
and performing parameter cleaning and parameter conversion on the interface return parameter data according to the data cleaning rule corresponding to each interface output parameter and the corresponding parameter conversion rule to obtain processed return parameter data.
Optionally, the update module 305 may be further specifically configured to:
reading a preset database table name and a plurality of field names from a preset memory database, and performing SQL statement processing on the processed return parameter data, the database table name and the plurality of field names based on a Structured Query Language (SQL) grammar rule to generate a target insertion statement;
and executing the target insertion statement, writing the processed return parameter data into a preset relational database to obtain an update result, and sending the update result to the terminal.
Optionally, the interface calling and interface data entering device further includes:
the recording module 306 is configured to perform data encapsulation on the interface call request, the response data, and the update result to obtain encapsulated interface operation information, and record the encapsulated interface operation information in a preset operation log;
and the analysis module 307 is configured to perform data analysis on the preset operation log at regular time to obtain an information analysis report, and push the information analysis report to the terminal, where the information analysis report is used to indicate an accuracy rate of storing the response data to the preset relational database after the interface is called.
In the embodiment of the invention, the online interface calling test is realized by importing the interface document, the verification efficiency of a business party is greatly accelerated, the interface information is cached after the interface document is imported, then when the interface is called, the input parameters and the calling interface are automatically assembled according to the cached interface information to obtain the interface return value, and the interface return value is directly put in storage after being automatically analyzed. And a new interface is docked without repeatedly developing codes, so that the interface docking period is shortened, and the interface docking efficiency is improved.
The interface calling and interface data warehousing device in the embodiment of the present invention is described in detail in terms of modularization in fig. 3 and 4, and the interface calling and interface data warehousing device in the embodiment of the present invention is described in detail in terms of hardware processing in the following.
Fig. 5 is a schematic structural diagram of an interface calling and interface data warehousing device according to an embodiment of the present invention, where the interface calling and interface data warehousing device 500 may generate relatively large differences due to different configurations or performances, and may include one or more processors (CPUs) 510 (e.g., one or more processors) and a memory 520, and one or more storage media 530 (e.g., one or more mass storage devices) for storing applications 533 or data 532. Memory 520 and storage media 530 may be, among other things, transient or persistent storage. The program stored on the storage medium 530 may include one or more modules (not shown), each of which may include a series of instruction operations for interface calls and interface data entry devices 500. Further, the processor 510 may be configured to communicate with the storage medium 530 to execute a series of instruction operations in the storage medium 530 on the interface call and interface data warehousing device 500.
The interface call and interface data warehousing device 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input-output interfaces 560, and/or one or more operating systems 531, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, and the like. Those skilled in the art will appreciate that the interface call and interface data warehousing facility architecture illustrated in fig. 5 is not intended to be limiting, and may include more or fewer components than those illustrated, or some components in combination, or a different arrangement of components.
The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium, or a volatile computer-readable storage medium, having stored therein instructions, which, when executed on a computer, cause the computer to perform the steps of the interface calling and interface data warehousing method.
The invention also provides interface calling and interface data storage equipment, which comprises a memory and a processor, wherein the memory stores instructions, and the instructions are executed by the processor, so that the processor executes the steps of the interface calling and interface data storage method in each embodiment.
Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the blockchain node, and the like.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. An interface calling and interface data warehousing method is characterized in that the interface calling and interface data warehousing method comprises the following steps:
when an interface file import request is received, acquiring an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file;
when the verification result is that verification is successful, analyzing the interface file to be imported through the POI to obtain interface parameter information, and caching the interface parameter information according to the service identification information to obtain cached parameter information;
when an interface calling request is received, determining interface information to be called from the cached parameter information according to the interface calling request, and carrying out interface calling according to the interface information to be called to obtain response data;
acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data;
and updating the processed return parameter data to a preset relational database to obtain an updating result, and sending the updating result to a terminal.
2. The interface calling and interface data warehousing method according to claim 1, wherein when an interface file import request is received, acquiring an interface file to be imported and service identification information based on the interface file import request, and performing file verification on the interface file to be imported to obtain a verification result, wherein the interface file to be imported is a spreadsheet excel format file, and the method includes:
when an interface file import request is received, performing parameter analysis on the interface file import request to obtain the interface file to be imported and the service identification information, wherein the interface file to be imported is a spreadsheet excel format file;
intercepting a file extension from the interface file to be imported, and judging whether the file extension exists in a preset suffix list or not, wherein the preset suffix list comprises xls and xlsx;
if the file extension name does not exist in a preset suffix list, determining that the verification result is verification failure;
and if the file extension name exists in a preset suffix list, determining that the verification result is successful.
3. The interface calling and interface data warehousing method according to claim 1, wherein when the verification result is that the verification is successful, the interface file to be imported is analyzed through the POI to obtain interface parameter information, and the interface parameter information is cached according to the service identification information to obtain cached parameter information, including:
when the verification result is that verification is successful, reading an excel text stream from the interface file to be imported;
analyzing the excel text stream line by line through the POI to obtain header field information and interface parameter information, wherein the interface parameter information comprises interface basic information, interface input parameter information and interface output parameter information;
acquiring a header field verification rule, and performing field verification on the header field information according to the header field verification rule to obtain a verification result;
if the verification result is verification failure, generating prompt information, and sending the prompt information to a terminal so that the terminal prompts a target user to correct the interface file to be imported;
and if the verification result is that the verification is successful, performing data format conversion on the interface basic information, the interface input parameter information and the interface output parameter information to obtain converted parameter information, and updating the converted parameter information into a preset database, wherein the preset database comprises a preset memory database and a preset relation database.
4. The method according to claim 3, wherein when receiving an interface call request, determining interface information to be called from the cached parameter information according to the interface call request, and performing interface call according to the interface information to be called to obtain response data, comprises:
when an interface calling request is received, analyzing the interface calling request to obtain target service identification information and a value of an interface parameter to be called;
inquiring cached parameter information from the preset memory database according to the target service identification information to obtain an inquiry result, and judging whether the inquiry result is a null value or not;
when the query result is not a null value, reading the interface basic information and the interface input parameter information from the query result;
and setting interface information to be called based on the interface input parameter information and the interface parameter value to be called, and carrying out interface calling according to the interface basic information and the interface information to be called to obtain response data.
5. The interface calling and interface data warehousing method according to claim 1, wherein the acquiring of the interface return parameter data from the response data, performing parameter verification and parameter conversion on the interface return parameter data according to the interface output parameter information in the interface parameter information to obtain processed return parameter data, comprises:
analyzing the response data to obtain interface return parameter data, and matching the interface return parameters according to the interface output parameter information to obtain a matching result;
when the matching result is that the matching is successful, reading a data cleaning rule corresponding to each interface output parameter and a corresponding parameter conversion rule from the interface output parameter information;
and performing parameter cleaning and parameter conversion on the interface return parameter data according to the data cleaning rule corresponding to each interface output parameter and the corresponding parameter conversion rule to obtain processed return parameter data.
6. The interface calling and interface data warehousing method according to claim 1, wherein the updating the processed return parameter data to a preset relational database to obtain an update result, and sending the update result to a terminal includes:
reading a preset database table name and a plurality of field names from a preset memory database, and performing SQL statement processing on the processed return parameter data, the database table name and the plurality of field names based on a Structured Query Language (SQL) grammar rule to generate a target insert statement;
and executing the target insertion statement, writing the processed return parameter data into a preset relational database to obtain an update result, and sending the update result to a terminal.
7. The interface calling and interface data warehousing method according to any one of claims 1 to 6, wherein after the updating of the processed return parameter data to a preset relational database to obtain an update result and sending the update result to a terminal, the interface calling and interface data warehousing method further comprises:
performing data encapsulation on the interface calling request, the response data and the updating result to obtain encapsulated interface operation information, and recording the encapsulated interface operation information into a preset operation log;
and carrying out data analysis on the preset operation log at regular time to obtain an information analysis report, and pushing the information analysis report to a terminal, wherein the information analysis report is used for indicating the accuracy of storing the response data to a preset relational database after an interface is called.
8. An interface calling and interface data warehousing apparatus, characterized in that the interface calling and interface data warehousing apparatus comprises:
the system comprises an acquisition module, a verification module and a verification module, wherein the acquisition module is used for acquiring an interface file to be imported and service identification information based on an interface file import request and performing file verification on the interface file to be imported to obtain a verification result when the interface file import request is received, and the interface file to be imported is a spreadsheet excel format file;
the analysis module is used for analyzing the interface file to be imported through the POI to obtain interface parameter information when the verification result is successful, and caching the interface parameter information according to the service identification information to obtain cached parameter information;
the calling module is used for determining interface information to be called from the cached parameter information according to the interface calling request and calling an interface according to the interface information to be called to obtain response data when the interface calling request is received;
the conversion module is used for acquiring interface return parameter data from the response data, and performing parameter verification and parameter conversion on the interface return parameter data according to interface output parameter information in the interface parameter information to obtain processed return parameter data;
and the updating module is used for updating the processed return parameter data to a preset relational database to obtain an updating result and sending the updating result to the terminal.
9. An interface calling and interface data warehousing device, characterized in that the interface calling and interface data warehousing device comprises: a memory and at least one processor, the memory having instructions stored therein;
the at least one processor invokes the instructions in the memory to cause the interface call and interface data warehousing device to perform the interface call and interface data warehousing method of any one of claims 1-7.
10. A computer-readable storage medium having instructions stored thereon, wherein the instructions, when executed by a processor, implement the interface call and interface data warehousing method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011207423.2A CN112287009A (en) | 2020-11-03 | 2020-11-03 | Interface calling and interface data warehousing method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011207423.2A CN112287009A (en) | 2020-11-03 | 2020-11-03 | Interface calling and interface data warehousing method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112287009A true CN112287009A (en) | 2021-01-29 |
Family
ID=74350384
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011207423.2A Pending CN112287009A (en) | 2020-11-03 | 2020-11-03 | Interface calling and interface data warehousing method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112287009A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113114490A (en) * | 2021-03-30 | 2021-07-13 | 海信集团控股股份有限公司 | API call abnormity warning method, device, equipment and medium |
| CN113377369A (en) * | 2021-05-17 | 2021-09-10 | 广州有信科技有限公司 | Universal method and device for interfacing third-party service system and terminal equipment |
| CN113377361A (en) * | 2021-06-28 | 2021-09-10 | 浙江孚临科技有限公司 | Method for realizing timing verification of data source based on linux crontad and jar packets |
| CN113419772A (en) * | 2021-06-30 | 2021-09-21 | 平安国际智慧城市科技股份有限公司 | Response data packing and unpacking method, response data packing device, response data unpacking device and response data unpacking medium |
| CN113535832A (en) * | 2021-06-10 | 2021-10-22 | 杭州未名信科科技有限公司 | Method and device for acquiring cloud service data, electronic equipment and medium |
| CN113535439A (en) * | 2021-09-15 | 2021-10-22 | 北京奇虎科技有限公司 | Service request processing method, device, equipment and storage medium |
| CN113687965A (en) * | 2021-10-25 | 2021-11-23 | 深圳市工易付电子科技有限公司 | Data interaction method, device, equipment and storage medium |
| CN114428815A (en) * | 2022-01-17 | 2022-05-03 | 多点生活(成都)科技有限公司 | Data storage method and device, electronic equipment and computer readable medium |
| CN115510825A (en) * | 2022-11-18 | 2022-12-23 | 深圳市徐港电子有限公司 | Audio parameter configuration method and device, electronic equipment and storage medium |
| CN115801914A (en) * | 2022-11-29 | 2023-03-14 | 重庆长安汽车股份有限公司 | Multi-protocol network data exchange method |
| CN117472367A (en) * | 2023-12-27 | 2024-01-30 | 中电数据产业有限公司 | Heterogeneous resource intelligent identification and access method, device, equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100082656A1 (en) * | 2008-09-24 | 2010-04-01 | Yi Jing | Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services |
| CN107766040A (en) * | 2017-09-19 | 2018-03-06 | 深圳市买买提乐购金融服务有限公司 | A kind of method, apparatus and computer-readable recording medium for generating interface document |
| CN108491475A (en) * | 2018-03-08 | 2018-09-04 | 平安科技（深圳）有限公司 | Data rapid batch introduction method, electronic device and computer readable storage medium |
| CN109344642A (en) * | 2018-08-31 | 2019-02-15 | 平安科技（深圳）有限公司 | Interface rules method of calibration, device, computer equipment and storage medium |
| CN109947646A (en) * | 2019-03-13 | 2019-06-28 | 平安信托有限责任公司 | Interface test method, device, computer equipment and storage medium |
| CN110134929A (en) * | 2019-04-17 | 2019-08-16 | 深圳壹账通智能科技有限公司 | Document verification method, apparatus, computer equipment and storage medium |
| CN110673892A (en) * | 2019-09-17 | 2020-01-10 | 中电万维信息技术有限责任公司 | Interface unified calling method based on component configuration |
-
2020
- 2020-11-03 CN CN202011207423.2A patent/CN112287009A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100082656A1 (en) * | 2008-09-24 | 2010-04-01 | Yi Jing | Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services |
| CN107766040A (en) * | 2017-09-19 | 2018-03-06 | 深圳市买买提乐购金融服务有限公司 | A kind of method, apparatus and computer-readable recording medium for generating interface document |
| CN108491475A (en) * | 2018-03-08 | 2018-09-04 | 平安科技（深圳）有限公司 | Data rapid batch introduction method, electronic device and computer readable storage medium |
| CN109344642A (en) * | 2018-08-31 | 2019-02-15 | 平安科技（深圳）有限公司 | Interface rules method of calibration, device, computer equipment and storage medium |
| CN109947646A (en) * | 2019-03-13 | 2019-06-28 | 平安信托有限责任公司 | Interface test method, device, computer equipment and storage medium |
| CN110134929A (en) * | 2019-04-17 | 2019-08-16 | 深圳壹账通智能科技有限公司 | Document verification method, apparatus, computer equipment and storage medium |
| CN110673892A (en) * | 2019-09-17 | 2020-01-10 | 中电万维信息技术有限责任公司 | Interface unified calling method based on component configuration |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113114490B (en) * | 2021-03-30 | 2023-10-27 | 海信集团控股股份有限公司 | API call abnormity warning method, device, equipment and medium |
| CN113114490A (en) * | 2021-03-30 | 2021-07-13 | 海信集团控股股份有限公司 | API call abnormity warning method, device, equipment and medium |
| CN113377369A (en) * | 2021-05-17 | 2021-09-10 | 广州有信科技有限公司 | Universal method and device for interfacing third-party service system and terminal equipment |
| CN113535832A (en) * | 2021-06-10 | 2021-10-22 | 杭州未名信科科技有限公司 | Method and device for acquiring cloud service data, electronic equipment and medium |
| CN113377361A (en) * | 2021-06-28 | 2021-09-10 | 浙江孚临科技有限公司 | Method for realizing timing verification of data source based on linux crontad and jar packets |
| CN113419772A (en) * | 2021-06-30 | 2021-09-21 | 平安国际智慧城市科技股份有限公司 | Response data packing and unpacking method, response data packing device, response data unpacking device and response data unpacking medium |
| CN113535439A (en) * | 2021-09-15 | 2021-10-22 | 北京奇虎科技有限公司 | Service request processing method, device, equipment and storage medium |
| CN113687965A (en) * | 2021-10-25 | 2021-11-23 | 深圳市工易付电子科技有限公司 | Data interaction method, device, equipment and storage medium |
| CN113687965B (en) * | 2021-10-25 | 2022-03-01 | 深圳市工易付电子科技有限公司 | Data interaction method, device, equipment and storage medium |
| CN114428815A (en) * | 2022-01-17 | 2022-05-03 | 多点生活(成都)科技有限公司 | Data storage method and device, electronic equipment and computer readable medium |
| CN115510825A (en) * | 2022-11-18 | 2022-12-23 | 深圳市徐港电子有限公司 | Audio parameter configuration method and device, electronic equipment and storage medium |
| CN115801914A (en) * | 2022-11-29 | 2023-03-14 | 重庆长安汽车股份有限公司 | Multi-protocol network data exchange method |
| CN115801914B (en) * | 2022-11-29 | 2024-04-30 | 重庆长安汽车股份有限公司 | Multi-protocol network data exchange method |
| CN117472367A (en) * | 2023-12-27 | 2024-01-30 | 中电数据产业有限公司 | Heterogeneous resource intelligent identification and access method, device, equipment and storage medium |
| CN117472367B (en) * | 2023-12-27 | 2024-03-26 | 中电数据产业有限公司 | Heterogeneous resource intelligent identification and access method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112287009A (en) | Interface calling and interface data warehousing method, device, equipment and storage medium | |
| US10769228B2 (en) | Systems and methods for web analytics testing and web development | |
| CN111367886B (en) | Method and device for data migration in database | |
| CN108563768B (en) | Data conversion method, device, equipment and storage medium for different data models | |
| CN110287109B (en) | Protocol interface testing method and device, computer equipment and storage medium thereof | |
| CN110162544B (en) | Heterogeneous data source data acquisition method and device | |
| CN108628748B (en) | Automatic test management method and automatic test management system | |
| CN112306881B (en) | Analog data generation method, device, equipment and storage medium | |
| CN112015430A (en) | JavaScript code translation method and device, computer equipment and storage medium | |
| CN107766353B (en) | Method and device for migrating statistical information of database | |
| CN110046155B (en) | Method, device and equipment for updating feature database and determining data features | |
| CN115757483A (en) | Automatic testing method and device, electronic equipment and storage medium | |
| CN110769002A (en) | LabVIEW-based message analysis method, system, electronic device and medium | |
| WO2019074687A1 (en) | Method for replicating production behaviours in a development environment | |
| CN110704325B (en) | Data processing method and device, computer storage medium and electronic equipment | |
| CN115599359A (en) | Code generation method, device, equipment and medium | |
| US20070150477A1 (en) | Validating a uniform resource locator ('URL') in a document | |
| CN110046086B (en) | Expected data generation method and device for test and electronic equipment | |
| CN111767213B (en) | Database check point testing method and device, electronic equipment and storage medium | |
| CN114116268A (en) | Method and device for checking Flink SQL statement, computer equipment and storage medium | |
| CN114968725A (en) | Task dependency relationship correction method and device, computer equipment and storage medium | |
| CN110781647B (en) | Method for realizing data format verification based on Flink | |
| CN114238024A (en) | Timing diagram generation method and system | |
| CN112527818A (en) | Report generation method, device, equipment and storage medium | |
| CN113138767A (en) | Code language conversion method, device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |