Export many rows from ION Compass to Excel

I'd like to export more than 100 rows from the ION data lake into an Excel file. I understand that I could instead load the data into Birst and then create whatever kind of excel file I would like, but that is aside the point.

I think this should be possible, simply because when I hover over the text in the data lake I see this:

How do I use the compass APIs to retrieve the full result set of a table in the data lake? Is it also possible to still export this data to excel?

Find more posts tagged with

ION API Gateway

Accepted answers

Raghavender Hariharan

Hi,

An Excel Add-In has been officially published in Microsoft AppStore.It has been published with the name "Infor OS Add-In for Excel". It can be accessed from - Find the right app | Microsoft AppSource . Attaching a few screenshots of the same for your reference.

All comments

Legacy Contributor

If you watch this YouTube video you will get all the information you need to be able to do just what you asking for.

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

Raghavender Hariharan

Hi,

Raghavender Hariharan

The listing is now in Marketplace. https://market.infor.com/en-US/apps/406377/infor-os-add-in-for-microsoft-excel/ . Please go through the UserGuide and the Guided Walkthrough from Marketplace. Thank you.

Legacy Contributor

Hi everyone.
We made a couple of changes to the Add-In, below are the details related to the same.

We introduced Limit and Offset which basically enables the user to download more than 100,000 records from the DataLake.
We are now checking the security roles of the logged in user and depending on these roles the access to various options (To IMS, To Data Lake, From Data Lake) is given to the user.

Additional details regarding this is available on the Instructions Page in the Add-In. Please feel free to reach out to us here, in case you have any questions/suggestions.

Legacy Contributor

Hello Everyone,

After receiving feedback from various customers regarding storage of frequently used queries, we're excited to announce a powerful new feature in the Infor OS EXCEL Add-In: "Add to Favourites." This feature is designed to streamline your workflow and enhance your user experience by allowing you to easily save and access your frequently used queries in the Microsoft EXCEL Add-In for Infor OS.

Key Benefits:

Effortless Access: With the "Add to Favourites" feature, you can now store up to 20 favourite queries
.
Personalized Efficiency: Tailor your workspace to your needs. By adding items to your favourites, you can improve your efficiency by reducing the time spent on writing repetitive queries.

Please feel free to use the new feature.

Additional details regarding this is available on the Instructions Page in the Add-In. Please feel free to reach out to us here, in case you have any questions/suggestions.

Legacy Contributor

Hello Everyone,

As we try to make our product "Infor OS Excel Add-In" even better and user friendly, we are excited to announce that we have added few additional features in the Add-In.

Automatic Query Generation from Object Schema: The user can choose the required schema and the query is automatically generated. This feature is present in the 'View Favorites' option where the user can find the list of all schemas present in the tenant the user is logged into. The user can simply click on the required schema and the query is generated automatically for the user.
In the 'View Favorites' dialog box we have added an option for the user to give desired name to their query so that they can find the required query instantly without going through the entire list of queries.

Please feel free to use the new feature.

Additional details regarding this is available on the Instructions Page in the Add-In. Please feel free to reach out to us here, in case you have any questions/suggestions. Alternatively, you can mail us on infor.labs@infor.com for any kind of assistance.

Copyright © 2025 Infor. All rights reserved.