Sending data via a GET com SIM808 request

#include <SoftwareSerial.h>
#include <DFRobot_sim808.h>
SoftwareSerial mySerial(11, 10);
DFRobot_SIM808 sim808(&mySerial);
#define MESSAGE_LENGTH 300
char message[MESSAGE_LENGTH];
int messageIndex = 0;
char MESSAGE[300];
char lat[12];
char lon[12];
char year[12];
char month[12];
char day[12];
char hour[12];
char minute[12];
char second[12];
char gprsBuffer[64];
char datetime[24];
char buffer[1000];
void inicio();
void getGPS();
void envinternet();

void setup()
{
  mySerial.begin(19200);
  Serial.begin(19200);
  delay(500);
  inicio();
}
void inicio ()
{
  while(sim808.init())
  {
      Serial.print("Sim808 OFF\r\n");
      delay(1000);
      mySerial.println("AT+CFUN=1,1");
  }
  delay(3000);
  Serial.println("OK");
  delay(200);
}

void getGPS()
{
   while(!sim808_check_with_cmd("AT+CGPSPWR=1\r\n", "OK\r\n", CMD))
   {
      Serial.println("FAIL GPS");
   }
    Serial.println("GPS OK");
    delay(200);
    while(!sim808_check_with_cmd("AT+CGPSSTATUS?\r\n", "+CGPSSTATUS: Location 3D Fix",CMD))
    {
      Serial.println("adq data ");
    }
    delay(500);
    mySerial.println("AT+CGPSout=32");
    while(!sim808.getGPS());
    mySerial.println("AT+CGPSOUT=0");
    delay(300);
    Serial.print("latitude:");
    Serial.println(sim808.GPSdata.lat,6);
    Serial.print("longitude:");
    Serial.println(sim808.GPSdata.lon,6);
    Serial.print("Año:");
    Serial.print(sim808.GPSdata.year);
    Serial.print("Mes:");
    Serial.print(sim808.GPSdata.month);
    Serial.print("Dia:");
    Serial.print(sim808.GPSdata.day);
    Serial.print("Hora:");
    Serial.print(sim808.GPSdata.hour);
    Serial.print("Minuto:");
    Serial.print(sim808.GPSdata.minute);
    Serial.print("Segundo:");
    Serial.print(sim808.GPSdata.second);
    Serial.println();
 
    float la = sim808.GPSdata.lat;
    float lo = sim808.GPSdata.lon;
    float ws = sim808.GPSdata.year;
    float mo = sim808.GPSdata.month;
    float da = sim808.GPSdata.day;
    float ho = sim808.GPSdata.hour;
    float mi = sim808.GPSdata.minute;
    float se = sim808.GPSdata.second;
     
    dtostrf(la, 4, 6, lat);
    dtostrf(lo, 4, 6, lon);
    dtostrf(ws, 4, 0, year);
    dtostrf(mo, 2, 0, month);
    dtostrf(da, 2, 0, day);
    dtostrf(ho, 2, 0, hour);
    dtostrf(mi, 2, 0, minute);
    dtostrf(se, 2, 0, second);
   
sprintf(MESSAGE,"Latitude=%s&Longitud=%s&Año=%s&Mes=%s&Dia=%s&Hora=%s&minuto=%s&segundo=%s ", lat, lon, year,month,day, hour, minute, second);
    delay(200);
 }

void   envinternet(){

//-----------------------------//---Test data------//----------------- 
//char http_cmd[] = "GET /datos.json?Latitud=9.678&longitud=15&ano=2019&mes=7&dia=20&hora=10&segundos=14 HTTP/1.1\r\nHost: d3n5q9vmna3dck.cloudfront.net\r\n\r\n";

//------------//--------------//--------------------

--------------------------First method----------------------------------------------
  char http_cmd[300]="GET /datos.json?Latitude=";
  char host[80]="HTTP/1.1\r\nHost: d3n5q9vmna3dck.cloudfront.net\r\n\r\n"; 
 strcat(http_cmd,lat);
 strcat(http_cmd,"&Longitud=");
 strcat(http_cmd,lon);
 strcat(http_cmd,"&ano=");
 strcat(http_cmd,year);
                                               //continued with each of the values obtained by the gps then i ended the string 
                                                                with the host
  strcat(http_cmd," "); 
  strcat(http_cmd,host);
   Serial.println(http_cmd);
----------------------------Second method--------------------------------------------------

 char http_cmd[300]="GET /datos.json?";
  char host[80]="HTTP/1.1\r\nHost: d3n5q9vmna3dck.cloudfront.net\r\n\r\n"; 
  strcat(http_cmd,MESSAGE);     
  strcat(http_cmd," "); 
  strcat(http_cmd,host);

--------------------------SEND GET------------------------------------
  while(!sim808.join(F("ba.amx"), F("comcel"), F("comcel"))) { 
      Serial.println("Sim808 join network error");
      delay(2000);
  }

  Serial.print("IP Address is ");
  Serial.println(sim808.getIPAddress());

  if(!sim808.connect(TCP,"d3n5q9vmna3dck.cloudfront.net", 80)) {   
      Serial.println("Connect error");
  }else{
      Serial.println("Connect mbed.org success");                //So far, I have no problem with anything, everything 
                                                                                                                 works as it should.
  }
  Serial.println("waiting to fetch...");
  sim808.send(http_cmd, sizeof(http_cmd)-1);
  while (true) {
      int ret = sim808.recv(buffer, sizeof(buffer)-1);
      if (ret <= 0){
          Serial.println("fetch over...");  
          break;
      }
      buffer[ret] = '\0';
      Serial.print("Recv: ");
      Serial.print(ret);
      Serial.print(" bytes: ");
      Serial.println(buffer);
      break;
  }
  sim808.close();
  sim808.disconnect();
}

(function ($) {
          $.getJSON('http://d3n5q9vmna3dck.cloudfront.net/datos.json', (response) => {
              console.log("data", response);
              const table = $("<table></table>")
              const tableHead = $("<thead></thead>")
              const tableHeadFila = $("<tr></tr>")
              const encabezados = ["Longitud", "Latitud", "Año", "Mes", "Dia", "Hora", "Segundos"]

              encabezados.forEach(encabezado => {
                    const td = $("<th></th>")
                    td.append(encabezado)
                    tableHeadFila.append(td)

              })

              const tableBody = $("<tbody></tbody>")


              response.datos.reverse().forEach((dato) => {
              //response.datos.forEach((dato) => {
                const tr = $("<tr></tr>")
                
                Object.keys(dato).forEach(columna => {
                    const td = $("<td></td>")

                    td.append(dato[columna])
                    tr.append(td)
                })

                tableBody.append(tr)
              })

              tableHead.append(tableHeadFila);
              table.append(tableHead)
              table.append(tableBody)
              console.log(table)
              $("div[role=main]").html(table)
          })
        })($)