Making a grid call using the Extensibility Framework

Legacy Contributor

Hello, I'm trying to make some grid calls while using the Extensibility Framework and grab some data. I found this following post and have tried to follow it as a template. However I don't get any Data when I return the 'response' object. My understanding is that this will return a response with an array of results based on the specified dataspy. Is this correct? Any help is appreciated.

Notes: 
- I have tried to add the uncommented LOV_ fields to narrow the search, but I'm not 100% clear on how they work. Are they filters?

Here is my sample code:

var getGridData = function () {
 
 try{
  var response = EAM.Ajax.request({
   
   url: 'GRIDDATA',
   params: {
    GRID_NAME: 'WSJOBS',
    REQUEST_TYPE: 'LIST.HEAD_DATA.STORED',
    DATASPY_ID: '107931',
    //LOV_ALIAS_NAME_1: 'workordernum',
    //LOV_ALIAS_VALUE_1: '1004085713',
    //LOV_ALIAS_TYPE_1: ''

   },
   async: false,
   method: 'POST'
  });
  

  return response;
 }
 catch (err) {
  console.log ("ERROR: " + err);
 }
}

Here is the response object I receive, there is no DATA being returned.

{success: true, response: {…}, responseData: {…}}
response: {request: constructor, requestId: 13, status: 200, statusText: "OK", getResponseHeader: ƒ, …}
responseData:
pageData:
fromCome: false
grid:
GRIDRESULT:
DATASPY: {id: "107931", label: ""}
GRID:

DATA: Array(0)        
length: 0
__proto__: Array(0)
FIELDS: {viewtype: "LIST", visibleColumn: true, visiblerowcount: "", FIELD: Array(311)}
METADATA: {REQUEST_TYPE_META: "LIST.HEAD_DATA.STORED", RECORDS: "0", BLACKLISTVIOLATIONS: "0", CLIENTROWS: "50", ISSYSTEMUSER: false, …}
__proto__: Object
TOOLBAR: {FIELD: Array(4), FIELDVALUES: {…}}
type: "LIST.HEAD_DATA.STORED"
__proto__: Object
__proto__: Object
messages: null
__proto__: Object
__proto__: Object
success: true
__proto__: Object

Legacy Contributor

In case anyone comes across this in the future, I was able to figure out the solution. RaviKiran's answer in this post  was a big help in pointing me in the right direction.

Notes:
* For some helpful information of available filters and other "params" look up the "Infor EAM Connector Grid Services Guide" pdf
   Specifically the Structure of a grid web service request section

* I had to specify which DATASPY_ID I wanted to use, if not it was defaulting to a DataSpy that returned to records.

* I got the desired results when specifying either USER_FUNCTION_NAME and SYSTEM_FUNCTION_NAME. But not specifying any would yield no results for me. (I may be wrong, you can do further testing to verify this)

Here is my code:

try{
                        var response = EAM.Ajax.request({
                           
                            url: 'GRIDDATA',
                            params: {
                                GRID_NAME: 'WSJOBS',
                                REQUEST_TYPE: 'LIST.HEAD_DATA.STORED',
                                DATASPY_ID: '107931', // If not specified will default to some other dataspy
                                USER_FUNCTION_NAME: 'WSJOBS',
                                SYSTEM_FUNCTION_NAME: 'WSJOBS',
                                CURRENT_TAB_NAME:'LST', // check if necessary
                                //NUMBER_OF_ROWS_FIRST_RETURNED: '200', // Max seems to be 100
                                //CLIENT_ROWS: '500',
                                // trying some filters. Can be found in "Infor EAM Connector Grid Services Guide"
                                MADDON_FILTER_ALIAS_NAME_1: targetField, //'workordernum',
                                MADDON_FILTER_OPERATOR_1: '=',
                                MADDON_FILTER_JOINER_1: 'AND',
                                MADDON_FILTER_SEQNUM_1: '1',
                                MADDON_FILTER_VALUE_1: targetValue//'1002188920'
                            },
                            async: false,
                            method: 'GET'
                        });
                       
                        // gridResult will hold Data returned as well as metadata from the response.
                        var gridResult = response.responseData.pageData.grid.GRIDRESULT.GRID;
                        

                        var results = gridResult.DATA; // grabs the data returned from the grid call. Is an array
                        var desiredFieldValue = results[0].<fieldname>; // returns the value for the first entry of the specified <fieldname>. 
                       
                    }
                    catch (err) {
                        console.log ("ERROR: " + err);
                    }