How To Call BIP Report Webservice From App Composer using Groovy Script

May 7, 2021 5:31PM

Hi All ,

Used below code to pass a parameter into the report and get the result.

def reportRequest =

[

byPassCache :true,

flattenXML :false,

reportAbsolutePath :"/Custom/AppCompReport/PRF Attchement Report.xdo",

sizeOfDataChunkDownload :2000,

parameterNameValues:

[

item:

[[

UIType :'Text',

dataType :'xsd:string',

defaultValue :'PRF-0000328-06052021',

fieldSize :'15',

label :'P_RECORD_NAME',

multiValuesAllowed :false,

name :'P_RECORD_NAME',

refreshParamOnChange :false,

selectAll :false,

templateParam :false,

useNullForAll :false,

lovLabels:

[

item:

[[

item :'PRF-0000328-06052021',

]],

],

//optional instance of type:'lovLabels' for accessor:'values'

]],

]

def s ='';

def appParams ='';

def result=adf.webServices.SupplierDetailsReport.runReport(reportRequest, appParams);

println(result)

def NewResult=decodeBase64(result.reportBytes.toString());

println(NewResult)

CRM On Demand - Reports and Dashboards (MOSC)