How to transfer file from FTP to NetSuite File Cabinet?Answered
I have having a use case where I have to send the FTP files to NetSuite File Cabinet, but I am not able to write any files to the file cabinet.
Can anybody tell me how to send the file from FTP to NetSuite file cabinet?
- Export FTP. Use "Parse files being Transferred" as "No"
- Export gives you a blobKey for the exported file. This data looks something like this
- Create the NS Import with below configuration, specifying the path to the "blobKey" from step 1.
- Run the flow, and verify file is transferred to the NS folder mentioned on the import step
Thanks Bhushan Rane for replying.
I tried the above approach and error popped up saying "The specified internal id is not allowed" . Below is the screenshot.
Not sure what is reason here, I tried giving different folder Ids still seeing the same error. Can you please tell me what could be the issue here?0
Does the user/role on your connection have access write permissions on those folders?0
Below are my permissions, I can add/write the file from UI using the role.0
I am in the process to attempt to do the same thing of transferring an file (any format) from FTP folder into NetSuite. I notice that Chirag was having issues.
There are any easy steps to accomplish this?
Hi Gabriel Jarillo Soto -
The recommendation from our Support team is to use the following quickstart template available in the Celigo Marketplace:
NetSuite - FTP template
I have downloaded the template and am trying to pull files from a folder in Netsuite onto an FTP folder. The temple is using a saved search to pull a folder with files in it. Is there anyway to have an example of a saved search that is accomplishing this? I've tried a couple but haven't been able recreate one that works with this sample. Thanks!0
Thanks for posting to the community. I'm checking with our experts.
Hi Tim Trimble
NetSuite saved search should be created on a Folder and it should return File : Internal Id and File : Name of the files to be exported from the target folder.
Please refer to screenshots below.
Kindly notice the custom label file_id and file_name, use the same label on your saved search as they are used in subsequent steps. The file_id is used to extract the file and the file_name is used while importing the files in FTP, you will find them under File Fields ... join option in saved search.
NetSuite Folder Search filter example:0
Alternatively, The Doc here, can help to have the Saved search installed. Feel free to use the bundle for the quick setup :).
Wow! Thanks so much for the rapid response. I installed the bundle and now I'm cooking. Thanks again, very much appreciated.0
Please sign in to leave a comment.