Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summary to detail page - dynamically load details using api's?

Hello,

 

I have searched the forum/blogs/etc. but so far have not found a solution, so I really appreciate any help that can be offered here.

 

I have a summary report that I'm trying to drillthrough to a details report (can be a page or separate report if needed). All datasources are APIs, so as far as I'm aware I'm not able to use DirectQuery. The detailed reports datasets are large. I am struggling with how I can dynamically pass in an ID by which I can run the details API query each time the page (or other report) is run so that the report contents dynamically update each time I drillthrough to the detail page.

 

Is this possible? Thank you again for any help!

 

Sincerely,

Jon

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    I found this API which might be helpful to solve your issue. It returns the specified page within the specified report from the specified workspace.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I appreciate the suggestion Anonymous but I don't think that addresses my issue. I'm not looking for a link to the detail page; I can get to that. What I need to do is be able to dynamically change the URL of the datasource in the detail page, depending on which record I'm drilling through in the summary, and only load that detail record (not pre-load; load dynamically when the page is loaded). Any other ideas?

      Thank you,

      Jon