I'm trying to create a simple signup service using Ballerina and MongoDB (using MongoDB Compass version 7.0.11). However, I'm encountering several errors related to MongoDB integration with Ballerina. Specifically, I'm getting the following errors during compilation: Incompatible types: 1.Error: expected…
I have a SQL Server database table with this structure: CREATE TABLE json_file_table ( file_id VARCHAR(50) PRIMARY KEY, json_value VARBINARY(MAX) ); How to write a SQL query to insert value into the database and bind values to that query in…
Consider the scenario where we create a record for capturing a JSON payload. (application/json content type) Is there any benefit of using a closed record with a JSON type rest descriptor over an open record? Since JSON allows any primitive…
For XML files in Ballerina, if we want to access a node with a given name nested anywhere within the tree, we can access it using the following way. // x/**/<name> - for every element e in x, retrieves every…
I have a local Ballerina server (http://localhost:8080) and React frontend (http://localhost:3000) set up, and I've encountered a CORS error while attempting to send POST requests to the server through axios. Interestingly, I don't encounter this error when making the same…
json data = {"vals": ["a", "b", "c"]}; How to iterate above JSON and get a,b,c?
I am trying to setup a simple JDBC client to talk with a database in Ballerina. However the "compile" ( VSCode ) error that is shown says: invalid remote method call: expected a client object, but found (ballerinax/java.jdbc:1.7.0:Client|ballerina/sql:1.7.1:Error)(BCE2421) Here is…
I have been trying to connect to a cluster in MongoDB Atlas using the mongodb:Client. I am not able to find any connection string that is supported by the Ballerina client. I could not find any sample code that suggests…
In this case I have seen the official documentation of choreo, ballerina, but I could not find how to execute a query where I need to filter by the ObjectId, In Java I could do it by importing BSON, but…