Start

Home / References

Set up your toolsAbout 10 min, once

Get your data out of Infor

Last checked . Checked against Ms implementation config cl sl, En us 1, Etl dl ag, Admin cl sl, En us 2, Cloudsuite industrial, Create customer order in c using rest service idos slcos and slcoitems slcos order totals not updating.

In short. In Infor CloudSuite Industrial (SyteLine), open the form, filter it to the rows you want, and choose Actions > To Excel. That works for anyone who can see the form. If you want the data to arrive by itself, ask IT for read-only access to the same data through Infor's API.

These steps are for Infor CloudSuite Industrial, also sold as SyteLine. It is the Infor ERP that most small and mid-size discrete manufacturers run. The cloud version and recent on-premises versions (10 and later) use the same forms. Infor LN, M3, and CloudSuite Distribution have different screens, so these steps do not apply to them.

Before you start

  • A user login that can open the form you want, such as Customer Order Lines or Current Operations. If you can see the rows on screen, you can export them.
  • Excel, or any program that opens .xlsx files.
  • Your company's AI rules. An export holds customer names, prices, and costs. Check what you are allowed to put in an AI tool before you attach one. Read the safe use notes.
  • For the API route only: someone in IT or your Infor partner who manages Infor OS (ION API).

Steps

Step 1. Open the form and show the grid

Open the form from the menu, or type its name in the form search, for example Customer Order Lines. If you see one record at a time, press Ctrl+2. That switches between the one-record view and the grid view, which shows many rows at once.

Step 2. Filter to the rows you want

Use the form's filter to pick the rows, for example every line with Status Ordered or Planned. Leave the filter loose rather than tight. It is better for the export to hold a few closed lines that a script sets aside than to miss open ones.

Step 3. Export with Actions > To Excel

Choose Actions > To Excel. Infor saves every row in the grid to a spreadsheet file and opens it in Excel. Infor's help does not name the file type, so if it opens as a .csv, use Save As to keep it as an Excel workbook (.xlsx). Save it with the date in the name, such as co-lines-2026-11-16.xlsx, and save every week's file in the same folder.

Three things about this file are normal. The columns may come out in a different order from the screen, because Infor writes them in its own data order. Columns that are hidden on your screen can show up. Some numbers and dates come out as text. A script or a column map handles all three, so do not tidy the file by hand.

Step 4. If To Excel is not on your menu, copy the grid

Click the first row number on the left, hold Shift, and click the last row number. Press Ctrl+C, open a blank Excel sheet, and press Ctrl+V. Infor's help notes that some columns come out empty or in a different format this way, so use To Excel when you have it.

Step 5. For data that arrives by itself, ask IT for read-only API access

You do not set this up yourself. Send IT this request, with your own forms filled in:

I want a read-only feed of the data on the Customer Order Lines form (and Current Operations) for a weekly report. Can you set up an ION API backend service account that can only read those IDOs, and give me either a scheduled file or a URL I can call? I do not need to change anything in Infor.

What IT will set up, so you know the words:

  • ION API is Infor's front door for programs. IT adds an authorized app of type backend service in API Gateway and downloads its key file (a .ionapi file). That key file is a password. It goes to IT's secure storage, not to an email, a chat, or an AI tool.
  • IDOs are the data objects behind each form. Customer order lines are usually the SLCoitems IDO. IT can confirm the exact names in your system.
  • The URL reads one IDO, for example .../IDORequestService/ido/load/SLCoitems?properties=CoNum,CoLine,CoRelease,Item,QtyOrdered,QtyShipped,DueDate. The properties part lists only the columns you need. A filter part, such as a test on the line status, picks the rows. Infor's page shows the same pattern with a different IDO. recordcap=0 returns every row instead of the first 200. Your IT person checks the exact property names and status codes for your system.
  • Read-only means the service account's role can load data but cannot save it. Ask for that in writing. A report never needs to change an order.

Step 6. Know the bigger options

If your company runs Infor OS with the Data Lake, IT can copy chosen tables there and you or an analyst can query them with Compass, Infor's query tool for the Data Lake. Birst is Infor's dashboard tool, and some CloudSuite Industrial sites already have it. Both cost setup time and often license money. A weekly export plus a checked script is usually the place to start.

Check it worked

Open the Excel file. Find one order you know, and check that its quantity, status, and due date match the screen. Count the rows: the file should hold as many rows as the grid showed. If you used the API, ask IT for one test call and compare a row with the screen the same way.

If something goes wrong

  • The file has only some of the rows. The grid may not have loaded every matching row yet. Tighten the filter so fewer rows match, for example one warehouse or one month of due dates, and export each part.
  • Columns are in a strange order, or there are extra ones. That is how To Excel works. Leave them. A column map that finds columns by name handles it.
  • Order numbers have spaces in front. Infor pads order numbers to a fixed width. Leave them, because a script takes the spaces off.
  • The API returns only 200 rows. That is the default cap. IT adds recordcap=0 or pages through with loadtype and bookmark.
  • IT says the API is not licensed or not set up. Use the weekly export. It does the same job, and you can switch later without changing your script's rules.

Used in

Get your first win this week.

One minute. Three guides picked for your job.

Start my first win