Hello Experts, I have a data model and a report created from that data model. I need to automate the report download through an API call. Later, I need to run a Python script for post-processing. Can anyone please share an API endpoint that I can use for this purpose? Thanks, Sam,

HI @Sam Bandara You can use below method from Catalog service downloadObjectInSession() Method Use downloadObjectInSession() method to download an object from the BI Publisher catalog for a given user.

You can get the path of bip report from "Schedule Report Job" screen as well. For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

@Sam Bandara You can get the path of bip report from "Schedule Report Job" screen. For example, the path is like "/Custom/kurasaki/per_users_rp.xdo".

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

API for Automating the OTBI Report download

Accepted answer

160

Views

Comments

Answers

Sam Bandara Rank 2 - Community Beginner

Apr 4, 2025 5:33AM edited Apr 4, 2025 5:39AM

@Kurasaki-Oracle
@ravikiran goda-Oracle
Do you know any method to download the report as a CSV?

0

MFA for Oracle Community

Oracle Transactional Business Intelligence

Categories

API for Automating the OTBI Report download

Answers