Site context for InvokeMethod in Mongoose REST API

I'm working with a Developer on an integration between CSI in MT Cloud and an AP Automation product using the Mongoose REST API and were finding that while some Method calls work will others return no data.

DueDateSp works fine (even though the Site does not appear in the parameters)

VendorGetVoucherNoSp returns null. If I execute in SQL preceding the call with EXEC SetSiteSp 'sitename',null then I get data.

Does anyone have a workaround for this? I had expected the Token to provide the necessary Site context, but it doesn't seem to work that way consistently. Do we need something else in the Header?

Thanks

Find more posts tagged with

API Usage

Accepted answers

Legacy Contributor

Site is not a parameter of DueDateSp in SQL or IDO Methods (where you should be looking at/for the required parameters), so not sure why you would expect that to be in the results? Also would be helpful to see what you are using for code or request parameters to see if you made a mistake somewhere.

VendorGetVoucherNoSp is a very simple call, because all you have to do is send a json list of 3 empty parameters. Below is some sample code using the RestSharp library generated from Postman.

var client = new RestClient($"https://{HOSTNAME}/IDORequestService/ido/invoke/SLAptrxrs?method=VendorGetVoucherNoSp");

client.Timeout = -1;

var request = new RestRequest(Method.POST);

request.AddHeader("Authorization", $"{TOKEN}");

request.AddHeader("X-Infor-MongooseConfig", "{CONFIGURATION}");

request.AddHeader("Content-Type", "application/json");

request.AddParameter("application/json", "[
    "",
    "",
    ""
]",  ParameterType.RequestBody);

IRestResponse response = client.Execute(request);

Console.WriteLine(response.Content);

The above code returned the following json document in response.Content.

{

"Message": null,

"Success": true,

"Parameters": [

"458",

"APRV 458",

"ReturnValue": "0"

}

Rees Howel

Unfortunately, my developer colleague is still getting null results. I've replicated the issue in Postman. Adding the Configuration Name into the Header doesn't seem to make any difference. Screenshot from Postman below including normally hidden headers (in case something there is messing things up)

RESTSharp translation below

var client = new RestClient("">csi10a.erpsl.eu1.inforcloudsuite.com/.../

client.Timeout = -1;

var request = new RestRequest(Method.GET);

request.AddHeader("Authorization", "{TOKEN}");

request.AddHeader("X-Infor-MongooseConfig", "{ConfigName}");

request.AddHeader("Content-Type", "application/json");

IRestResponse response = client.Execute(request);

Console.WriteLine(response.Content);

I did try POST rather than GET as per Tim's example but got 405 Method not allowed

I also notice that VendorGetVoucherNoSp is one of those Sps already replaced by .NET code. Form behaviour in CSI seems OK though, so the problem is still most likely in the API Call.

I'm running out of ideas. Anyone?

All comments

Legacy Contributor

VendorGetVoucherNoSp is a very simple call, because all you have to do is send a json list of 3 empty parameters. Below is some sample code using the RestSharp library generated from Postman.

var client = new RestClient($"https://{HOSTNAME}/IDORequestService/ido/invoke/SLAptrxrs?method=VendorGetVoucherNoSp");

client.Timeout = -1;

var request = new RestRequest(Method.POST);

request.AddHeader("Authorization", $"{TOKEN}");

request.AddHeader("X-Infor-MongooseConfig", "{CONFIGURATION}");

request.AddHeader("Content-Type", "application/json");

request.AddParameter("application/json", "[
    "",
    "",
    ""
]",  ParameterType.RequestBody);

IRestResponse response = client.Execute(request);

Console.WriteLine(response.Content);

The above code returned the following json document in response.Content.

{

"Message": null,

"Success": true,

"Parameters": [

"458",

"APRV 458",

"ReturnValue": "0"

}

Rees Howel

Hi Tim

I wasn't expecting Site to be in the results. What was puzzling me was that in the absence of Site in the parameter list, what told CSI which site to use if the Token itself wasn't sufficient? My guess was that something else was needed in the call Header which I think you've provided.

request.AddHeader("X-Infor-MongooseConfig", "{CONFIGURATION}");

Thank you

Rees

Rees Howel

RESTSharp translation below

var client = new RestClient("">csi10a.erpsl.eu1.inforcloudsuite.com/.../

client.Timeout = -1;

var request = new RestRequest(Method.GET);

request.AddHeader("Authorization", "{TOKEN}");

request.AddHeader("X-Infor-MongooseConfig", "{ConfigName}");

request.AddHeader("Content-Type", "application/json");

IRestResponse response = client.Execute(request);

Console.WriteLine(response.Content);

I did try POST rather than GET as per Tim's example but got 405 Method not allowed

I also notice that VendorGetVoucherNoSp is one of those Sps already replaced by .NET code. Form behaviour in CSI seems OK though, so the problem is still most likely in the API Call.

I'm running out of ideas. Anyone?

Rees Howel

Problem solved. The call used above works.

The problem was that my colleague used a POST call and nulled the NextVoucher field in the lasttran_mst table. Once I posted a voucher manually with a number CSI could accept, the GET call above returned:

{

"Message": null,

"MessageCode": 0,

"Parameters": [

"9215101",

"APRV 9215101",

"ReturnValue": "0"

}

Copyright © 2025 Infor. All rights reserved.