topic Re: How to extract result files from Mongo DB? in Alteryx Server Discussions

How to extract result files from Mongo DB?

akviletamol — Tue, 31 May 2022 09:39:39 GMT

Hi,

I want to download the result files of the users, who ran workflows in Alteryx Gallery.

For this purpose I used Mongo DB Input, database AlteryxService and collection AS_ResultsFiles.

How to extract the files themselves from __ServiceData blob?

When I use Blob Convert tool, I only get Filename, but not the actual file.

Re: How to extract result files from Mongo DB?

Ladarthure — Wed, 01 Jun 2022 13:32:34 GMT

Hi @akviletamol,

have you tried using the service data parser macro. I know that those blob files contains many informations.

You can find an article and the macro on the post bellow :

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx/ta-p/10534

Re: How to extract result files from Mongo DB?

akviletamol — Wed, 01 Jun 2022 13:50:27 GMT

Hi,

yes, I did tried this macro. This provides me these columns all in V_WString format:

Id
AS_Queue__ID
File
FileName
UserName

I'm wondering how to retrieve the file itself rather than the metadata about result file?

Re: How to extract result files from Mongo DB?

Ariharan — Wed, 13 Jul 2022 21:15:27 GMT

Hi @akviletamol,

You can open the data parser macro and follow the below steps to retrieve the file instead of columns.

Right click the Data parser >> Open Macro

Once Macro opened you will see the input and output tool infront of output tool drag and drop the Output tool and save the output file in any of desired location.

Save the Macro and close the macro workflow

Run the main workflow

Regards,

Ariharan R

Re: How to extract result files from Mongo DB?

ashley_harris — Tue, 16 Aug 2022 09:43:31 GMT

Hi,

I am having the same problem with this - the collections I have used only return the name of the output excel files, whereas I want to return the contents of the output excel files. Is there a way to do this using MongoDB?

Thanks,

Ashley

Re: How to extract result files from Mongo DB?

akviletamol — Tue, 16 Aug 2022 09:57:06 GMT

Hi @ashley_harris

we later found the solution. You need to use Options - View Schedules - Select your Controller on the drop down list - Go to Results tab

And then if you extract the Job details by clicking on the plus sign, you can actually open the files by clicking on Output button and then clicking on the links to the outputs you find there.

How much history you can find there I guess depends on the settings used on your server.

Hope this helps.

Re: How to extract result files from Mongo DB?

ashley_harris — Tue, 16 Aug 2022 12:49:21 GMT

Thanks @akviletamol , I'll give that a go!