https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74032#M26637 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/1981">@john.hammond</a>,<BR /><BR />FWIW - There is a method in the .NET Framework that will return the MIME mapping for a specified file. You can find more about it <A href="https://docs.microsoft.com/en-us/dotnet/api/system.web.mimemapping.getmimemapping?view=netframework-4.7.2" target="_blank" rel="noopener">here</A>.<BR /><BR />Cheers,<BR />​<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Fri, 26 Aug 2022 15:10:00 GMT ewilson 2022-08-26T15:10:00Z https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74030#M26635 Afternoon all. I'm experimenting with using the 'Send Mail' functionality from the Outlook Graph API connector, but the required collection for Attachments requires 3 columns - the name of the file, the MIME type of the file (e.g. application/pdf) and the content of the file in binary. Previously, using the Outlook VBO, you simply needed a filepath to the file to be attached. Are there any objects that could reliably and consistently provide the MIME type for a given file and convert it into binary data for use with this action?<BR /><BR />------------------------------<BR />John Hammond<BR />------------------------------<BR /> Fri, 26 Aug 2022 13:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74030#M26635 john.hammond 2022-08-26T13:19:00Z https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74031#M26636 Apologies - spent a bit more time playing with this and 'kinda' figured it out, in case anyone else finds themselves in need (although any better ways of getting the MIME type would probably not be a bad idea):<BR /><BR />Didn't realise but one of the File functions (LoadBinaryFile) in a calc stage has the ability to convert a file into binary data, so that was the first problem solved. As for the MIME type, I made up a collection of the common file extensions we may end up emailing (came up with about 18 at the moment) and then looped through this collection, comparing it against the extension of the file I was trying to attach. Works a charm now!<BR /><BR />------------------------------<BR />John Hammond<BR />------------------------------<BR /> Fri, 26 Aug 2022 14:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74031#M26636 john.hammond 2022-08-26T14:19:00Z https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74032#M26637 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/1981">@john.hammond</a>,<BR /><BR />FWIW - There is a method in the .NET Framework that will return the MIME mapping for a specified file. You can find more about it <A href="https://docs.microsoft.com/en-us/dotnet/api/system.web.mimemapping.getmimemapping?view=netframework-4.7.2" target="_blank" rel="noopener">here</A>.<BR /><BR />Cheers,<BR />​<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Fri, 26 Aug 2022 15:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Convert-file-to-Binary-and-get-MIME-type/m-p/74032#M26637 ewilson 2022-08-26T15:10:00Z