Hi! I have a Data Flow that contains a script that transforms an XML into a JSON and then calls an ION API, where I need to pass the JSON exactly as the script returns it in the request body of the API Connection Point. But when I use the "IonApiRef" in the request body of the API Connection Point, it doesn't recognise it.
I'm not sure if it could be because it's a JSON Array. The JSON returned by the script (which is what I need for the API) is:
[{"StockCode": "ART01", "Warehouse": "AAA", "Quantity": 248}, {"StockCode": "ART02", "Warehouse": "AAA", "Quantity": 70}, {"StockCode": "A3T01", "Warehouse": "AAA", "Quantity": 115}]
And what I put in the API Connection Point is:
But when I run a TEST it doesn't pick it up correctly:
Many thanks in advance, or does anyone know how I can do this?
