API Connection Point– JSON from BOD Array Issue

jporcello · 2025-05-15T16:17:02+00:00

There was an error rendering this rich post.

I'm working to configure the ION API Connection Point to convert a BOD that matches my API request into JSON. The conversion structure works well in general.

However, I'm encountering an issue:

When there's only a single purchase order line, the resulting JSON omits the array brackets [], which causes problems for my downstream processing that expects an array regardless of the number of items.

Is there anything I can include in the XML during the mapping process to force the resulting JSON to always use an array, even when there's only a single element, during the BOD-to-JSON conversion?

My Object Schema for the incoming document used within the connection point describes purchase_orders as a repeatable group.

Any ideas would be appreciated.

Here are some additional detail:

Find more posts tagged with

Comments

Fabiano Silva

@jporcello , Do you try force a line 0 ? always you will be "two" lines, line 0 and line 1. And in your convertion you skip line 0 .

jporcello

Hi Fabiano,

Thank you for your reply. I believe I have tried just about everything.

Infor's current approach taken by the ION API Connection Point seems to overlook the importance of the document schema, opting instead for a more generic conversion. This creates unnecessary complexity and risk in many integrations, which could otherwise be avoided.

The document schema is foundational to the Infor OS platform—it provides structure, predictability, and consistency. It really needs to be factored into how these APIs are handled.

This issue goes beyond a simple ERS; it impacts how integrations across the platform can be sustainably developed.

I have strongly recommend involving Product Management at this stage to evaluate the implications and ensure they are aligned on a path forward.

Kind regards,
John

Fabiano Silva

You right we need a INFOR support for this issue

Fabiano Silva

I guess so but Do you tried use script to convert XML to JSON?

if you create a empty tag

you will be this result, maybe can help you

Copyright © 2025 Infor. All rights reserved.