Reading file contents from Netsuite File Cabinet
We have a few integrations now that move Files using IDs to other destinations (FTP, HTTP, etc...).
At this point, I need to build an integration that actually picks a file up out of the file cabinet and consumes the data... I haven't found a way to do it natively yet. I should be able to pick up the file, move it (i.e. - to an FTP server), and then have a second source based on that location, but I wanted to see if I was just missing something. Is there a native option (or scripting option) that would allow me to either consume the file contents from the file cabinet, or pick up the contents from Celigo's cache based on id?
2
Comments
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.
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.
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!
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
Hello Bas van Ditzhuijzen can you share some details of that Hook how it was done?
Please sign in to leave a comment.