[Need Help] Merge and analyze search results from different engines

Questions
1

Describe the problem/error/question

I am trying to create an automation that takes a name and location of a person, searches on Perplexity and Tavily and then creates a persona based on the search results using OpenAI Chat Model.

But my problem is that both perplexity and tavily output their payload (JSON) in different structures and I can’t figure out how to merge them to give it as input to OpenAI.

I tried Aggregate and Merge and even read their docs, but there’s nothing on how to aggregate or merge if your data sets are different.

As you can see, in the OpenAI node, the second part from Tavily Search "
{{ $json.results }}" comes up as ‘undefined’.

I have frozen/pinned all the outputs because Tavily requires an API key that is to be sent along with the search. I ran the workflow, pinned all the outputs and then removed the node that passed the API key to Tavily node.

I would really appreciate if I could get some guidance on how to use both search results to pass on to OpenAI for its analysis and processing.

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.66.0
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): no clue what this is
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm on raspi
  • Operating system: debian
2

For anyone who has the same problem as I did, here’s the solution:

1 Like
3

Hey @fpcteam , I believe you are not usin the correct Merge mode. By using “Append” you create two separate items. You need to use “Combine” to have one item corresponding to your persona.

4

I had tried combine first. but it didn’t work, so I changed it to append. it works fine now. I posted my working flow above. :slight_smile:

5

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