Alteryx Server Ideas

Hi Alteryx Team,

in one of my current projects we would like to set up a Alteryx Gallery Collection using the API, which already works fine using the current API implementation.

In addition we want users of this collection enable to use DataConnection to DBs they are allowed to access. This can already be done manually. I can create a Data Connection manually and then I assign the same users I already assigned to the Collection also to the Data Connection. Adding these users to the Data Connection can also be done using API. The only part that is missing is the CREATION OF DATA CONNECTION USING API.

The other option is to make it possible to assign Data Connections to Collections, which is unfortunately also not possible at the moment.

Our challenge is that we want to create those kind of workspaces a lot of times for a lot of colleagues without additional manual effort.

That's why I ask for enhancing the DataConnection API in order to create Data Connection using Gallery API.

Regards

Robert

Upon utilizing the Alteryx gallery to create and test an automation app in cooperation with other business areas, we found that the list of "recent modified files" that appears when selecting a file browse query has several issues, or areas in desperate need of improvement:

Not only does this list append new files to the bottom, resulting in a less than desirable experience when selecting files from this list across multiple occasions when testing, but the list eventually reaches a capacity where no new files can be shown. Furthermore, for processes that involve small modifications being made to a file or group of files that is fairly consistent in naming, a list of ambiguously named files will quickly cause confusion. If this type of small improvement is possible, please reach out to me about any avenues towards achieving it, or if there is a person or department to appropriately contact.

-John

A maintenance mode would not be luxury, so that the worker does not take any more new job and finishes those which it has in progress. to be able to stop this one more easily.

Hello,


There are some tools that helps to monitor what happens on a website. Some are even open source (like matomo and open web analytics). Why not including one of those tools on Alteryx Server ?

There are of course a lot of feature but I like this one, an heatmap to show where a user click

Best regards,

Simon

I have a lot of workflows that depend on each other. Currently there's LOTS of hassle to effectively schedule a set of workflows to run subsequent.

Typically we run workflows (eg. product hierarchies) that would need to be completed before the next workflow should start (eg. sales data). We currently have some wonky workarounds that are high maintenance, but I would love to see this as a feature in the Gallery.

We have groups asking within our organization for ways to check the status of a running workflow in Gallery. They are wanting to understand which step in the process the workflow has completed for longer-running workflows.

They are looking for an experience similar to when running in Designer where they can see which tools have been completed. At the very least, they would like the log to be reported live and not shown at the end of the run.

Currently, the run feels like a black box where they do not know how close it is to completion or which steps it has made it through.

We have tried to build workarounds like the Email tool, but have been unsuccessful. For example, the Email tool does not send an Email until the workflow completes which defeats the purpose. The closest workaround is writing our own log along the way that can be reported on which is not a clean solution. 

Hello, Alteryx users,

My idea is simple but would make things way easier for the analytical app users on the Gallery.

Currently, the order is ascending and we can see all the files from all the applications we have run before.

It would help a million to see the most recent files first and only see the files related to this workflow.

Thank you,

Fernando Vizcaino

I have tried so many python packages to Refresh excel Pivot table automatically through Alteryx and save the refreshed data, most of the packages are working perfectly on designer but none of them are working on server.

If we find out anyway that will refresh pivot tables of Excel through Alteryx then it will be great for us. 

I would like to propose a number of small enhancements to the Gallery:

1. Time format. The 12-hour time format (

    

   ) is confusing to everybody except Americans. Please add support for a 24-hour format. This could be done either by extending the Locale settings or by a separate check box. Please make sure that this time format is used everywhere in the Gallery (last update, last run, schedule, etc.).
2. Date format. Even though using English as GUI language, I prefer the time format according to ISO 8601-1, namely "YYYY-MM-DD". Please add support for this format, independent of selected language.
3. Number of Rows per Page in My Workspace: Each time I open My Workspace, the number of listed workflows per page is set back to 10. Please add support to set the default number of workflows in the user settings or at least preserve the chosen number within the same session.
4. Fully utilize the screen in My Workspace: Even after switching to more than 10 rows per page, nearly half of my screen stays empty. Please add function to utilize the screen completely.
   

Currently, DCM credentials appear to only be used in combination with a DCM Data Source.  

For ease of use for my end users (non-Designers), I would like my end users to be able to save a user ID and password as a standalone DCM credential.  Then, I want the user to have the option to select that credential for use in two places:

