Can BI pub report be generated as CSV or JSON format

User_HOD8G

Summary:

We are setting up the BI pub report in OAC to send the output to the OCI object storage. It is working fine with either PDF or excel format, but we need the CSV or JSON format.

Content (required):

The major purpose of requesting those two particular formats is to enable the data transformation between OCI and our CRM system. From their endpoint, they are able to receive CSV or JSON data.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Mallikarjuna Kuppauru-Oracle

Hi @Ravee

you can can web-service and use below method to get the JSON format.

https://medium.com/%40akashpandians/how-to-create-json-output-using-bi-publisher-ab1baa259869

Regards,

Arjun

Sahithi Kolasani-Oracle

Hi

Have you specified the output format of the BIP report as csv?

Please go to View a list -> Output Format -> Select Data (CSV) and unselect other formats. you should be able to get the output as a csv file.

Thank you

Sahithi

Ravee

Hi Can I use postman to get the data of BI report in JSON format?