How do I use the columns perameter in the playlist items API endpoint?

[cowardlycamper32]

when I send a request to 127.0.0.1:8880/api/playlists/p1/items/0:5?columns=Track Title,Track Artist the data I recieve is this

{
    "playlistItems": {
        "items": [
            {
                "columns": [
                    "Track Title",
                    "Track Artist"
                ]
            },
            {
                "columns": [
                    "Track Title",
                    "Track Artist"
                ]
            },
            {
                "columns": [
                    "Track Title",
                    "Track Artist"
                ]
            },
            {
                "columns": [
                    "Track Title",
                    "Track Artist"
                ]
            },
            {
                "columns": [
                    "Track Title",
                    "Track Artist"
                ]
            }
        ],
        "offset": 0,
        "totalCount": 1062
    }
}

My question is, what are you supposed to include in the columns paremeter? Why does the items columns just return an array of what I put in? what am I doing wrong?

[cowardlycamper32]

answered myself by checking the web server settings page, you use %title% for the title ect. ect. Some clarification on the API documentation on this would be nice however.

[hyperblast]

Hi,

all column expressions use title formatting syntax.

If you are going to write complex expression note that additional escaping must be performed:

• , should be passed as \, (plain comma is an array item separator)
• \ should be passed as \\

Since all these values go to URL the resulting string should be URL escaped, but probably you've already figured this out.