Some API responses return large numeric values (as a string) that do not fit within a 32-bit integer. For example, the Microsoft 365 Exchange Mailboxes API Poller template returns total storage usage in bytes, which with a medium to large tenant may actually be hundreds of GB or event TB. The value in bytes is too large to fit within a 32-bit integer as used by SWQL in modern dashboards and, as a result, you cannot use this API value as a metric or in dashboards.
We need some way to deal with these large (64-bit) numeric values; either provide a transform to allow unit conversion or change the underlying process used for SWQL to use 64-bit arithmetic vs 32-bit.
