Skip to content
Back
DatabasesGraphQLCloud

GraphQL: get a subset of attributes from documents

View on Discord

Votes

0

Replies

16

Participants

Unknown

Messages

17

ChinmayaOriginal post

Rank 1: Thread

  1. I'm trying to query for a subset of attributes from documents but failing. https://discord.com/channels/564160730845151244/1190627623907364965 This question about using queries in GraphQL to filter the database attributes is not answered and the docs around that are fuzzy at best. Below is the JSON request body I'm using for this request.
  2. Also, for the Appwrite cloud, is there a URL for the GraphQL Explorer? I see some tutorials around that for local instances, but no reference for cloud.
[ { "query": "query($databaseId: String!, $collectionId: String!) { databasesListDocuments( databaseId: $databaseId, collectionId: $collectionId, queries: [ {'method': 'select', 'attributes': ['first_name', 'last_name'] } ] ) { total documents { _id _collectionId _databaseId _createdAt _updatedAt _permissions data } }}", "variables": { "databaseId": "onlinestore-xyz", "collectionId": "customers" } } ]
Steven

Also, for the Appwrite cloud, is there a URL for the GraphQL Explorer?
You can set up the GraphQL explorer locally and point it to Cloud. You won't get the references/docs, though as those are disabled on cloud

Steven

oh we don't support selecting attributes for our graphql implementation

Steven

typically, a graphql api won't require passing select queries. you would just specify which attributes you want returned

Steven

you actually might be able to get the lmited attributes returned with that select query...

Chinmaya

Rank 1: Thread

Right, how can I do that?

Steven

what's happening though?

Chinmaya

Rank 1: Thread

Well, I feel that the queries is being ignored altogether and it always returns the full document. I even tried to list the attribute names instead of the data in the document attribute list.

Steven

one thing that could be a problem is:

{'method': 'select', 'attributes': ['first_name', 'last_name'] }

this isn't valid JSON. and, it should be stringified

Steven

ahhh good point. it should be values

Chinmaya

Rank 1: Thread

Same result with queries: [ \"{\"method\": \"select\", \"values\": [\"first_name\", \"last_name\"] }\"]

Steven

This worked for me:

Steven
GraphQL
{
  databasesListDocuments(
    databaseId: "default"
    collectionId: "usernames"
    queries: ["{\"method\":\"select\",\"values\":[\"username\"]}"]
  ) {
    total
    documents {
      data
      _id
      _collectionId
      _databaseId
      _createdAt
      _updatedAt
      _permissions
    }
  }
}
Steven

the raw payload ended up being:

JSON
{
  "query": "\n{\n  databasesListDocuments(\n    databaseId: \"default\"\n    collectionId: \"usernames\"\n    queries: [\"{\\\"method\\\":\\\"select\\\",\\\"values\\\":[\\\"username\\\"]}\"]\n  ) {\n    total\n    documents {\n      data\n      _id\n      _collectionId\n      _databaseId\n      _createdAt\n      _updatedAt\n      _permissions\n    }\n  }\n}\n",
  "variables": {},
  "operationName": null
}
Chinmaya

Rank 1: Thread

Cool. Let me try.

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join DiscordGet premium support