Tranfer PDF files within FTP server
HI,
How to read PDF files from an FTP location and upload them to another FTP location?
In other words, how can we transfer PDF files to an FTP server?
-
Official comment
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
-
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 -
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 -
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 -
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 -
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
Jacky0 -
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
Jacky0 -
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.
Comments
8 comments