Cannot delete points using filtered - gdrant node

Questions
1

I can delete points in Collection using filter:
{“must”: [{“key”: “metadata.name”,“match”: {“value”: “{{ $json.documents[0].name }}”}}
]}
I using Qdrant vector db with dataloader: metadata.name

image
image1523×951 85.1 KB

image
image1517×948 142 KB

Describe the problem/error/question

{ “status”: { “error”: “Bad request: Index required but not found for \“metadata.name\” of one of the following types: [keyword]. Help: Create an index for this key or use a different filter.” }, “time”: 0.000019217 }

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
1 Like
2

Hey @Giang_Vu Welcome to the n8n community!

Your configurations of the node seems fine, have you tried refreshing your credentials? Most of the times that’s the reason it sometimes gives 404, And rechecking your metadata.name would help this! Also using a different filter than the original one might help! Let me know what’s up with that and also sharing your workflow would help as well
Cheers!

3

Yeah, the issue was about the metadata, i must create payload index for metadata.name before using it for filter or anything

4

Indeed the configurations of the metadata and the payload index was causing the issue, have you solved it?

5

Yes, i solved that. Create a payload index metadata.name type keyword after you create a collection.

6

Cheers! Mark that as a solution!