Invoke

When you create your Invoke:

Dim RequestInvoiceSP As InvokeRequestData = New InvokeRequestData
Dim ResponseInvoiceSP As InvokeResponseData
RequestInvoiceSP.IDOName = "SLOrderInvoicingCreditMemoReport"
RequestInvoiceSP.MethodName = "Rpt_OrderInvoicingCreditMemoSp"
RequestInvoiceSP.Parameters.Add(pSessionIDChar)
RequestInvoiceSP.Parameters.Add(InvType)
RequestInvoiceSP.Parameters.Add(Mode)
RequestInvoiceSP.Parameters.Add(StartInvNum)
RequestInvoiceSP.Parameters.Add(EndInvNum)
RequestInvoiceSP.Parameters.Add(StartOrderNum)
RequestInvoiceSP.Parameters.Add(EndOrderNum)
RequestInvoiceSP.Parameters.Add(StartInvDate)
RequestInvoiceSP.Parameters.Add(EndInvDate)

etc...

How do you get data from the response into a datatable?

ResponseInvoiceSP = Me.Context.Commands.Invoke(RequestInvoiceSP)

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

You don't use Invoke for that. You have to use LoadCollection and specify the SP in the customLoadMethod parameter and the SP parameters in the clmParameters parameter.

Kirill Kuchumov

Hi Tim,

Do you know if there is a documentation (examples) on how to use LoadCollection or Invoke methods to get data from M3 to Mongoose?

Thanks

Kirill

Yao Jiang

https://www.youtube.com/watch?v=fb5rWmGeEpk

The last few mins demos how to call InvokeIONAPIMethod to query ION API for M3 data.

Couldn't figure out how to attach the IDO Development doc here but here are examples of LoadCollection.

After retrieving the data you can plug it in here to store the data into Mongoose

   // Collection Load
    LoadCollectionRequestData Load = new LoadCollectionRequestData();
    string PropertyValue = string.Empty;
    Load.IDOName = "{IDOName}";
    Load.PropertyList.Add("{Property}");
    Load.Filter = "{FilterValue}";
    Load.OrderBy = "{OrderByValue}";
    Load.RecordCap = 200;
    LoadCollectionResponseData idoResponse = IDOClient.LoadCollection(Load);
    PropertyValue = idoResponse[Row, {PropertyName}].Value;

    // Collection Update
    UpdateCollectionRequestData upd = new UpdateCollectionRequestData("{CollectionName}");
    IDOUpdateItem itm = new IDOUpdateItem(UpdateAction.Update);
    itm.Properties.Add("RowPointer", "{RowPointerValue}", false);
    itm.Properties.Add("RecordDate", "{RecordDate}", false);
    itm.Properties.Add("{Property}", "{PropertyValue}");
    upd.Items.Add(itm);
    IDOClient.UpdateCollection(upd);

    // Collection Insert
    UpdateCollectionRequestData insert = new UpdateCollectionRequestData("{CollectionName}");
    IDOUpdateItem itm = new IDOUpdateItem(UpdateAction.Insert);
    itm.Properties.Add("{Property}", "{PropertyValue}");
    insert.Items.Add(itm);
    IDOClient.UpdateCollection(insert);

Kirill Kuchumov

Thanks for examples.

In the video response = Context.Commands.Invoke(IDORequest);

But I get this error in my script

What am I missing?

Copyright © 2025 Infor. All rights reserved.