viur-export-csv.py

# -*- coding: utf-8 -*-
import requests, argparse, sys, csv
from collections import OrderedDict

if __name__ == "__main__":

	host = "https://www.xxx.de/"
	sess = requests.Session()

	ret = sess.post(
		host + "/vi/user/auth_userpassword/login",
        data={
            "name": "xxx@xxx.de",
			"password": "xxx",
            "skey": sess.get(host + "/vi/skey").json()
        }
	)

	if not ret.ok:
		print("Unable to logon")
		sys.exit(1)

	count = 0
	cursor = None
	writer = None
	f = open("out.csv", "w")

	while True:
		ret = sess.get(host + "/vi/module/list", params={"cursor": cursor, "amount": 99}).json()
		if not ret["skellist"]:
			break

		cursor = ret["cursor"]

		if writer is None:
			writer = csv.DictWriter(f, [x[0] for x in ret["structure"]])
			writer.writeheader()

		for skel in ret["skellist"]:
			writer.writerow({k: v.encode("utf-8") if isinstance(v, basestring) else v for k, v in skel.items()})

		count += len(ret["skellist"])
		print("%d entries read so far" % count)

	f.close()

	print("All Done!")