Workflow support for dynamic action output

Patent metadata

Field	Value
Publication number	US-11435983-B2
Application number	US-202117157423-A
Country	US
Kind code	B2
Filing date	Jan 25, 2021
Priority date	Mar 19, 2019
Publication date	Sep 6, 2022
Grant date	Sep 6, 2022

Abstract

Persistent storage may contain metadata actions and integration actions related to a remote service, wherein the remote service includes a remote service application programming interface (API) that provides access to structured data, and a metadata API that provides access to a schema of the structured data. Processors may be configured to: (i) generate and provide, for metadata action design graphical user interfaces (GUIs), options for specification of a metadata action, where the metadata action defines a metadata query to the metadata API, rules for parsing the schema, and a normalized format for the structured data; (ii) generate and provide, for integration action design GUIs, options for specification of an integration action, where the integration action defines a structured data query to the remote service API and an indication that the metadata action is to be used to represent a result of the structured data query in the normalized format.

First claim

What is claimed is:

1. A method, comprising:
causing, via a processor, a workflow design graphical user interface (GUI) to be displayed on a client device, wherein the workflow design GUI comprises a menu of actions available to be incorporated into a workflow;
receiving an input indicative of a command to incorporate an integration action into the workflow, wherein the integration action defines a structured data query to a remote service application programming interface (API) of a remote service that provides access to structured data, and wherein the integration action defines an indication that a metadata action is to be performed to query a metadata API for a schema of a result of the structured data query to present the result of the structured data query in a normalized format based on the schema of the result of the structured data query; and
writing, via the processor, a representation of the workflow to a persistent storage, wherein the workflow comprises the integration action to be performed based on a trigger.

2. The method of claim 1 , further comprising causing the result of the structured data query to be displayed on the workflow design GUI in the normalized format upon receiving the input indicative of the command to incorporate the integration action into the workflow.

3. The method of claim 1 , further comprising causing a menu to be displayed on the workflow design GUI, wherein the menu comprises a plurality of integration actions selectable for incorporation into the workflow, and wherein the input indicative of the command to incorporate the integration action into the workflow is received via the menu.

4. The method of claim 1 , wherein the integration action defines a list of tables to be retrieved, and wherein the method further comprises querying the metadata API for the list of tables in response to receiving the input indicative of the command to incorporate the integration action into the workflow.

5. The method of claim 4 , further comprising causing a first menu to be displayed on the workflow design GUI, wherein the first menu comprises the list of tables, and wherein each table of the list of tables is selectable for incorporation into the workflow.

6. The method of claim 5 , further comprising receiving an additional input to retrieve a table from the list of tables and presenting a second menu comprising a plurality of additional actions to be performed with respect to the table from the list of tables.

7. The method of claim 6 , further comprising querying the metadata API for a particular schema of the table from the list of tables in response to receiving the additional input and presenting data items selectable for incorporation into the workflow for each additional action of the plurality of additional actions based on the particular schema of the table from the list of tables.

8. The method of claim 6 , further comprising receiving a further input indicative of a selection of an additional action of the plurality of additional actions such that the workflow comprises the additional action of the plurality of additional actions to be performed on the table from the list of tables based on the trigger.

9. A system, comprising:
a processor; and
a persistent storage accessible by the processor, the persistent storage storing instructions that, when executed by the processor, cause the processor to perform operations comprising:
causing a first menu to be displayed via a workflow design graphical user interface (GUI) of a client device, wherein the first menu comprises a plurality of integration actions;
receiving a first input indicative of a selection of an integration action of the plurality of integration actions to be incorporated into a workflow, wherein the integration action of the plurality of integration actions defines a structured data query to a remote service application programming interface (API) of a remote service that provides access to structured data, and wherein the integration action of the plurality of integration actions comprises a metadata action to be performed to query a metadata API of the remote service to retrieve a list of tables and respective schemas of the list of tables for presenting a result of the structured data query in a normalized format based on the respective schemas of the list of tables; and
storing the workflow in the persistent storage, wherein the workflow comprises the integration action of the plurality of integration actions to be performed in response to a trigger to retrieve the list of tables.

10. The system of claim 9 , wherein the operations further comprise:
causing a second menu to be displayed via the workflow design GUI of the client device, wherein the second menu comprises the list of tables retrieved via the metadata action; and
receiving a second input indicative of a selection of a table from the list of tables via the second menu.

11. The system of claim 10 , wherein the operations further comprise:
causing a third menu to be displayed via the workflow design GUI of the client device, wherein the third menu comprises a plurality of additional actions selectable for performance with respect to the table from the list of tables; and
receiving a third input indicative of a selection of an additional action of the plurality of additional actions via the third menu.

12. The system of claim 11 , wherein the operations further comprise executing the workflow to perform the additional action of the plurality of additional actions with respect to the table from the list of tables in response to the trigger to retrieve the list of tables.

13. The system of claim 11 , wherein the metadata action causes query of the metadata API to retrieve a particular schema of data items associated with the table from the list of tables, and wherein the additional action of the plurality of additional actions comprises a data item selected from the particular schema of data items associated with the table from the list of tables.

14. The system of claim 9 , wherein the operations further comprise causing a pane to be displayed on the workflow design GUI based on the metadata action, and wherein the pane comprises the result of the structured data query in the normalized format upon receiving the first input indicative of the selection of the integration action of the plurality of integration actions to be incorporated into the workflow.

15. A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, are configured to cause the one or more processors to perform operations comprising:
causing a first pane to be displayed on a workflow design graphical user interface (GUI) of a client device, wherein the first pane comprises a menu comprising a plurality of integration actions available for selection to incorporate in a workflow, wherein a first integration action of the plurality of integration actions defines a structured data query to a remote service application programming interface (API) that provides access to structured data, wherein the first integration action of the plurality of integration actions comprises an indication that a metadata action is to be performed, and wherein the metadata action defines a metadata query to a metadata API that provides access to a schema of the structured data to present a result of the structured data query in a normalized format defined by the metadata action and based on the schema of the structured data;
causing a second pane to be displayed on the workflow design GUI, wherein the second pane comprises the result of the structured data query pr

Assignees

• Servicenow Inc

Inventors

• Burman Jacob Samuel
• Dias Rebecca Anita
• Nerius Joshua Timothy
• Maloy Christopher
• Alvarado Jimenez Alberto
• Nelson Harry Thomas

Classifications

• G06F9/44521

  Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading · CPC title

• G06F9/451

  Execution arrangements for user interfaces · CPC title

• G06Q10/0633 Primary

  Workflow analysis · CPC title

• G06F8/34 Primary

  Graphical or visual programming · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title