Possible to sort across all pages of export?




  • Official comment
    Bhavik Shah Senior Product Manager
    Answer Pro
    Great Answer

    Shrehith Martin Jahn  - Thanks for posting to the community. We have grouping capability available on FTP connector. In our upcoming release, this feature will be extended to Universal HTTP and Database connectors. 


  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Steve Klett,

    Great to hear from you! Unfortunately, there's currently no way to handle this scenario, although we do have some concepts in the planning stage. Let me check with our PM on these, Vili, and get back to you. Thanks so much for letting us know about this need!

  • viliandy leonardo Product Management Director

    Steve Klett

    There is no alternative or a creative way in IO to sort file records that span multiple pages.

    We have a feature backlog to sort file content to address your use case. I am gathering customer's feedback on how they plan or want to use this sort. Would you please explain what your flow scenario is and provide some examples of the file layout along with sorting rule.



  • Abhinav Kaushal


    I have similar ask where I need to sort and then use group by on CSV so I can eliminate the duplicates from CSV. I was thinking of having a parent work flow which dumps the CSV and then next work flow will consume it and do group by. Looks like it won't work as for group by we need to sort the content.

    Is there any global variable which has scope within integration and can ne written and called in various flows so it will eliminate the CSV dump and can be sorted out using JS?


    Abhinav Kaushal

  • Kate Larson Senior UX Researcher Community moderator

    Thanks for posting to the community, Abhinav Kaushal. I’m checking with our experts and will get to back to you with their recommendation.

  • Kate Larson Senior UX Researcher Community moderator

    Abhinav Kaushal - I heard back from our engineers. We don't have any global variable that has scope beyond the current execution. All variables are passed in as arguments for the hooks or other function being called.

  • Shrehith Strategic Partner


    I am having the same issue. Do we have any solution developed to handle this scenario now?

  • Martin Jahn Channel Partner
    Celigo University Level 1: Skilled

    Anyone have an update on this request?

    We have source system that provides rows of data that need to be grouped before being sent to the destination system.  We have a Pre Save Page script but unfortunately when Integrator IO splits the data set into Pages, it sometimes splits groups of records that should have been grouped together.

    Current workaround is to import the raw data rows into a NetSuite custom record, then use a saved search and record grouping functionality from the Integrator IO Export from NetSuite functionality.  This adds overhead as we need to write the custom records, then do an update to the custom record to either mark the rows as processed and/or delete the custom record entries.

  • Bhavik Shah Senior Product Manager
    Answer Pro
    Great Answer

    UPDATE : We recently released the support for Grouping. You can now group your source records for HTTP and Database connectors. Please follow this article to learn more about this : 




Please sign in to leave a comment.