Custom metadata for Pinecone

[pnkapadia6]

I want to insert documents into Pinecone but it is not using the metadata fields that I am adding.
In the step right before Pinecone, I have the binary file and adding some custom fields like file_* or doc_* in $input.item.json and event $input.item.json.metadata. But none of that gets picked up by Pinecone.

Information on your n8n setup

core

• n8nVersion: 1.90.2
• platform: docker (cloud)
• nodeJsVersion: 20.19.0
• database: sqlite

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 168 hours
• maxCount: 2500 executions

client

• userAgent: mozilla/5.0 (macintosh; intel mac os x 10_15_7) applewebkit/537.36 (khtml, like gecko) chrome/135.0.0.0 safari/537.36
• isTouchDevice: false

[unomateo]

This is a google doc to pinecone workflow. It is working for adding the metadata to the index items

[pnkapadia6]

But when the database is queries, only file_name is returned in the metadata json and none of the other fields.

[unomateo]

Make sure you default data loader has the value set