Skip to main content
To homepage To homepage
SUBMITTED

Handling JSON arrays in the table builder

Related products:Data source providers
  • August 20, 2025
  • 1 reply
  • 55 views
L
Participant
Forum|alt.badge.img

Hi team,

 

We've encountered that JSON with a nested array inside takes the lowest node of the XSLT generated by the table builder down to the level of said array, instead of keeping it at the desired base node.

 

When running the generated XSLT in a table flattening endpoint the output does not reflect the actual data structure and number of rows of the input.

 

Is it possible to implement a change in the table builder so that a nested array no longer "breaks” the data and keeps the base node at the "original” level? See the related for more detailed information.

 

Best,

 

Luuk Bouman

    1 reply

    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+8
    • rory.smith
    • TimeXtender Xpert
    • August 21, 2025

    Hi,

    the issue here is exemplified by: 

     

    Another common occurence is to have more than one ‘subtable’ inside a JSON below the level you need to use as the lowest. In that case you can only really choose one for the table builder and would need to make more endpoints or something more advanced to handle a relatively simple structure.

    I think it would be really useful to be able to apply a setup (expansion node, “join” between flattened record and subtables, etc.) and immediately be able to see the result, perhaps only in a schematic that shows the operations. This avoids a lot of back-and-forth between tweaking settings, hacking xlst and then diving into the logging to try and get closer to what you want. It probably also would make it clearer to understand what is going on for users that are not used to thinking in JSON / XML structures.

      Terms and ConditionsAccessibility statement