Receiving Password protected xls or xlsx files via email connector
I am trying to find a solution to receive password protected files (XLS or XLSX ) via the email connector.
If we use the XLSX format on a protected file; the connector does not accept the file and throws up an error (see screen shot 1).
If we use a XLS protected file; the connector accepts the file, but only if the password is "test" (the password is case sensitive). However, XLS files, when sent to Domo, the column headings are not recognised for numeric fields and therefore an aliases are used as column headings (see screen shot 2).
Is there any other option to receive password protected files?