OpenAI Assistant Node: Expects String Instead of Array

Questions
,
1

Describe the problem/error/question

I´m getting messages from a baserow database to send to an OpenAI assistant, since are multiples rows and columns on the DB to send i arregate all on one and then send to openai but it expect a string instead of an array.
How can i accomplish that?

What is the error message (if any)?

ERROR: 400 Invalid type for ‘thread.messages[0].content’: expected a string, but got an array instead.

Please share your workflow

Share the output returned by the last node

Summary

[
{
“id”: 1918,
“order”: “1836.00000000000000000000”,
“id 2”: null,
“sender_name”: “Group”,
“chat_id”: “-1001122114774”,
“message_text”: “Bom Dia Clube!\n\nPassando aqui para avisar que dia 10/03 às 09h30 teremos nossa live de pista.\nEste mês teremos um super convidado: Apolônio, treinador de Rédeas e Professor de Equitação.\n\nApolônio é Treinador UDC (Grau Máximo de nossa Certificação de Treinadores) e irá dar uma super aula para vocês com foco em Rédeas. Ele vai abordar exercícios e dicas de equitação para a modalidade. \n\nANOTEM NA AGENDA: DOMINGO 10/03 ÀS 09H30 NO YOUTUBE.\nhttps://youtube.com/live/WdRZ9T3aXCU\n\nPara irem conhecendo mais sobre o nosso super Treinador já sigam ele no instagram:\nhttps://www.instagram.com/apolo.redeas/”,
“date_time”: “2024-03-02 8:36:47”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48033”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1920,
“order”: “1838.00000000000000000000”,
“id 2”: null,
“sender_name”: “ct.trapa”,
“chat_id”: “-1001122114774”,
“message_text”: “Bom dia Clube!”,
“date_time”: “2024-03-02 8:41:14”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48035”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1921,
“order”: “1839.00000000000000000000”,
“id 2”: null,
“sender_name”: “Adriano Araujo”,
“chat_id”: “-1001122114774”,
“message_text”: “@visualpleasuremag on Instagram: "Figueras Polo Stables by Estudio Ramos Buenos Aires, Argentina. Photography : Daniela Mc Adden, Matias Lix Klett and Celeste Najt #architecture #architecturephotography #visualpleasuremag"”,
“date_time”: “2024-03-02 9:13:06”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48036”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1922,
“order”: “1840.00000000000000000000”,
“id 2”: null,
“sender_name”: “Adriano Araujo”,
“chat_id”: “-1001122114774”,
“message_text”: “Bom dia clube.”,
“date_time”: “2024-03-02 9:13:15”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48037”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1923,
“order”: “1841.00000000000000000000”,
“id 2”: null,
“sender_name”: “Adriano Araujo”,
“chat_id”: “-1001122114774”,
“message_text”: “Arquitetura fantastica hein?”,
“date_time”: “2024-03-02 9:14:09”,
“is_reply”: null,
“replied_to_name”: “Adriano Araujo”,
“message_id”: “48038”,
“reply_to_message_from_name”: “Adriano Araujo”,
“reply_to_message_from_id”: “6693577492”,
“reply_to_message_from_username”: null,
“reply_to_message_id”: “48036”,
“reply_to_message”: “@visualpleasuremag on Instagram: "Figueras Polo Stables by Estudio Ramos Buenos Aires, Argentina. Photography : Daniela Mc Adden, Matias Lix Klett and Celeste Najt #architecture #architecturephotography #visualpleasuremag"”,
“chat_title”: “Clube UC”
},
{
“id”: 1924,
“order”: “1842.00000000000000000000”,
“id 2”: null,
“sender_name”: “Joi CHOY Duarte”,
“chat_id”: “-1001122114774”,
“message_text”: “Bom dia Clubão bão :cowboy_hat_face:”,
“date_time”: “2024-03-02 9:25:14”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48039”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1925,
“order”: “1843.00000000000000000000”,
“id 2”: null,
“sender_name”: “Joi CHOY Duarte”,
“chat_id”: “-1001122114774”,
“message_text”: “Top demais​:clap::clap::clap:”,
“date_time”: “2024-03-02 9:25:28”,
“is_reply”: null,
“replied_to_name”: “Group”,
“message_id”: “48040”,
“reply_to_message_from_name”: “Group”,
“reply_to_message_from_id”: “1087968824”,
“reply_to_message_from_username”: “GroupAnonymousBot”,
“reply_to_message_id”: “48033”,
“reply_to_message”: “Bom Dia Clube!\n\nPassando aqui para avisar que dia 10/03 às 09h30 teremos nossa live de pista.\nEste mês teremos um super convidado: Apolônio, treinador de Rédeas e Professor de Equitação.\n\nApolônio é Treinador UDC (Grau Máximo de nossa Certificação de Treinadores) e irá dar uma super aula para vocês com foco em Rédeas. Ele vai abordar exercícios e dicas de equitação para a modalidade. \n\nANOTEM NA AGENDA: DOMINGO 10/03 ÀS 09H30 NO YOUTUBE.\nhttps://youtube.com/live/WdRZ9T3aXCU\n\nPara irem conhecendo mais sobre o nosso super Treinador já sigam ele no instagram:\nhttps://www.instagram.com/apolo.redeas/”,
“chat_title”: “Clube UC”
},
{
“id”: 1926,
“order”: “1844.00000000000000000000”,
“id 2”: null,
“sender_name”: “Gabriel Marins”,
“chat_id”: “-1001122114774”,
“message_text”: null,
“date_time”: “2024-03-02 9:27:18”,
“is_reply”: null,
“replied_to_name”: “”,
“message_id”: “48041”,
“reply_to_message_from_name”: “”,
“reply_to_message_from_id”: null,
“reply_to_message_from_username”: null,
“reply_to_message_id”: null,
“reply_to_message”: null,
“chat_title”: “Clube UC”
},
{
“id”: 1927,
“order”: “1845.00000000000000000000”,
“id 2”: null,
“sender_name”: “Lucas Teixeira”,
“chat_id”: “-1001122114774”,
“message_text”: “Muito obrigado, gratidão”,
“date_time”: “2024-03-02 9:40:42”,
“is_reply”: null,
“replied_to_name”: “MURGUINHA”,
“message_id”: “48042”,
“reply_to_message_from_name”: “MURGUINHA”,
“reply_to_message_from_id”: “670172279”,
“reply_to_message_from_username”: “Murguinha”,
“reply_to_message_id”: “47774”,
“reply_to_message”: “https://dai.ly/x7uost4 baixei aqui”,
“chat_title”: “Clube UC”
},
{
“id”: 1928,
“order”: “1846.00000000000000000000”,
“id 2”: null,
“sender_name”: “Fábio Cox”,
“chat_id”: “-1001122114774”,
“message_text”: “Bom dia, clube!\nBom dia, Biel! Que esqueminha legal, hein? Bom pras cavalgadas de mais de um dia tb. Nas situações com dificuldade de lugar nos pousos.”,
“date_time”: “2024-03-02 9:41:33”,
“is_reply”: null,
“replied_to_name”: “Gabriel Marins”,
“message_id”: “48043”,
“reply_to_message_from_name”: “Gabriel Marins”,
“reply_to_message_from_id”: “1366860582”,
“reply_to_message_from_username”: null,
“reply_to_message_id”: “48041”,
“reply_to_message”: null,
“chat_title”: “Clube UC”
}
]

Information on your n8n setup

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

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • 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
3

hello @rafaelxc

to send string, instead of using {{ $json.summary }} use formula {{ JSON.stringify($json.summary) }}

2 Likes
4

@rafaelxc you can use edit node and set datatype to string also

1 Like
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.