Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

Connect Pipedrive to QlikSense

Hello everybody,

I want to create a dashboard in QlikSense with information from my pipedrive account. Is there a way to connect Qlik to Pipedrive without downloading manually an excel report?

Thanks in advance,

Pablo

3 Replies
JustinDallas
Specialist II
Specialist II

I think this would be more of a question for the folks at Pipedrive.  I did decide to look around though.  It appears they have a RESTful API that you can use.

Pipedrive API v1 Reference

With that in mind, you might be able to create a Web Folder connection, and download your data to a qvd that way with something like this.

https://companydomain.pipedrive.com/v1/deals:(id,title,value,currency)?api_token=YOUR_API_TOKEN

If the RESTful API doesn't work, you would probably have to resort to using something like Powershell to periodically make the request, and save the file which Qlik would then read.

cookiejest
Partner
Partner

Hey you can use cloudslurp to connect to pipedrive and then pull the whole data set of data (rather than individual pages of data) in one API call using the standard qlik REST connector. Cloudslurp keeps your api key alive, handles authorisation and pagination for you.

 

https://www.cloudslurp.com