Create Rows from Line Items on Uploaded File

Ask for Help
1

Before starting on this I wanted to check if anyone has tips for the best setup.

The scenario is as follows:
A pricing quote File is uploaded via a form.
Row is created for each line item with the product code and prices at various quantity breaks show in a table on the file.

Has anyone achieved something similar with looped workflows and Ai file to text actions etc?

2

I would use Document to Text to convert the file to text first, then Text to JSON to convert the only relevant part to a JSON array. Please instruct the AI model to only look for the relevant part here.

Then, loop through the resulting JSON array, parse the fields out using Query JSON, and add them to your destination table.