search

ppy / osu-api

Public API for accessing osu! related data.
320 stars 16 forks source link

Osu Api Google Sheets #291

Closed ghost closed 4 years ago

ghost commented 4 years ago

I would like to use osu api to get my user data and recent scores ect on a google sheet. I have added the importjson function with a script but cant figure out how to format it with the api access token. I am fairly competent at google sheets, but clueless beyond that. Any help appreciated.

tybug commented 4 years ago

Do you just need the url to retrieve the json from? if so, this is the format: https://osu.ppy.sh/api/ENDPOINT_NAME?k=API_KEY&PAREMETER=VALUE&PARAMETER=VALUE (etc)

To retrieve your recent scores as json, use: https://osu.ppy.sh/api/get_user_recent?k=API_KEY&u=YOUR_USER_ID, replacing the capitalized words with the necessary values.

ghost commented 4 years ago

I think I got the hang of it now, just needed help with the format thx a lot.