IP Library Granted Patent US 11,669,520
Granted Patent B1
US 11,669,520 · App. 17/901,219 · Granted Jun 6, 2023

Non-structured data oriented communication with a database

Inventors: Lacey Perretta (Pittsburgh, PA); Rich Wilkie (Pittsburgh, PA); Michael David Angle (Warwick, NY); Sandeep Damodar Bhide (Randolph, NJ)
Assignee: Coupa Software Incorporated
G06F16/2428G06F16/2425G06Q30/0203
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,669,520
App. No.
17/901,219
Granted
Jun 6, 2023
Kind
B1
Abstract

Techniques for communicating with a third-party management database are described herein. According to an embodiment, a computer receives a search-style query, searches the third-party management database, retrieves multiple computer-readable database search strings, displays the computer-readable database search strings, and receives a selected computer-readable database search string. In response, the computer queries the third-party management database using the selected search string, returns a temporary variable associated with a supplier risk score, and receives a command to perform a decision step as part of a workflow.

Claims (46)

1. A method for communicating with a third-party management database, as part of a computer-implemented workflow, via an application programming interface (“API”) coupled with a data-access tool, the method comprising:

receiving a search-style query for extracting the third-party data from the third-party management database;

searching the third-party management database for one or more variables that are associated with the search-style query;

retrieving, from the third-party management database, a plurality of computer-readable database search strings associated with the one or more variables;

displaying to a user the plurality of computer-readable database search strings that were retrieved; and

receiving a user-selected computer-readable database search string from the plurality of computer-readable database search strings that were retrieved, the user-selected computer-readable database search string being based, at least in part, on one or more of the plurality of retrieved computer-readable database search strings, and in response to the receiving the user-selected computer-readable database search string, querying the third-party management database with a new query including the user-selected computer-readable database search string;

returning, to the user, one or more results of the user-selected computer-readable database search string from the third-party management database, the results being a temporary variable, wherein the temporary variable is associated with a supplier risk score;

receiving, from the user, a command to perform a decision step via the data-access tool based on the temporary variable, the decision step determining a specified path to take through the computer-implemented workflow.

2. The method of claim 1 , wherein the search-style query comprises a variable name.

3. The method of claim 1 , wherein the search-style query comprises a partial variable name.

4. The method of claim 3 , further comprising auto-completing the search-style query when the search-style query comprises a partial variable name.

5. The method of claim 1 , wherein the search-style query comprises at least one or more of an operator; a parameter; and a keyword.

6. The method of claim 5 , further comprising, in response to the receiving of the user-selected computer-readable database search string, querying the third-party management database with a query including the user-selected computer-readable database search string and further including at least one or more of an additional operator; an additional parameter; and an additional keyword.

7. The method of claim 1 , further comprising, when one or more variables are not found to be associated with the search-style query,

alerting the user; and prompting the user with auto-generated additional options of words related to the search-style query received.

8. The method of claim 7 , wherein the words include one or more: variables; search terms; and query terms.

9. The method of claim 1 , further comprising receiving data associated with one or more third party surveys.

10. The method of claim 9 , wherein the data associated with one or more third party surveys includes a plurality of questions, each question being individually generated and relating to a third party, each question from the plurality of questions being either a single-select multiple-choice question type or a multiple-select multiple-choice question type, each question comprising:

a plurality of selectable answer options; and

one or more metadata attributes tagged to each question.

11. The method of claim 10 , the metadata attributes comprising one or more of:

a score attribute, each selectable answer option having a pre-determined score assigned to the selectable answer option;

a visibility attribute configured to make visible a question and based on a previously selected selectable answer option;

a conditional attribute wherein when the conditional attribute is tagged to a question, the question is displayed when a pre-determined selectable answer option from a previous question is selected; and

a requirement attribute that when tagged to the questions causes a selection of at least one selectable answer option associated with the questions to be made prior to a selectable of answer option from a subsequent question is made.

12. The method of claim 11 , further comprising, in response to a selected answer option by a third-party respondent, in real-time:

writing the selected answer option to the third-party management database;

