Cannot add members via REST API

[norairn]

First of all, thank you for doing great job with Dexie Cloud!

I'm running into some issues with adding members using Dexie Cloud and the REST API. I found a resolved issue online that seemed relevant, but when I follow the steps exactly, I still get errors. Here's how I'm trying to reproduce it.

Create a new database.

npx dexie-cloud create

Obtain a token and send the following request. Using rlm-public in this experiment.

### Add members
POST {{baseUrl}}/all/members HTTP/1.1
Content-Type: application/json
Authorization: Bearer {{token}}

[{
 "realmId": "rlm-public",
 "email": "foo@bar.com",
 "userId": "foo@bar.com",
 "accepted": true,
 "invite": false,
 "permissions": {},
}]

When the token is obtained with ["ACCESS_DB", "GLOBAL_WRITE"], I get HTTP/1.1 403 Forbidden. Not authorized to mutate any data.
When the token is obtained with ["ACCESS_DB", “GLOBAL_READ”, "GLOBAL_WRITE"], I get HTTP/1.1 404 Not Found. Table 'members' was not found in database '<id>'.

However, the following GET of members returns success withHTTP/1.1 200 OK [].

### Get members
GET {{baseUrl}}/all/members HTTP/1.1
Authorization: Bearer {{token}}

Any ideas on what's happening?

[dfahlander]

Unfortunately all of GLOBAL_READ, GLOBAL_WRITE and ACCESS_DB are required when POSTing objects into the 'all' or 'public' endpoints.

[norairn]

Sorry, when I POST to /all/members with GLOBAL_READ, GLOBAL_WRITE and ACCESS_DB I get: 404. Table 'members' was not found in database '<id>'.
But when I try to read the same table /all/members using GET, it succeeds with 200 and returns [].

It must be something with this specific system table members. Any other table works fine on POST, and GET.

When I download schema it returns this table (members):

{
  "schema": {
    "todoItems": "@itemId",
    "todoLists": "@id",
    "members": "@id",
    "roles": "[realmId+name]",
    "realms": "@realmId"
  },
  "sealed": false
}

[dfahlander]

I see. That sounds as a bug. Please send your database URL and a timepoint when this happened to privsupport@dexie.org and refer to this issue and we'll look into it asap.

[dfahlander]

I tried to repro this on another database and I could not reproduce any issue. This attached script is able to add new members using the same data you provided when using one of my databases.

repro2195.js

Can you try it as well, setting env vars DB_URL, CLIENT_ID and CLIENT_SECRET before running the script?

[norairn]

I've sent my database URL to the support email.
The repro2195.js script returns the same error 404 in the addMember function.
This is a brand new empty test database I've created a couple of days ago. I wonder it needs to be initialized with any other seed data.

[dfahlander]

Thanks! I could reproduce the bug using my script on your database.
When I debugged this it turned out that the database did not have full information about the existance of the "members" table - probably it's fresh and haven't synced schema yet.

What I did now to fix it for your specific DB was:

npx dexie-cloud export --schema dbschema.json
npx dexie-cloud import dbschema.json

So it should work from now. Keeping this issue open until the root cause of this is solved. Please verify it's working now.

[norairn]

Yes, I have verified it is working now! I will keep in mind the steps to re-import the schema to mitigate this for now.