Data processing methods, apparatus, electronic devices and storage media

Abstract

This invention relates to the field of computer information processing technology, and particularly to a data processing method, apparatus, electronic device, and storage medium. The method is applied to an intermediate server, which is connected to a third-party platform and a business system in a restricted access network. The method includes: first, creating records by calling an interface based on user-submitted data; then, periodically pulling records to be processed from the business system and synchronizing them to the third-party platform; and finally, periodically reading status markers filled in by the user on the platform and automatically updating the record status in the business system based on the markers. Thus, by introducing a third-party platform as an interaction and relay bridge, the intermediate server periodically performs data retrieval, synchronization, and status marker scanning, and automatically drives the status flow of the intranet business system based on user markers. This solves the problems in related technologies where external network users cannot participate in the data processing of the intranet business system in an intuitive interactive manner, and where the status flow of the intranet business system cannot be automatically driven based on user feedback.

Description

Technical Field

[0001] This invention relates to the field of computer information processing technology, and in particular to a data processing method, apparatus, electronic device, and storage medium. Background Technology

[0002] Project tracking and issue management systems (such as Jira) have become core collaboration platforms for enterprise R&D and testing teams. However, for information security reasons, such systems are usually deployed on the enterprise's internal network, and external users (such as traveling employees and partners) cannot directly access them, leading to difficulties in cross-network collaboration.

[0003] Among related technologies, an internal and external network interaction platform is proposed. This platform establishes a data forwarding channel between external third-party services and the internal network platform by setting up an external service acquisition module and an internal data acquisition module, thereby realizing bidirectional data transmission between the internal and external networks.

[0004] However, this method is essentially still a system-to-system data channel, and there are still problems such as external network users not being able to participate in the data processing of the internal network business system in an intuitive interactive way, and not being able to automatically drive the flow of internal network business status based on user feedback, which urgently need to be solved. Summary of the Invention

[0005] This invention provides a data processing method, apparatus, electronic device, and storage medium to solve the problems in related technologies where external network users cannot participate in the data processing of internal network business systems in an intuitive interactive manner, and cannot automatically drive the flow of internal network business status based on user feedback, thereby achieving efficient and secure automation of cross-network business processes.

[0006] To achieve the above objectives, a first aspect of the present invention provides a data processing method, which is applied to an intermediate server connected to a third-party platform and a business system in a restricted access network, and the method includes the following steps: Receive structured data, wherein the structured data is submitted by the user through the third-party platform; Based on the structured data, the corresponding data record is generated by calling the creation interface of the business system, and the identifier of the data record is obtained. According to the first preset cycle, the query interface of the business system is called to obtain a set of data records that meet the preset state conditions, and the set of data records is sent to the preset storage area of ​​the third-party platform; According to the second preset period, the status flag of each data record in the preset storage area is obtained, and the status update interface of the business system is called according to the status flag to drive the corresponding data record to perform status transition.

[0007] According to an embodiment of the present invention, the status marker includes a first preset marker and a second preset marker, and the step of calling the status update interface of the business system according to the status marker to drive the corresponding data record to perform status transition includes: In response to the status flag being the first preset flag, the status update interface is invoked to update the status of the corresponding data record to the target completion status; In response to the status flag being the second preset flag, the status update interface is invoked to update the status of the corresponding data record to the target rollback status.

[0008] According to an embodiment of the present invention, obtaining the status flag of each data record in the preset storage area includes: The table reading interface of the third-party platform is called to scan the cell contents of the status marker column in the online table document, wherein the cell contents are text manually entered by the user or values ​​selected from preset options; The status marker for each data record is obtained based on the cell content.

[0009] According to one embodiment of the present invention, sending the data record set to a preset storage area of ​​the third-party platform includes: The table writing interface of the third-party platform is invoked to write the data record set into the preset storage area in table form. The preset storage area is an online table document, which includes a status flag column for the user to fill in the status flag.

[0010] According to one embodiment of the present invention, after obtaining the identifier of the data record, the method further includes: The write interface of the third-party platform is invoked to write the identifier back to the location in the third-party platform associated with the structured data.

[0011] According to the data processing method proposed in this embodiment of the invention, records are first created by calling an interface based on user-submitted data; then, records to be processed are periodically retrieved from the business system and synchronized to a third-party platform; finally, status markers filled in by the user on the platform are periodically read, and the record status in the business system is automatically updated based on the markers. Thus, by introducing a third-party platform as an interaction and relay bridge, with an intermediate server periodically performing data retrieval, synchronization, and status marker scanning, and automatically driving the status flow of the intranet business system based on user markers, this solves the problems in related technologies where external network users cannot participate in the data processing of the intranet business system in an intuitive interactive manner, and where the status flow of intranet business processes cannot be automatically driven based on user feedback. This achieves efficient and secure automation of cross-network business processes.

[0012] To achieve the above objectives, a second aspect of the present invention provides a data processing apparatus applied to an intermediate server, the intermediate server being connected to a third-party platform and a business system in a restricted access network, the apparatus comprising: A receiving module is used to receive structured data, wherein the structured data is submitted by the user through the third-party platform; The generation module is used to generate corresponding data records based on the structured data by calling the creation interface of the business system, and to obtain the identifier of the data record; The first processing module is used to call the query interface of the business system according to a first preset period, obtain a set of data records that meet preset state conditions, and send the set of data records to a preset storage area of ​​the third-party platform. The second processing module is used to obtain the status flag of each data record in the preset storage area according to the second preset period, and call the status update interface of the business system according to the status flag to drive the corresponding data record to perform status transition.

