Skip to main content
Question

Get Report Results Paginated Export ID

  • April 26, 2024
  • 3 replies
  • 145 views
L
Helper III
Forum|alt.badge.img+3

I am clearly missing something here.

I would like to use the Get Report Results Paginated API to feed a BI system. My alternative is to use an API with multiple calls to get the same data, and that burns up some license stuff on the BI side…..soooo trying a different approach.

I have a report that has all the data I want. I just need to get it to the BI system. I don’t have an SFTP. I can’t use Google Sheets or similar. I would prefer not to have to manually do a flat file import every time I need to refresh the data.

Enter the API…….

I have the report ID, easy enough.

What I can’t seem to find is how to get the required Export_ID parameter.

If I schedule the report (new reports), will it have an Export_ID ? Will it be unique for each scheduled run? Where do I find this thing?

 

@Bfarkas I read your post on reports everywhere (love it!)…...but I didn’t see this specific API discussed. Hopefully I didn’t miss where you already answered my question.

Jeremy.McKinley
1 person likes this
  • Jeremy.McKinley
    Jeremy.McKinley

3 replies

codywinchester
Contributor II

Looking for the same thing.

L
Helper III
Forum|alt.badge.img+3
  • lhubbard
  • Author
  • Helper III
  • 187 replies
  • June 12, 2024

@codywinchester I have been told that the Export ID is returned by calling the report first. Like (maybe) the Create Report call, which returns idReport. So even though it’s not called the same thing, it is what the paginated API is looking for. I have not tested the theory though since it looks like this solution will ultimately not work for me.

codywinchester
Contributor II

@lhubbard , I came across this yesterday after more digging: 

I’ve tested a few of these calls in tandem and I’m close to getting to the report. The pagination part is still tricky, but the CSV export might be another alternative. I have yet to get this to work. I have noticed that there is a a kind of bug retrieving custom reports - they have to refresh first before any of the data is available. I’m told that this is done regularly on the hour, but in practice I’ve seen instances where the call returns nothing. The difficulty presented here I think highlights the work that @Docebo needs to do to catch up to modern reporting protocols.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings