Issue


Versions

Versions this documentation is relevant for:

  • 8.7.0+

List

The Issue – List API call reads existing Issues from Eyelit MES-M. The data can be filtered based on the parameters passed in the body/payload of the JSON packet giving the flexibility to search for one or multiple Issues 

Using the Issues – List API call has no impact on the data within the given Eyelit MES-M application, it is read-only

Figure 1 - Logic within Issues/List API Call 

ActiveX control 

Data Prerequisites 

There is no data required in Eyelit MES-M to act as a pre-requisite to make the API call to list Issues. If parameters are passed in through the body that return no valid results, an empty payload will be returned.  

Request 

Table 1 shows the method and endpoint required to make the API call to list Issues 

Table 1 - Outbound Message Detail for Issues - List 

Method 

URL Structure 

Endpoint 

POST 

https://[environment].mestec.net 

/api/Issues/List 

The body of the payload should follow the format below 

JSON Structure for Issues List 

ActiveX control 

See Table 2 for information on which fields are optional, the appropriate data types and the mappings to fields in Eyelit MES-M. 

Table 2 - Parameter Information for Issues - List 

Parameter Name 

Data Mapping 

Data Type 

Mandatory 

Case Sensitive 

Match Type 

ID 

issue.id 

NUMBER 

Yes 

N/A 

Exact 

Note: For any fields where the match type is ‘Like’, a percent symbol should be used as a wildcard character to indicate a number of characters within the given string.  

Sample Request 

See below for sample use cases with examples of the JSON payload format required 

To list Issues where the ID of the issue is 1234: 

JSON Sample for Issues List Request B 

ActiveX control

Response 

When using the Issues – List API call, if any data has been found in Eyelit MES-M that meets the parameter values passed in the original payload, a JSON payload will be returned containing data in the following structure: 

JSON Structure for Issues List 

ActiveX controlSample Response 

See below for sample use cases with examples of the JSON payload format returned. 

No results were found that matched given parameters: 

JSON Sample for Issues List Response A 

ActiveX control

Issue found that matched given parameters: 

JSON Sample for Issues List Response B 

ActiveX controlUpsert

When Issue ID is provided, The Issue – Upsert API call checks if an Issue with the given ID already existsIf it does, appropriate fields are updated in the matching issue in Eyelit MES-M. 

When the Issue ID is omitted, a new Issue will be created. 

Figure 2 - Logic within Issue/Upsert API Call 

ActiveX control 

Data Prerequisites 

The following data entities must exist if they are referenced in an upsert call. 

  • Issue Type 
  • Owner (User Account) 
  • Raised By (User Account) 
  • Issue Status 
  • Issue Reason 
  • Issue Priority 
  • Team 
  • Resolution Type 
  • Item Scope 

Request 

Table 3 shows the method and endpoint required to make the API call to upsert Issue. 

Table 3 - Outbound Message Detail for Issue - Upsert 

Method 

URL Structure 

Endpoint 

PUT 

https://[environment].mestec.net 

/api/Issue/Upsert 

The body of the payload should follow the format below.  

ActiveX controlSee Table 4 for information on which fields are optional, the appropriate data types and the mappings to fields in Eyelit MES-M. 

Table 4 - Parameter Information for Issue - Upsert 

Parameter Name 

Data Mapping 

Data Type 

Mandatory 

Case Sensitive 

Match Type 

ID 

issue.id 

NUMBER 

No

N/A 

Exact 

IssueType 

issuetype.name 

VARCHAR2(50) 

No 

No 

Exact 

Title 

issue.title 

VARCHAR2(100) 

No 

N/A 

N/A 

Description 

issue.description 

VARCHAR2(2000 BYTE) 

No 

N/A 

N/A 

Owner 

useraccount.username 

VARCHAR2(50) 

No 

No 

Exact 

ExternalRef 

issue.externalref 

VARCHAR2(20) 

No 

N/A 

N/A 

IssueStatus 

issuestatus.status 

VARCHAR2(20) 

No 

No 

Exact 

ClosedDT 

issue.closeddt 

TIMESTAMP(6) 

No 

N/A 

N/A 

IssueReason 

issuereason.reason 

VARCHAR2(20) 

No 

No 

Exact 

Qty 

issue.quantity 

NUMBER(5) 

No 

N/A 

N/A 

Team 

team.name 

VARCHAR2(50) 

No 

No 

Exact 

DueDT 

issue.duedt 

TIMESTAMP(6) 

No 

N/A 

N/A 

IssueParentID 

issue.issueparentid 

NUMBER(10) 

No 

No 

Exact 

ResolutionType 

issueresolutiontype.resolutiontype 

VARCHAR2(100) 

No 

No 

Exact 

Rank 

issue.rank 

NUMBER(10) 

No 

N/A 

N/A 

CompletePercent 

issue.completepercent 

NUMBER(3) 

No 

N/A 

N/A 

Priority 

Issuepriority.name 

VARCHAR2(100) 

No 

No 

Exact 

ItemScope 

issueitemscope.name 

VARCHAR2(20) 

No 

No 

Exact 

ResolutionDetail 

issue.resolutiondetails 

VARCHAR2(2000) 

No 

N/A 

N/A 

Note: For any fields where the match type is ‘Like’, a percent symbol should be used as a wildcard character to indicate a number of characters within the given string.  

Sample Request 

See below for sample use cases with examples of the JSON payload format required. 

To create an Issue. 

ActiveX controlTo update title and description by ID. 

ActiveX controlResponse 

When using the Issue – Upsert API call, if an Issue has been Created or Updated a JSON payload will be returned containing data in the following structure: 

ActiveX control 

Sample Response 

See below for sample use cases with examples of the JSON payload format returned. 

ActiveX controlDelete

The Issue – Delete API call attempts to delete an Issue. An Issue can be deleted as long as there are no Issue Items linked to the Issue. 

Figure 3 shows the logic used within the Issue – Delete API call. 

Figure 3 - Logic within Issue/Delete API Call 

ActiveX control 

Data Prerequisites 

In order to delete an Issue, the Issue must exist in Eyelit MES-M. The Issue must have no Issue Items linked. 

Request 

Table 5 shows the method and endpoint required to make the API call to delete an Issue. 

Table 5 - Outbound Message Detail for Issue - Delete 

Method 

URL Structure 

Endpoint 

DELETE 

https://[environment].mestec.net 

/api/Issue/Delete 

The body of the payload should follow the format below.  

ActiveX control 

See Table 7 for information on which fields are optional, the appropriate data types and the mappings to fields in Eyelit MES-M. 

Table 7 - Parameter Information for Issue - Delete 

Parameter Name 

Data Mapping 

Data Type 

Mandatory 

Case Sensitive 

Match Type 

ID 

issue.id 

NUMBER 

No 

N/A 

Exact 

Note: For any fields where the match type is ‘Like’, a percent symbol should be used as a wildcard character to indicate a number of characters within the given string. 

Sample Request 

See below for sample use cases with examples of the JSON payload format required. 

Delete by ID 

ActiveX control 

Response 

When using the Issue – Delete API call, if an Issue has been Deleted a null JSON payload will be returned.