Anyone using OIS320 MI Web Service? Can it handle more than one per? A List or Array?

Legacy Contributor

Good Evening!

A group of us are working late on a Friday night trying to solve a big Sales problem...trying to get prices for a lot of Items.

The documentation we have for the Web Services is sparse, so we had a few questions for anyone using them.

We were thinking that maybe the OIS320 Web Service(s) could be helpful, but looping through it one Item at a time may not be effective.

Does anyone know how / if the Price Web Service can take a list of Items?  Or how to "feed" the Service a list or array of Items?

Thanks!

Steve

Rene Bottern

I believe you can still use the OIS320MI if that works for you.

Just run it as a 'BULK API', which will allow you to submit ALL your requests as a 'SINGLE request' instead, and then you will get ALL of the Result-sets back together in one big swoop.

Found here: Available APIs / Infor M3 / InforM3MIBulkv2

Formatting is fairly straight forward, just be aware that this is a 'POST' API (not 'GET' like normal M3 API's).

All the API Calls are part of the 'BODY'.

Body would be something like this:

{
"program": "OIS320MI",
"cono": 001,
"divi": "AAA",
"lanc": "string",
"locale": "string",
"timeZone": "EST",
"dateFormat": "YMD8",
"excludeEmptyValues": true,
"rightTrim": true,
"maxReturnedRecords": 0,
"transactions": [
{
"transaction": "GetPriceLine",
"record": {
"CUNO": "0123456",
"ITNO": "ITEM1",
"ORQA": "55"
},
"selectedColumns": [
"SAPR,LNAM,PRRF,KIT1,KQT1,KSP1,KDS1,KIT2,KQT2,KSP2,KDS2"
]
},
{
"transaction": "GetPriceLine",
"record": {
"CUNO": "0123456",
"ITNO": "ITEM2",
"ORQA": "20"
},
"selectedColumns": [
"SAPR,LNAM,PRRF,KIT1,KQT1,KSP1,KDS1,KIT2,KQT2,KSP2,KDS2"
]
}
]
}

Hope this help to get you to a solution.