[0013] According to an embodiment of the present invention, the status marker includes a first preset marker and a second preset marker. The second processing module, which calls the status update interface of the business system based on the status marker to drive the corresponding data record to undergo status transition, is specifically used for: In response to the status flag being the first preset flag, the status update interface is invoked to update the status of the corresponding data record to the target completion status; In response to the status flag being the second preset flag, the status update interface is invoked to update the status of the corresponding data record to the target rollback status.

[0014] According to an embodiment of the present invention, the second processing module, in obtaining the status flag of each data record in the preset storage area, is specifically used for: The table reading interface of the third-party platform is called to scan the cell contents of the status marker column in the online table document, wherein the cell contents are text manually entered by the user or values ​​selected from preset options; The status marker for each data record is obtained based on the cell content.

[0015] According to an embodiment of the present invention, the first processing module, in sending the data record set to a preset storage area of ​​the third-party platform, is specifically used for: The table writing interface of the third-party platform is invoked to write the data record set into the preset storage area in table form. The preset storage area is an online table document, which includes a status flag column for the user to fill in the status flag.

[0016] According to an embodiment of the present invention, after obtaining the identifier of the data record, the generation module is further configured to: The write interface of the third-party platform is invoked to write the identifier back to the location in the third-party platform associated with the structured data.

[0017] The data processing apparatus proposed in this embodiment of the invention first creates records by calling an interface based on user-submitted data; then periodically pulls records to be processed from the business system and synchronizes them to a third-party platform; finally, periodically reads the status markers filled in by the user on the platform and automatically updates the record status in the business system based on the markers. Thus, by introducing a third-party platform as an interaction and relay bridge, with an intermediate server periodically performing data retrieval, synchronization, and status marker scanning, and automatically driving the status flow of the intranet business system based on user markers, this solves the problems in related technologies where external network users cannot participate in the data processing of the intranet business system in an intuitive interactive manner, and where the status flow of intranet business processes cannot be automatically driven based on user feedback. This achieves efficient and secure automation of cross-network business processes.

[0018] To achieve the above objectives, a third aspect of the present invention provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and capable of running on the processor, wherein the processor executes the program to implement the data processing method as described in the above embodiments.

[0019] To achieve the above objectives, a fourth aspect of the present invention provides a computer-readable storage medium having a computer program stored thereon, which is executed by a processor to implement the data processing method as described in the above embodiments.

[0020] To achieve the above objectives, a fifth aspect of the present invention provides a computer program product comprising a computer program that, when executed by a processor, is used to implement the data processing method as described in the above embodiments.

[0021] Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0022] The above and / or additional aspects and advantages of the present invention will become apparent and readily understood from the following description of the embodiments taken in conjunction with the accompanying drawings, wherein: Figure 1 A flowchart illustrating a data processing method according to an embodiment of the present invention; Figure 2 This is a schematic diagram of the architecture of a data processing system according to an embodiment of the present invention; Figure 3 A schematic diagram of a data creation process according to an embodiment of the present invention; Figure 4 This is a schematic diagram of a state synchronization process according to an embodiment of the present invention; Figure 5 This is a schematic diagram of a state synchronization refinement process according to an embodiment of the present invention; Figure 6 This is a block diagram of a data processing apparatus provided according to an embodiment of the present invention; Figure 7 This is a schematic diagram of the structure of an electronic device provided according to an embodiment of the present invention. Detailed Implementation

[0023] Embodiments of the present invention are described in detail below. Examples of these embodiments are illustrated in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and intended to explain the present invention, and should not be construed as limiting the present invention.

[0024] The data processing method, apparatus, electronic device, and storage medium according to embodiments of the present invention are described below with reference to the accompanying drawings.

[0025] Figure 1 This is a flowchart of a data processing method according to an embodiment of the present invention.

[0026] Before introducing the data processing method proposed in the embodiments of the present invention, let's briefly introduce the relevant technical background.

[0027] In related technologies, project tracking and issue management systems (such as Atlassian Jira) have become core collaboration platforms for software development, testing, and operations teams. However, for information security reasons, these systems are typically deployed on corporate intranets (i.e., internal networks), allowing access only via intranet addresses. This prevents users on external networks (i.e., external networks) (such as traveling employees, partners, etc.) from directly accessing and operating the system, severely impacting collaboration efficiency. To address the issue of external network access to intranet systems, related technologies often employ virtual private network (VPN) technology. For example, remote secure access solutions based on SSL VPN (Secure Sockets Layer Virtual Private Network) assign intranet addresses to users, enabling them to access systems like Jira as if they were on an intranet. In addition, some systems also provide email-triggered ticket creation functionality, allowing users to send emails in a specific format to a designated email address, which the system then parses and automatically creates a ticket.

[0028] However, the above methods have at least the following drawbacks: VPN solutions essentially open the door to the enterprise intranet for external users, increasing the network attack surface and potential security risks. At the same time, the allocation, permission management, and maintenance of VPN accounts also increase the management burden on the IT department. For short-term or temporary external collaborators, it is neither economical nor secure. Email solutions have limited functionality and poor user experience. They can usually only fill in limited fields (such as title and description), and cannot realize the filling of complex forms and the structured entry of data. They also cannot realize the synchronous update, query, and batch processing of work order status. Users find it difficult to conveniently track the status of work orders or perform batch confirmation operations in emails, resulting in a poor interactive experience and a high risk of errors. In addition, whether it is direct VPN access or email creation, subsequent work order status flow, verification, and closure operations still need to be completed manually in the Jira system, which cannot form an end-to-end automated closed loop from creation to closure, resulting in low efficiency.

