Use API to get data from [Microsoft Defender for Cloud | Recommendations, All recommendations]

[KevinNiko]

Currently using csv download

[Microsoft Defender for Cloud | Recommendations, All recommendations, Download CSV report].

Is there an API I can use to get this information  ?

If I get data from Log Analytics Workspace (continuous export enabled), the data does not match that in csv download 100%.  (due to snapshot which can take a week).

If I use query in Azure Resource Graph explorer, how do I automate that data export into Azure SQL Server ? 

[#2]

@KevinNiko did you find a way to do this?

[#3]

https://learn.microsoft.com/en-us/azure/defender-for-cloud/workflow-automation

"recommendation" is a supported trigger, so you can call a Playbook