topic Connecting QlikSense to the Toggl Reporting Tool in Integration, Extension & APIs

Connecting QlikSense to the Toggl Reporting Tool

jmalenfant — Fri, 26 Aug 2016 18:01:16 GMT

Hi,

I'm new to QlikSense and APIs but wanted to see if anyone has used the Qlik rest connector (or other methods) to connect to data in web applications like Atlassian Confluence or JIRA or the Toggl (www.toggl.com) time tracking tool?

For Toggl, the API only accepts JSON requests, so I'm not sure if the rest connector is the right approach or basically where to start. It would be great to know how others use these types data.

Thanks!

Re: Connecting QlikSense to the Toggl Reporting Tool

jmalenfant — Fri, 26 Aug 2016 19:32:53 GMT

I should have mentioned that I'm basically stuck in figuring out what to enter in the query parameters section for the variables I want to get out of the Toggl applicatio nhttps://github.com/toggl/toggl_api_docs/blob/master/reports/project.md

and what the syntax should be for a GET request

Re: Connecting QlikSense to the Toggl Reporting Tool

Fri, 03 Feb 2017 12:55:42 GMT

For example:

URL:

https://toggl.com/reports/api/v2/summary/

Timeout

Method

GET

+ Autodetect response time

Key generation strategy

Sequince ID

Use Windows authentication

User name

<empty>

Password

<empty>

+ Force basic authentication

Use certificate

Pagiation type

None

Query parameters

Name Value

user_agent <your account e-mail>

workspace_id <integer number from your account URL - https://toggl.com/app/reports/summary/xxxxxxx>

Query headers

Name Value

Authorization <Base64 encoded value (API token in your profile:api_token)>