Apologies if this is not allowed since this is not directly within Botpress. I need to automate creating sales orders and I do it after receiving an image of an invoice through whatsapp which I process with Google OCR and is transformed into JSON with OpenAI. At the end, I send each item to an airtable table and once all items are sent, I send a get request to get all the items ready to be entered into the sales order creation module (Zoho Books).
The issue is, each record has "recordID" and "created" keys which I don't need and Zoho Books require a very particular JSON format. I have tried everything - transform, parse JSON, asked every AI available to me but still no solution.
I need every item field (quantity, rate,..) directly within their collection number (1,2,..)
https://cdn.discordapp.com/attachments/1108396291060408352/1255419116706074675/fields.PNG?ex=667d0fa9&is=667bbe29&hm=2e9940539ff6d63be2e71ccb867d32db4d939ae97a5267cf926640c7a56b3536&