The flat file API

Use the flat file application programming interface (API) to supply and modify IBM® Predictive Maintenance and Quality master data.

The IBM Predictive Maintenance and Quality API supports the upsert operation.

The upsert operation attempts to update an existing row. If the matching row cannot be found, a new row is created that uses the values in the input record.

All the values for the row must be included even if only a single value of the row is being changed.

An IS_ACTIVE indicator is used to mark records as no longer in use (IS_ACTIVE = 0).

The IS_ACTIVE indicator is not used to take any decisions while loading the master or event data. For example, while loading a resource, if the associated location has the following indicator: IS_ACTIVE=0, that resource is loaded and associated with that location. Similarly if the event is reported by the resource with IS_ACTIVE=0, the event is processed and stored in the datastore.