De kolom employee_id is niet gevuld in Power BI in EmployeeTargets.
Is deze data niet beschikbaar of is het een bug?
Volgens de documentatie van Gripp CRM zou deze kolom waarden moeten hebben, maar in de bestudeerde omgeving (met circa 100 rijen) is er niet één met data voor het zogenaamde “employee”-object). De waarde van employee_id ontbreekt dus volledig.
Dit lijkt een discrepantie tussen de API-documentatie en de werking te zijn. Advies is om een storing te melden bij Gripp CRM op de API.
| Aspect | Waarde |
|---|---|
| URL | API Docs 3.0 |
| Tabel | GrippCrm…EmployeeTargets |
| Methode | POST |
| Automatic decompression | All |
| Maximum automatic redirections | 50 |
| Maximum response headers length | 64 |
| Protocol version | 1.1 |
| Timeout | 300.000 ms |
| Continue Timeout | 350 ms |
| Read/write Timeout | 300.000 ms |
| Send chunked | False |
| Request header Accept | application/json |
| Request header Authorization | Bearer secret |
| Request header Content-Length | 120 |
| Request header Content-Type | application/json; charset=utf-8 |
| Request | [{“method”:“employeetarget.get”,“params”:[[],{“paging”: “firstresult”:0,“maxresults”:250},“orderings”:null}],“id”:null}] |
| Header Date | Tue, 27 Sep 2022 17:17:09 GMT |
| Header Server | nginx |
| Header Strict-Transport-Security | max-age=31536000; includeSubDomains |
| Header Transfer-Encoding | chunked |
| Header X-RateLimit-Limit | 1000 |
| Header X-RateLimit-Remaining | 1000 |
| Header X-Robots-Tag | noindex |
De JSON-inhoud bevat geen verwijzing naar employee:
[{"id":null,"result":{"rows":[{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":null,"targetbillability":0,"id":1},{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":"123.00","targetbillability":60,"id":2},{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":"123.88","targetbillability":80,"id":3},{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":"123","targetbillability":40,"id":4},{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":"123","targetbillability":60,"id":5},{"year":2022,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":"123","targetbillability":70,"id":6},...
{"year":2021,"targetsales":null,"targetrevenue":null,"targetgrossprofit":null,"targethourlyrate":null,"targetbillability":90,"id":96}]
,"count":96,"start":0,"limit":250,"next_start":250,"more_items_in_collection":false},"error":null}]
Ik zal dit melden bij Gripp.
1 like