curl --request POST \
  --url https://app.bily.ai/api/customer/v1/ad-metrics/{storeUrl}/query \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <api-key>' \
  --data '
{
  "sql": "SELECT channel, sum(spend) AS spend FROM _ GROUP BY channel ORDER BY spend DESC"
}
'

const options = {
  method: 'POST',
  headers: {'x-api-key': '<api-key>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    sql: 'SELECT channel, sum(spend) AS spend FROM _ GROUP BY channel ORDER BY spend DESC'
  })
};

fetch('https://app.bily.ai/api/customer/v1/ad-metrics/{storeUrl}/query', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://app.bily.ai/api/customer/v1/ad-metrics/{storeUrl}/query"

payload = { "sql": "SELECT channel, sum(spend) AS spend FROM _ GROUP BY channel ORDER BY spend DESC" }
headers = {
    "x-api-key": "<api-key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

{
  "dataset": "ad_metrics",
  "storeUrl": "<string>",
  "maxRows": 123,
  "inputLimit": 123,
  "page": 123,
  "adAccountScope": 1,
  "meta": [
    {
      "name": "<string>",
      "type": "<string>"
    }
  ],
  "data": [
    {}
  ],
  "rows": 123,
  "statistics": {
    "elapsed": 123,
    "rows_read": 123,
    "bytes_read": 123
  }
}

{
  "error": "Store not found",
  "requestId": "<string>",
  "details": "<unknown>",
  "retryAfter": "<string>"
}

{
  "error": "Store not found",
  "requestId": "<string>",
  "details": "<unknown>",
  "retryAfter": "<string>"
}

{
  "error": "Store not found",
  "requestId": "<string>",
  "details": "<unknown>",
  "retryAfter": "<string>"
}

{
  "error": "Store not found",
  "requestId": "<string>",
  "details": "<unknown>",
  "retryAfter": "<string>"
}

{
  "error": "Store not found",
  "requestId": "<string>",
  "details": "<unknown>",
  "retryAfter": "<string>"
}