Unified application programming interface for transformation of structured data

Patent metadata

Field	Value
Publication number	US-11531683-B2
Application number	US-201916675985-A
Country	US
Kind code	B2
Filing date	Nov 6, 2019
Priority date	Nov 6, 2019
Publication date	Dec 20, 2022
Grant date	Dec 20, 2022

Abstract

A system includes a processor configured to create a rule repository instance. The rule repository instance specifies a plurality of different procedures that facilitate specifying a sequence of transformer rules by cascading each of the procedures together using a dot notation format. The processor configures the rule repository instance with a plurality of transformer rules using the dot notation format. The processor receives data from a file arranged according to a first structured data format. The processor executes the sequence of transformer rules to convert data elements in the file to a second structured data format. The processor then provides for display or storage the data as converted into the second structured data format by the sequence of transformer rules.

First claim

What is claimed is:

1. A system comprising:
a processor; and
a memory in communication with the processor, storing instruction code executable by the processor to cause the processor to perform operations that include:
creating a rule repository instance, wherein the rule repository instance specifies a plurality of different procedures that facilitate specifying a sequence of transformer rules, wherein the sequence of transformer rules is specified by cascading the procedures together using a dot notation format;
configuring the rule repository instance with a plurality of transformer rules specified by a set of the procedures that are cascaded together using the dot notation format, wherein each of the transformer rules specifies (i) a set of data elements that are arranged according to a first structured data format, (ii) structural changes to be performed on the set of data elements that convert the set of data elements into a second structured data format, and wherein the plurality of transformer rules comprises:
a first transformer rule that applies an adapter of a plurality of adapters, wherein the adapter modifies values of the set of data elements; and
a second transformer rule that does not apply any adapter of the plurality of adapters;

associating a transformer class instance with (i) the rule repository instance, and (ii) a file arranged according to the first structured data format;
controlling, via a first procedure of the transformer class instance, the transformer class instance to perform the structural changes to the file according to the first transformer rule of the rule repository instance;
controlling, via a second procedure of the transformer class instance, the transformer class instance to apply the adapter to modify the values of the data elements in the file according to the first transformer rule of the rule repository instance;
controlling, via a third procedure of the transformer class instance, the transformer class instance to perform the structural changes to the file according to the second transformer rule of the rule repository instance; and
providing, from the transformer class instance, data as converted into the second structured data format by the sequence of transformer rules.

2. The system according to claim 1 , wherein a fourth procedure takes a path parameter and a field parameter, and wherein the processor performs operations that include:
storing a key/value pair data structure in the memory, wherein a key of the key/value pair data structure corresponds to the field parameter and a value of the key/value pair data structure corresponds to a further value in a first structured data file specified by the path parameter.

3. The system according to claim 2 , wherein the path parameter corresponds to a Java object, a JavaScript Object Notation (JSON) path or an Extensible Markup Language (XML) path that specifies the set of data elements to be converted.

4. The system according to claim 2 , wherein the second procedure that corresponds to the adapter for performing an operation is cascaded to the fourth procedure, wherein the fourth procedure takes a further field parameter that corresponds to the field parameter of the fourth procedure, wherein the second procedure controls the processor to perform operations that include:
modifying the value associated with the key/value pair data structure stored in the memory according to an operation associated with the adapter.

5. The system according to claim 2 , wherein the operation associated with the second procedure corresponds to one of: a math operation that modifies the value of the key/value pair data structure according to a computation, a text operation that modifies the value of the key/value pair data structure by trimming a portion of the value, or a concatenation operation that modifies the value of the key/value pair data structure by adding another value to the value.

6. The system according to claim 1 , wherein each of the procedures returns a reference to the rule repository instance.

7. The system according to claim 1 , wherein the first structured data format corresponds to one of: JavaScript Object Notation (JSON), Extensible Markup Language (XML), a JAVA object, or a database table, and wherein the second structured data format corresponds to one of: JSON, XML, a JAVA object, or a database table.

8. The system according to claim 1 , wherein the set of data elements correspond to one or more of: scalar values, records, objects, or arrays of objects.

9. The system according to claim 1 , wherein cascading the procedures together using the dot notation format comprises specifying that the plurality of different procedures specified in the rule repository instance be performed in a particular order, one after another.

10. A computer-implemented method comprising:
creating a rule repository instance, wherein the rule repository instance specifies a plurality of different procedures that facilitate specifying a sequence of transformer rules, wherein the sequence of transformer rules is specified by cascading the procedures together using a dot notation format;
configuring the rule repository instance with a plurality of transformer rules specified by a set of the procedures that are cascaded together using the dot notation format, wherein each of the transformer rules specifies (i) a set of data elements that are arranged according to a first structured data format, (ii) structural changes to be performed on the set of data elements that convert the set of data elements into a second structured data format, and wherein the plurality of transformer rules comprises:
a first transformer rule that applies an adapter of a plurality of adapters, wherein the adapter modifies values of the set of data elements; and
a second transformer rule that does not apply any adapter of the plurality of adapters;
associating a transformer class instance with (i) the rule repository instance, and (ii) a file arranged according to the first structured data format;
controlling, via a first procedure of the transformer class instance, the transformer class instance to perform the structural changes to the file according to the first transformer rule of the rule repository instance;
controlling, via a second procedure of the transformer class instance, the transformer class instance to apply the adapter to modify the values of the data elements in the file according to the first transformer rule of the rule repository instance;
controlling, via a third procedure of the transformer class instance, the transformer class instance to perform the structural changes to the file according to the second transformer rule of the rule repository instance; and
providing, from the transformer class instance, data as converted into the second structured data format by the sequence of transformer rules.

11. The computer-implemented method according to claim 10 , wherein a fourth procedure takes a path parameter and a field parameter, and wherein the method comprises:
storing a key/value pair data structure in a memory, wherein a key of the key/value pair data structure corresponds to the field parameter and a further value of the key/value pair data structure corresponds to a further value in a first structured data file specified by the path parameter.

12. The computer-implemented method according to claim 11 , wherein the path parameter and field parameters are text strings.

13. The computer-implemented method according to claim 11 , wherein the path parameter corresponds to a Java object, a JavaScript Object Notation (JSON) path or an Extensible Markup Language (XML) path th

Assignees

• Servicenow Inc

Inventors

• Motamedi Khosrow Jian
• Ros Fernando

Classifications

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title