Ninox>>Make.com>>FreeAgent webhook

I am trying to create a setup where, once an invoice is created in my Ninox database, I press a button and it sends the data to FreeAgent and creates a matching invoice there for my HMRC records. I am a complete novice and have used AI to create the button script. In Make I have a webhook, then a JSON parse, then a ‘create invoice’ in FreeAgent. No matter what I do, I can’t make the data pass over. I don’t know what the problem is - the parse separates it all into a long list but although I click on the individual items in the FreeAgent section and the invoice appears in the FreeAgent website, it has the wrong data. Any help greatly appreciated!

Hey Rachel,

can you share some screenshots of the setup you have? Is the correct data coming from the webhook? Or is that data wrong as well?

Hi Stoyan,

These screenshots show the script in Ninox and the raw output coming from the webhook.

Hello,

Welcome to the community!

The issue is in the payload structure rather than in Make itself.

customer is being serialized as a JSON string (formatJSON(...)) instead of being sent as a proper JSON object, and lines is also being generated as a plain text string rather than a JSON array/object structure.

As a result, the webhook receives malformed JSON data, which is why the output looks broken in Make.

Also- in most cases you can use parsing within Webhook module which is enabled by default.

Have a nice day,
Michal

I have simplified the information being sent to try to see what is going on. The following are the screenshots of the Ninox script, the scenario in Make, and the inputs and outputs of the webhook and JSON parse. The information doesn’t come through to FreeAgent properly and it produces five invoices for five different contacts.