[0029] Based on the above problems, this invention proposes a data processing method. This method is applied to an intermediate server, which is connected to a third-party platform and a business system in a restricted access network. Specifically, it constructs a solution that uses a cross-network accessible third-party collaboration platform (such as Lark) as a bridge. Through bidirectional data synchronization and rule-based state machine driving, it realizes automatic data flow and closed-loop business processing between internal and external network systems. This solves the problems in related technologies where network isolation prevents external network users from directly accessing internal network business systems, resulting in low collaboration efficiency and security risks. It achieves efficient and secure automation of cross-network business processes.

[0030] The following describes the data processing system involved in this data processing method, such as... Figure 2As shown, the data processing system includes an external network, third-party platforms (including Lark and Cube), an internal enterprise network (including the internal Jira system (i.e., the business systems in the aforementioned restricted access network) and the Jira REST API (Application Programming Interface)), and an intermediate server component acting as a bridge between the internal and external networks. External users can enter structured data through Cube on the third-party platform and submit it to the intermediate server via Webhook (a time-triggered automatic notification mechanism) or active invocation. The intermediate server component includes an intermediate server, a data receiving and parsing module, a Jira API client, a scheduled task scheduler, and a state synchronization engine. The Jira API client converts structured data into work orders in the internal Jira system by calling the Jira REST API. The scheduled task scheduler periodically pulls work order data that meets the state conditions from the internal Jira system, processes it through the state synchronization engine, and writes it back to the cloud document on the Lark platform for external users to mark the cloud document status and confirm synchronization, thus forming a complete closed loop from data creation, synchronization to state flow.

[0031] Next, the data processing method proposed in the embodiments of the present invention will be described in detail.

[0032] For example, such as Figure 1 As shown, the data processing method includes the following steps: In step S101, structured data is received, wherein the structured data is submitted by the user through a third-party platform.

[0033] It is understood that, in this embodiment of the invention, structured data refers to data organized according to a predefined format, such as rows and columns in a table, where each field has a clear type and meaning. In this embodiment, the structured data corresponds to various information of the work order to be created, such as the work order title, problem description, priority, and reporter. A third-party platform is an external collaboration platform independent of the enterprise's internal network, such as Lark, DingTalk, and WeChat Work. These platforms are deployed on the public internet and can be accessed normally by external users. Users refer to external personnel who cannot directly access the enterprise's internal network, such as internal employees on business trips, external partners, and outsourced testers.

[0034] Specifically, external users (such as partners or employees on business trips) can fill in various information related to work orders through interfaces provided by third-party platforms (such as Lark, DingTalk, etc.) according to preset formats, such as the work order title, detailed description, priority, and issue type. The third-party platform encapsulates this information according to an agreed-upon data format (such as JSON (JavaScript Object Notation)) and sends it to an intermediate server. This structured data adheres to preset data specifications; that is, the field names, field types, required fields, and value ranges are all organized and constrained according to predefined rules. This ensures that the data submitted by the third-party platform can be correctly parsed by the intermediate server and successfully mapped to the field format required by the internal business system, avoiding data record creation failures or data corruption due to inconsistent data formats. The intermediate server, as the recipient, obtains this structured data, preparing for the subsequent creation of corresponding data records in the internal business system.

[0035] It should be noted that this structured data was submitted consciously and proactively by the user, rather than being actively retrieved by the intermediate server from a third-party platform.

[0036] In step S102, based on structured data, the corresponding data record is generated by calling the creation interface of the business system, and the identifier of the data record is obtained.

[0037] It is understood that, in this embodiment of the invention, the business system is a project tracking and issue management system, such as Jira, deployed in a restricted access network (such as an enterprise intranet). This system manages data records such as work orders, tasks, and defects, but external users cannot directly access it. The creation interface refers to the application programming interface provided by the business system for creating new data records within the system. By calling this interface and passing in data that conforms to the specifications, the business system can generate a new record based on the received data. A data record refers to a work order, task, or issue entry created in the business system. Each data record corresponds to a specific work item and includes multiple fields such as title, description, priority, and status. The identifier is a globally unique identifier assigned to each data record by the business system, for example, a work order number (such as PROJ-123). This identifier allows for unique location and manipulation of the corresponding data record within the business system.

[0038] Specifically, the intermediate server can call the creation interface of the business system, taking the structured data received in step S101 as input, generating a corresponding data record in the business system, and obtaining the identifier of the data record. That is, the intermediate server can map and assemble the received structured data according to the format required by the business system. For example, mapping the "title" field in the third-party platform to the "summary" field in the business system, and mapping the "problem description" field to the "description" field, etc. Subsequently, the intermediate server can send a request to the creation interface of the business system, passing the assembled data to the business system. After receiving the request, the business system generates a new data record based on the input data (such as creating a new work order) and assigns a globally unique identifier (such as a work order number) to this record. This identifier is used for subsequent operations such as querying, updating, or status transitioning of this data record. After obtaining this identifier, the intermediate server completes the cross-network data transfer from the external network user's submission to the internal network business system for record creation.

