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 Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
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

177

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

Oracle Transactional Business Intelligence

Categories

API for Automating the OTBI Report download

Answers