Subscription for integrating external data from external system

A computer system, comprising:

• a processor;
• a memory communicatively coupled to the processor;
• and
• a program module (i) which executes in the processor from the memory and (ii) which, when executed by the processor, causes the computer system to integrate external data from an external system into a client system by
• selecting a subscription file, the subscription file comprising a read method, a query method, and an association method, the read method defining fields of a client cache operating in a client system;
• executing the query method to retrieve, from the external system, field values corresponding to at least a subset of the fields;
• upon executing the query method, executing the read method to retrieve, from the external system, additional field values corresponding to a remaining subset of the fields that were not retrieved by executing the query method;
• executing the association method to retrieve second additional field values from related entities;
• and
• populating the client cache with the field values, the additional field values, and the second additional field values according to the fields.

A computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to:

• select a subscription file, the subscription file comprising a read method, a query method, an association method, and an explicit identity, the read method defining fields of a client cache operating in a client system;
• execute the query method to retrieve, from the external system, field values corresponding to at least a subset of the fields;
• associate a refresh rate with the field values;
• upon executing the query method, execute the read method to retrieve, from the external system, additional field values corresponding to a remaining subset of the fields that were not retrieved by executing the query method;
• execute the association method to retrieve second additional field values from related entities;
• utilizing the explicit identity to retrieve third additional field values by specific identifier;
• populating the client cache with the field values, the additional field values, the second additional field values, and the third additional field values according to the fields;
• and
• refresh the field values according to the refresh rate.