Is there any way to find all the nintex workflows with webservice call?
Aha! Found it quicker than I thought!
Try this SQL Query:
SELECT DISTINCT i.workflowname, a.activityname, i.webid, i.siteid, i.listid
FROM dbo.workflowinstance i
inner join WorkflowProgress P
on I.InstanceID = P.InstanceID
inner join Activities A
on P.ActivityID = A.ActivityID
WHERE a.activityname = 'Execute SQL'
Note: You can replace 'Execute SQL' with any of the values from the dbo.activities table.
Not presently however, this can be accomplished with a SQL Query (you could create your own web service call that performs the query and returns the results in whatever format you are looking for).
For SQL you can do something like this (not optimized in the least): SELECT * FROM [DatabaseName].[dbo].[PublishedWorkflows]
That would return something like the following:
Sorry for interpreting it wrong way.
I need to find all the nintex workflows which use webservice call (ex: getuserprofile, getuserfrom group etc)inside the workflow.
Gotcha! I think I may have something that will help you with this. Let me take a look.
Thank you verymuch.. this is what i am looking for this.
Perfect! Please mark your question as answered to further assist future users.
Retrieving data ...