SYSTEM AND METHOD FOR AUTOMATICALLY SUGGESTING REMOTE QUERY PARAMETERS BASED FOR CUSTOMIZED DATA INTEGRATION PROCESS
An information handling system operating an automated data set query suggestion system may comprise a processor executing code instructions for identifying a data set through an API query, a GUI receiving a user-selected query object, and the processor generating a natural language sentence describing a suggested API query, based on node and edge values for a previously executed query database describing previously executed API queries. The suggested API query may have include a suggested query object, a suggested query operator, or a suggested API to be queried, associated in the previously executed query database with the user-selected query object. The GUI may receive a user instruction to perform the suggested API query, the processor may automatically generate a set of code instructions for future execution of the suggested API query, and a network interface device may transmit the code instructions for future execution by a runtime engine for execution at a remote location.
1 . An information handling system operating an automated data set query suggestion system comprising:
a processor executing code instructions to model an integration process for identifying a data set through a remote application program interface (API) query, and performing a user-selected action on the data set;
a dataset query selection user interface (GUI) receiving a user-selected query object;
the processor generating a natural language sentence describing a suggested API query, based on first node value and a first to second edge value for a previously executed query database describing previously executed remote API query parameters;
the suggested API query having suggested query parameters that comprise a suggested query object, a suggested query operator, or a suggested remote API to be queried, associated in the previously executed query database with the user-selected query object;
the GUI receiving a user instruction to perform the suggested API query, described by the natural language sentence, within the integration process;
the processor automatically generating a set of connector code instructions for future execution for performing the user-selection action on the data set matching the suggested query parameters; and
a network interface device transmitting the set of connector code instructions for future execution and a runtime engine for execution at a remote location in deployment of the integration process.
2 . The information handling system of claim 1 further comprising:
the processor identifying the previously executed remote API query parameters within a previously executed set of connector code instructions; and
the processor generating the previously executed query database comprising a first node, having the suggested query object as the first node value, connected to a second node, having the user-selected query object as the second node value, via a first to second edge, having the first to second edge value including a natural language relationship between the first node and the second node.
3 . The information handling system of claim 2 , wherein the previously executed set of connector code instructions are executed by a first user, and the set of connector code instructions for future execution are transmitted to a remote location of a second user.
4 . The information handling system of claim 2 , wherein the previously executed query database comprises a third node value including an identification of an API to be queried, connected to the first node value via a first to third edge value describing a natural language relationship between the first node value and the third node value.
5 . The information handling system of claim 2 , wherein the previously executed set of connector code instructions are written in a non-structured query language, and the processor generates the previously executed query database based on metadata describing a previous execution of the previously executed set of connector code instructions.
6 . The information handling system of claim 1 , wherein the previously executed set of connector code instructions comprises code instructions for a previously executed remote query of a relational database.
7 . The information handling system of claim 1 , wherein the previously executed set of connector code instructions comprises code instructions for a previously executed remote query of a non-relational database.
8 . A method of automatically generating data set query suggestions comprising:
identifying previously executed remote API query parameters, via a processor, including a previously executed query object and a previously queried data set source within a previously executed set of connector code instructions;
generating a previously executed query database comprising a first node value including the previously executed query object, and a second node value, including the previously queried data set source, connected to the first node value via a first to second edge value including a natural language relationship between the first node value and the second node value;
executing code instructions to model a future integration process for identifying a data set managed by a remote data set source to be queried in the future, through a future data set query, via the processor;
receiving, via a dataset query selection user interface (GUI), a user instruction to include the first node value or the second node value within the future data set query;
generating a natural language suggested API query, via the processor, based on the first node value, the second node value, and the first to second edge value;
receiving, via the GUI, a user instruction to perform the natural language suggested API query, within the future data set query;
automatically generating a set of connector code instructions for execution of the future data set query via the processor; and
transmitting, via a network interface device, the set of connector code instructions for future execution and a runtime engine for execution at a remote location in deployment of the integration process.
9 . The method of claim 8 , wherein the previously executed set of connector code instructions are executed by a first user, and the set of connector code instructions for future execution are transmitted to a remote location of a second user.
10 . The method of claim 8 , wherein the remote data set source to be queried in the future is a relational database.
11 . The method of claim 10 , wherein the previously queried data set source is a remotely managed non-relational database.
12 . The method of claim 8 , wherein the remote data set source to be queried in the future is a non-relational database.
13 . The method of claim 12 , wherein the previously queried data set source is a remotely managed relational database.
14 . The method of claim 8 , wherein the remote data set source to be queried in the future is an application programming interface (API).
15 . An information handling system operating an automated data set query suggestion system comprising:
a processor identifying previously executed remote API query parameters, including a previously executed query object and a previously queried data set source within a previously executed set of connector code instructions;
the processor generating a previously executed query database comprising:
a first node value including the previously executed query object;
a second node value including the previously queried data set source, connected to the first node value via a first to second edge value including a natural language relationship between the first node value and the second node value;
the processor executing code instructions to model a future integration process for identifying a data set through a future data set query;
a dataset query selection user interface (GUI) receiving a user instruction to include the first node value or the second node value within the future data set query;
the processor generating a natural language suggested API query, based on the first node value, the second node value, and the first to second edge value;
the GUI receiving a user instruction to perform the natural language suggested API query, within the future data set query;
the processor automatically generating a set of connector code instructions for execution of the future data set query; and
a network interface device transmitting the set of connector code instructions for future execution and a runtime engine for execution at a remote location in deployment of the integration process.
16 . The information handling system of claim 15 , wherein the previously executed set of connector code instructions are executed by a first user, and the set of connector code instructions for future execution are transmitted to a remote location of a second user.
17 . The information handling system of claim 15 , wherein the previously queried data set source is a remotely managed software application.
18 . The information handling system of claim 15 , wherein the previously queried data set source is a remotely managed relational database.
19 . The information handling system of claim 15 , wherein the previously queried data set source is a remotely managed relational database.
20 . The information handling system of claim 15 , wherein the previously queried data set source is an application programming interface (API).