Mindzai Wrote:I'm sure this must have been asked but my searching hasn't turned up the answer. Where can I find details of the available fields for methods such as VideoLibrary.GetTVShowDetails and VideoLibrary.GetEpisodeDetails please? I notice the GetMovieDetails fields are listed in the wiki but not most other methods.

Thanks

Montellese Wrote:Call JSONRPC.Introspect and study the answer. You will find all the available fields for the different methods there. If you don't know JSON schema yet (which is what JSONRPC.Introspect returns) this might help you understand better what you get back: http://tools.ietf.org/html/draft-zyp-json-schema-03

Mizaki Wrote:I've looked around and no one seems to have mentioned it. Something like:

RecentlyAddedAlbums
RecentlyAddedArtists
RecentlyAddedSongs

Is this planned?

Mizaki Wrote:Sort order desending doesn't appear to work.

Code:

{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { "sort": { "order": "descending" }, "limits": { "end": 10 } }, "id": 1}

The more basic:

Code:

{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { "sort": { "order": "descending" }}, "id": 1}

Returns the same as:

Code:

{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { "sort": { "order": "ascending" }}, "id": 1}

Or am I misunderstanding something?

topfs2 Wrote:If you give the outside world access to your mysql it is your setup not XBMC which gives access to it. The same if you give remote access to the sqldb file, its a big difference between YOU giving remote programs all access to the database and XBMC ALWAYS giving all access to the database. JSONRPC gives access based on what the client requests and on a per client basis, so a nfo editor may change the data but your phone may only read.

Also you should not assume it will either be sqlite or mysql, there have been talks about switching to other databases before and is something which is a likely scenario. Besides, forcing a client to write both for sqlite and mysql has been shown problematic (the differences are small but they are there). If you force a client to also write to couchdb or whatever because we switch to it for eden, it just becomes unmanageable. Why should the client _need_ to care for it, makes no sense.

You may use it for now but it is clear that giving full access to the database is not future proof, there is no room for arguing on that point. It is deprecated and will at some point be removed. If you wish to give full access to your mysql or sqlitedb file, this is your choice.

Cheers,
Tobias

vikjon0 Wrote:I totally understand the approach but will you support at least readonly SQL queries when the http api is removed? There will always be something missing and while adding it to the new api is the way to go that means quite some lead time if you develop add-ons for existing stable.

Assuming sql is only used while waiting for the next stable, changes to db model is not an issue since the code is only meant to be used in one version before being replaced with a api call.

topfs2 Wrote:No, if your missing something feature request it and we will add it proper instead. No point in allowing hacks, all that will do is make people reluctant to feature request.

vikjon0 Wrote:Yes, allowing hack will most likely have that effect.

So basically if I miss something for an add-on I log a request (or make a patch) and push the add-on to next stable?
How isolated is the api? Could it be an option in the future to release the api interface more frequently than core?

I guess one could just make a hack un-official add-on and clean it upp next stable.

billylg Wrote:Hi Newbie here,
Got a question on using Json RPC. I am trying to figure out how to make JSON RPC calls for a project. I am using the Simple REST client on chrome to test the request and response. I could quite figure out how to get audio playing. The request I sent is the following:

{ "jsonrpc": "2.0", "method": "XBMC.Play", "params": {"name": "C:\music.mp3", type: "audio"}, "id": 1 }

And the response I got back is:

{"error":{"code":-32700,"message":"Parse error."},"id":null,"jsonrpc":"2.0"}

Can someone tell me what I am doing wrong? Thanks for the help!

billylg Wrote:Hi Newbie here,
Got a question on using Json RPC. I am trying to figure out how to make JSON RPC calls for a project. I am using the Simple REST client on chrome to test the request and response. I could quite figure out how to get audio playing. The request I sent is the following:

{ "jsonrpc": "2.0", "method": "XBMC.Play", "params": {"name": "C:\music.mp3", type: "audio"}, "id": 1 }

And the response I got back is:

{"error":{"code":-32700,"message":"Parse error."},"id":null,"jsonrpc":"2.0"}

Can someone tell me what I am doing wrong? Thanks for the help!

Manromen Wrote:Does something changed for the recent linux nightly builds (20110606)?
We have a Trakt Utilities addon user reporting issues with the following call not returning a tvshowid:

{'jsonrpc': '2.0', 'method': 'VideoLibrary.GetTVShows','params':{'fields': ['title', 'year', 'imdbnumber', 'playcount']}, 'id': 1}

Edit:
He uses a mysql database.