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

  • Profile Image
    Ann Olaguer
    Asked on December 21, 2020 at 04: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

  • Profile Image
    Mike_G
    Answered on December 21, 2020 at 06: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.

  • Profile Image
    Valor2461
    Answered on December 21, 2020 at 07: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]
    ...
  • Profile Image
    Mike_G
    Answered on December 21, 2020 at 08: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.

  • Profile Image
    Mike_G
    Answered 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.