In our previous post, we saw how we can execute MI transaction in H5 using the MIUtiltool utility tool we created. In this post we will be expanding on this tool to include a helper in retrieving output fields on the executed transaction.
Let’s look back on the transaction we’ve executed
let miTrans = new MIUtilTool.Transact("CRS530MI");
miTrans.set("FCOM", userContext.CONO);
miTrans.set("TCOM", userContext.CONO);
miTrans.set("FDIV");
miTrans.set("TDIV");
miTrans.set("FEMN", "CSANTOS");
miTrans.set("TEMN", "Y500");
miTrans.execute("LstEmployee", this.onSuccess, this.onFail);
Running the code above will give us an Object. The records we need are stored on an array named MIRecord. MIRecord’s value are made up of object, that has property named NameValue. This NameValue is another array for each output fields. In short the structure of the output is Object>Array>Object>Array. 
We need to traverse this should we want to retrieve a specific value. But i don’t want to do that every single time i perform an MI transaction. Ideally, i would like to be able to query the fields with this syntax: result.getField("EMNO");
And it will return me an array of “EMNO” or a string if the output only consist of one record. As such, I created a helper class named Output that does the work for me. We will be placing this class inside our MIUtilTool. It will only be consist of one method:setField() that will accept the ‘output field’ as the parameter. We would need to pass the ‘result Object’ when creating an instance of this class. A sample usage will look like this:
let out = new MIUtilTool.Output(result);
console.log(out.getField("EMNO"));
This will result to:
And here is our updated MIUtilTool:
namespace MIUtilTool {
export class Transact {
private url: string;
private paramsUrl: string;
private params: any = {};
constructor(program: string) {
this.url = '/execute/' + program + '/';
this.paramsUrl = '';
}
public set(field: string, value?: userContext | string): Transact {
this.params[field] = value;
return this;
}
public execute(transaction: string, onSuccess, onFail, constraints ?: IApiConstraints, excludeEmpty: boolean = false): void {
this.url += transaction + ';metadata=true' +
';cono=' + userContext.CurrentCompany +
';divi=' + userContext.CurrentDivision +
';excludempty=' + excludeEmpty;
if (constraints) {
if (constraints.maxRecords) {
this.url += ';maxrecs=' + constraints.maxRecords;
} else {
this.url += ';maxrecs=999999';
}
if (constraints.outputFields) {
this.url += ';returncols=' + constraints.outputFields.toString();
}
}
this.url += '?';
$.each(this.params, (key, value) => {
this.url += (key + '=' + value + '&');
});
this.url = this.url.slice(0, -1);
ScriptUtil.ApiRequest(this.url, onSuccess, onFail);
}
}
interface IApiConstraints {
maxRecords?: number;
outputFields?: Array<string>;
}
export class Output {
private result;
private recLength: number;
private fieldLength: number;
public getField(field: string, single: boolean = true) : any {
if (this.recLength === 1 && single) {
let fieldValue: string;
this.result.MIRecord[0].NameValue.some(function(val, ind) {
if (val.Name === field) {
fieldValue = val.Value.trim();
}
return val.Name === field;
});
return fieldValue;
}
let fieldArray: string[] = [];
for (let i = 0; i < this.recLength; i++) {
this.result.MIRecord[i].NameValue.some(function(val, ind) {
if (val.Name === field) {
fieldArray.push(val.Value.trim());
}
return val.Name === field;
});
}
return fieldArray;
}
public createArrayObjects(): any {
let fieldArray: any[] = [];
for (let i = 0; i < this.recLength; i++) { let test = {}; this.result.MIRecord[i].NameValue.forEach(element => {
test[element.Name] = element.Value.trim();
});
fieldArray.push(test);
}
return fieldArray;
}
constructor(result) {
this.result = result;
this.recLength = 0;
this.fieldLength = 0;
if (result.MIRecord) {
this.recLength = result.MIRecord.length;
this.fieldLength = result.MIRecord[0].NameValue.length;
}
}
}
MIUtilTool.Init = function(){};
}
Update 20170413: I have updated the script above to handle MI Outputs of large records. By default the MI REST service will only return a maximum of 500 records if the number of desired records is not indicated on the request.
You can download the complete typescript file here or the converted javascript here.
