Generating Dynamic PDFs using PDF Monkey with Airtable Data

Hello!

I'm looking for assistance debugging my scenario. I've spent hours trying to resolve it with ChatGPT, but none of the suggested solutions have worked.

I'll explain the situation as clearly as possible, and if you can solve it, I'd be happy to hire you for this task.

I generate data using an Airtable search records module, which produces between 5 and 8 bundles. The objective is to create dynamic PDF documents via PDF Monkey using this data. Each bundle contains 7 objects that need to be sent to PDF Monkey.

I have a correctly configured template in PDF Monkey with the necessary HTML code, and I can also provide you with correct test data from PDF Monkey to illustrate the required JSON structure. Everything on the PDF Monkey side is confirmed to be working correctly.

My main challenge is constructing the correct JSON output from the Airtable data, ensuring it functions smoothly and dynamically with the 5 to 8 bundles. I attempted using an Array Aggregator followed by a Create JSON module, but without success. I also tried an Aggregate JSON module, also without success.

Currently, I have an API call to ChatGPT integrated to generate the correct JSON. This works about 80% of the time but isn't 100% reliable. Given that this action will run approximately 40,000 times a month, relying on API calls could become quite expensive.

Therefore, the goal is to generate the correct JSON structure without using a ChatGPT API call and with the fewest modules possible to conserve operations.

If you can help with this, please comment, and I'll get back to you quickly!

Languages: English, German, or French are acceptable!