API de Jotform: fecha de envío y recuento de columnas

Hola, buenas tardes equipo,...

por favor su amable ayuda...

Lo primero

estoy conectándome por API a mis tablas pero tengo algunas que tienen más de 160 columnas, entonces, les quería preguntar si tengo alguna manera de conocer el número de la columna de mi tabla para poder recoger el dato desde mi consulta local.

Lo segundo, en referencia a lo mismo. ¿como debo ir a buscar los datos de fecha que están con calendario en Jotform desde mi sistema ?

eso es,... saludos y gracias por su amable trabajo.

Hi Miguel,

Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

As for your issue, I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Hi Miguel,

If I understand correctly, you want to count the number of columns on your table and then get the date of the submission using an API. Is that right? If so, you can use our API call to get your form submission. You can use the API call URL format below:

https://api.jotform.com/form/{formID}/submissions?apiKey={apiKey}

Once you have the submission data, you can use a JavaScript command to count the number of columns in the submission data by counting the JSON objects under "answers" object, but first you need to parse your JSON data and then append the Length property to it. You can visit this Stack Overflow guide to learn more about it. I've triggered a sample API call for demonstration. Check out the screenshot below:

As you can see, the submission columns are under the "answers" object. As for getting the date of submission, you can create a loop to find the date object on your JSON data. You can visit this Stack Overflow guide to learn how to create a loop with an array of JSON objects using JavaScript. The date of your submission is indicated in the "created_at" object of your JSON data. Check out the screenshot below:

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Once we hear back from you, we'll be able to help you with this.