Thank you for your suggestion. We understand it is super important to whitelist specific IP list for ADF as part of firewall rules and avoid opening network access to all. We are working on this with high priority. Once this is ready, we will also add ADF to the list of “Trusted Azure service” for Azure Storage and Azure SQL DB/DW.
I assume that you are asking for a built-in array sort expression?
As a work around you can call an Azure Function that can sort the array as well.
Thanks for the suggestion.
473 votesEagleEyes commented
Having a SFTP PaaS solution would have solved weeks of integration proving and testing on my current project and would have kept the design a lot simpler, so please allow this to be created for PaaS, as stated elsewhere, creating a VM (so IaaS) for a pure PaaS environment breaks the model the customer is moving to.
Thanks for the feedback! We are interested in collecting feedback on this request – please vote for it if this is something you like to see.
We’re also interested in learning more what people want to use the SFTP/FTPS for and which protocol they prefer. Please feel free to leave us a comment letting us know more detail!
Program Manager, Azure Files