OpenAI Transform Text to Structured Data - more than one output Bundle

How To
1

I’m almost at my wit’s end. :slight_smile:
I built an automation that extracts values from a PDF containing data and a table. So far, so good—it all works.

After the OpenAI “Message to Assistant,” I use the “Transform Text to Structured Data” module for the extracted text. I do get the data structured correctly, but unfortunately only as a single bundle. I would like to have an output dataset for each record (per voucher).

Output

  • Bundle 1Collection
    • ZahlungArray
      • 1 Beleg: 10095001, Ihr Beleg: 0010095001, Datum: 31.10.2024, Bruttobetrag: 1.064,57 €
      • 2Beleg: 10095002, Ihr Beleg: 0010095002, Datum: 31.10.2024, Bruttobetrag: 314,16 €
      • 3 Beleg: 10095003, Ihr Beleg: 0010095003, Datum: 31.10.2024, Bruttobetrag: 2.284,80 €

Does anyone have any ideas?

2025-02-06 11_12_53-Window
2025-02-06 11_12_53-Window407×385 6.2 KB

2

You should define the data structure as array of objects and then define objects