Forum Discussion
Consuming K2 blackpearl workflow data
I report on my K2 Blackperal workflows in Power BI, but that OData API is only available for Appit, not Blackperal. I have created some SQL views that I might publish to the community when they are better.
Product documentation is at
https://help.k2.com/help#!/K2 blackpearl/4.7
under Developer Reference -> Reference Information -> Database Reference ->K2ServerLog database/schema ERD. I downloaded the Workflow Definition ERD and Workflow Reporting ERD.
I report on my K2 Blackperal workflows in Power BI, but that OData API is only available for Appit, not Blackperal. I have created some SQL views that I might publish to the community when they are better.
Product documentation is at
https://help.k2.com/help#!/K2 blackpearl/4.7
under Developer Reference -> Reference Information -> Database Reference ->K2ServerLog database/schema ERD. I downloaded the Workflow Definition ERD and Workflow Reporting ERD.
Thanks for your reply, I will try and give this method a go.
Regards,
Matt
Hi,
I was able to connect to the workflow data in Power BI. Thanks for helping me out. Also I don't mind imperfect SQL views ;)
Matthias93,
Glad to hear the issue is solved, you can accept appropriate reply as solution to close this thread.
Regards,