[0039] In step S103, according to the first preset cycle, the query interface of the business system is called to obtain the set of data records that meet the preset state conditions, and the set of data records is sent to the preset storage area of ​​the third-party platform.

[0040] It is understood that in this embodiment of the invention, the first preset period is a pre-set time interval, such as once per hour or once every 30 minutes. This period is used to control the frequency at which the intermediate server pulls data from the business system and can be flexibly configured according to business needs. The query interface refers to the application programming interface provided by the business system to retrieve data records from the business system based on specified conditions. By calling this interface and passing in query conditions (such as a status field equal to a certain value), a list of data records that meet the conditions can be obtained. Preset status conditions refer to pre-set status filtering conditions used to filter data records. For example, only data records with a status of "pending processing" or "pending verification" are retrieved, while records that are completed or closed are not. The data record set is a collection of one or more data records that meet the preset status conditions. The preset storage area refers to a pre-specified location in a third-party platform used to store data, which external network users can access and manipulate.

[0041] In other words, a scheduled task is configured on the intermediate server, which can be automatically triggered at pre-set time intervals (i.e., the first preset period, such as once per hour). When the scheduled task is triggered, the intermediate server can send a request to the query interface of the business system, carrying preset status conditions in the request, such as querying only data records with a status of "pending processing" or "pending verification". The business system retrieves internal data records based on the query conditions and returns the set of data records that meet the conditions to the intermediate server. After receiving this set, the intermediate server can send it to a preset storage area of ​​a third-party platform, allowing external users to view the contents of these data records on the third-party platform.

[0042] Through this step, data records to be processed in the intranet business system are periodically and automatically synchronized to a third-party platform accessible to external users, providing a basis for subsequent user viewing and feedback.

[0043] As one possible implementation, in some embodiments, sending the data record set to a preset storage area of ​​a third-party platform includes: calling the table writing interface of the third-party platform to write the data record set into the preset storage area in table form, wherein the preset storage area is an online table document, the online table document includes a status flag column, the status flag column is used for users to fill in status flags.

[0044] It is understood that, in this embodiment of the invention, the table writing interface refers to the application programming interface provided by a third-party platform, used to write data into a preset storage area in tabular form. Tabular form means that data is organized by rows and columns, with each row corresponding to one data record and each column corresponding to a field (such as work order number, title, status, etc.). This format facilitates intuitive viewing and manipulation of data by users. The online table document refers to a cloud-based table application provided by a third-party platform, such as Lark Multidimensional Table, DingTalk Docs, and Google Sheets. Users can access and edit the table through a browser or client application without installing traditional spreadsheet software. The status marker column refers to a column in the online table document specifically used by users to fill in the processing result or confirmation opinion for each data record. Each cell in this column corresponds to user feedback for one data record.

[0045] Specifically, during the process of sending the data record set to the preset storage area of ​​the third-party platform, the intermediate server calls the table writing interface provided by the third-party platform to write the acquired data record set into a table format into the preset storage area. This preset storage area is an online spreadsheet document of the third-party platform. That is, the intermediate server can convert each data record into a row in the table, filling in the various fields of the data record (such as work order identifier, summary, priority, etc.) into the corresponding columns, thus forming a clearly structured "to-do list" in the online spreadsheet document. In addition, the online spreadsheet document also has a pre-set status flag column, which is specifically used for users to fill in the processing result or confirmation opinion for each data record. Users can independently fill in feedback content in each cell of this column, such as selecting "pass" or "fail," or filling in other custom information, thereby expressing the business confirmation result for that data record.

[0046] In this way, pending data records in the intranet business system are presented in an intuitive tabular form on a third-party platform accessible to external network users, providing users with a convenient feedback portal.

[0047] In step S104, according to the second preset period, the status flag of each data record in the preset storage area is obtained, and according to the status flag, the status update interface of the business system is called to drive the corresponding data record to perform status transition.

[0048] It is understood that in this embodiment of the invention, the second preset period is another pre-set time interval, for example, executed once every 10 minutes. This period is used to control the frequency at which the intermediate server reads status flags from the third-party platform. The first preset period and the second preset period can be set to the same or different time intervals to adapt to different business needs. Status flags refer to information filled in by the user in the preset storage area of ​​the third-party platform to express the business confirmation result of a certain data record. For example, the user fills in "yes" to indicate that the confirmation is passed, fills in "no" to indicate that the confirmation is not passed; or selects options such as "pass" or "reject" from the drop-down menu. The status update interface refers to the application programming interface provided by the business system to modify the status field of existing data records in the business system. By calling this interface and passing in a new status value, the data record can be driven to flow from the current status to the target status. Status flow refers to the process of the status of the data record changing in the business system, for example, from "pending processing" to "processing", or from "pending verification" to "completed". Status flow follows the preset workflow rules of the business system.

[0049] In other words, the intermediate server is also configured with another scheduled task, which can be automatically triggered at a pre-set time interval (i.e., the second preset period, such as once every 10 minutes). When this scheduled task is triggered, the intermediate server can read the contents of the status flag column corresponding to each data record in the preset storage area of ​​the third-party platform (such as an online spreadsheet document) to obtain the business confirmation result filled in by the user. Subsequently, the intermediate server determines the corresponding target status based on the specific value of the status flag: for example, when the status flag indicates that the confirmation is passed, the target status is determined to be "completed" or "closed"; when the status flag indicates that the confirmation is failed, the target status is determined to be "returned" or "reopened". Then, the intermediate server calls the status update interface of the business system, passing in the identifier of the corresponding data record and the target status information. After receiving the request, the business system updates the status of the corresponding data record to the target status, thereby completing the status transition of the data record.

