Matches List API Code:
let
// Define the API URL and headers
apiUrl = "[Link]
headers = [
#"X-RapidAPI-Key" = "Paste your API Key ",
#"X-RapidAPI-Host" = "[Link]"
],
// Create a function to make the API request
getApiData = (url as text, headers as record) =>
let
// Make the request
response = [Link](url, [Headers=headers]),
// Parse the JSON response
jsonResponse = [Link](response)
in
jsonResponse,
// Call the function to get the API data
apiData = getApiData(apiUrl, headers)
in
apiData
Live Score API Code :
let
// Define the API URL and headers
MatchID = [Link](Live_Match_ID{0}[MatchID]),
// Make sure Live_MatchID is your table name and MatchID is your ID Column
name
LastRul="scard",
apiUrl = "[Link] MatchID
&"/"&LastRul,
headers = [
#"X-RapidAPI-Key" = "Paste your key",
#"X-RapidAPI-Host" = "[Link]"
],
// Create a function to make the API request
getApiData = (url as text, headers as record) =>
let
// Make the request
response = [Link](url, [Headers=headers]),
// Parse the JSON response
jsonResponse = [Link](response)
in
jsonResponse,
// Call the function to get the API data
apiData = getApiData(apiUrl, headers)
in
apiData