Array of Objects Expected in Parameter line_items

Hi,

I have perused other article and attempted each of the suggestions, but I am still unable to resolve the issue.

I would greatly appreciate if someone could provide assistance.

I am currently endeavoring to consolidate a list of line items and then convert them into JSON format. Then output this to the accounting system, it returns an “array of objects expected in parameter line_items”.

Please see the screenshot below:

Hi @STEFTPOS ,

What value do you pass in your Zoho books app?

Glenn - Callinetic

2 Likes

Hi @Callinetic,

I passed the JSON string to Zoho books.

JSON string

{“line_items”:[{“name”:“Refundable Deposit (excl. of GST)”,“rate”:13,“unit”:“Ea”,“quantity”:1,“description”:null,“line_item_id”:“4454906000000090058”},{“name”:“Installation Charge”,“rate”:12,“unit”:“Ea”,“quantity”:1,“description”:null,“line_item_id”:“4454906000000090049”},{“name”:“DRMS - 1 Year”,“rate”:11,“unit”:“Ea”,“quantity”:1,“description”:“

Terminal ID: 1234567
Installation Date: 2023-10-16

”,“line_item_id”:“4454906000000090040”},{“name”:“A930 - Rental - 1 year”,“rate”:10,“unit”:“Ea”,“quantity”:1,“description”:“

-Including the SIM card

\r\n

 Terminal ID: 123456

\r\n

Installation Date: 2023-10-16

”,“line_item_id”:“4454906000000090027”}]}

Hi @STEFTPOS,

Instead of constructing the JSON structure, which appears to be incorrect in this particular scenario, I recommend simply mapping the result of your array aggregator directly to the Line Items field in Zoho.

Could you give it a try and share the results with us?

Glenn - Callinetic

2 Likes

Hi @Callinetic,

You are a charm! Thanks for your kind assistance. I believe the issue with the array of objects is resolved.

However, I’m now encountering a runtime error related to invalid HSN/SAC code.

I noticed that this is something I can pass in the array aggregator. Do you have any ideas about this, or should I check with the Zoho team? Because I can’t find any info about this in the Zoho software.

image

Hi @STEFTPOS,

I think that’s something you best check with the the Zoho team indeed. :smiling_face:

Glenn - Callinetic

2 Likes