[0050] Through this step, the feedback results filled in by users on third-party platforms are automatically and periodically synchronized to the intranet business system, driving work orders or tasks to move forward according to preset workflow rules, thus realizing a business loop across the network.

[0051] As one possible implementation, in some embodiments, obtaining the status marker of each data record in a preset storage area includes: calling the table reading interface of a third-party platform to scan the cell content of the status marker column in the online table document, wherein the cell content is text manually filled in by the user or a value selected from preset options; and obtaining the status marker of each data record based on the cell content.

[0052] It is understood that, in this embodiment of the invention, the table reading interface refers to the application programming interface provided by a third-party platform for reading content from online table documents. By calling this interface, data from a specific row, column, or cell in a specified table can be obtained. Preset options are cell input restriction functions provided by the third-party platform, such as drop-down menus, radio buttons, and checkboxes. Users do not need to manually enter text; they only need to select a value from a pre-set list of options to complete the status flag entry. This method reduces input errors and improves data consistency.

[0053] Specifically, in the process of obtaining the status marker for each data record, the intermediate server scans the cell content of the status marker column in the online table document by calling the table reading interface provided by the third-party platform. That is, the intermediate server sends a table reading request to the third-party platform, specifying the online table document to be read and its status marker column. The third-party platform responds to the request and returns the content of all cells in that column. This cell content can be text manually entered by the user, such as "Yes" or "No," "Pass" or "Fail," etc.; or it can be values ​​selected from preset options, such as "Agree" or "Reject" from a drop-down menu, or "Complete" or "Return" by clicking a radio button. After obtaining these cell contents, the intermediate server can parse and recognize the content of each cell, converting it into the corresponding status marker value, thus obtaining the status marker for each data record. For example, cells with content "Yes" or "Pass" are recognized as indicating confirmation of approval, and cells with content "No" or "Reject" are recognized as indicating confirmation of rejection.

[0054] In this way, the intermediate server can accurately and efficiently obtain the business confirmation results filled in by the user on the third-party platform.

[0055] As one possible implementation, in some embodiments, the status marker includes a first preset marker and a second preset marker. Based on the status marker, the status update interface of the business system is called to drive the corresponding data record to undergo status transition, including: in response to the status marker being the first preset marker, calling the status update interface to update the status of the corresponding data record to the target completion status; in response to the status marker being the second preset marker, calling the status update interface to update the status of the corresponding data record to the target rollback status.

[0056] It is understood that, in this embodiment of the invention, the first preset flag refers to a pre-set flag value used to indicate that the user's business confirmation result for the data record is "affirmative" or "passed". For example, the user can fill in "yes", "passed", "agree" or select "passed" from preset options, etc., and these values ​​are all specific manifestations of the first preset flag. The second preset flag refers to a pre-set flag value used to indicate that the user's business confirmation result for the data record is "negative" or "not passed". For example, the user can fill in "no", "reject", "return" or select "not passed" from preset options, etc., and these values ​​are all specific manifestations of the second preset flag. The target completion status refers to the final or successful status of the data record in the business system, indicating that the work item corresponding to the data record has been successfully processed. Different business systems can use different status names, such as "completed", "closed", "resolved", etc., which are all specific manifestations of the target completion status. The target return status refers to the status of the data record in the business system that needs to be returned to the upstream link for reprocessing, indicating that the work item corresponding to the data record failed to pass the confirmation and needs to be modified or supplemented by the initiator. Different business systems can use different status names, such as "return", "rejected", "reopened", "pending modification", etc., which are all specific manifestations of the target return status.

[0057] Specifically, during the state transition of the corresponding data records, when the intermediate server identifies a data record with a first preset flag (i.e., user confirmation passed), it responds to the first preset flag and updates the data record's state to the target completion state by calling the business system's state update interface. When the intermediate server identifies a data record with a second preset flag (i.e., user confirmation failed), it responds to the second preset flag and updates the data record's state to the target rollback state by calling the business system's state update interface. In other words, after obtaining the state flag of each data record, the intermediate server compares the value of the state flag with the preset flag value. If the value of the status flag matches the first preset flag (e.g., the user entered "Yes" or "Pass"), it is determined that the data record needs to be transferred to the final state of successful completion. Therefore, the status update interface is called to modify the status of the data record to "Completed" or "Closed". If the value of the status flag matches the second preset flag (e.g., the user entered "No" or "Return"), it is determined that the data record needs to be returned to the upstream process for reprocessing. Therefore, the status update interface is called to modify the status of the data record to "Return" or "Reopen".

[0058] In this way, positive or negative feedback from users on third-party platforms is automatically converted into status changes in data records within the business system, thus automating business decisions across networks.

[0059] Optionally, in some embodiments, after obtaining the identifier of the data record, the method further includes: calling the write interface of a third-party platform to write back the identifier to the location in the third-party platform associated with the structured data.

[0060] It is understood that, in this embodiment of the invention, the write interface refers to the application programming interface provided by the third-party platform for writing or updating data into the platform. By calling this interface, content can be written to a specified location (such as a specific cell in an online table). The location associated with the structured data refers to the storage location in the third-party platform corresponding to the structured data initially submitted by the user. For example, if a user fills in a row of data in a Lark multidimensional table, a specific cell in that row is the associated location, used to receive the write-back identifier.

