Fill Grid from FormScript

Hi,

I need to fill Grid component with data, and I need to do that from FormScript. In my case, user hit button, event is triggered, and then in FormScript I prepare data which I get via ION API, and I need to fill it to the grid

But I can't find any working example of this.

I suppose that I need to prepare

List<string> data

and then add it to the grid component maybe by this Method?

ThisForm.Components["grid1"].ListSourceScriptAddEntries(data);

And I read in documentation that, filling Grid must be done from GlobalScript.

But I only receiving this error message

Find more posts tagged with

Accepted answers

Yao Jiang

IWSFormComponent oGrid = ThisForm.Components["gridComponentName"]

oGrid.GetGridRowCount()

oGrid.GetGridValue(rowNum, columnNum)

oGrid.SetGridValue(rowNum, columnNum, valueToSet)

oGrid.DeleteGridRows(currentRow, numRowsToDelete)

Here are some methods that you can use You can find more info at docs.infor.com/mg/2023.x/en-us/mongooseolh/default.html and search for these methods.

tdickens

This is what I've done.

//*********************************************************
//* This method controls loading the data to the grid
//*********************************************************
public void Refresh()
{
ThisForm.PrimaryIDOCollection.ClearEntries();

if (ThisForm.Variables("vSelectedBP").Value == String.Empty)
{
return;
}

SetSelectedDate();

var summaryList = GetSummaryData();

LoadCollection(summaryList);
}

//*******************************************************************************************************************************
//* This method executes a service to get the Power Bill Summary data.
//*******************************************************************************************************************************
public List<PowerBillSummary> GetSummaryData()
{
var summaryList = new List<PowerBillSummary>();

var beg = ThisForm.Variables("vSelectedBeg").Value;
var end = ThisForm.Variables("vSelectedEnd").Value;
var companySelection = ThisForm.Variables("vSelectedCompany").Value;
string[] companySplit = companySelection.Split('-');
var company = companySplit[0];
string swapOnly = ThisForm.Variables("vProduct").Value;

var method = "/MI/api/PowerBillSummary?fromDate=" + beg + "&thruDate=" + end + "&company=" + company + "&swapOnly=" + swapOnly;

InvokeRequestData request = new InvokeRequestData();
InvokeResponseData response;

request.IDOName = "IONAPIMethods";
request.MethodName = "InvokeIONAPIMethod";

InvokeParameterList parameters = new InvokeParameterList
{
"1",
"0",
"CustomerAPI/MongooseInterfaces",
"GET",
method,
{ string.Empty, true },
"application/json",
"10000",
{ string.Empty, true },
{ string.Empty, true },
{ string.Empty, true },
{ string.Empty, true }
};

request.Parameters = parameters;

response = IDOClient.Invoke(request);

ThisForm.Variables("AECI_HttpResponseCode").Value = response.Parameters[8].Value;
ThisForm.Variables("AECI_Response").Value = response.Parameters[9].Value;
ThisForm.Variables("AECI_ResponseHeaders").Value = response.Parameters[10].Value;
ThisForm.Variables("AECI_InfoBar").Value = response.Parameters[11].Value;

//If HttpResponseCode is not 200 then there is an API error
if (ThisForm.Variables("AECI_HttpResponseCode").Value != "200")
{
ThisForm.Variables("vReturnCode").Value = ThisForm.Variables("AECI_HttpResponseCode").Value;
ThisForm.Variables("vProjectName").Value = ThisForm.Variables("AECI_Response").Value;
return summaryList;
}

var result = JsonConvert.DeserializeObject<List<PowerBillSummary>>(ThisForm.Variables("AECI_Response").Value);

return result;

}

//*******************************************************************************************************************************
//* This method loads the data to the IDO Collection so that the data can be displayed on the grid.
//*******************************************************************************************************************************
public void LoadCollection(List<PowerBillSummary> summaryList)
{
int i = 0;
foreach (var row in summaryList)
{
ThisForm.PrimaryIDOCollection.New();
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("CompanyName", row.companyName);
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("CompanyAcronym", row.companyAcronym);
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("PurchaseAmount", row.purchaseAmt.ToString());
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("Derived_PurchaseAmount", row.purchaseAmt.ToString("c2"));
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("Derived_SaleAmount", row.saleAmt.ToString("c2"));
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh("SaleAmount", row.saleAmt.ToString());

ThisForm.CurrentIDOCollection.SetObjectNew(i, false);
ThisForm.CurrentIDOCollection.SetObjectModified(i, false);
i++;
}

//This sets the focus to the 1st line
ThisForm.PrimaryIDOCollection.SetCurrentObject(0);
}

public class PowerBillSummary
{
public string companyName { get; set; }
public string companyAcronym { get; set; }
public decimal purchaseAmt { get; set; }
public decimal saleAmt { get; set; }
}

All comments

Yao Jiang

IWSFormComponent oGrid = ThisForm.Components["gridComponentName"]

oGrid.GetGridRowCount()

oGrid.GetGridValue(rowNum, columnNum)

oGrid.SetGridValue(rowNum, columnNum, valueToSet)

oGrid.DeleteGridRows(currentRow, numRowsToDelete)

Here are some methods that you can use You can find more info at docs.infor.com/mg/2023.x/en-us/mongooseolh/default.html and search for these methods.

tdickens

This is what I've done.

request.IDOName = "IONAPIMethods";
request.MethodName = "InvokeIONAPIMethod";

}

public class PowerBillSummary
{
public string companyName { get; set; }
public string companyAcronym { get; set; }
public decimal purchaseAmt { get; set; }
public decimal saleAmt { get; set; }
}

tdickens

I forgot, here's how to reference Newtonsoft.Json. In case you haven't done that yet.

using System;

using Mongoose.IDO.Protocol;

using Mongoose.Scripting;

using System.Collections.Generic;

using System.Linq;

//<ref>Newtonsoft.Json.dll</ref>

using Newtonsoft.Json;

Inquiry Tab Placement.docx

Copyright © 2025 Infor. All rights reserved.