Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

How to extract result files from Mongo DB?

akviletamol
6 - Meteoroid

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.

6 REPLIES 6
Ladarthure
14 - Magnetar
14 - Magnetar

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...

akviletamol
6 - Meteoroid

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?

Ariharan
9 - Comet

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ashley_harris
7 - Meteor

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

akviletamol
6 - Meteoroid

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.

ashley_harris
7 - Meteor

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