0

So I have managed to get a list of owned games and total hours in each game with =importJson. The only issue is I only want data for one game. The json query returns all owned games. The api wiki says I am able to filter by appid (in this case I want appid 393380 only) however I am having trouble figuring out where to put the string the wiki is describing, any thoughts?

=ImportJSON("http://api.steampowered.com/IPlayerService/GetOwnedGames/v0001/?key=1470922A6B6E5C001546E51ACA5D987B&format=json&steamid="&B2)

https://docs.google.com/spreadsheets/d/1yPNsNbS5osdORa9UfYc62WbqCApbeipHTUbU_DUOOGw/edit?usp=sharing

https://developer.valvesoftware.com/wiki/Steam_Web_API#GetOwnedGames_.28v0001.29

-1

You need to include the &input_json={"appids_filter":393380} at the end of the URL.

So your URL would be ("http://api.steampowered.com/IPlayerService/GetOwnedGames/v0001/?key=1470922A6B6E5C001546E51ACA5D987B&steamid=XXXXXXXXXXXXXXXX&format=json&input_json={"appids_filter":[393380]})

The JSON must be URL encoded as well. However if your profile is not set to public it will return an Internal Server Error from what I understand.

I could not get this to work because it kept sending me a 500 Internal Server Error. I used this documentation https://developer.valvesoftware.com/wiki/Steam_Web_API#Calling_Service_interfaces

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.