How to transfer file from FTP to NetSuite File Cabinet?

Answered

Chirag2006

• December 14, 2021 11:01
• Edited

Hi experts,

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?

Thanks,

0

• 

  Bhushan Rane Integration Engineer

  • December 14, 2021 15:13

  • Export FTP. Use "Parse files being Transferred" as "No"
  • Export gives you a blobKey for the exported file. This data looks something like this
  • {
    "success": true,
    "fileMeta": {
    "fileName": "combined.pdf",
    "lastModifiedTime": 1636586398000
    },
    "blobKey": "717a84e9ac4249268b8b352018d1af72"
    }
  • 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

  0
• 

  Chirag2006

  • December 14, 2021 19:34

  

  

  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
• 

  Bhushan Rane Integration Engineer

  • December 14, 2021 19:45

  Does the user/role on your connection have access write permissions on those folders?

  0
• 

  Chirag2006

  • December 14, 2021 20:37
  • Edited

  

  

  Bhushan Rane

  Below are my permissions, I can add/write the file from UI using the role.

  

  0
• 

  Gabriel Jarillo Soto

  • March 28, 2022 16:38

  

  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?

  Thank you!

  0
• 

  Kate Larson Senior UX Researcher Community moderator

  • March 28, 2022 18:12
  • Edited

  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

  Thanks,
  Kate

   

  0
• 

  Tim Trimble

  • May 02, 2022 22:34

  Kate Larson

  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
• 

  Anitha Abraham Community moderator Principal Technical Writer

  • May 03, 2022 06:06

  

  Tim,
  Thanks for posting to the community. I'm checking with our experts.
  Anitha 

  0
• 

  Diksha Khatri Software Engineering Manager

  • May 03, 2022 15:43

  

  

   

  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
• 

  SWATANTRA ROUT Lead Engineer

  • May 03, 2022 15:55
  • Edited

  

  Hello,

  Alternatively, The Doc here, can help to have the Saved search installed. Feel free to use the bundle for the quick setup :).

  Thanks!

  0
• 

  Tim Trimble

  • May 03, 2022 20:40

  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.