Can we only use mongoose if we create an IDO?

DM9346

 What if I have an API and I just want to manipulate the results and display it in listview. My goal is to manipulate this result below. I want to summarize the array into one row and convert the tenantName into columns

[ { "name": "test1", "summaryGroup": [ { "name": "test1", "tenantName": "TST", "isAvailable": true, "updatedOn": "2023-10-16T10:23:11.437Z", "updatedBy": "user5" }, { "name": "test1", "tenantName": "PRD", "isAvailable": true, "updatedOn": "2023-10-12T19:16:40.787Z", "updatedBy": "user1" } ] }, { "name": "test2", "summaryGroup": [ { "name": "test2", "tenantName": "TST", "isAvailable": true, "updatedOn": "2023-10-13T14:06:24.457Z", "updatedBy": "user1" } ] } ]

unknown

I find an IDO is better as you have more control over data types and property classes to keep the column headings consistent. You can use a "Dummy" table with unbound columns. But, no - you don't have to use an IDO. You can just add values to a grid control that isn't bound to an IDO. Use something like...

Dim oGrid As IWSFormComponent = ThisForm.Components("MyGridComponent")

oGrid.InsertGridRows(...)

oGrid.SetGridValue(...)

oGrid.DeleteGridRows(...)

Also - check out Newtonsoft //<Ref>Newtonsoft.Json.dll</Ref> if you haven't already. This will help you to read in the JSON without having to search for the property names each time.