Re: JSON to Datagrid
JSONToArray works well for me if your JSON is correct. Always use try when decoding from JSON to catch any errors. On Wed, Dec 8, 2021 at 12:58 PM Mike Kerner via use-livecode < use-livecode@lists.runrev.com> wrote: > completely off the top of my head, so this might not be quite right > jsonToArray > set the dgData of group "datagrid 1" to > > On Wed, Dec 8, 2021 at 11:39 AM Keith Clarke via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > Hi Skip, > > I don’t use Datagrids but have used a two-step process to get JSON into > > the Tree widget and a similar process may provide a direction of travel > to > > test…? > > > > 1. JSON-to-array > > > https://lessons.livecode.com/m/4071/l/1303394-how-to-read-in-data-from-a-json-file > > 2. Setting the array data of datagrid… > > > > Good luck. > > Best, > > Keith > > > > > On 8 Dec 2021, at 16:15, Skip Kimpel via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > > > > I have been googling a solution for this but have not found a solid > > > solution for this. > > > > > > Can anybody lead me in the right direction on this? > > > > > > SKIP > > > ___ > > > use-livecode mailing list > > > use-livecode@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > ___ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > -- > On the first day, God created the heavens and the Earth > On the second day, God created the oceans. > On the third day, God put the animals on hold for a few hours, >and did a little diving. > And God said, "This is good." > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Tom Glod Founder & Developer MakeShyft R.D.A (www.makeshyft.com) Mobile:647.562.9411 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: JSON to Datagrid
completely off the top of my head, so this might not be quite right jsonToArray set the dgData of group "datagrid 1" to On Wed, Dec 8, 2021 at 11:39 AM Keith Clarke via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Skip, > I don’t use Datagrids but have used a two-step process to get JSON into > the Tree widget and a similar process may provide a direction of travel to > test…? > > 1. JSON-to-array > https://lessons.livecode.com/m/4071/l/1303394-how-to-read-in-data-from-a-json-file > 2. Setting the array data of datagrid… > > Good luck. > Best, > Keith > > > On 8 Dec 2021, at 16:15, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > I have been googling a solution for this but have not found a solid > > solution for this. > > > > Can anybody lead me in the right direction on this? > > > > SKIP > > ___ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: JSON to Datagrid
Hi Skip, I don’t use Datagrids but have used a two-step process to get JSON into the Tree widget and a similar process may provide a direction of travel to test…? 1. JSON-to-array https://lessons.livecode.com/m/4071/l/1303394-how-to-read-in-data-from-a-json-file 2. Setting the array data of datagrid… Good luck. Best, Keith > On 8 Dec 2021, at 16:15, Skip Kimpel via use-livecode > wrote: > > I have been googling a solution for this but have not found a solid > solution for this. > > Can anybody lead me in the right direction on this? > > SKIP > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: JSON to Datagrid
To functions actually needed... need to be able to convert to a datagrid and I will be also pumping this data into a SQL server. SKIP On Wed, Dec 8, 2021 at 11:15 AM Skip Kimpel wrote: > I have been googling a solution for this but have not found a solid > solution for this. > > Can anybody lead me in the right direction on this? > > SKIP > ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
