Extract Input Results from MongoDB

Question

Hello,

I am connected to our MongoDB and would like to know if there is a way to extract the contents of the files that are uploaded via file uploader that is stored with AS_QueueInputs.Files under AlteryxService. We are wanting to make sure that there is no sensitive data being stored in MongoDB. I followed another article that parsed data from AS_ResultsFiles that used the ServiceDataParse macro, but that did not seem to help me at all.

Any help that can be offered is appreciated.

Thank you

fmvizcaino · Answer

Hi @Link86 ,

I'm not 100% sure here but in previous versions (not sure which one, we are currently using the 22.1), we were able to download the yxmd files from the service data column from the application's collection if I'm not mistaken.

Here is a post talking about it: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-yxmd-file-from-Mongodb-Scheduler-db/td-p/27447

I would say that it was quite similar for other collections (or it was already encrypted, not sure), but right now, it is not possible anymore;

I think Alteryx included some kind of encryption in the service data, making it impossible to retrieve the data anymore. So, to answer your questions, the sensitive data is there but only accessible from inside the gallery and not downloadable from anywhere else.

One thing that I'm still able to access and I would say we shouldn't, are the collections.files (QueueInputs.files for example) that are created in case you have a larger file.

Best,

Fernando Vizcaino