API to extract cloud cost data from Flexera

[sbalajipune]

I'm looking to integrate with PowerBI to extract the cloud cost details. Is there any Flexera API available to download the data from cloud/Cost Optimization/ Biling Centers and cloud/cost optimization/Optimization?

[JohnSorensenDK · Accepted solution]

@sbalajipune 

Please refer to the Cloud Cost Optimization APIs and specifically:

• Cloud Cost Optimization Billing Center API 
• Cloud Cost Optimization Bill Analysis, Bill Adjustment, Budget, and Rule-Based Dimensions APIs  

The Optimization UI is populated using policies, please refer to Flexera Automation Policy API 

Thanks,

[sbalajipune]

Thank you @JohnSorensenDK , this helps.

Can you direct me to API that gets the Potential Cost savings and recommendations, please?

[JohnSorensenDK]

@sbalajipune 

I would use the aggregated costs API and I've just tested attached sample json payload that works for me.

Thanks,

[sbalajipune]

@JohnSorensenDK , Thank you for attached json request. It though returns me an error as 'savings_rate_reduction_amortized_adj' in metrics as not recognized.

Where do we find all the possible metric values and the fields in the requests? Is there schema somewhere I can refer to?

[JohnSorensenDK]

@sbalajipune 

I found the available metrics when testing it in my org using a GET request against /bill-analysis/orgs/{{orgId}}/costs/metrics

Thanks,