Pass data via API: not able to grab all the data that's in the forms

  • Ann Olaguer
    Asked on December 21, 2020 at 4:52 PM

    I have a question regarding accessing data through API. We use a BI Tool and we have the connection via API to Jotform setup however, it seems that we are not able to grab all the data that's in our forms. Is this a limitation? Does the system limit how much data we can call?

    We'd like to essentially grab all the data that's in our forms so we can match it with our internal software to validate the submissions.

    Thank you,

    Ann

  • Mike_G JotForm Support
    Replied on December 21, 2020 at 6:58 PM

    We will be glad to help you with your concern. Can you please tell us which form in your account you are having the issue you have described, please? Also, can you tell which field data are not being passed to your BI Tool via API, please?

    We will wait for your response.

  • Valor2461
    Replied on December 21, 2020 at 7:22 PM
    It’s all three forms that we have.
    * Refill/Transfer RX
    * Order RX
    * Prescribe
    The data only pulls 20 Rows of Data for each form.
    Thanks,
    Ann
    -Ann Olaguer
    [cid:alfin_a50f33e2-a818-478f-86a1-3d324bf5cd12.jpg]
    Ann Olaguer
    Director of Business Initiatives & Client Account Manager
    2461 Shattuck Ave, Berkeley, CA 94704
    P: 510.548.8777 | F: 510.548.0305
    M: 510.561.9189 | E: aolaguer@vcprx.com
    [cid:SocialLink_Facebook_32x32_073af1f8-8dd4-4bbd-bcfb-2e46451c1baf.png][cid:SocialLink_Linkedin_32x32_5af2f7f5-622e-41c7-b42d-cb0db88e82b5.png][cid:SocialLink_Twitter_32x32_fcd89a09-e2d7-4a9e-bea5-d7442e7bf210.png][cid:SocialLink_Instagram_32x32_2bc8bea3-36a8-4a42-8e4f-d1279e1ea0d6.png]
    [cid:INC-5000-PNG-Recoveredresized2_a5974534-b97c-4fbf-a936-37cec2206850.png][cid:PCABGoldSealofAccreditation-CMYKresizedfinal_2bb7da55-60a5-4c04-8a1a-47944cc58ceb.jpg]
    ...
  • Mike_G JotForm Support
    Replied on December 21, 2020 at 8:29 PM

    Please allow me some time. I will be checking the issue you are having on my end further. I will update you on this ticket as soon as I have my findings.

  • Mike_G JotForm Support
    Replied on December 22, 2020 at 12:30 AM

    We would like to apologize for any inconvenience. There is a limit to the amount of data you can pass via API. The default limit is 20. However, you can increase the limit by adding a "limit" parameter to the URL.

    Here's an example:

    https://api.jotform.com/form/123456789101112/submissions?apiKey=1b*****68*****de*****e0*****d3**&limit=40

    Please give it a try and let us know if you need any further assistance.