Post

2 followers Follow
0
Avatar

Integration of Clarizen with Qliksense (BI tool) using API

I am trying to integrate/connect Clarizen with Qliksense (a BI tool) using REST API / Web Service API. What I achieved now is to log in with credentials and get a response of session ID.I want to access to the entire database in Clarizen and connect it into Qliksense but what I found on the documentation pages are specific queries to get certain data. Anybody knows how to achieve this? Many thanks!

 

(Attached is the REST connector on Qliksense to connect to data sources. I don't know which url to use to access to the entire data source of Clarizen)

Cheryl Answered

Official comment

Avatar

Hi Cheryl,

It is not possible to get all the database in one API call. You can get data from a specific table by using the https://api.clarizen.com/V2.0/services/data/Query endpoint. Example: 

POST https://api.clarizen.com/V2.0/services/data/Query

{"Q":"SELECT Name,Work FROM Project WHERE DueDate<'2021-01-01' AND StartDate>'2020-01-01' LIMIT 1000 OFFSET 0"}

This would get the first 1000 projects matching the filter (DueDate<'2021-01-01' AND StartDate>'2020-01-01') and return their Name and Work.

Documentation: https://api.clarizen.com/V2.0/services/data/Query

I hope this helps.

Roland

Roland Pumputis
Comment actions Permalink

Please sign in to leave a comment.

1 comment