Just to add to this. The last "rows" array is actually not standard array of jsonObjects, but it's an array of JsonValues. So to get appInsights values we need to know exact order of columns and then associate values to columns. So in Erik example that should look like var columnJV: JsonValue; valueTxt: text; row.Get(0, T); //eventId columnJV := T.AsValue(); valueTxt := columnJV.AsText() row.Get(1, T); //companyName columnJV := T.AsValue(); valueTxt := columnJV.AsText() row.Get(2, T); //message columnJV := T.AsValue(); valueTxt := columnJV.AsText()
Great video and very useful to understand how to call web services and get results. In the Microsoft official documentation they should put links to this video, I'm sure many AL developers would appreciate it. Thank you Erik!
@@Hougaard I have searched in your videos library with TRIGGERS as a keyword, but did not find a single video with Triggers in the title, i wonder where that video is :/