Credential Input Issue for HTML Table Listings

  • Profile Image
    secresources
    Asked 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?

  • Profile Image
    secresources
    Answered 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

  • Profile Image
    Rosa_C
    Answered on August 25, 2020 at 07: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.

    15983539507.gif

    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.


  • Profile Image
    secresources
    Answered 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?

  • Profile Image
    Krishna_D
    Answered on August 25, 2020 at 03: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.

    1598382910DeepinScreenshot_select-area_2

    Let us know about the issue if we were not able to grasp.

    Feel free to contact.