let
url = "https://api.livecoinwatch.com/coins/list",
body = "{""currency"":""USD"",""sort"":""rank"",""order"":""ascending"",""offset"":0,""limit"":100,""meta"":true}",
headers = [
#"content-type" = "application/json",
#"x-api-key" = "f74b69e5-743c-4f72-b298-84bdbcc78581" // Replace <YOUR_API_KEY> with your actual API key
],
Source = Json.Document(Web.Contents(url, [Content = Text.ToBinary(body), Headers = headers, ManualStatusHandling = {400, 404}]))
in
Source
Hallo
Thank you for this Lessons.
is it possible with google sheet too?
thanks