[0061] In other words, after the intermediate server obtains the data record identifier returned by the business system, it can write this identifier back to the location associated with the original structured data on the third-party platform by calling the write interface provided by the third-party platform. Specifically, when the intermediate server successfully calls the creation interface of the business system to generate a data record and obtains the unique identifier of the record (such as the work order number PROJ-123), the intermediate server does not simply store the identifier locally, but actively calls the write interface of the third-party platform to send the identifier back to the third-party platform and write it to the storage location corresponding to the structured data initially submitted by the user. For example, if the user initially filled in work order information in a row of Lark Multidimensional Table, the intermediate server will write back the number generated by the Jira system for that work order to the designated column of that row (such as the "Work Order Number" column).

[0062] In this way, users can view the data record identifiers generated by the intranet business system without leaving the third-party platform, thereby realizing the correlation and traceability of intranet and extranet data, forming a preliminary information closed loop, which makes it convenient for users to query or track the data based on the identifier.

[0063] To facilitate a better understanding of the data processing method proposed in the embodiments of the present invention by those skilled in the art, the following is in conjunction with... Figure 3-5 Further details are provided.

[0064] It is understood that the data processing method of this invention can mainly include two processes: a data creation process and a state synchronization process.

[0065] like Figure 3As shown, the data creation process begins with the intermediate server receiving structured data from Lark's multidimensional tables; then, a work order is created in the internal Jira system by calling the Jira API; after successful creation, the work order KEY returned by the internal Jira system is obtained and stored; at this point, the work order is successfully created and the process ends.

[0066] Specifically, the data creation process is triggered by external users submitting data on the Lark platform (a third-party platform), ultimately generating a corresponding work order in the internal Jira system. External users first access a pre-configured Lark multidimensional table, where each column strictly corresponds to a field in the Jira work order to be created, such as "Project," "Issue Type," "Summary," "Description," "Priority," and "Reporter." After filling in all the necessary information, the user clicks the "Submit" button on the Lark application. This button triggers a pre-configured Webhook request, sending the data from that record in the table to an intermediate server in JSON format. Upon receiving the request, the intermediate server parses and validates the JSON data to ensure correct data format and complete fields. Subsequently, the intermediate server constructs a "Create Work Order" request conforming to the Jira REST API specification within the internal network environment, mapping the parsed structured data to the request body required by the Jira API. For example, the "Summary" field in the Lark table is mapped to the "summary" field in Jira. Then, the intermediate server sends an authenticated POST request (i.e., a data submission request) to the Jira API endpoint. After processing the request, the Jira system returns a successful response containing a globally unique identifier (i.e., a KEY, such as PROJ-123) for the newly created ticket. Finally, the intermediate server optionally calls the Lark API again to write the KEY back to the corresponding record in the Lark multidimensional table, thus establishing a connection between internal and external network data. This allows users to easily check the processing status of tickets locally, forming a preliminary information loop. At this point, a request from the external network is securely and automatically transformed into a formal ticket within the internal Jira system.

[0067] Therefore, external users do not need to directly access the internal network; they can participate in business processes simply by accessing a recognized secure enterprise collaboration platform (such as Lark), which greatly reduces the enterprise's network attack surface and improves information security. Furthermore, utilizing the user-friendly spreadsheet and document interfaces of platforms like Lark, this embodiment of the invention provides external users with a data entry and status confirmation experience comparable to native systems, supporting the filling of complex structured data and intuitive batch operations, effectively breaking down collaboration barriers between internal and external networks.

[0068] After a work order is created and moves to the "Pending Verification" status, the status synchronization process begins. For example... Figure 4 and Figure 5As shown, the status synchronization process is an independently running, never-ending automated closed loop. This process operates periodically to ensure that the status of Jira work orders is consistent with user actions on Lark. After the status synchronization process begins, a scheduled task first pulls work orders with a status of "Pending Verification" from the Jira system, synchronizes the work order list to the Lark document, and waits for user action. Testers mark each work order as "Yes" in the Lark document, and then the scheduled task scans the Lark document, reading the status mark of each work order to be processed. If the mark is "Yes", a flow instruction with a target status of "Completed" is generated, and the Jira status flow API is called to update the work order status to "Completed". If the mark is "No", a flow instruction with a target status of "Returned" is generated, and the Jira status flow API is called to update the work order status to "Returned". If the mark is empty or contains other content, the work order is skipped. The system then checks whether there are any more work orders to process. If there are still unprocessed work orders, it continues to read the next mark and execute the corresponding operation. If all work orders have been processed, the current synchronization cycle ends.

[0069] To facilitate understanding, the state synchronization process is explained in detail below.

