In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Server Discussions

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

Looking for a way to search all workflows on company gallery for reference to a SQL table

OldDogNewTricks
10 - Fireball
‎02-19-2020 09:31 AM

Hey community!  As the description says, I am looking for a way to search through all workflows in the company gallery for any SQL in an input data tool and/or command tool that references a specific table name.

 

Any ideas?

Labels:
Reply
0 Likes
1 REPLY 1
AbhilashR
15 - Aurora
15 - Aurora
‎02-19-2020 10:16 AM

Assuming the published workflow has run atleast once in the Alteryx Gallery, one way could be to access the workflow output (logs) and parse through the data to identify the table name.

 

Alteryx has made it easy to access server data via APIs: https://gallery.alteryx.com/api-docs/#subscription

Reply
server new user guide
Labels
Top Solution Authors
View All