Mapped array in HTTP module

How To
1

Hi everyone,
I’m building a scenario that creates a vector embedding through the OpenAI embedding API and this embedding then should be stored in a pinecone database.

The problem I’m having is, that whenever I map the output of the embedding API(which is a very long array, with 1536 different numbers to be precise) the input of the HTTP module, that sends it to pinecone doesn’t apear to be an array anymore, which leads to the error I attached.

I also attached the output of the parse JSON module, which shows its an array and then the input of the HTTP module, where I mapped the output and all of a sudden its not an array anymore.
And the last image is what I put as request body in the HTTP module.

If I manually take the output of the parse JSON module(the long array) and send it in the request body, everything works out fine. I just get the error message as soon as I map the output.

Help would be greatly appreciated.

Error http-pinecone module
Error http-pinecone module387×398 20.7 KB

Output parse JSON
Output parse JSON334×326 6.79 KB

Input bundle pinecone module
Input bundle pinecone module799×794 25.1 KB

mapped body pinecone
mapped body pinecone430×174 6.29 KB

2

Welcome to the Make community!

Did you forget to put quotes around the variable, if a string is expected?

"vector": " ",

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

An array is expected, thats the problem. I found a workaround though, I used a text parser and put the result of the text parser in squared brackets.

image
image392×138 3.46 KB

But I’d still be interested, why I can’t map the array directly.

4

Because in JSON, an array starts and ends with square brackets, the same way a String starts and ends with double quotes.

5

Yes I understand that, but the problem is, that the output of the parse JSON module is an array, which I can map into the http module, but when I run it then, I get an error, showing that its not an array. And when I then check the input bundle, I can see its just a string and not an array anymore.

6

While the output of the parse JSON module is an array, mapping the variable into a text field converts it into a comma-separated string.

In JSON, to define an array, you still need to insert the square brackets around the items.