What is the best practice for pulling data out of SAP Subscription Billing for Reporting Needs

[tzaengle]

I have a requirement to create some custom reports using data available in SAP Subscription Billing. I investigated using Excel's Power Query to call the Subscription Billing APIs but there is a limitation in Power Query in terms of reading the API Repsonse Header information which is vital to know how many request will be needed to fetch all the desired data. Is there a recommended best practice (tool or process) for pulling data from Subscription Billing for reporting purposes?

Thank you,

[tzaengle]

Hi Shakeel:

Thank you for your reply. Is there a reporting tool the you would recommend to fetch the data programmatically, parse the JSON responses and store the data in a table structure so that it can be reported on. Initially I was going to use Excel but it's power query capability is limited when it comes to reading API response header attributes like x-count and x-pagecount. Do you know if Tableau has this ability?

Thank you,

Tom

[former_member772797]

Hi Tom,

there are page-size limitations in API (default 40 records i think) , hence to extract all needed records JSON you have to use headers['x-count'] and headers['x-pagecount'] and then on based of it you have to call API in loop from 1 to pagecount.

call API at first and get pagecount and records count and then call same API with pageNumber in loop.

for i in 1 to pagecount

https://eu10.revenue.cloud.sap/api/subscription/v1/subscriptions/?&pageNumber={i}&pageSize=100

remember to change eu10 or us10 in url as per your region.

endfor