Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[laerm]

Hi all –

Is there a way to export a field? I could make a view that only has that field in it, then export that playlist with "only visible fields" selected, but I was wondering if there was a more straightforward way.

Thanks –
Micah

[MrC]

That's the way.

Or you could use MCWS to retrieve it.

[laerm]

Then onward ho for me.

Gracias –
Micah

[MrC]

De nada.

Note I edited my post shortly afterwards - you may not have seen the MCWS comment.

[laerm]

I didn't; I was too quick on the draw.

I'll play with MCWS a bit, too. I'm trying to grab all lyrics by an artist, and it looks like you can't really filter, but I'll see...

Micah

My turn to edit: looks like I can do it. Thanks!

[MrC]

Here's the idea:

    http://192.168.2.20:52199/MCWS/v1/Browse/Files?Action=mpl&ActiveFile=-1&Zone=-1&Fields=Lyrics&ID=1

You'll get also the FileKey, so the MPL list will include even files without Lyrics.  But you could pre-filter your list of File Keys first with a Search Query on files with non-empty Lyrics.

[laerm]

Interesting. The doc says URLs go
http://.../MCWS/v1/Library/Values
but yours is
http://.../MCWS/v1/Browse/Files

What's the difference there?

Also, it looks like you're generating a playlist. Take out the 'Action=' statement and it just displays in browser, right? I.e. that's the "default" action?

[MrC]

I used the Browse interface, just so I didn't have to lookup any FileKey's or do any Queries, just as a demo it can be done.  Use which ever is easiest.

Yup, the Action here is unnecessary for our purposes.  You get an MPL with Browse.

[MrC]

If you use:

   http://localhost:52199/MCWS/v1/Library/Values?Field=Lyrics

You'll get all your Lyrics, but no associated Filename.  To get more Fields, you have to use the Filter parameter too.

[laerm]

I used the Browse interface, just so I didn't have to lookup any FileKey's or do any Queries, just as a demo it can be done.  Use which ever is easiest.

Yup, the Action here is unnecessary for our purposes.  You get an MPL with Browse.

Got it. Makes sense to me.

If you use:

   http://localhost:52199/MCWS/v1/Library/Values?Field=Lyrics

You'll get all your Lyrics, but no associated Filename.  To get more Fields, you have to use the Filter parameter too.

Aha, yep, and that was what I was just working on. Trying to get the filter to apply to the right field now, as it seems to be stuck on filter [Name] and not [Artist].

http://192.168.1.113:52199/MCWS/v1/Library/Values?Field=Artist&Filter=Eno&Field=Lyrics

EDIT: duh, it is filtering the lyrics and not artist. Is there a hierarchy of the & elements, or some kind of nesting? I tried other orders and other text, all filter lyrics only. (But if I leave the &Field=Lyrics off, Artist filters properly.)

[MrC]

I think you want a Fields=Artist,Lyrics approach, not multiple Fields parameters.  I'm not sure this solves the issue.

[laerm]

You are absolutely correct. Thanks!

Micah