Expand my Community achievements bar.

Extract Tasks Details + Nested Comments (Notes) as JSON

Avatar

Level 2


Hi Community,
I’m building a Fusion scenario to extract all tasks details from a specific project along with all their comments/updates (Notes) and their replies structured as nested JSON. 
I’d appreciate any guidance on optimizing this setup or best practices for handling the nested data efficiently.

Thanks in advance!

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 6

Hi @yearahull,

 

I have never done this so far but if I had to do it I would do something like this , fetch the tasks and all of the related updates and 

Tasks.png

then from there have it all in a aggregated json 

Json.png

which gives you a json string looking something like

 

[{"ID":"IDED_TESTED","name":"SOME NAME","updates":[]},{"ID":"IDED_TESTED","name":"SOME_NAME","updates":[]},{"ID":"SOME_ID","name":"SOME_NAME","updates":[]}]

 

Hopefully this helps.

 

Best regards,
Ivan