searching the third-party management database for all questions that include:

data relating to data included in the selected answer option;

the visibility attribute tagged to the questions; and

making visible the questions in a third-party survey.

13. A third-party management system configured to enable implementation of non-structured-data-oriented communication with a third-party management database, the system comprising:

an application programming interface (“API”) configured to enable communication with the third-party management database via an expression-type language, the API coupled with a data-access tool and configured to accept, from the data-access tool, search-style queries formulated in the expression-type language;

an electronic workflow platform configured to monitor and manage, in real-time, a third-party workflow platform comprising: a workflow graphical user interface (“GUI”); and a workflow communication module that together with the data-access tool and the API enable communication with the third-party management database;

the data-access tool configured to receive from the user, a search-style query into a search-box of the GUI configured to retrieve third party data from the third-party management database;

the API being configured, in response to the data-access tool receiving the search-style query, to: search for one or more variables associated with the search-style query; retrieve, from the third-party management database, a plurality of computer-readable database search strings associated with the one or more variables; display to the user, via the data-access tool, the plurality of computer-readable database search strings that were retrieved; receive a user-selected computer-readable database search string from the plurality of computer-readable database search strings that were retrieved; query the third-party management database with a new query including the user-selected computer-readable database search string; return to the user one or more results of the user-selected computer-readable database search string from the third-party management database, the results being a temporary variable, wherein the temporary variable is associated with a supplier risk score; and receive a command to perform a decision step via the data-access tool based on the temporary variable, the decision step determining a specified path to take through a computer-implemented workflow.

14. The system of claim 13 , the system further comprising an electronic survey platform configured to manage and modify, in real time, execution of a plurality of survey data, the electronic survey platform comprising: a survey GUI; and a survey communication module that together with the data access tool and the API are configure to communicate with the third-party management database; the plurality of survey data comprising a plurality of third-party questions associated with a user from a plurality of users of the system.

15. The system of claim 13 , each question being either a single-select multi-choice question type or a multiple-selection question type data and each question further comprising: a plurality of selectable answer options; and one or more metadata attributes tagged to each question.

16. The system of claim 14 , the metadata attributes including a score attribute and each selectable answer option comprising a pre-determined score assigned to the selectable answer option.

17. The system of claim 14 , the metadata attributes including a visibility attribute configured to make visible a question based on a previously selected answer option.

18. The system of claim 14 , the metadata attributes comprising a conditional attribute; and the API being configured, when the conditional attribute is tagged to a question, to cause displaying the question only when a pre-determined selectable answer option from a previous question is selected.

19. The system of claim 14 , the metadata attributes comprising a requirement attribute; and the API being configured, when the requirement attribute is tagged to the question, to require input of a selection of at least one selectable answer option associated with the question prior to a selection of a selectable answer option from a subsequent question.

20. The system of claim 16 , the survey communication module being configured, in response to an answer option selected by a third-party respondent, the survey communication module to:

transmit the selected answer option to the third-party management database in real time;

search the third-party management database in real time for all questions that include: data relating to the data of the selected answer option; and the visibility attribute tagged to the questions; and

in real time display the questions in a survey corresponding to the survey data.

Assignments (4)
SECURITY INTEREST Recorded Feb 28, 2023
From: COUPA SOFTWARE INCORPORATED; YAPTA, INC.
To: SSLP LENDING, LLC
Reel/Frame 062887/0181 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 1, 2022
From: PERRETTA, LACEY; WILKIE, RICH; ANGLE, MICHAEL DAVID; BHIDE, SANDEEP DAMODAR
To: OPUS GLOBAL, INC.
Reel/Frame 061613/0687 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 1, 2022
From: HIPEROS, LLC
To: COUPA SOFTWARE INCORPORATED
Reel/Frame 061614/0086 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 1, 2022
From: OPUS GLOBAL, INC.
To: HIPEROS, LLC
Reel/Frame 061832/0214 →
Continuity (2)
Continuation 16455368 · Jun 27, 2019
Provisional Application 62691109 · Jun 28, 2018