Thank you , Lin. After tried with a few scenarios, I feel tWriteJSONField is not feasible enough to cater for complex JSON format. I have changed to use tJSONDoc* component which are available in Exchange.
Thanks, Lin. This approach works for now. Because it relies on "Group by" feature on tWriteJSONField to output one single line, this approach only works for constant count. What to do if count has different value? E.g.
Hello seanzhang1212, You can just create a field 'bidon'(french) and you don't use it at the end. I take the same exemple, if the field 'bidon' is 'count', you delete just the link of the 'count' in the component tWriteJSONField. I hope that is understandable for you.
Thank you , Lin. After tried with a few scenarios, I feel tWriteJSONField is not feasible enough to cater for complex JSON format. I have changed to use tJSONDoc* component which are available in Exchange.