Pinecone Connector Guide

Back Next

Rules and guidelines for using Pinecone connector

Consider the following rules and guidelines when using the Pinecone connector:

To use the Fetch Vectors action, you must add array of IDs to the query parameters as shown in the following sample code:

<root> 
<element>id-1</element> 
<element>id-2</element> 
<element>id-3</element> 
<element>id-4</element> 
</root>

The Get Index Statistics, Query Vectors, and Delete actions might contain filter properties. You might create a requestBody with a filter field. Filter field uses query language with query selectors. To build a filter field correctly, you must replace the

with the

. For example, replace

$eq

with

_eq

as shown in the following sample code:

<root>
	...
	<vector>-0.120900110</vector>
	<filter>
		<genre>
			<_eq>comedy</_eq>
		</genre>
	</filter>
	<topK>3</topK>
</root>

For more information about filter data with metadata, see Pinecone documentation.

To use fields with data types, such as array, boolean, double, or integer, you must use annotation as shown in the following sample code:

<root xmlns:m="urn:informatica:ae:xquery:json2xml:meta-data">
	<field_array m:isArray="true">
		<property_1> ...</property_1>
	</field_array>
	<field_boolean m:type="xs:boolean">true</field_boolean>
	<field_double m:type="xs:double">10.3</field_double>
	<field_integer m:type="xs:int">5</field_integer>
</root>

If you need additional types in the field, use the additional namespaces as shown in the following sample code:   

<root xmlns:m="urn:informatica:ae:xquery:json2xml:meta-data"> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <vector>0.3</vector> 
    <filter> 
    <_and> 
        <genre> 
            <_eq>drama</_eq> 
        </genre> 
    </_and> 
    <_and> 
        <year> 
            <_gte m:type="xs:int">2020</_gte> 
        </year> 
    </_and> 
</filter> 
<topK>3</topK> 
<includeValues>true</includeValues> 
</root>