What I meant in my previous message was that you needed to remove the space after "Authorization". Whether or not you have a space before "Bearer" is a different topic. I like to include one to make it easier to read, but it's not mandatory. However, spaces before the colon are not allowed.
As to the other issue, it seems like you're not really targeting an actual API endpoint and are simply sending a request to a URL that is designed to return an HTML document (that a browser can convert to a table).
Are you actually doing this according to some kind of an API documentation?
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
