QlikSense & BambooHR integration

NarBI — Thu, 28 Apr 2022 11:41:04 GMT

Hello,

I want to build dashboard based on data coming from BambooHr.

Could you help me please how to make this connection. which connector shoul I use ?

Thank you

Re: QlikSense & BambooHR integration

Hatus — Mon, 02 Oct 2023 13:14:57 GMT

You will need a REST connection with GET methode.

In the BambooHR you need an API Key generated with an admin account.

Important settings:

Authentication -> Authentication Schema = Basic

User name = {API key provided}

Password = just leave empty

Query headers = Accept application/json

CUSTOM CONNECT TO "provider=QvRestConnector.exe;url=https://api.bamboohr.com/api/gateway.php/{myCompany}/v1/employees/directory;timeout=30;readwritetimeout=300;method=GET;httpProtocol=1.1;isKeepAlive=true;bodyEncoding=UTF-8;sendExpect100Continue=true;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;XMLDTD=0;authSchema=basic;serverCertificateValidation=None;checkCertificateRevocation=false;useCertificate=No;certificateStoreLocation=LocalMachine;certificateStoreName=My;queryParameters=format%2json%1;addMissingQueryParametersToFinalRequest=false;queryHeaders=Accept%2application/json%1;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;isCookieContainerEnabled=false;useProxy=false;proxyBypassOnLocal=false;proxyUseDefaultCredentials=true;"

Have fun!

Hatus Peters