Integrated asynchronous access interface for data retrieval from distributed data sources

A system for asynchronously performing search requests across a plurality of databases, the system comprising:

• a computing system including:
• a first database;
• a plurality of asynchronous APIs including at least a search request API, a status API, a response API, and a database API;
• and
• a processor;
• and
• a memory storing instructions to execute a search request which, when executed, causes the computing system to:
• receive a search request from a tenant computing device;
• transmit, by the search request API, the search request to a first database;
• create, by the status API, a server sent event;
• separate the search request into individual search attributes;
• identify, by the processor, a plurality of search attributes in the search request;
• map, by the processor, each search attribute of the plurality of search attributes to a corresponding database of a plurality of databases;
• generate a plurality of sub-search requests by, for each search attribute of the plurality of search attributes, generating a sub-search request to query the corresponding database for data matching the search attribute;
• initiate, through the database API, a search sequence comprising the plurality of sub-search requests;
• receive, by the status API, a notification that the process search sequence is in progress;
• construct a response packet in the first database, the response packet including stored data matching the plurality of search attributes from the plurality of databases;
• receive, by the status API, a notification that the search sequence is complete;
• update, by the status API, the status of the process search sequence as complete;
• receive, by the status API, notification that the response packet is ready for download by the tenant computing device;
• notify the tenant computing device, by the status API, that the response packet is ready for download by the tenant computing device;
• receive, by the response API, the response packet;
• receive, at the response API from the tenant computing device, a request to download the response packet;
• and
• transmit, by the response API, to the tenant computing device, the response packet.

A non-transitory computer readable medium having stored thereon instructions that cause a processor to execute a method, the method comprising:

• receiving a search request from a tenant computing device at a search interface including a search request API, the search interface being hosted by a computing system comprising a processor;
• transmitting, by the search request API, the search request to a first database;
• creating, by a status API, a server sent event;
• identifying, by the processor, a plurality of search attributes in the search request;
• mapping, by the processor, each search attribute of the plurality of search attributes to a corresponding database of a plurality of databases;
• generating a plurality of sub-search requests by, for each search attribute of the plurality of search attributes, generating a sub-search request to query the corresponding database for data matching the search attribute;
• initiating, by the processor, through a database API a search sequence comprising the plurality of sub-search requests;
• receiving, by the status API, a notification that the search sequence is in progress;
• constructing, by the processor, a response packet in the first database, the response packet including stored data matching the plurality of search attributes from the plurality of databases;
• receiving, by the status API, a notification that the search sequence is complete;
• updating, by the status API, the status of the search sequence as complete;
• receiving, by the status API, notification that the response packet is ready for download by the tenant computing device;
• notifying the tenant computing device, by the status API, that the response packet is ready for download by the tenant computing device;
• receiving, by a response API, the response packet;
• receiving, at the response API from the tenant computing device, a request to download the response packet;
• and
• transmitting, by the response API, to the tenant computing device, the response packet.