Send splitted array object to ION API as Document

Question

Hej !

I have a CSV file that is transformed into a JSON payload containing an array of objects. I then use a Splitter with $.objects[*] to split the array into individual JSON objects.

My goal is to send each split object to an ION REST API step that expects a JSON object as an input variable. I created a custom document/object schema in the ION Data Catalog for the API input.

However, I am unable to map the split JSON object to the custom document object that the API accepts as input. Graphical Mapping appears to work for BODs, but not for the split JSON object produced by the Splitter.

What is the recommended way to pass a split JSON object from a Data Flow into an ION REST API that expects an Object Catalog/Data Catalog object as input?

Regards

Mulugeta

Carsten Steinhoefel · Answer

Yes, exactly (you can rename the variable to something more descriptive of course).

After you have the target json object in the script, convert it to a string and assign it to the output variable of the script. It will then be sent on to the ION API Connection Point and can be passed as is.

mfo · Answer

Do you mean I can add a Python Script activity after the Splitter in the Data Flow and use the split object as the script input?

So the Data Flow split object would be available as input_var_1, and inside the script I can construct/map the JSON object into the structure expected by the ION REST API input object.

mfo · Answer

Copyright © 2025 Infor. All rights reserved.