Answered

How to transfer file from FTP to NetSuite File Cabinet?

Avatar
Chirag2006
Updated
Celigo University Level 3: Master
Engaged

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

Comments

12 comments
Date Votes
  • Avatar
    Bhushan Rane
    Integration Engineer
    • 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
  • Avatar
    Chirag2006
    Celigo University Level 3: Master
    Engaged

    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
  • Avatar
    Bhushan Rane
    Integration Engineer

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

    0
  • Avatar
    Chirag2006
    (Edited )
    Celigo University Level 3: Master
    Engaged

    Bhushan Rane

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

    0
  • Avatar
    Gabriel Jarillo Soto
    Engaged

    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
  • Avatar
    Kate Larson
    (Edited )
    Senior UX Researcher Community moderator

    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
  • Avatar
    Tim Trimble

    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
  • Avatar
    Anitha Abraham
    Community moderator Principal Technical Writer
    Celigo University Level 3: Master

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

    0
  • Avatar
    Diksha Khatri
    Software Engineering Manager
    Celigo University Level 2: Seasoned
    Great Answer

     

    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
  • Avatar
    SWATANTRA ROUT
    (Edited )
    Lead Engineer
    Great Answer

    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
  • Avatar
    Tim Trimble

    Wow! Thanks so much for the rapid response. I installed the bundle and now I'm cooking. Thanks again, very much appreciated. 

    0
  • Avatar
    Hank Morton

    Was there a solution to the original post from Bhushan Rane?  Having the same “The specified internal id is not allowed” error and permission are set to full as well. 

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post