Skip to main content

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.

Looking for the same thing.

@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.

@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


Terms & ConditionsCookie settings