Path: C:\
<?php
$inicial = '2024-09-04';
$final = '2024-09-04';
define('URL_HTTP', 'https://api.jotform.com/form/');
define('API_KEY', '9659ead4a973f60dc8b567df2e4f259d');
define('DIA_INICIAL', $inicial);
define('DIA_FINAL', $final);
//define('FORM_ID', '233304164387657'); // TAC/ETC
// define('FORM_ID', '242103379099662'); // Qualificação Veicular
//define('FORM_ID', '240113399602047'); // HMC
//define('FORM_ID', '202883407439663'); // Ponto
$url = URL_HTTP.'/'.FORM_ID.'/submissions?apikey='.API_KEY.'&filter={"status":"ACTIVE"}&limit=1000';
//$url = URL_HTTP.'/'.FORM_ID.'/submissions?apikey='.API_KEY.'&filter={"status":"ACTIVE","created_at:gt":"'.DIA_INICIAL.' 00:00:00","created_at:lt":"'.DIA_FINAL.' 23:59:59"}&limit=1000';
echo $url.'<br>';
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
//curl_setopt($curl, CURLOPT_HEADER, true);
$resp = curl_exec($curl);
curl_close($curl);
$data=json_decode($resp, true);
echo '<pre>';
var_dump($data);
echo '</pre>';
exit;
/*
$fopen = fopen('JSON/submission.json','w');
$fwrite = fwrite($fopen,$resp);
fclose($fopen);
echo '</pre>';
echo count($data['content']).'<br>';
//echo $data['content'][0]['answers'][67]['prettyFormat'];
*/
?>