Create JSON output format in BI Publisher

Luis Gustavo

We have a request to raise a BIP report using JSON output.

We needed to build a complex report query to get JSON layout, but when business user runs this report, everytime they have challenges to convert it to JSON output.

The output option JSON should be available in BIP similar to eText and XML.

SwapnilDandgvhal

any udpate please?

CharanBochker

try this..

SELECT JSON_OBJECT ('SupplierNumber' VALUE ps.segment1,
'VendorType' VALUE ps.vendor_type_lookup_CodeFORMAT JSON) sample_output
FROM poz_suppliers ps