How to transfer file from FTP to NetSuite File Cabinet?

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,

  • 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

Thanks @bhushanrane 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?

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

@bhushanrane

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

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!

Hi @gabrieljarillosoto -
The recommendation from our Support team is to use the following quickstart template available in the Celigo Marketplace:
NetSuite - FTP template

Thanks,
Kate

@katelarson

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!

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

Hi @timtrimble

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:

Hello,

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

Thanks!

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

Was there a solution to the original post from @bhushanrane-Bhushan-Rane" rel="nofollow noreferrer">Bhushan Rane? Having the same “The specified internal id is not allowed” error and permission are set to full as well.