[Bug]: Firestore connection configuration works wrong

[gring2]

Is there an existing issue for this?

• I have searched the existing issues

Description

When i try to connect to firestore's non-default database, appsmith keep connecting to default database.
because it seems not to use url options, I tested with wrong database url and appsmith success to connect to default firestore db.

I expect to connect to db which's database url pointing (https://DATABASE_NAME.firebaseio.com).
https://firebase.google.com/docs/database/web/start

I think bug is in here. FirestorePlugin try to access to default firestore first. it should give using options priority

.map(options -> {
    try {
        return FirebaseApp.getInstance(projectId);
    } catch (IllegalStateException e) {
        return FirebaseApp.initializeApp(options, projectId);
    }
})

https://github.com/appsmithorg/appsmith/blob/release/app/server/appsmith-plugins/firestorePlugin/src/main/java/com/external/plugins/FirestorePlugin.java

Steps To Reproduce

1. Go to data.
2. choose firestore
3. try to connect to firestore with wrong database url.
4. click test configuration
5. successfully connects.
6. put non default db url. in database url input.
7. click test configuration
8. still connects to default db

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

self hosted - 1.5.2

[HardikRathod123]

is this issue open to contribution? I would like to take on this issue

[sneha122]

Hi @HardikRathod123 yes this is open for contribution, you can check it out and let me know the approach for fixing this issue. During my research, I have found a couple of pointers that could be helpful for you:

1. When we create firestore database, it creates a default database with free plan but for this issue, we would need upgraded plan in order to create non default database and test it
2. This is the documentation for firestore java SDK https://firebaseopensource.com/projects/firebase/firebase-admin-java/