Can't use GET request from MongoDB using arduino uno wifi rev.2

I've been trying to figure out how to get the arduino uno wifi rev.2 to do a GET request to the MongoDB database. The endpoint I'm trying to use is:

https://data.mongodb-api.com/app/data-nhwaq/endpoint/getAll

This endpoint just responds with all my data in json format from activities collection. It should work for anyone who just pastes it on their browser since I've made the function of the endpoint allow anyone to get data without any authentication. I've made it work on postman below:

I've looked at other topics like my own and I still can't seem to figure out whether it's my request headers, the microcontroller, or the database acting up. The code I'm using is the modified wifi web client file from the WiFiNiNa library

/*
  Web client

 This sketch connects to a website (http://www.google.com)
 using the WiFi module.

 This example is written for a network using WPA encryption. For
 WEP or WPA, change the WiFi.begin() call accordingly.

 This example is written for a network using WPA encryption. For
 WEP or WPA, change the WiFi.begin() call accordingly.

 Circuit:
 * Board with NINA module (Arduino MKR WiFi 1010, MKR VIDOR 4000 and UNO WiFi Rev.2)

 created 13 July 2010
 by dlf (Metodo2 srl)
 modified 31 May 2012
 by Tom Igoe
 */


#include <SPI.h>
#include <WiFiNINA.h>

#include "arduino_secrets.h" 
///////please enter your sensitive data in the Secret tab/arduino_secrets.h
char ssid[] = SECRET_SSID;        // your network SSID (name)
char pass[] = SECRET_PASS;    // your network password (use for WPA, or use as key for WEP)
int keyIndex = 0;            // your network key index number (needed only for WEP)

int status = WL_IDLE_STATUS;
// if you don't want to use DNS (and reduce your sketch size)
// use the numeric IP instead of the name for the server:
//IPAddress server(74,125,232,128);  // numeric IP for Google (no DNS)
char server[] = "https://data.mongodb-api.com/app/data-nhwaq/endpoint";    // name address for Google (using DNS) 

// Initialize the Ethernet client library
// with the IP address and port of the server
// that you want to connect to (port 80 is default for HTTP):
WiFiClient client;

void setup() {
  //Initialize serial and wait for port to open:
  Serial.begin(9600);
  while (!Serial) {
    ; // wait for serial port to connect. Needed for native USB port only
  }

  // check for the WiFi module:
  if (WiFi.status() == WL_NO_MODULE) {
    Serial.println("Communication with WiFi module failed!");
    // don't continue
    while (true);
  }

  String fv = WiFi.firmwareVersion();
  if (fv < WIFI_FIRMWARE_LATEST_VERSION) {
    Serial.println("Please upgrade the firmware");
  }

  // attempt to connect to WiFi network:
  while (status != WL_CONNECTED) {
    Serial.print("Attempting to connect to SSID: ");
    Serial.println(ssid);
    // Connect to WPA/WPA2 network. Change this line if using open or WEP network:
    status = WiFi.begin(ssid, pass);

    // wait 10 seconds for connection:
    delay(10000);
  }
  Serial.println("Connected to WiFi");
  printWifiStatus();

  Serial.println("\nStarting connection to server...");
  // if you get a connection, report back via serial:
  if (client.connect(server, 80)) {
    Serial.println("connected to server");
    // Make a HTTP request:
    client.println("GET /getAll HTTP/1.1");//HTTP/1.1
    client.println("Host:data.mongodb-api.com"); //data.mongodb-api.com
    client.println("User-Agent: ArduinoWiFi/1.1");
    client.println("Content-Type:application/json");
    client.println("Access-Control-Request-Headers: *");
    client.println("Connection: close");   
    
    client.println();
  }
}

void loop() {
  // if there are incoming bytes available
  // from the server, read them and print them:
  while (client.available()) {
    char c = client.read();
    Serial.write(c);
  }

  // if the server's disconnected, stop the client:
  if (!client.connected()) {
    Serial.println();
    Serial.println("disconnecting from server.");
    client.stop();

    // do nothing forevermore:
    while (true);
  }
}


void printWifiStatus() {
  // print the SSID of the network you're attached to:
  Serial.print("SSID: ");
  Serial.println(WiFi.SSID());

  // print your board's IP address:
  IPAddress ip = WiFi.localIP();
  Serial.print("IP Address: ");
  Serial.println(ip);

  // print the received signal strength:
  long rssi = WiFi.RSSI();
  Serial.print("signal strength (RSSI):");
  Serial.print(rssi);
  Serial.println(" dBm");
}

Found the answer myself, turns out that you had to change the server[] equal to data.mongodb-api.com. You also had to use WiFiSSLClient instead of WiFiClient and upload the root certificate for the website for it to authenticate properly as well. Finally, for the actual GET request instead of putting /getAll you would put /app/data-nhwaq/endpoint/getAll. I'm still a beginner to mongoDB api and arduino but I'm glad I found out how this works since I was trying to figure out why it was going wrong for a few days now.

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.