Methods, systems, and computer readable media for data translation using a representational state transfer (REST) application programming interface (API)

Patent metadata

Field	Value
Publication number	US-11561997-B2
Application number	US-201916352738-A
Country	US
Kind code	B2
Filing date	Mar 13, 2019
Priority date	Mar 13, 2019
Publication date	Jan 24, 2023
Grant date	Jan 24, 2023

Abstract

According to one method, the method comprises: receiving, from a client via a REST API, input in a first format; converting, using predetermined metadata, the input in the first format into input in a second format; sending the input in the second format to a legacy system for performing an operation using the input in the second format; receiving, from the legacy system, output in the second format, wherein the output is based at least in part on the operation performed using the input in the second format; converting, using the predetermined metadata, the output in the second format into output in the first format; and sending, to the client via the REST API, the output in the first format.

First claim

What is claimed is:

1. A method for data translation using a representational state transfer (REST) application programming interface (API), the method comprising:
at a server comprising a metadata-based data translation framework for providing data translation and facilitating interaction with a legacy system using a REST API:
receiving, from a client via the REST API using a hypertext transfer protocol (HTTP) request message, input in a first format, wherein the input includes an object type identifier;
generating, at runtime and using the HTTP request message, conversion logic for converting between a first format and a second format; wherein the conversion logic is generated using predetermined metadata and reflection programming, wherein generating the conversion logic includes instantiating, at runtime, a marshaller object based on the object type identifier and the request type of the HTTP request message;
converting, using the conversion logic, the input in the first format into input in a second format, wherein converting the input in the first format into input in the second format includes validating that a value of the input in the first format is valid in the second format and, in response to determining that the value in the first format is invalid in the second format, changing the value in the first format to a valid value in the second format;
sending the input in the second format to the legacy system for performing an operation using the input in the second format;
receiving, from the legacy system, output in the second format, wherein the output is based at least in part on the operation performed using the input in the second format;
converting, using the conversion logic, the output in the second format into output in the first format; and
sending, to the client via the REST API, the output in the first format.

2. The method of claim 1 wherein the first format is a JavaScript object notation (JSON) format or an extensible markup language (XML) format and the second format is a field list (FList) format or a portal communications module (PCM) format.

3. The method of claim 1 wherein the first format is a field list (FList) format or a portal communications module (PCM) format and the second format is a JavaScript object notation (JSON) format or an extensible markup language (XML) format.

4. The method of claim 1 wherein an action to perform or a hypertext transfer protocol (HTTP) request type.

5. The method of claim 1 comprising:
performing a backward compatibility test for determining whether data in the second format is valid or for determining whether the output in the first format is valid.

6. The method of claim 5 wherein the backward compatibility test is triggered in response to receiving additional metadata from an operator or the client.

7. The method of claim 1 wherein the client includes a user interface application, an external system, a customer relationship management system, a cloud service, a web service, a REST API client, or financial software.

8. A system for data translation using a representational state transfer (REST) application programming interface (API), the system comprising:
at least one processor; and
a server comprising a metadata-based data translation framework for providing data translation and facilitating interaction with a legacy system using a REST API, wherein the server is implemented using the at least one processor; wherein the server is configured for:
receiving, from a client via the REST API using a hypertext transfer protocol (HTTP) request message, input in a first format, wherein the input includes an object type identifier;
generating, at runtime and using the HTTP request message, conversion logic for converting between a first format and a second format; wherein the conversion logic is generated using predetermined metadata and reflection programming, wherein generating the conversion logic includes instantiating, at runtime, a marshaller object based on the object type identifier and the request type of the HTTP request message;
converting, using the conversion logic, the input in the first format into input in a second format, wherein converting the input in the first format into input in the second format includes validating that a value of the input in the first format is valid in the second format and, in response to determining that the value in the first format is invalid in the second format, changing the value in the first format to a valid value in the second format;
sending the input in the second format to the legacy system for performing an operation using the input in the second format;
receiving, from the legacy system, output in the second format, wherein the output is based at least in part on the operation performed using the input in the second format;
converting, using the conversion logic, the output in the second format into output in the first format; and
sending, to the client via the REST API, the output in the first format.

9. The system of claim 8 wherein the first format is a JavaScript object notation (JSON) format or an extensible markup language (XML) format and the second format is a field list (FList) format or a portal communications module (PCM) format.

10. The system of claim 8 wherein the first format is a field list (FList) format or a portal communications module (PCM) format and the second format is a JavaScript object notation (JSON) format or an extensible markup language (XML) format.

11. The system of claim 8 wherein the server is configured for selecting conversion rules based on an action to perform or a hypertext transfer protocol (HTTP) request type.

12. The system of claim 8 wherein the server is configured for performing a backward compatibility test for determining whether data in the second format is valid or for determining whether the output in the first format is valid.

13. The system of claim 12 wherein the server is configured to trigger the backward compatibility test in response to receiving additional metadata from an operator or the client.

14. The system of claim 8 wherein the client includes a user interface application, an external system, a customer relationship management system, a cloud service, a web service, a REST API client, or financial software.

15. A non-transitory computer readable medium comprising computer executable instructions that when executed by a processor of a computer cause the computer to perform steps comprising:
at a server comprising a metadata-based data translation framework for providing data translation and facilitating interaction with a legacy system using a representational state transfer (REST) API:
receiving, from a client via the REST API using a hypertext transfer protocol (HTTP) request message, input in a first format, wherein the input includes an object type identifier;
generating, at runtime and using the HTTP request message, conversion logic for converting between a first format and a second format; wherein the conversion logic is generated using predetermined metadata and reflection programming, wherein generating the conversion logic includes instantiating, at runtime, a marshaller object based on the object type identifier and the request type of the HTTP request message;
converting, using the conversion logic, the input in the first format into input in a second format, wherein converting the input in the first format into input in the second format includes validating that a value of the input in the first format is valid in the second format and, in response to determining that the value in the first format

Assignees

• Oracle Int Corp

Inventors

• Pigeon Alain
• Dueck Brian James
• Thomas Prakash John
• Dey Deepankar

Classifications

• H04L67/02

  based on web technology, e.g. hypertext transfer protocol [HTTP] · CPC title

• G06F9/54

  Interprogram communication · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• H04L67/34

  involving the movement of software or configuration parameters  (network booting or remote initial program loading [RIPL] G06F9/4416) · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title