Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
Hi,
I am trying to convert infotable data into JSON. The fields order available in InfoTable is not same in JSON string.
How to reorder the fields in InfoTable? Fields not follow the infotable order in JSON. How to resolve this?
My Infotable:
Converrted JSON:
{"rows":[{"Description":"Demo","AddedOn":1596949613100,"AddedBy":"Administrator","TemplateFile":"Report.xlsx","Template":"Report Demo"}],"dataShape":{"fieldDefinitions":{"Description":{"name":"Description","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":2},"AddedOn":{"name":"AddedOn","aspects":{"isPrimaryKey":false},"description":"","baseType":"DATETIME","ordinal":4},"AddedBy":{"name":"AddedBy","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":5},"TemplateFile":{"name":"TemplateFile","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":3},"Template":{"name":"Template","aspects":{"isPrimaryKey":true},"description":"","baseType":"STRING","ordinal":1}}}} |
Solved! Go to Solution.
Thanks for the response.
I got a solution with ordinal of the fields.
Regards,
Sathishkumar C.
Hi,
You can sort the infotable using sort() function as below:
result.Sort({ name: "Name", ascending: true });
Thanks for the response.
I got a solution with ordinal of the fields.
Regards,
Sathishkumar C.