topic Hi John, can you please… in Product Forum

HTTP command Proclist is not giving appropriate result

NilanshuSoni — Mon, 21 May 2018 18:48:00 GMT

Hi All, when running the HTTP command- /proclist on a resource pc, it is giving list of all the processes and business objects instead of giving only published processes list. can you please suggest a way to get list of only published processes either using database or HTTP command?

I think that's a bug…

John__Carter — Tue, 22 May 2018 12:37:00 GMT

I think that's a bug Nilanshu, the /help%20proclist command states: Command: proclist Provides a list of processes which are available to be run. Only published processes appear in this list. But I also see unpublished processes in the output - I'll raise a ticket. Querying the BPAProcess table is an option, but you must be conscious of the risk of creating a direct connection to the DB.

Thanks for clarification…

NilanshuSoni — Wed, 23 May 2018 12:11:00 GMT

Thanks for clarification John. Can you please let me know the query i should fire on BPAProcess table to get the relevant data? its a one time activity so risk factor is very low.

Hi John, can you please…

NilanshuSoni — Wed, 23 May 2018 17:44:00 GMT

Hi John, can you please provide the query?

I think it's something like…

John__Carter — Thu, 24 May 2018 16:55:00 GMT

I think it's something like SELECT [name] FROM BPAProcess WHERE processtype='p' AND attributeid=2

Hi John, Please suggest if…

NarayanShrawagi — Mon, 27 Aug 2018 14:48:00 GMT

Hi John, Please suggest if the bug has been fixed. I have the same requirement where I need to get list of published processes

Actual syntax for HTTP API…

NarayanShrawagi — Thu, 30 Aug 2018 13:24:00 GMT

Actual syntax for HTTP API for proclist is http://bapab902:8181/user%20name%20&password%20&proclist. The syntax for HTTP command lines uses the & symbol to chain options (in place of ""/"" for AutomateC.exe command line) and ""%20"" to replace spaces.