Absent Member.. AlexGg Absent Member..
Absent Member..
709 views

Run report by ReportUrl or RunId via invoke method

If anyone can help me to find the way to run a report either by: ReportUrl or just by RunId. 

I mean to be able see result of run in report form, but without direct log on the central?

Same as Invoke method to run a flow and passing user/password credentials to command line.


The only way I know is: to write some report flow and pass the runID as an argument, but maybe someone used something else?

 

Thanks!

 

 

Labels (1)
0 Likes
6 Replies
Absent Member.. AlexGg Absent Member..
Absent Member..

Re: Run report by ReportUrl or RunId via invoke method

Nobody knows?

0 Likes
Absent Member.. AlexGg Absent Member..
Absent Member..

Re: Run report by ReportUrl or RunId via invoke method

Ok, I see it's not possible in simple way. Well, let me ask another question: anybody knows when you look at Basic Report by RunId, what table of OO DB is treated? I am interesting specifically about a "Step Name" column.
0 Likes
Absent Member.. ntt00015 Absent Member..
Absent Member..

Re: Run report by ReportUrl or RunId via invoke method

Hi Alex,

If you know only the runId parameter you cannot get the report from url. You have to know at least uuid parameter of the flow.

https://host/PAS/app?service=external/Reports#oneRun?repairName=flow_name&uuid=flow_uuid&runId=4523622&historyId=4523621&filtered=true


Check the tables below:
select * from FLOW_METRICS
select * from run
select * from run_history
select * from runstep_history

The information you are searching is in runstep_history table. This table has the report's detail info.



0 Likes
Absent Member.. AlexGg Absent Member..
Absent Member..

Re: Run report by ReportUrl or RunId via invoke method

Thank you ntt00015 for the table info - will look into.
In regards of report URL - I discovered - there no way to get it without prompt credentials, even via wget... that is the issue. So now I have just the way grab and generate report via DB. Thanks again.
0 Likes
palachance Absent Member.
Absent Member.

Re: Run report by ReportUrl or RunId via invoke method

Hello

 

You should be able to call your flow with wget or curl.

 

wget example:

 

wget -b --post-data=<var1=val1&var2=val2> --no-check-certificate --http-user=<user> --http-passwd=<passwd> https://<your_host>:<your_port>/<path_to_your_flow>

 

curl example:

 

curl -k -u <user>:<passwd> -d "<var1=val1&var2=val2>" https://<your_host>:<your_port>/<path_to_your_flow>

 

Cheers!

0 Likes
Absent Member.. AlexGg Absent Member..
Absent Member..

Re: Run report by ReportUrl or RunId via invoke method

Yes, it's true for the flow, but will not work for report URL... such as:
https://server:port/PAS/app?service=RCLinkService/ReportLinkDispatch&sp=SINDIVIDUAL_REPAIR_LEVEL&sp=SUUID&sp=l0&sp=l124620&sp=l124621
because it calls application and HPOO is drilled to open SSO page....
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.