[0070] Specifically, first, a scheduled task (e.g., set to run hourly) runs on the intermediate server. When triggered, this task calls Jira's search API (the query interface of the business system) and uses JQL to query work orders with specific statuses, such as "Pending Verification." Jira returns a list of work orders containing key information such as the work order key, summary, and handler. Next, the intermediate server calls Lark Cloud Docs' API (the table writing interface of a third-party platform) to write the obtained work order list into a pre-created Lark document. This document serves as the user's "Unified To-Do List," containing columns such as "Jira Work Order Number," "Issue Summary," and "To-Do Instructions." The "To-Do Instructions" column is initially empty, awaiting user input. Then, another scheduled task with a higher frequency (e.g., running every 10 minutes) runs on the intermediate server. When triggered, this task calls Lark Cloud Docs' API (the table reading interface of a third-party platform) to read the table content and parse the "Status Confirmation" column, which is manually filled in by the user, typically with "Yes" or "No." Finally, the intermediate server executes decisions and status transitions based on the marked content: if the mark is "Yes," the business confirmation is deemed successful, the intermediate server constructs a Jira workflow transition request, finds the transition ID pointing to the "Completed" status, and calls the API (i.e., the status update interface of the business system) to perform the status transition, closing the work order; if the mark is "No," the business confirmation is deemed unsuccessful, the server finds the transition ID pointing to the "Returned" or "Reopened" status and calls the API (i.e., the status update interface of the business system) to perform the transition, returning the work order to the initiator; if the mark is empty or other values, it is determined that the user has not yet processed the work order, skipping it without any operation. The system processes each work order on the list in a loop until all records are processed, ending the current synchronization cycle, and then the scheduled task restarts to begin the next cycle. Through the above process, this invention establishes a secure, efficient, and fully automated data processing and synchronization channel between the external third-party platform and the internal business system, solving the problem of internal and external network collaboration.

[0071] Therefore, the intermediate server constructed in this invention, acting as a bridge between internal and external networks, does not rely on the implementation details of specific internal business systems (such as Jira) or third-party platforms (such as Lark). It can be easily adapted to other similar systems (such as GitLab, DingTalk, and WeChat Work), demonstrating good universality and scalability. Furthermore, this invention achieves fully automated closed-loop processes of creation-pull-synchronization-marking-driving, realizing unmanned intervention throughout the entire process from external user request to final internal system state update, significantly improving business process efficiency and reducing human error and operational delays.

[0072] According to the data processing method proposed in this embodiment of the invention, records are first created by calling an interface based on user-submitted data; then, records to be processed are periodically retrieved from the business system and synchronized to a third-party platform; finally, status markers filled in by the user on the platform are periodically read, and the record status in the business system is automatically updated based on the markers. Thus, by introducing a third-party platform as an interaction and relay bridge, with an intermediate server periodically performing data retrieval, synchronization, and status marker scanning, and automatically driving the status flow of the intranet business system based on user markers, this solves the problems in related technologies where external network users cannot participate in the data processing of the intranet business system in an intuitive interactive manner, and where the status flow of intranet business processes cannot be automatically driven based on user feedback. This achieves efficient and secure automation of cross-network business processes.

[0073] Next, the data processing apparatus according to an embodiment of the present invention is described with reference to the accompanying drawings.

[0074] Figure 6 This is a block diagram of a data processing apparatus according to an embodiment of the present invention.

[0075] like Figure 6 As shown, the data processing device 10 includes: a receiving module 100, a generating module 200, a first processing module 300, and a second processing module 400.

[0076] The receiving module 100 is used to receive structured data, which is submitted by the user through a third-party platform. The generation module 200 is used to generate corresponding data records based on structured data by calling the creation interface of the business system and to obtain the identifier of the data record. The first processing module 300 is used to call the query interface of the business system according to the first preset period, obtain the data record set that meets the preset state conditions, and send the data record set to the preset storage area of ​​the third-party platform. The second processing module 400 is used to obtain the status flag of each data record in the preset storage area according to the second preset period, and call the status update interface of the business system according to the status flag to drive the corresponding data record to perform status transition.

[0077] Optionally, in some embodiments, the status flag includes a first preset flag and a second preset flag. Based on the status flag, the status update interface of the business system is called to drive the corresponding data record to undergo status transition. The second processing module 400 is specifically used for: In response to the status flag being the first preset flag, the status update interface is called to update the status of the corresponding data record to the target completion status; In response to the status flag being the second preset flag, the status update interface is called to update the status of the corresponding data record to the target rollback status.

[0078] Optionally, in some embodiments, the second processing module 400 obtains the status flag of each data record in a preset storage area, specifically for: Call the table reading interface of a third-party platform to scan the cell contents of the status marker column in the online form document. The cell contents are either text manually entered by the user or values ​​selected from preset options. The status marker for each data record is obtained based on the cell content.

[0079] Optionally, in some embodiments, the data record set is sent to a preset storage area of ​​a third-party platform, and the first processing module 300 is specifically used for: The system calls the table writing interface of a third-party platform to write the data record set into a preset storage area in the form of a table. The preset storage area is an online table document, which includes a status flag column for users to fill in status flags.

[0080] Optionally, in some embodiments, after obtaining the identifier of the data record, the generation module 200 is further configured to: Call the write interface of the third-party platform to write the identifier back to the location in the third-party platform associated with the structured data.

[0081] It should be noted that the foregoing explanation of the data processing method embodiments also applies to the data processing apparatus of this embodiment, and will not be repeated here.

[0082] The data processing apparatus proposed in this embodiment of the invention first creates records by calling an interface based on user-submitted data; then periodically pulls records to be processed from the business system and synchronizes them to a third-party platform; finally, periodically reads the status markers filled in by the user on the platform and automatically updates the record status in the business system based on the markers. Thus, by introducing a third-party platform as an interaction and relay bridge, with an intermediate server periodically performing data retrieval, synchronization, and status marker scanning, and automatically driving the status flow of the intranet business system based on user markers, this solves the problems in related technologies where external network users cannot participate in the data processing of the intranet business system in an intuitive interactive manner, and where the status flow of intranet business processes cannot be automatically driven based on user feedback. This achieves efficient and secure automation of cross-network business processes.

