Flattening Hierarchical Source

I have a JSON response that I want to flatten into a database record but the only solution I’ve been able to find is to call the API call twice and then join them.

I feel like during training there was a better way to do this. I’ve received errors using other transformations.

Hi ,

In this case you can directly map your fields from a single API Response to your database object. It should flatten your data. No need to use an extra API Rest Client or a join.

Let me know if you have any confusion.


Due to some cardinality issue, we are unable to flatten the data from three different streams (parent and two sibling children) i.e., item, email, sms.

Instead of calling the same API multiple times, a more proper approach would be to make a single API call, use a Passthru Transformation to flatten two streams (parent and child nodes), and then use a Join Transformation to combine data from the third stream (sibling of the child).