Problems importing contacts using JotForm C# API

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

Unfortunately, I am not having C# knowledge. Do you mean to read the submissions of a form using API? Did you take a look at our API documentation that is provided with Sample data and it might help in writing the code as per your requirement.

Meanwhile, I'll check with my team members if we have anyone with C# knowledge who can help you with the issue. Please provide us with more information of the issue that you are experiencing that can help us in providing you with necessary assistance.

Thank you!

Maria

Answered on December 15, 2016 at 09:16 AM

With c# jot form API I can get all the submission and the answers

I did a program that get all the informations I need

but when I cicle the submissions and then when I cicle the answers of all the submissions I get Just some contact but not all of them

If I extract the Excel of a specific submission from Jotform I get some contact more

Thanks

JotForm Support

Kiran

Answered on December 15, 2016 at 09:32 AM

I understand that you are getting the form submissions using API and you are looping the submissions. Do you mean to say that the looping of the submissions is not working?

Could you provide us with the complete code that you are using to loop the submissions to take a look?

I CHECKED IF THE PROBLEM WAS IN THE DATE BUT I DO NOT FIND ANY DIFFERENCE BETWEEN THE CONTACT EXTRACTED AND THE CONTACT I DO NOT FIND

IF YOU NEED I CAN GIVE YOU SONE EXAMPLES

THANKS

MARIA

Boris

Answered on December 16, 2016 at 05:55 AM

Thank you for providing your script and the form in question (60704494096359).

Can you please provide an example contact that you cannot find, as well as an example contact that you are able to find? This is so that we can compare the recorded data whether there may be differences in this data within your submissions, and check for possible causes of the issue you are experiencing.

Looking forward to your response. Thank you!

Santoshk

Answered on December 16, 2016 at 06:24 AM

Problem still exists. Sharing the latest submission after updating the url shared by you.

There was Employee Name as Santosh Kumar andEmployee Code/AD IDas 900980. But when i used the prepopulate link. Both these fields are not reflected.

I have hilighted both the cases as the same was blank in the link received.

Boris

Answered on December 16, 2016 at 06:32 AM

@Santoshk, you have replied on another person's support thread regarding a totally different topic. For this reason, and so we can assist you with your own issue as well, your post has been moved to a support thread of your own:

limit (Number)Number of results in each result set for form list. Default is 100. Maximum is 1000.Example: 30

I see that submissions from lino.b69@libero.it are 96 and 97 of your last received submissions, while submission from g.daddino@virgilio.it is 286. If you are calling for submissions through API without specifying the limit parameter on your call, it will only return up to 100 submissions.

Please make sure you adjust your call and increase the "limit" parameter in your API call.

Similarly, and described in the same section of our documentation, you can perform your desired filtering by date directly on the API call:

Please try making these adjustments, and let us know how it goes. Thank you!

/// <param name="formID">Form ID is the numbers you see on a form URL. You can get form IDs when you call /user/forms.</param>/// <param name="offset">Start of each result set for form list. (optional)</param>/// <param name="limit">Number of results in each result set for form list. (optional)</param>/// <param name="filter">Filters the query results to fetch a specific form range.(optional)</param>/// <param name="orderBy">Order results by a form field name. (optional)</param>/// <returns>Submissions of a specific form</returns>

The filter "created_at:gt":"2016-10-10 00:00:00" will get all submissions made since 2016-10-10 00:00:00, which is what I believe you were after originally.

Please first try out the above mentioned call with a hard-coded filter in a string, and if it works correctly based on your needs, then you can proceed on modifying your script further to use your date variables inside the filter instead of the hard-coded string.

In any case, customization of your own code is unfortunately outside of the scope of our technical assistance, so I would recommend going through our API documentation if you need further understanding of how to use the API. Additionally, for specific questions about anything that might look vague in our API documentation, you may want to reach out to our dedicated API team:

They will be happy to provide clarifications if any is needed about some part of the API, but same as our technical support in the forum, please do not expect for the API team to assist with actual script building. We only provide the API so you can use your own programs to access the data programmatically.

Thank you.

pagine

Answered on December 19, 2016 at 09:33 AM

there should be something wrong in the sintax because visual studio doesn't accept this string

We do apologize for the provided custom coding giving you further problems with your c# request but, unfortunately as Boris stated much of this requires deeper programming knowledge that what some of our technical support team is able to provide currently other than looking at it when we can.

It is recommended to send our api team an email as suggested above to api@jotform.com and our API Team will then put you in touch with one of our devs that can likely assist you with it further.

Additionally, I'll meet you half way on this subject by mentioning your thread here to our API Team on your behalf so that we can try to help you out more with it.