PHP BI7 WEB AS

[former_member204618]

Hi All,

Not sure if this is the right forum for this post, so I will apologize in advance if it's not.

Anyways, I am trying to use PHP and it's curl functions to return the results of a web query from BI 7 to do some manipulation of the returned table content. But when I try to run the query like so :-

<?php

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://<hostname>/sap/bw/BEx?SAP-LANGUAGE=EN&PAGENO=1&CMD=RESET_DATA_PROVIDER&DATA_PROVIDER=DP&INFOCUBE=CM_MCLPOV&QUERY=AH_CXA_TEC_001');
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); 
curl_setopt($ch, CURLOPT_USERPWD, 'username:password');
$data = curl_exec($ch); 
curl_close($ch);

print $data; 

?>

The web application server terminates with this message :- "Web application processing terminated"

Now running the url directly works just fine and it works just fine with web templates that have embedded queries but not running the queries directly.

Can anyone help ?

Thanks

Craig

[former_member204618]

Doesn't matter I fixed the problem, it was a malformed URL.

Thanks

Craig