Obtaining input and output files from MongoDB

Question

Hi all,

Apologies if this has been posted already, I have had a look through a few forums and haven't found a complete answer to my question.

I have an app hosted on Alteryx Server that allows people to submit input files that is either rejected with no output, or completed with an output file produced. The output file is then presented back to the user to download.

I was wondering, how would I obtain a copy of the input and output files that each user would obtain as a result of this (regardless of pass or fail)? I have seen other people mention this is done with MongoDB, so does this mean querying it with the MongoDB Input Tool in Designer, then uploading an app to run that will download all inputs/outputs within a time period? And in which case, what collection would I need to query?

Any help would be fantastic.

Thanks.

ashley_harris · Answer

Hi @BrianR ,

Thanks for your reply. I think that helps with the input files, but I am still struggling with the outputs. I see the collection AS_ResultsFiles contains the name of the output, but I can't figure out a way to obtain the full contents of the output file. Would you happen to know how this is done?

Thanks,

Ashley

BrianR · Answer

I haven't actually tested this out - but take a look at this video from one of our partners, DataMeaning - while the exact data might be a bit different, I think the technique talked about in this video might also apply to those files - https://www.youtube.com/watch?v=doljUWtycH8

ashley_harris · Answer

@BrianR wrote:Hi @ashley_harris , I was looking into this recently - I was able to get to the AS_ResultsFiles Collection via the AlteryxService database. What I see are lists of file names that were output from a given workflow, not sure this is exactly what you are after, but here's how I configured the MongoDB Input:

Hi BrianR, thank you for your comment. That's interesting, so that collection doesn't actually provide the data in the files, just the names? Do you know of any way, using MongoDB, that would allow me to pull the data from the files (.csv) uploaded to the tool on the server?

Thanks again for your help!