topic Re: How to get data from WunderList in QlikView

How to get data from WunderList

stantrolav — Fri, 16 Sep 2016 10:31:43 GMT

Hi there!

Simple question:

How can I get data from Wunderlist?

I want to get such field as:

TaskID

DateOfTask

DateOfTaskReminder

ThemeOfTask

DetailsOfTask

MarkOfTaskCompletion

ListIDOfTask

ListNameOfTask

FolderOfList

Using that field would help me to control life better in personal analytics. Help me to find the way to get data.

Wunderlist | To-do list, Reminders, Errands - App of the Year!

Wunderlist Developer

Re: How to get data from WunderList

Anil_Babu_Samineni — Fri, 16 Sep 2016 16:47:51 GMT

Where you want to see this?

Re: How to get data from WunderList

stantrolav — Mon, 26 Sep 2016 08:27:24 GMT

I want to enter my profile in wounderlist and get data from it to qlikview table.

Re: How to get data from WunderList

stantrolav — Wed, 28 Sep 2016 08:39:57 GMT

I found some kind of solution. I can get information from .ics calendar of my account. Link to it can be taken from account page of Wunderlist.This link can be used as web-data.

Information from .ics calendar consists of several near events that have future date.

I still can't get full information from Wunderlist

Re: How to get data from WunderList

v_petrenko — Wed, 23 Nov 2016 15:19:00 GMT

Stanislav, the same idea came to me and I've successfuly accomplished it with the help of recently published Qlik REST Connector, which is completely free.

Here are the steps to make:

Obtain and install Qlik REST Connector. You can download it from Qlik Customer Downloads section.
Make necessary preparations on Wunderlist site.
1. Create a new App under your account at Wunderlist Developer site.
2. Get a "Client ID" and an "Access Token" codes for this newly created App (the latter is created by pressing "create access token" button).
Study Documtation section on the site and decide which Endpoints you're going to use. I suggest that you start with "User" for initial connection efforts.
Open "REST connection" dialog from QV script Data pane and enter following credentials there:
- URL: https://a.wunderlist.com/api/v1/{ENDPOINT} - replace {ENDPOINT} with "user" or another endpoint.
- User name and password: your Wunderlist account.
- Query Headers section (name : value pairs):
  - X-Access-Token : {the "Access Token" code which you've got on step 2.2}
  - X-Client-ID : {the "Client ID" code which you've got on step 2.2}
Test the connection, and if everything is fine, proceed with OK, then go to Select dialog from Data pane.

Wunderlist Data model is rather straighforward, no sense to describe it here.

Please mark the answer Correct and your answer as Answered if my recommendations would help.

Some useful resources I've studied before finally made the case:

Create a REST connection ‒ Qlik Connectors

GitHub - wayneashleyberry/wunderline: A command-line client for Wunderlist, the easiest way to get stuff done.