Export a list of all created forms

  • Railtrain
    Asked on March 27, 2018 at 4:29 AM

    I need to list all our JotForms on our intranet so that people can go there, click on the name of the JotForm and be directed to it to submit.  

    Is there a way to export this in an excel document or the like, or do i have to do it one by one by writing my own list and grabbing each individual published link to add to it?

    See screen shot of how i have started the list, atm people can click and it takes them there but i need an update list, and i cannot export it out of our intranet to do it so would like to be able to do it from our JotForm account direct.

    Jotform Thread 1426813 Screenshot
  • york
    Replied on March 27, 2018 at 10:24 AM

    You can get the data related to your forms (title, URL etc.) in JSON format using our API.

    If you write https://api.jotform.com/user/forms?apiKey={apiKey} to your address bar and replace {apiKey} with your API key, you can view your forms. You can get your API key here https://www.jotform.com/myaccount/api

    1522159861apikey Screenshot 10

    Here is the page you view after entering that address.

    1522159930raw Screenshot 21

    You can make this page more readable if you use an extension that prettifies JSON data. I used an extension called "JSON Formatter" for Google Chrome.

    1522160236json Screenshot 32

    Please note that all your forms including the deleted ones are displayed here. You can configure the address to only get forms with status "ENABLED": https://api.jotform.com/user/forms?apiKey={apiKey}&filter=%7B%22status%22%3A%22ENABLED%22%7D&orderby=id

    For more info about our API, you can check http://api.jotform.com/docs/ 

    I read cURL documentation to get these URLs.

    1522160574curl Screenshot 43