[0083] Figure 7 This is a schematic diagram of an electronic device provided in an embodiment of the present invention. The electronic device may include: The memory 701, the processor 702, and the computer program stored on the memory 701 and executable on the processor 702.

[0084] When the processor 702 executes the program, it implements the data processing method provided in the above embodiments.

[0085] Furthermore, electronic devices also include: Communication interface 703 is used for communication between memory 701 and processor 702.

[0086] The memory 701 is used to store computer programs that can run on the processor 702.

[0087] The memory 701 may include high-speed RAM (Random Access Memory) memory, and may also include non-volatile memory, such as at least one disk storage.

[0088] If the memory 701, processor 702, and communication interface 703 are implemented independently, then the communication interface 703, memory 701, and processor 702 can be interconnected via a bus to complete communication between them. The bus can be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, or an EISA (Extended Industry Standard Architecture) bus, etc. The bus can be divided into address bus, data bus, control bus, etc. For ease of representation, Figure 7 The bus is represented by a single thick line, but this does not mean that there is only one bus or one type of bus.

[0089] Optionally, in a specific implementation, if the memory 701, processor 702, and communication interface 703 are integrated on a single chip, then the memory 701, processor 702, and communication interface 703 can communicate with each other through an internal interface.

[0090] The processor 702 may be a CPU (Central Processing Unit), an ASIC (Application Specific Integrated Circuit), or one or more integrated circuits configured to implement embodiments of the present invention.

[0091] This invention also provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the data processing method described above.

[0092] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the data processing method described above.

[0093] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this invention, "a plurality of" means at least two, such as two, three, etc., unless otherwise explicitly specified.

[0094] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., refer to specific features, structures, materials, or characteristics described in connection with that embodiment or example, which are included in at least one embodiment or example of the present invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.

[0095] Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of the present invention.

Claims

1. A data processing method, characterized in that, The method is applied to an intermediate server, which is connected to a third-party platform and a business system in a restricted access network, and the method includes the following steps: Receive structured data, wherein the structured data is submitted by the user through the third-party platform; Based on the structured data, the corresponding data record is generated by calling the creation interface of the business system, and the identifier of the data record is obtained. According to the first preset cycle, the query interface of the business system is called to obtain a set of data records that meet the preset state conditions, and the set of data records is sent to the preset storage area of ​​the third-party platform; According to the second preset period, the status flag of each data record in the preset storage area is obtained, and the status update interface of the business system is called according to the status flag to drive the corresponding data record to perform status transition.

2. The data processing method according to claim 1, characterized in that, The status marker includes a first preset marker and a second preset marker. The step of calling the status update interface of the business system based on the status marker to drive the corresponding data record to undergo status transition includes: In response to the status flag being the first preset flag, the status update interface is invoked to update the status of the corresponding data record to the target completion status; In response to the status flag being the second preset flag, the status update interface is invoked to update the status of the corresponding data record to the target rollback status.

3. The data processing method according to claim 1, characterized in that, The step of obtaining the status flag of each data record in the preset storage area includes: The table reading interface of the third-party platform is called to scan the cell contents of the status marker column in the online table document, wherein the cell contents are text manually entered by the user or values ​​selected from preset options; The status marker for each data record is obtained based on the cell content.

4. The data processing method according to claim 1, characterized in that, Sending the data record set to the preset storage area of ​​the third-party platform includes: The table writing interface of the third-party platform is invoked to write the data record set into the preset storage area in table form. The preset storage area is an online table document, which includes a status flag column for the user to fill in the status flag.

5. The data processing method according to claim 1, characterized in that, After obtaining the identifier of the data record, the process also includes: The write interface of the third-party platform is invoked to write the identifier back to the location in the third-party platform associated with the structured data.

6. A data processing apparatus, characterized in that, The apparatus is used in an intermediate server, which is connected to a third-party platform and a business system in a restricted access network, and the apparatus includes: A receiving module is used to receive structured data, wherein the structured data is submitted by the user through the third-party platform; The generation module is used to generate corresponding data records based on the structured data by calling the creation interface of the business system, and to obtain the identifier of the data record; The first processing module is used to call the query interface of the business system according to a first preset period, obtain a set of data records that meet preset state conditions, and send the set of data records to a preset storage area of ​​the third-party platform. The second processing module is used to obtain the status flag of each data record in the preset storage area according to the second preset period, and call the status update interface of the business system according to the status flag to drive the corresponding data record to perform status transition.

7. The data processing apparatus according to claim 6, characterized in that, The status marker includes a first preset marker and a second preset marker. The second processing module, which calls the status update interface of the business system based on the status marker to drive the corresponding data record to undergo status transition, is specifically used for: In response to the status flag being the first preset flag, the status update interface is invoked to update the status of the corresponding data record to the target completion status; In response to the status flag being the second preset flag, the status update interface is invoked to update the status of the corresponding data record to the target rollback status.

8. An electronic device, characterized in that, include: A memory, a processor, and a computer program stored in the memory and capable of running on the processor, the processor executing the program to implement the data processing method as described in any one of claims 1-5.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, The program is executed by the processor to implement the data processing method as described in any one of claims 1-5.

10. A computer program product, characterized in that, It includes a computer program, which, when executed by a processor, is used to implement the data processing method according to any one of claims 1-5.

Images