IDO Extension Class over Rest API

I have an IDO that loads a custom method based on an extension class. It extends the SLReportDataViews IDO and it works fine as a dataview. I now need to call that IDO over the REST API so it can be used in Qlik and Excel. When I try it in Excel it returns an error message "Invalid object name 'dbo.ReportDataView'.::2". Any help would be appreciated.

XA Virtual Summit - Foundation for the future.mp4

Find more posts tagged with

Syteline Development

Accepted answers

All comments

Stephen Cena

Can you show how you are using the REST API calls (VB.NET source code I'd imagine)

John Hart

I've been making the calls through the Power Query editor in Excel.

let
Token = Json.Document(Web.Contents("">csi10b-erpsl.inforgov.com/.../********")),

Source = Json.Document(Web.Contents("csi10b-erpsl.inforgov.com/.../ue_ARAgingRev3, ue_CreateDate, ue_curr_code, ue_cust_name, ue_cust_po, ue_DerInvAmount, ue_DerOpenBalance, ue_DerPaymentAmount, ue_due_date, ue_inv_date, ue_inv_num, ue_part, ue_part_qty, ue_terms_code, ue_type", [Headers=[Authorization=Token[Token]]])),

Items=Source[Items]
in

Items

John Hart

And this is the source code for the extension class.

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Mongoose.IDO;
using Mongoose.IDO.Protocol;
using Mongoose.Core.Common;
using Mongoose.Core.Extensions;

namespace ue_ARAgingRev2
{

//Debug example - writes to Application debug Log Listing
//string messageName = "";
//string messageDetail = "";
//string sourceType = "O";
//string longSource = "ue_ARAging";
//UpdateCollectionResponseData logResponse = new UpdateCollectionResponseData();
//logResponse = MaintainApplicationDebugLog(sourceType, longSource, messageName, messageDetail);

public class ue_ARAging : IDOExtensionClass
{
public DataTable GetARAging()
{
DataTable resultsView = new DataTable();
DataTable invoiceView = new DataTable();
DataTable creditView = new DataTable();

//Properties being returned for the final report
resultsView.Columns.Add("cust_num");
resultsView.Columns.Add("cust_name");
resultsView.Columns.Add("type");
resultsView.Columns.Add("inv_num");
resultsView.Columns.Add("co_num");
resultsView.Columns.Add("terms_code");
resultsView.Columns.Add("inv_date");
resultsView.Columns.Add("due_date");
resultsView.Columns.Add("CreateDate");
resultsView.Columns.Add("curr_code");
resultsView.Columns.Add("DerInvAmount");
resultsView.Columns.Add("DerPaymentAmount");
resultsView.Columns.Add("DerOpenBalance");
resultsView.Columns.Add("cust_po");
resultsView.Columns.Add("part");
resultsView.Columns.Add("part_qty");

String sPropertyList = "cust_num,cust_name,type, inv_num, co_num, terms_code,inv_date, due_date, CreateDate, curr_code, DerInvAmount, DerPaymentAmount, DerOpenBalance,cust_po";
String sInvFilter = "type='I' AND DerOpenBalance<>0";
String sCreditFilter = "type = 'C' AND apply_to_inv_num = ''";

invoiceView = GetIDOCollection("ue_ARAging", sPropertyList, sInvFilter, "", 0);

for (int x=0; x < invoiceView.Rows.Count -1; x++)
{
DataRow drInvRow = invoiceView.Rows[x];
DataRow drInvResults = resultsView.NewRow();

drInvResults["cust_num"] = drInvRow["cust_num"].ToString();
drInvResults["cust_name"] = drInvRow["cust_name"].ToString();
drInvResults["type"] = drInvRow["type"].ToString();
drInvResults["inv_num"] = drInvRow["inv_num"].ToString();
drInvResults["co_num"] = drInvRow["co_num"].ToString();
drInvResults["terms_code"] = drInvRow["terms_code"].ToString();
drInvResults["inv_date"] = drInvRow["inv_date"].ToString();
drInvResults["due_date"] = drInvRow["due_date"].ToString();
drInvResults["CreateDate"] = drInvRow["CreateDate"].ToString();
drInvResults["curr_code"] = drInvRow["curr_code"].ToString();
drInvResults["DerInvAmount"] = drInvRow["DerInvAmount"].ToString();
drInvResults["DerPaymentAmount"] = drInvRow["DerPaymentAmount"].ToString();
drInvResults["DerOpenBalance"] = drInvRow["DerOpenBalance"].ToString();
drInvResults["cust_po"] = drInvRow["cust_po"].ToString();
drInvResults["part"] = "";
drInvResults["part_qty"] = 0;

resultsView.Rows.Add(drInvResults);
}

return resultsView;
}

private DataTable GetIDOCollection(string idoName, string propertyList, string sFilter, string orderBy, int recordCap)
{
DataTable idoCollection = new DataTable(idoName);
LoadCollectionRequestData request = new LoadCollectionRequestData();
LoadCollectionResponseData response = new LoadCollectionResponseData();

request.IDOName = idoName;
request.PropertyList = new PropertyList(propertyList);
request.Filter = sFilter;
request.OrderBy = orderBy;
request.RecordCap = recordCap;
response = this.Context.Commands.LoadCollection(request);

foreach (string listItem in request.PropertyList.List)
{
idoCollection.Columns.Add(listItem);
}

response.Fill(idoCollection);
return idoCollection;
}

public UpdateCollectionResponseData MaintainApplicationDebugLog(string sourceType, string longSource, string messageName, string messageDetail)
{
IDOUpdateItem debugItem = new IDOUpdateItem(UpdateAction.Insert);
debugItem.Properties.Add(new IDOUpdateProperty("SourceType", sourceType, true));
debugItem.Properties.Add(new IDOUpdateProperty("SourceName", longSource.Length > 128 ? longSource.Substring(0, 128) : longSource, true));
debugItem.Properties.Add(new IDOUpdateProperty("MessageName", messageName.Length > 60 ? messageName.Substring(0, 60) : messageName, true));
debugItem.Properties.Add(new IDOUpdateProperty("MessageDetail", messageDetail, true));
IDOUpdateItems updateItems = new IDOUpdateItems() { debugItem };
UpdateCollectionRequestData request = new UpdateCollectionRequestData()
{
IDOName = "SLApplicationDebugLogs",
Items = updateItems,
RefreshAfterUpdate = true
};
return this.Context.Commands.UpdateCollection(request);
}
}
}

Stephen Cena

I think it might be related to you extending (and/or replacing) SLReportDataViews. What was the need to introduce that extension?

unknown

Infor Documentation Library

In your http request, you're missing the clm parameter to specify your custom load method.

As an aside, why are you creating IDOs like ue_ARAgingRev2, ue_ARAgingRev3, are you not using a source control system like Git?

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.