Create a list of URLs from an http request

What I’m trying to do:
Enter a search term in Airtable and have an http request pull in the top 10 search results links and then run a content gap analysis with Perplexity for my client’s page, compared to the to 10 search results.

What I have set up:
Airtable/Wehook/Airtable (to pull in the cell data)/HTTP Request (data items)/Iterator/Array aggegator

The Array aggregator is set up to pull in the links, which is does, and it creates the bundles, which are labeled as " {{13.array.link}} ". When I insert the {{13.array.link}} into the LLM (Perplexity) instructions to do the analysis, it only uses the 1st link from {{13.array.link}}. I want it to look at all of the links and compare them to my client’s page.

@KurtLoh can you share a screenshot of what you have created

Welcome to the Make community!

You probably need to join the links into a single text variable.

To do that, you can use the built-in functions map and join

e.g.:

{{ join(map(13.array; "link"); ", ") }}

For more information, see Array functions page in the Make Help Centre, which covers the following:

  • add (array; value1; value2; …)
  • contains (array; value)
  • deduplicate (array)
  • distinct (array; [key])
  • first (array)
  • flatten (array)
  • join (array; separator)
  • keys (object)
  • last (array)
  • length (array)
  • map (complex array; key;[key for filtering];[possible values for filtering separated by a comma])
  • merge (array1; array2; …)
  • remove (array; value1; value2; …)
  • reverse (array)
  • shuffle (array)
  • slice (array; start; [end])
  • sort (array; [order]; [key])
  • toArray (collection)
  • toCollection (array; key; value)

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.

1 Like