tiktok meterial music

excel format:songs.xlsx
json format:songs.json

{
  "ret": "0",
  "errmsg": "success",
  "svr_time": 1697613052,
  "log_id": "202310181510523D438B1678479636ABF1",
  "data": {
    "has_more": true,
    "songs": [
      {
        "id": 6893469927033342733,
        "web_id": "6893469927033342733",
        "status": 1,
        "title": "无法坠入爱河",
        "author": "叶琼琳",
        "album": "",
        "duration": 29,
        "cover_url": {
          "hd": "https://p9.douyinpic.com/aweme/1080x1080/tos-cn-v-2774c002/cd70458dc3e44f118ba5ede62892e9ee.jpeg",
          "large": "https://p9.douyinpic.com/aweme/720x720/tos-cn-v-2774c002/cd70458dc3e44f118ba5ede62892e9ee.jpeg",
          "medium": "https://p9.douyinpic.com/aweme/200x200/tos-cn-v-2774c002/cd70458dc3e44f118ba5ede62892e9ee.jpeg",
          "thumb": "https://p9.douyinpic.com/aweme/100x100/tos-cn-v-2774c002/cd70458dc3e44f118ba5ede62892e9ee.jpeg"
        }
      }
    ]
  }
}

how to get data

1. visit https://www.capcut.com/
2. use fiddler to capture the request
3. save the response to json file
4. use python to parse the json file
5. load the data to excel