1.  Run-As - when running a workflow on demand, the user should be able to choose their saved DCM credential.
2. Credential injection into Input Data or other relevant tools in Analytic Apps - I want to use the DCM Connection tool to build Analytic Apps that prompt my users to select their DCM Credential (NOT a full DCM Connection with data source - I don't want my users to have to set that up.)  When the user selects their Credential, their user ID and password should be securely encrypted and inserted into the existing connection set up by the App designer.

Having this functionality would remove administrative burden from both our Designers and the end users they support.

Currently when we need to disable/enable schedule on API,we need to update all the schedule info,could you provide only one attribute to disable.

Can we just update on parameter

"enabled": true, --> "enabled": false

current update example,we need update all

{
"workflowId": "string",
"ownerId": "string",
"iteration": {
"iterationType": "Once",
"startTime": "2022-09-06T08:01:52.717Z",
"endTime": "2022-09-06T08:01:52.717Z",
"hourlyContract": {
"hours": 0,
"minutes": 0
},
"dailyContract": {
"runOnlyWorkWeek": true
},
"weeklyContract": {
"daysOfWeek": [
"Sunday"
]
},
"monthlyContract": {
"simpleDayOfMonth": true,
"dayOfMonth": 0,
"occurrence": 0,
"dayOfWeek": "Sunday"
},
"customContract": {
"daysOfMonth": [
0
],
"months": [
0
]
}
},
"name": "string",
"comment": "string",
"priority": "Default",
"workerTag": "string",
"enabled": true,
"credentialId": "string"
}

Hi All, 

The Alteryx API documentation was only available for certain entities(workflow, collection, etc.,) and not available for Schedule entities.

https://help.alteryx.com/developer-help/auditlog-endpoint

I want to see schedule audit information like old value(before change), new value, operation (update, delete, insert).

E.g If you create a schedule in Gallery, information about the schedule like creation date time, frequency, owner, type, last run, next run, etc. will be updated in MongoDB.
If a user edits or modifies a schedule in the gallery, the edit/updated information is only available in MongoDB.

Regards, 

Ariharan R

HI All, 

In the Gallery Page under My Workspace-->Share With Me we could see the fields like Name, Type, Owner, Shared Source, Uploaded, Manual Runs. Among these we are not able to sort the fields "Type" and "Owner" alphabetically, whereas we are able to sort the other fields Name, Shared Source, Uploaded, Manual Runs accordingly. Kindly refer the attached snapshot. 

Regards, 

Ariharan R

HI All, 

While creating a schedule to the workflow we could observe that the frequency is basically categorized into four options like Hourly, Daily, Weekly, Monthly. When coming to the "weekly" option why the user can have a choice to select multiple days in a week here? And why not the user who select "Daily" option can have a choice to select their own days according to the requirement?. In Daily frequency we could find only one option "Run only during work Week9Mon-Fri". Whereas in Tableau Schedules we could observe Weekly frequency enables the user to schedule only a single day in a week and in Daily frequency it enables the user to select multiple days in a week which really helps the user to create schedules in an effective way.

Alteryx:Daily Frequency Schedule

Alteryx:Weekly Frequency Schedule

Tableau:Daily Frequency Schedule:

Tableau:Weekly Frequency Schedule:

Regards 

Ariharan R

Today, when you trigger a job using the Server API, it is considered as a manual run type. In fact there are only 2 type of jobs : "Scheduled" and "Alteryx_Run"

I think "Alteryx_Run" should be segregated into "API_Run" and "Manual_Run". This way in future version we could treat those type of job differently. 

We could also have more stats around the type of jobs.

Hello all,

As of today, if you want to give the Alteryx Gallery user an Excel with your data out of your worfklow, you MUST design an Excel Report with Report tools.

However :
1/ It's highly time consuming to design the report
2/ It leads to many errors, especially on column size : a quick research on Alteryx community gives you several hundred topics
3/ the excel output works really fine

This is frustrating as hell for users !

Best regards,

Simon

Currently we can create static pages on the gallery from the Admin view using the Pages tab. I haven't been able to add in custom HTML code and would like to have such a page dynamically updated from the output of an Alteryx workflow Render tool (or similar). Ideally it would allow as much functionality as possible so that arbitrary HTML features could be implemented. Partly suggested by a prior idea: https://community.alteryx.com/t5/Alteryx-Server-Ideas/Embed-webpages-in-Gallery-Pages/idi-p/8963

The page title never changes from Gallery when navigating through it. This is quite frustrating if you are trying to go back to a specific page or searching for something on the browse history.

I might be missing something here but as far as I know there is no feature (user or admin) providing a list of data connections being used by a specific workflow. And conversely, which workflows use a given data connection. This should work for both 'Standard' Data Connections as well as the DCM.