-
secresourcesAsked on August 25, 2020 at 12:30 AM
Hi support,
I recently came across this page: https://www.jotform.com/answers/1452433-Username-and-password-when-reading-Excel-report-from-Excel
When it discusses about the use of Web data in Excel's Power Query Editor. I'm attempting to do so too for my created HTML Report Listings:
https://www.jotform.com/table/202371065458050
However, I want this report to be locked behind a password.
I wanted to add that credential information in Excel. Is it possible?
-
secresourcesReplied on August 25, 2020 at 12:47 AM
Even if I removed the password, this error would occur:
DataSource.Error: The remote server return an HTTP status code '500' when trying to access 'https://www.jotform.com/table/202371065458050'.
Details:
DataSourceKind=Web
DataSourcePath=https://www.jotform.com/table/202371065458050
Url=https://www.jotform.com/table/202371065458050 -
Rosa_CReplied on August 25, 2020 at 7:16 AM
Hi, I'm happy to help you today.
Yes, it is possible to enable password protection for your HTML table report. Just go to My forms page-> select the form-> Click on Reports-> Click on the Pencil button to edit the report-> Enable the Password protection and enter the desired password.
If you already created a password and you're getting the error, please remove the HTML table report and create it again.
Let us know if you have further questions.
Thanks.
-
secresourcesReplied on August 25, 2020 at 12:07 PM
Hi Rosa,
Sorry that the answer was a little bit off from what I meant.
What I meant is, I wanted to use Excel's PowerQuery function to 'connect' to the HTML table listing, while having it password protected.
Is it possible?
-
Krishna_DReplied on August 25, 2020 at 3:16 PM
Unfortunately there is no such provision to connect with Power Query tool for using HTML table listing.
BTW,I was able to view the submissions on going to the given path that you provided.
Let us know about the issue if we were not able to grasp.
Feel free to contact.