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

  • Profile Image
    sckuperman
    Asked on June 21, 2017 at 01: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?

  • Profile Image
    Jim_R
    Answered on June 21, 2017 at 02: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

    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.

  • Profile Image
    sckuperman
    Answered on June 21, 2017 at 03:16 PM

    AWESOME!  THANK YOU!