Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Web API V1

Method Format and Syntax

The MES Web API includes standard Put, Post, Get, and Delete methods to interact with the MES database.

  • POST Generally used when the call inserts new records into the MES database.
  • PUT Generally used when the call updates existing records in the MES database.
  • GET Used to return information from the MES database.
  • DELETE Used to remove records from the MES database. 

General Format

The general format of the Web API is:

API?Filter=FilterValue&Filter2=Filter2Value

This document lists all the names and the corresponding filter parameters. The endpoint name is followed by the ? symbol to indicate the start of the filters. If no filters are needed, then do not include the ? symbol.

To include multiple filters, separate each with the & symbol.

Endpoint entries are case insensitive.

Syntax

Nearly all the GET Web API endpoints require filter parameters to identify what records to return from the database. Some Get methods have no filter or optional filter parameters. Gets can return a model, a value, a JSON object, or a JSON array. These are predefined formats as needed by the MES Web Portal. 

The DELETE Web API endpoints require the key field in the database so that only a single record will be deleted at a time.

The POST Web API endpoints can include parameters in addition to the model. The new or updated database table record is returned in the response body as a model as well.

The PUT Web API endpoints can include parameters to identify the record to be updated in addition to a model.

Note: There is no equivalent to the Stateless APIs for UpdateSpecific. When using a Web API PUT, all the fields in the model are required as there is no way currently for the MES Web API to distinguish between setting the value of a column to NULL or ignoring the value and keep what is already there. In this documentation, the fields used to identify the record to be updated are listed. Consequently, it is generally recommended to read the values from the database first and then update the desired values and pass back all the other values read from the database.

 

In This Topic
TitleResults for “How to create a CRG?”Also Available in