JS code in "Get Data" script items in Azure templates could be more effective.{}

1) Instead of make API call for each metric, Azure Graph API allow getting up to 20 metrics in one call. Such approach already implemented in some Azure templates (VM and VM sets, for example).

Templates which such rework would be nice to do in:

• Azure PostgreSQL Single Server by HTTP
• Azure PostgreSQL Flexible Server by HTTP
• Azure MySQL Single Server by HTTP
• Azure MySQL Flexible Server by HTTP
• Azure Microsoft SQL Database by HTTP
• Azure Microsoft SQL Serverless Database by HTTP

2) Instead of calculating date and time for timeframe, it is possible to distinguish it in API call (example: ...&timespan=PT5M). Such approach will take off some unnecessary calculation on the server side.

Templates which such rework would be nice to do in:

• Azure PostgreSQL Single Server by HTTP
• Azure PostgreSQL Flexible Server by HTTP
• Azure MySQL Single Server by HTTP
• Azure MySQL Flexible Server by HTTP
• Azure Cosmos DB for MongoDB by HTTP
• Azure by HTTP

3) Azure Graph API is inconsistent in terms of returning the latest data. For some instances it returns the latest data, but for some returns second last or even third one. Such behavior can be universally countered by receiving 5 last metrics and getting the last one.