How do I password protect my data feed in a way which is compatible with automation?

  • Profile Image
    SVLL
    Asked on April 24, 2012 at 05:24 PM

    We need to wire up processes on our backend to process data from Jotform submissions.  The challenge today is that all of the report options either offer downloadability with no credentials, or the usage of a password which is furnished to Jotform in the form of a post-back.

     

    Now, before I go and write some "HTML POST handler" in powershell or .NET to accomplish that, Is there another way to utilize standard HTTP challenge credential mechanisms which would work natively with Access, Excel, or SQL Server Intergration Services?  We deal with PII and I cannot compromise on security so "security through obscurity" is not an option.

     

    Thanks!

    /Ty

     

  • Profile Image
    jonathan
    Answered on April 25, 2012 at 08:41 AM

    Hello,

    Can you please provide us a more simplied scenario on what it is we wanted to achieve?
    I wanted to help but I am a bit lost on some of the technical jargons. =)
    Perhaps you can simplify why we cannot use secure form, or password protected reports, or using captcha.

    Thanks. 

  • Profile Image
    SVLL
    Answered on May 03, 2012 at 01:27 AM

    I am just looking for basic authentication on a web resource.. http://en.wikipedia.org/wiki/Basic_access_authentication .  When I go into Excel and try to "import from web" it gives me an option to provide a userID / password or password only authentication.  When it connects to the resource, it uses these credentials to satisfy the authentication challenge.

     

    The problem is that the authentication used by Jotform appears to be an HTML page with a password field.  Excel (or other data connections) dont know how to handle that.

     

     

  • Profile Image
    jonathan
    Answered on May 03, 2012 at 04:32 AM

    Hello SVLL,

    Thank you for updating us.

    You are correct. I think it is far more complicated to use the JotForm reports as web resouce with automation due to the reports being proprietary in nature. If you are going to create an interface for the reports, you will probably need to have the source code of the reports before you can program them.

    But I think you can also create your own data feed as web resource by collecting the data as soon as they are submitted from the form. Please check on this guide How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP .

    It maybe on MySQL or PHP, but I believe this are also applicable on other programming langauges.

    What is immediately viable is to just used the JotForm reports as is, and publish them with manual intervention.

    Hope this help provide some insights. Please contact us should have other concerns on JotForm.

    Thanks.