Highlighted
Boekkamp
1 Nickel

Realtime reports using DPA API and built-in webserver (apache)

Jump to solution

Hi All,

Currently we are creating static reports using the scheduled reports option and placing the resulting html documents in the reports folder.

Does anyone know how to use the DPA API to create dynamic reports using a webserver so we can request reports using

The report would be requested using an url like:

http://dpaserver:9002/reports/dpa_api.cgi?request=report&?reportname=reportcard

dpa_api.cgi should be a custom script where we can do the talking to dpa_apitool and using the variable values and predefined information

such as the authfile.

The result of the request should be an xml which is sent back to the browser so it can be formatted using an xlt

My questions are:

  • what would be needed to run the reports like this
  • how to set this up using the built in http server for DPA
  • how would the script look like
  • what would be the easiest way to format an xlt which makes the xml data readable

Kind regards,

Jeroen

1 Solution

Accepted Solutions
doster1
1 Nickel

Re: Realtime reports using DPA API and built-in webserver (apache)

Jump to solution

Hi Boekkamp,

  • what would be needed to run the reports like this
    • Easiest solution is probably to have a custom script that runs reports from the command line. Refer to DPA Administration guide section ‘Running reports from the Publisher’. Alternative is to refer to the DPA API guide, where XML can be sent to the Reporter (and received).
  • how to set this up using the built in http server for DPA
    • Don't have quick answer
  • how would the script look like
    • Don't have quick answer
  • what would be the easiest way to format an xlt which makes the xml data readable
    • Don't have quick answer but in my opinion this would be difficult if not impossible to do. The XML really isn't meant to be ‘read’. It is meant to be parsed and then presented in a readable format.

Support does not have the capacity to write scripts so it would be best to discuss with your sales person if Professional Services would be able to perform such.

Hope that helps

Dan

0 Kudos
2 Replies
doster1
1 Nickel

Re: Realtime reports using DPA API and built-in webserver (apache)

Jump to solution

Hi Boekkamp,

  • what would be needed to run the reports like this
    • Easiest solution is probably to have a custom script that runs reports from the command line. Refer to DPA Administration guide section ‘Running reports from the Publisher’. Alternative is to refer to the DPA API guide, where XML can be sent to the Reporter (and received).
  • how to set this up using the built in http server for DPA
    • Don't have quick answer
  • how would the script look like
    • Don't have quick answer
  • what would be the easiest way to format an xlt which makes the xml data readable
    • Don't have quick answer but in my opinion this would be difficult if not impossible to do. The XML really isn't meant to be ‘read’. It is meant to be parsed and then presented in a readable format.

Support does not have the capacity to write scripts so it would be best to discuss with your sales person if Professional Services would be able to perform such.

Hope that helps

Dan

0 Kudos
proxy3
1 Copper

Re: Realtime reports using DPA API and built-in webserver (apache)

Jump to solution

Hi Boekkamp,

I did something very similar some time ago. I wrote a perl script to convert the xml output into html or csv. We can now run a DPA report by running the script  from the command line or by calling a URL. Instead of using the DPA http server (it's not apache) we installed a separate apache webserver on the DPA server. You can contact me for more info if you want.

Joachim