What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    What's the format/trick to programmatically calling the RSS Feed URL and passing the password

    Asked by MStepan on March 05, 2016 at 10:33 AM

    We've created a few web forms that are now collecting data. That's all working great, and JotForm makes this pretty easy. We've also created an RSS Feed so that we can retrieve the submissions. Due to the content on the forms, we needed to set a password on the RSS Feed. I'm struggling to pass that password programmatically to the RSS Feed URL. I'm using VBA. Here's what I have, which I have to believe is only the right tweak away, but I don't know how to include the password to prevent the pop-up:

    Function GetHTTPResponse(url As String) As String

    Dim msXML As Object

       Set msXML = CreateObject("Microsoft.XMLHTTP")
      
       With msXML
          .Open "Get", url, False
          '.Open "Get", url, False, "", "thepassword" '(this did not work)
          '.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
          '.setRequestHeader "Authorization", "Basic thepassword" '(this did not work)
          .send
          GetHTTPResponse = .responseText
       End With
      
       Set msXML = Nothing

    End Function

    Any ideas, thoughts, comments, etc, would be appreciated.

    Thanks, Mark

     

    rss feed format and Submissions web forms JotForm
  • Profile Image
    JotForm Support

    Answered by Boris on March 05, 2016 at 08:12 PM

    Hey Mark, could you please try using the link with the passKey URL parameter.

    For example, if your RSS feed was behind the following URL:

    https://www.jotform.com/rss/12345

    And if your password was test12

    You would be using the following link to access the RSS feed directly:

    https://www.jotform.com/rss/12345?passKey=test12

    Please try it out, and let us know how it goes. If you run into any issues along the way, we are here to help. :)

  • Profile Image

    Answered by MStepan on March 05, 2016 at 08:27 PM

    THANK YOU Boris!!! I had the feeling it was a syntax issue. I tried a couple variations that I saw on the net, but obviously not that one. It worked like a charm. Thanks again for your help!!!

  • Profile Image
    JotForm Support

    Answered by Boris on March 05, 2016 at 09:37 PM

    You are most welcome, Mark, glad it helped. If you ever run into a similar issue in the future, you can try right-clicking on the password field and using your browser's Developer Tools to inspect the element.

    It will show the password field's name, which can usually / sometimes be used as an URL parameter. Here is how inspecting the password field on the RSS Report looks like:

    If there is anything else we can help you, we are always just a support thread away.