Is there way to fetch all the data from M3 API?

Hi,

Is there way to fetch all the data from M3 API. For example, I want to get all customers form M3 to develop a custom search in Mongoose.
I used below C# code and tried replacing record cap 0 and -1. But both time it only retrieves 100 records.
If I use a number other than 0 or -1 it retrieves that number of records. But maximum number I can use is 9999. In my case we have more than 15,000 customers.

LoadCollectionResponseData FullCollection;
FullCollection = this.IDOClient.LoadCollection("FTD_LstCustomers", "CUNO", "", "", -1);

Thanks
Regards,
Nishantha.

Find more posts tagged with

Accepted answers

All comments

antonio-caria

You should not get all Costumer's by API.....

Legacy Contributor

Retrieving all customers by API can work, however, you may have a server side cap of records that can be queried either by M3 or Mongoose. Check the process defaults in Mongoose to see if the cap has been set there.

per-ravnborg

I think the right approach is to set up Enterprise Search for OCUSMA (Customer master table) and then use the standard M3 API: CRS610MI.SearchCustomer which takes the input SQRY in lucene syntax(120 bytes). You can test the search right away in CRS610 if IES is set up: ex. TOWN:BENTONVILLE AND PYNO:1002

In your case you UI can offer some search fields and you can consolidate then in the CRS610MI.SearchCustomer SQRY request, and then use the response in your UI result listing.

The beyond search done with MITEST looks like this:

Input:

Output:

Notice! the output only has a subset of fields from OCUSMA.

Copyright © 2025 Infor. All rights reserved.