Reading file contents from Netsuite File Cabinet



  • Orion Abrams Technical Implementation Consultant

    Hi Wade,

    You aren't missing something. It's currently unsupported to parse the file data from the NetSuite file cabinet, but as you said, you could have one flow putting the files on an FTP, and another flow exporting the files from the FTP and importing them into another system. The files would have to be one of the supported FTP export file types such as XML, CSV, etc. 

  • Wade Shelton

    OK.  Thanks, Orion.

    Just a suggestion... since the files are stored in the Celigo file cache once picked up, it would be really nice to have that as a Source or Lookup option.  i.e. - be able to pass in the id and actually read the file contents.

  • Kate Larson Senior UX Researcher Community moderator

    Hi Wade Shelton
    I'm moving this thread to our Enhancement Requests topic that our product managers monitor so you and others can vote on it. Thanks!

  • Bas van Ditzhuijzen Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz
    Partner Implementation Certification
    Great Answer
    Answer Pro
    Celigo University Level 4: Legendary

    I've previously done this with a suitescript hook. Made an export for a saved search that picks up the file metadata, and used a SS2.0 hook to load the file contents and pass them on to Celigo. Mind that it will probably not work for very large files and if you need data to be split in lines/pages you would need to do that in a separate presave hook

  • Akber Ali Strategic Partner

    Hello Bas van Ditzhuijzen can you share some details of that Hook how it was done?


Please sign in to leave a comment.