I've setup a dataflow to use an incoming SalesOrder BOD to populate an ION API request. I'm able to retrieve the result into a JSON object that is then used to merge a new element into the BOD and then send it on to the receiving connection point. It works well.
I'm attempting to refine the flow for distribution and I've come across an issue trying to get the accounting entity value in the API request as an integer instead of a string.
If I try to use accounting_entity, I get an error in Request Parameters: "Request cannot be constructed, please see details below: Unable to get paths from JSON Body due to Error parsing body content as JSON". I assume this is because the BOD is xml, but I'm guessing.
I then tried using a standard element from the SalesOrder BOD: {"IonApiRef": "SyncSalesOrder/DataArea/Sync/AccountingEntityID"}. This works to provide the accounting entity value, but it is converted in the JSON as a string:
I then tried adding an extra field to the user area since the namevalue entries have a type attribute, but it was also converted to a string:
@{"IonApiRef": "SyncSalesOrder/DataArea/SalesOrder/SalesOrderHeader/UserArea/Property/NameValue[@name='oeeh.cono']"}
Regardless, the value is converted to a string in the resulting json request, which causes the ION API call to fail, since it is expecting an integer and not a string.
Is there a way to force this value to an integer when it is converted into the JSON request body?
