US 12,254,012 B2
Data extraction with user-configurable extract templates
Magnus Norrby, Bromma (SE); Saker Asllan, London (GB); Yulia Havriuk, Khmelnytsky (UA); and Mikael R. Nilsson, Hägersten (SE)
Assigned to NASDAQ TECHNOLOGY AB, Stockholm (SE)
Filed by Nasdaq Technology AB, Stockholm (SE)
Filed on Nov. 22, 2023, as Appl. No. 18/517,196.
Application 18/517,196 is a continuation of application No. 17/135,289, filed on Dec. 28, 2020, granted, now 11,829,369.
Prior Publication US 2024/0095250 A1, Mar. 21, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2457 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/2457 (2019.01) [G06F 16/2379 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one memory device configured to store an extract template for accessing data in a database, each extract template comprising a query to be run on the database, a set of input parameters and a set of output columns; and
at least one processor configured to access the at least one memory device and to execute a data extract service program code, wherein the data extract service program code includes instructions which, when executed by the at least one processor, cause the at least one processor to perform operations comprising:
receiving first configuration information from a first client device, wherein the first configuration information includes a subset, selected via a first user interface displayed by the first client device, of a set of input parameters of the extract template;
storing, in the at least one memory device, said first configuration information as an extract job template associated with the extract template;
publishing an application program interface (API) endpoint for a second client device to access the stored extract job template;
in response to a request message from the second client device received via the published API endpoint:
accessing the selected subset of the input parameters in the stored extract job template and transmitting a response message including information for displaying a second user interface enabling the second client device to obtain client-specified values to the selected subset of the input parameters;
receiving, from the second client device, client-specified values for one or more input parameters in the selected subset of the input parameters;
injecting, into the query, at least some of the received client-specified values to corresponding input parameters in the selected subset of the input parameters; and
running said query with the injected client-specified values; and
outputting results of said running of said query, the results including one or more output columns from the set of output columns in the extract template.