Analytics

Hello - 

We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.

Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.

Has anyone had any experience setting up their connection that you would share? 

Many thanks!

Hey Kylie!

Thank you so much for the question! Just wanted to touch on the API documentation, the correct docs for our API is going to be here: https://live.prontoforms.com/api-docs and the base API URL will still be listening at: https://api.prontoforms.com/api/1.1/ 

That is one of the things that we did not update to TrueContext because there are a lot of existing workflows built out there so we didn't want to break anything like that.

When it comes to PowerBI, I would personally suggest that you push your data into a Sharepoint List and point PowerBI at the list to report from there. I have actually written a community post about doing just that, it is a high level overview on this topic but should shed some light on the topic: https://community.truecontext.com/discussion/ians-insights-ep-9-microsoft-lists-and-powerbi-what-to-do-with-your-data#bm2b921673-5a2b-4b28-a161-e2bfb8019215

Using the Sharepoint List as a place for all your data makes the ingestion and formatting of the data a little easier than pushing the submissions through with our API. If you are already using a List or Document Library as a destination for your forms, you can even just point PowerBI to a Document Library and report off the Custom Metadata that is associated.

I am also curious as to which endpoint you were trying to use and were unsuccessful with in regards to our API. 

I hope this helps and feel free to follow up with more details/questions!
Thank you

Hello - 

We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.

Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.

Has anyone had any experience setting up their connection that you would share? 

Many thanks!

Hi Ian - 

Thanks for responding to this - I did sent you a DM thanking you. I was wondering if you might be able to help me. We set up connections to SP Lists based on your recommendation - 2 of the lists populate as expected, however 2 of them constantly receive this error message:

I have a ticket open with support, but have not heard back from them in over a week. Anything you can provide that might give me some insight to this error would be greatly appreciated.

Thanks!

Hey Kylie!

Thank you so much for the question! Just wanted to touch on the API documentation, the correct docs for our API is going to be here: https://live.prontoforms.com/api-docs and the base API URL will still be listening at: https://api.prontoforms.com/api/1.1/ 

That is one of the things that we did not update to TrueContext because there are a lot of existing workflows built out there so we didn't want to break anything like that.

When it comes to PowerBI, I would personally suggest that you push your data into a Sharepoint List and point PowerBI at the list to report from there. I have actually written a community post about doing just that, it is a high level overview on this topic but should shed some light on the topic: https://community.truecontext.com/discussion/ians-insights-ep-9-microsoft-lists-and-powerbi-what-to-do-with-your-data#bm2b921673-5a2b-4b28-a161-e2bfb8019215

Using the Sharepoint List as a place for all your data makes the ingestion and formatting of the data a little easier than pushing the submissions through with our API. If you are already using a List or Document Library as a destination for your forms, you can even just point PowerBI to a Document Library and report off the Custom Metadata that is associated.

I am also curious as to which endpoint you were trying to use and were unsuccessful with in regards to our API. 

I hope this helps and feel free to follow up with more details/questions!
Thank you

Hello - 

We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.

Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.

Has anyone had any experience setting up their connection that you would share? 

Many thanks!

Hey Kylie,

Thank you for bringing this to our attention, we will respond to this via the support ticket for tracking purposes and post a response back here with the solution once the issue is resolved. Thanks for your patience. 

Hi Ian - 

Thanks for responding to this - I did sent you a DM thanking you. I was wondering if you might be able to help me. We set up connections to SP Lists based on your recommendation - 2 of the lists populate as expected, however 2 of them constantly receive this error message:

I have a ticket open with support, but have not heard back from them in over a week. Anything you can provide that might give me some insight to this error would be greatly appreciated.

Thanks!

Hey Kylie!

Thank you so much for the question! Just wanted to touch on the API documentation, the correct docs for our API is going to be here: https://live.prontoforms.com/api-docs and the base API URL will still be listening at: https://api.prontoforms.com/api/1.1/ 

That is one of the things that we did not update to TrueContext because there are a lot of existing workflows built out there so we didn't want to break anything like that.

When it comes to PowerBI, I would personally suggest that you push your data into a Sharepoint List and point PowerBI at the list to report from there. I have actually written a community post about doing just that, it is a high level overview on this topic but should shed some light on the topic: https://community.truecontext.com/discussion/ians-insights-ep-9-microsoft-lists-and-powerbi-what-to-do-with-your-data#bm2b921673-5a2b-4b28-a161-e2bfb8019215

Using the Sharepoint List as a place for all your data makes the ingestion and formatting of the data a little easier than pushing the submissions through with our API. If you are already using a List or Document Library as a destination for your forms, you can even just point PowerBI to a Document Library and report off the Custom Metadata that is associated.

I am also curious as to which endpoint you were trying to use and were unsuccessful with in regards to our API. 

I hope this helps and feel free to follow up with more details/questions!
Thank you

Hello - 

We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.

Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.

Has anyone had any experience setting up their connection that you would share? 

Many thanks!

Hello - 

We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.

Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.

Has anyone had any experience setting up their connection that you would share? 

Many thanks!

------------------------------
Kylie Clarke
Contracts Manager
Anderson Environmental Contracting
WA
------------------------------