Microsoft Power BI is an interactive data visualisation software product developed by Microsoft with a primary focus on business intelligence.
​
You can now send data from Recruiterflow to PowerBI and make custom reports.
​
To integrate Recruiterflow and PowerBI, you need to do the following :
​
The first step is to get your API Key from Recruiterflow :
​
​Here is how you can get you API Key :
​
Go to the settings page from the top right corner and then click integrations as shown below :
​

Once you are on the integrations page you will see the PowerBI section
​
From here you can copy the authentication key (API key) for your account for you to be able connect Recruiterflow to PowerBI.
​

After obtaining your API key :
.
The second step is to go on the toolbar click on 'Get Data' and from the dropdown select the 'Blank Query' option
This will open up a new query editor.
​
​

Once you open the blank query, paste the desired function

from our query documentation in the section shown below:
​
​

In the example above we have pasted the function to fetch candidate data.
​
To replicate the same : In the query editor area, paste the below function to get all the candidates data

let

headers = [#"powerbi-api-key" = <api key that you created in step 1>],

Source = Json.Document(Web.Contents("https://recruiterflow.com/api/integrations/feed/power-bi/candidates" & "?items_per_page=100&current_page=1",[Headers=headers, Query=[current_page=Number.ToText(current_page)]]))

in

Source

After pasting the function, please replace : <api key that you created in step 1>

with your API key from Recruiterflow.

To get all the candidates

Once the function is pasted with your API key, you can check if it's working by doing the following :
​
You can pull data for a particular page and to do so you need to enter a page number in the 'current_page' box as shown below :
​

Once you add a page number, for eg '1' then you can invoke the function. Once you invoke the function you will see as below :
​
​

And once you click on the 'list' you will be able to see all the records from page 1 :
​
​

This function allows you to pull data page by page. Each page will have 100 records.
​
To automatically pull all pages in a loop you can use the pagination function after the previous set up.

Pagination Function :
​

API pagination refers to a technique used in API design and development to retrieve large data sets in a structured and manageable manner. When an API endpoint returns a large amount of data, pagination allows the data to be divided into smaller, more manageable chunks or pages
​
After creating the function in the previous section, click on 'New Source' in the toolbar, and create another blank query.
​
​

in the query field, paste the below code to paginate and get all the candidates data to your data model.

For paginating candidate API

= List.Generate(

() => [current_page = 1, candidate = FnGetCandidates(current_page)],

each not List.IsEmpty([candidate][data]),

each [current_page = [current_page] + 1, candidate = FnGetCandidates(current_page)],

each [candidate]

)

Pagination will essentially help you pull all the records (all pages of your data) automatically.
​
​

Current data points sent from Recruiterflow to PowerBI

​