Than you so much samliew. I did manage to get my very ‘clean’ test bundles of data into the Quickbooks line item. This part works as desired using the data shown next. image.
But I’m not done yet.
USE CASE: I’m building a largely automated Quickbooks Online invoicing tool for use by contractors in the field. The technicians in the field talk into their phone and delineate the various job tasks performed charges, prices, descriptions, and amount into a recording.
My Make.com scenario fetches the audio file, transcribes, converts to structured data, and produces a line-by-line invoice on the fly.
A walk-through of my scenario: I am sending a short audio file recording to the webhook [85]. Parse results at [84] and retrieve recording URL at [13]. Transcribe with OpenAI module [115]. All of this works fine.
The problem: I simply cannot get [96] ‘Transform Text to Structured Data’ to return a proper JSON format that will produce bundles I can iterate to create Quickbooks invoice line items.
Revised prompts, revised outputs, revised everything with the ‘Transform Text to Structured Data’ [96]… all have failed. The closest I can get is either ‘n’ lines of comma-delimited text which I cannot iterate over. Ideally, the [96] module would produce the outcome desired. If not, can anyone steer me to a way to convert the results I have produced that can then become an array?
My fields are ‘amount’, ‘description’, ‘quantity’, ‘price’. Nothing complex.
Here is one result:
and here another
I’m finally crying ‘uncle’ and asking for help.
Thanks in advance. I love Make.com but the most powerful features (looping, and data manipulation or management, etc) are so terribly difficult to grasp. There are a number of YouTube videos (always appreciated), but often the content for more advanced features is presented poorly.
Make.com would do well to produce some more complex use case scenario-driven video content at the advanced features level.
