Is there a way to include the password as a URL parameter on HTML reports?

  • sckuperman
    Asked on June 21, 2017 at 1:48 PM

    I set a report for my form.  It is of the HTML type.  I password protected it to make sure that others cannot see my data.  Also, I will not be able to keep private the numeric component of the report URL.  (I must make the number portion public to other users in an Excel spreadsheet.)

    I *CAN* hide the URL and the programming to use/access it, on my end.

    In order to access the HTML table without a lot of extra programming on my end, is there a way to feed the password into the URL so that VBA, JS, PHP, or other APIs can call the table from your server side, without first authenticating from Internet Explorer (for example)?

    How have you set up your cURL so that I can incorporate the password?

  • Support_Management Jotform Support
    Replied on June 21, 2017 at 2:46 PM

    I'm afraid it's not possible to use our API to fiddle around with the password since it's not included in the JSON response to begin with. You would only know whether the report is password protected or not.

    https://api.jotform.com/docs/#report-id

    Is there a way to include the password as a URL parameter on HTML reports? Image 1 Screenshot 20

    The good news is, it looks like you may use URL parameters to include the password in the URL.

    https://www.jotform.com/table/{reportID}?passKey={password}

    Where {reportID} is the ID of the HTML report you generated, and {password} being the password.

  • sckuperman
    Replied on June 21, 2017 at 3:16 PM

    AWESOME!  THANK YOU!