Client-defined field resolvers for database query language gateway

Patent metadata

Field	Value
Publication number	US-2021406078-A1
Application number	US-202016914402-A
Country	US
Kind code	A1
Filing date	Jun 28, 2020
Priority date	Jun 28, 2020
Publication date	Dec 30, 2021
Grant date	—

Abstract

A query gateway service for servicing API requests of software services, the query gateway service configured to monitor for, and execute, client-defined field resolvers so that client applications can define, at least in part, how data served to that client application in response to an API request is formatted, validated, mutated, or otherwise presented.

First claim

What is claimed is:

1 . A database language query gateway communicably coupled to a client device and a software service, the database language query gateway comprising:
a processor allocation; and a memory allocation storing executable instructions that when accessed by the processor allocation instantiate a gateway service configured to:
receive, from the client device, an application programming interface (API) request, the API request comprising:
a first portion comprising a request for data stored in a database accessible to the software service; and
a second portion comprising a field resolver identifier, the field resolver identifier identifying a field resolver;

generate, based on the API request, at least one query of the database;
receive, from the database of the software service, a response to the at least one query comprising a field to be resolved by the field resolver;
pass the field to the field resolver;
receive an output from the field resolver;
generate an API response, the API response comprising the output received from the field resolver; and
provide the API response to the client device.

2 . The database language query gateway of claim 1 , wherein the field resolver is a function executed by the client device.

3 . The database language query gateway of claim 1 , wherein the field resolver is a function executed by a resolver service.

4 . The database language query gateway of claim 3 , wherein the resolver service comprises a server separate from the software service and the client device.

5 . The database language query gateway of claim 1 , wherein:
the database is a first database; the field is a first field; the response is a first response; and the gateway service is configured to:
generate, based the API request, at least one query of a second database of the software service;
receive, from the database of the software service, a second response to the at least one query of the second database, the second response comprising a second field; and
generate the API response, the API response comprising the output received from the field resolver and the second field.

6 . The database language query gateway of claim 5 , wherein:
the field resolver is a first field resolver; and the second field is resolved by a second field resolver, the second field resolver internal to the gateway service.

7 . The database language query gateway of claim 1 , wherein the field resolver identifier identifies the field to be resolved by the field resolver.

8 . The database language query gateway of claim 1 , wherein the field resolver identifier comprises a string of executable code that, when executed by the gateway service, instantiates the field resolver.

9 . A client-server system for servicing API requests, the system comprising:
a software service comprising at least one database; a client device comprising a first processor allocation executing a first instance of a client application, the client application configured to generate an API request comprising:
a request for data stored in the at least one database of the software service; and
a client-defined field resolver; and
a query gateway comprising a second processor allocation executing a second instance of a gateway service, the gateway service in communication with the client application and configured to:
receive the API request from the client device;
generate at least one query of the at least one database of the software service based on the request for data of the API request;
cause the at least one query to be executed against the at least one database and receive a first output therefrom;
modify at least one field of the first output by passing at least a portion of the first output to the client-defined field resolver;
receive a second output from the client-defined field resolver;
generate an API response comprising the second output; and
communicate the API response to the client application.

10 . The system of claim 9 , wherein the client-defined field resolver is executed at least in part by the client device.

11 . The system of claim 9 , wherein the client-defined field resolver is executed at least in part by the gateway service.

12 . The system of claim 11 , wherein the API request comprises executable code that, when executed by the gateway service, performs a function defining an operation of the client-defined field resolver.

13 . The system of claim 9 , wherein the client-defined field resolver is executed at least in part by a resolver service communicably coupled to the gateway service.

14 . The system of claim 9 , wherein the software service comprises the query gateway.

15 . The system of claim 9 , wherein the client application is configured to:
generate the API request in response to receiving an input to a graphical user interface; and update the graphical user interface in response to receiving the API response.

16 . A method of operating a database language query gateway service, the method comprising:
receiving, from a client application executing on a client device, an API request; extracting from the API request a data request and a client-defined resolver; generating at least one query responsive to the data request; executing the at least one query against at least one database of a software service communicably coupled to the database language query gateway service; receiving a result of the at least one query from the at least one database; modifying at least one field of the result by passing the result to the client-defined resolver; generating an API response including the modified at least one field; and communicating the API response to the client application.

17 . The method of claim 16 , wherein the client-defined resolver comprises executable code executed by the database language query gateway service.

18 . The method of claim 16 , wherein passing the result to the client-defined resolver comprises submitting a resolution request to the client application, the resolution request comprising the at last one field of the result.

19 . The method of claim 16 , wherein passing the result to the client-defined resolver comprises submitting a resolution request to a resolution service, the resolution request comprising the at last one field of the result.

20 . The method of claim 16 , wherein the at least one field of the result is modified by a gateway-defined resolver operated by the database language query gateway service.

Assignees

• Atlassian Pty Ltd
• Atlassian Inc

Inventors

• Sukhyani Kapil

Classifications

• G06F9/44505

  Configuring for program initiating, e.g. using registry, configuration files · CPC title

• G06F16/24553 Primary

  of query operations · CPC title

• G06F9/5027 Primary

  the resource being a machine, e.g. CPUs, Servers, Terminals · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F9/546

  Message passing systems or structures, e.g. queues · CPC title