So I got this scenario that looks at a newsletters email and extracts Ai topics and the links related to the article of that news segment. My first OpenAI chat completion provides a list with various AI related topics mentioned and their article URLs however when passing on to OpenAI text to structured data only the first topic goes through and as of which in excel it only populates 1 segment not all that are initially captured. How do I make it so this process repeats for all the topics and news parts that the first OpenAI module found?
Try changing the “Data Type” in the “Structured Data Definition” of the OpenAI module to Array (text). Then just use an iterator to go through each array item.
Note that something like an email newsletter you would be able to parse without AI. Just need to find the pattern within the HTML code. Down the line might be something to look at to save on cost.
Hope this help!
Your module [5]'s Object/Data definitions could possibly be restructured to return an array of items, removing the need for an aggregator and solving your problem at the same time.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
1 Like
Thanks for help, much obliged. It seems to be working better, however now all answers come into the one cell instead of creating a separate row for each topic and corresponding URL link (these are also all mashed into 1 excell row, into 1 cell).
You need to use an iterator to split the array and then have each bundle go through a “Create Row” module.