Tranfer PDF files within FTP server

Comments

8 comments

  • Official comment
    Rohit Prasad Senior Product Manager
    Celigo University Level 4: Legendary

    Dear @Jacky Mao,

    Thank you for reaching out. Currently, we do not offer support for accessing blobKey raw data and converting it to base64 string. However, we have included this feature in our roadmap and intend to prioritize it in future releases.

    We have some workarounds available, which involve using an Amazon S3 trigger to invoke a Lambda function. If you are interested, we would be more than happy to provide you with further details.

    Also, please use the portal card provided here to vote for this feature.

    Best regards,

    Rohit

  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Tharaka Athukorala,

    I've moved this to our main troubleshooting area for custom flows. Our export article states that the supported file types for FTP export, which doesn't include PDF. I've submitted your enhancement request to our PM team for evaluation. You can also submit enhancement requests in the Product portal when you're logged in to integrator.io, or you can add an enhancement here. Thanks so much for letting us know of this need!

    0
  • viliandy leonardo Product Management Director
    Answer Pro
    Top Contributor

    Hi Tharaka Athukorala We can certainly grab and move files within FTP server, but we only support some file types if you need to read and parse the file content. I also notice that our support team has received your question via a case and they'll be in touch to assist you.

    Thank you

    0
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    I was about to say the same thing as Viliandy.  If you do an export and chose not to parse the file you can transfer the BLOB to another FTP server.  Should be pretty simple. 

    0
  • Tharaka Athukorala
    Engaged
    Celigo University Level 4: Legendary

    Thank you for the above comments and information.

    The real scenario is we need to read PDF files from an FTP location and need to upload them to another third-party system.

    This is how we handle that scenario from Celigo.

    1) We fetch the PDF file from an FTP server using an FTP connector
    2) Then we have an import where we should push this PDF file as a base64 encoded string to a 3rd party app through their APIs. For this, we use an HTTP connector
    3) We cannot figure out how to retrieve the base64 string of the imported PDF, we only get the blobKey as the input data into this import.

     

    This is the request body that we need to pass data to the third-party system. We need to convert the read PDF file into base64 and post a request as given below. 

    https://api.orangehrm.com/#api-Employee-addEmployeeAttachment 

    0
  • Jacky Mao

    Hi All,

    Just checking if anyone found the solution for it.

    As I'm facing the same things, I'm able to transfer the files from SF to FTP server using blobKey function.

    But how do I access the blobKey raw data and convert to base64 and add it into the payload into API for uploading the files into our custom system?

     

    Cheers
    Jacky

    0
  • Jacky Mao

    Hi Rohit Prasad,

    Can you show me how to use the Amazon S3 trigger to invoke a Lambda function?  Will that count additional license in our flow?

    Cheers
    Jacky

    0
  • Rohit Prasad Senior Product Manager
    Celigo University Level 4: Legendary

    Hi Jacky Mao,

    Yes, that will count as an additional endpoint license. 

    In a nutshell, every time when a file is uploaded to the S3 bucket, a lambda function is invoked which converts the file with the same name, adds a ".json" extension and puts it back in the same bucket.

    However, there is one caveat, this conversion process in S3 is a little slow and IO is faster and you might need to split the flow into two flows to keep up with the IO.

    Best Regards,

    Rohit

     

     

    0

Please sign in to leave a comment.