import json
import requests
import pandas as pd
import csv
from pprint import pprint

auth = "Bearer " + "BQDjWiV3Phqr3AcwZxAlXVIaKadlORfbGGShWAUsUuycKjKsQL9NysqgO23fWqS8z46RDi0Emdch03H69RDHR9HnpMG-Ne_8-ocd3wtbizMrRauU9k9BMKUXP_tHuQMaOhUqWwyLz8i3Mw"
user_id = 'spotify'

response = requests.get('https://api.spotify.com/v1/users/' + user_id + '/playlists?offset=0&limit=50', headers={"Authorization": auth})

data = response.json()

#print data

ids = []




total_playlists = data.get("total")
print total_playlists , "total playlists from user " + user_id

for offset in range (0, total_playlists, 50):
	#print offset 
	response = requests.get('https://api.spotify.com/v1/users/' + user_id + '/playlists?offset={}&limit=50'.format(offset), headers={"Authorization": auth})
	data = response.json()
	
	for item in data:
		ls = data.get("items")
		for n in range(len(ls)):
			id = ls[n].get("name")
			if id not in ids: ids.append(id)

pprint(ids)

import csv

ids = [x.encode('utf-8') for x in ids]
	
with open('spotify_owned_playlists.csv', 'wb') as myfile:
    wr = csv.writer(myfile, quoting=csv.QUOTE_ALL)
    wr.writeco(ids)