I want to export record(Contact) with image(attachment ) into ftp folder. The export format for record are excel, xml and txt. Image in the form of jpeg. Each record should have separate file. For example, if i have 2 contacts and their images. I should create folder with below structure.
The request should trigger from salesforce on button click as filter condition are different each time and its a user input. We tried with data loader. problem with that is i cant export attachment with filter condition which is on contact. Report exports image as url link.
So I have couple options in mind. integration tools like boomi , SSIS. Or build custom