What I want to do is summarise up to 3 RSS feeds using Open AI and then return each summary into a field in the database. Tried iterators, array aggregators, iterator and array aggregator, text aggregator and nothing seems to work also tried combining into one field and nothing seems to work
This is the total scenario - currently with an array aggregator but as mentioned tried various approaches and tried using AI to help
There are three Operations but sadly not in array like the other example I was looking at otherwise I could try using map
Here is the output bundle
[
{
“result”: “Title: XRP Climbs Amid Market Standstill: Did BTC Halving Cause Rally?\n\nSummary: Despite a standstill across the crypto market, XRP has managed to climb in value. Some analysts believe that the recent Bitcoin halving may have indirectly caused this rally in XRP prices. The halving event, which took place in May 2020, reduced the supply of new Bitcoins entering the market, leading to speculation that investors turned to XRP as an alternative investment option. The increase in XRP value amidst a market downturn has raised questions about the correlation between Bitcoin halving events and the performance of other cryptocurrencies.”,
“id”: “chatcmpl-9GCARoYZijjqMmpFmx8fkXEG2q96N”,
“object”: “chat.completion”,
“created”: “2024-04-20T21:04:07.000Z”,
“model”: “gpt-3.5-turbo-0125”,
“choices”: [
{
“index”: 0,
“message”: {
“role”: “assistant”,
“content”: “Title: XRP Climbs Amid Market Standstill: Did BTC Halving Cause Rally?\n\nSummary: Despite a standstill across the crypto market, XRP has managed to climb in value. Some analysts believe that the recent Bitcoin halving may have indirectly caused this rally in XRP prices. The halving event, which took place in May 2020, reduced the supply of new Bitcoins entering the market, leading to speculation that investors turned to XRP as an alternative investment option. The increase in XRP value amidst a market downturn has raised questions about the correlation between Bitcoin halving events and the performance of other cryptocurrencies.”
},
“logprobs”: null,
“finish_reason”: “stop”
}
],
“usage”: {
“prompt_tokens”: 115,
“completion_tokens”: 125,
“total_tokens”: 240
},
“system_fingerprint”: “fp_c2295e73ad”
}
]
Then when I try and use the array aggregator once again they are in separate operations
They look something like this
[
{
“array”: [
{
“title”: “XRP Climbs Amid Market Standstill: Did BTC Halving Cause Rally? - DailyCoin”,
“choices”: [
{
“index”: 0,
“message”: {
“role”: “assistant”,
“content”: “Title: XRP Climbs Amid Market Standstill: Did BTC Halving Cause Rally?\n\nSummary: Despite a standstill across the crypto market, XRP has managed to climb in value. Some analysts believe that the recent Bitcoin halving may have indirectly caused this rally in XRP prices. The halving event, which took place in May 2020, reduced the supply of new Bitcoins entering the market, leading to speculation that investors turned to XRP as an alternative investment option. The increase in XRP value amidst a market downturn has raised questions about the correlation between Bitcoin halving events and the performance of other cryptocurrencies.”
},
“logprobs”: null,
“finish_reason”: “stop”
}
],
“dateCreated”: “2024-04-20T19:22:55.000Z”
}
],
“IMTAGGLENGTH”: 1
}
]
I tried using 1 2 and 3 in the array but that didn’t work - still ended up overwriting or not outputting anything.
What I need to know is how to reference a result in Operation 1 and assign it to Summary 1 and Operation 2 and assign it to Summary 2 and Operation 3 and assign it to Summary 3 when Operation itself does not show up - would be nice if Make.com just put these Operations inside their own array to better be able to access the contents.
As you can see the last three modules all run 3 times to correspond to each of the three RSS feeds - here is the output of the RSS module
[
{
“id”: “tag:google.com,2013:googlealerts/feed:8813157065349785368”,
“title”: “XRP Climbs Amid Market Standstill: Did BTC Halving Cause Rally? - DailyCoin”,
“description”: “XRP defies market trends, surging post-Bitcoin halving. Retail investors and whales are accumulating. Is XRP poised for a breakout?”,
“summary”: “”,
“url”: “https://www.google.com/url?rct=j&sa=t&url=https://dailycoin.com/xrp-climbs-amid-market-standstill-did-btc-halving-cause-rally/&ct=ga&cd=CAIyHGNkMDc4ZWFmMjZiZWY2MWE6Y28udWs6ZW46R0I&usg=AOvVaw2muKJNg0RaItyaisjkF80m”,
“dateCreated”: “2024-04-20T19:22:55.000Z”,
“dateUpdated”: “2024-04-20T19:22:55.000Z”,
“comments”: “”,
“author”: “”,
“image”: {},
“categories”: ,
“source”: {},
“enclosures”: ,
“date”: “2024-04-20T19:22:55.000Z”
},
{
“id”: “tag:google.com,2013:googlealerts/feed:912787229249030970”,
“title”: “Ripple Amplified: Enhancing Bitcoin Investments through XRP and Altcoins - Eye On Annapolis”,
“description”: “One of Ripple’s key features is its role as a bridge currency. This section explains how XRP facilitates transactions between different fiat …”,
“summary”: “”,
“url”: “https://www.google.com/url?rct=j&sa=t&url=https://www.eyeonannapolis.net/2024/04/ripple-amplified-enhancing-bitcoin-investments-through-xrp-and-altcoins/&ct=ga&cd=CAIyHGNkMDc4ZWFmMjZiZWY2MWE6Y28udWs6ZW46R0I&usg=AOvVaw1KwqV1ASnhxNCaWV3SFgpD”,
“dateCreated”: “2024-04-20T19:03:24.000Z”,
“dateUpdated”: “2024-04-20T19:03:24.000Z”,
“comments”: “”,
“author”: “”,
“image”: {},
“categories”: ,
“source”: {},
“enclosures”: ,
“date”: “2024-04-20T19:03:24.000Z”
},
{
“id”: “tag:google.com,2013:googlealerts/feed:7336971485024674625”,
“title”: “Crypto Analyst Predicts XRP Price Will Surge 57,000% To $288 - Here’s When - BSC News”,
“description”: “Crypto analyst Javon Marks predicts that the XRP price can rise to $288, but experts say ETFSwap (ETFS) is a better bet.”,
“summary”: “”,
“url”: “https://www.google.com/url?rct=j&sa=t&url=https://www.bsc.news/post/crypto-analyst-predicts-xrp-price-will-surge-57-000-to-288-here-s-when&ct=ga&cd=CAIyHGNkMDc4ZWFmMjZiZWY2MWE6Y28udWs6ZW46R0I&usg=AOvVaw0fqHqMEl2xvLslsI3LR_Ca”,
“dateCreated”: “2024-04-20T18:50:29.000Z”,
“dateUpdated”: “2024-04-20T18:50:29.000Z”,
“comments”: “”,
“author”: “”,
“image”: {},
“categories”: ,
“source”: {},
“enclosures”: ,
“date”: “2024-04-20T18:50:29.000Z”
}
]
I am doing the following in Open AI
Please provide the Title then create a summary from the URL {{substring(2.url; indexOf(2.url; “&url=”) + length(“&url=”); length(2.url))}}
and put it underneath the date and title
This is to strip out the google redirect which it didn’t like.
I expect it is an easy fix but I am stuck - I’ve also tried searching through some other answers in this forum but can’t exactly get the answer.
Thanks
Paul