So I need to create an API connection to Personio (a company Human Resource tool), where I obtain specific data about employees.
I have a Client-ID for that API, as well as a API-Secret (which I assume is the API Key). Also, I have done some minor previous work with API connection to Jira and NewRelic, both methods dont work here.
A reason for this is what a developer told me, that first an authentication needs to take place, before the data can be requested. Meaning that there is 2 different enpoints which need to connected to according to the Personio documentation.
I have listed their POSTMAN information below of how the authentication runs and then the custom attribute endpoint.
I need to get that data into PowerBI somehow and would truly appreciate any help here. I have already gone through the forums to test various answers on API connections, but no success.
Thank you to anyone who can help here!
Personio POSTMAN Documentation:
"item": [
{
"name": "Authentication",
"item": [
{
"name": "Auth Endpoint",
"event": [
{
"listen": "test",
"script": {
"exec": [
"var data = pm.response.json();",
"var token = data.data.token;",
"",
"if (token) {",
" pm.environment.set(\"authToken\", token);",
"}"
],
"type": "text/javascript"
}
}
],
"request": {
"auth": {
"type": "noauth"
},
"method": "POST",
"header": [],
"url": {
"raw": "https://api.personio.de/v1/auth?client_id=XXXXX&client_secret=XXXXX",
"protocol": "https",
"host": [
"api",
"personio",
"de"
],
"path": [
"v1",
"auth"
],
"query": [
{
"key": "client_id",
"value": "XXXXX"
},
{
"key": "client_secret",
"value": "XXXXX"
}
]
}
},
"response": []
}
]
"name": "Get All Custom Attributes",
"event": [
{
"listen": "test",
"script": {
"exec": [
"var authHeader = pm.response.headers.get(\"authorization\");",
"",
"if (authHeader) {",
" pm.environment.set(\"authToken\", authHeader.substring(7));",
"}"
],
"type": "text/javascript"
}
}
],
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "https://api.personio.de/v1/company/employees/custom-attributes",
"protocol": "https",
"host": [
"api",
"personio",
"de"
],
"path": [
"v1",
"company",
"employees",
"custom-attributes"
]
}
},
"response": []
},
{
"name": "Get All Attributes",
"event": [
{
"listen": "test",
"script": {
"exec": [
"var authHeader = pm.response.headers.get(\"authorization\");",
"",
"if (authHeader) {",
" pm.environment.set(\"authToken\", authHeader.substring(7));",
"}"
],
"type": "text/javascript"
}
}
]
