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 :/
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!
Stay tuned, it's web-service-week on the channel, much more to come ;)
Best CONTENT on yt...
That’s something that I planed to do tomorrow:) Thanks, Erik!
27:52 you forgot about Request Content assignment, yes, I was almost yelling :D
Gotta keep you on your toes :)
Awesome ! Erik can you do a lecture on something like triggers precedence :)
These's already a video on that, go find it :)
@@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 :/
Something with validate perhaps
@@Hougaard Got it, Thanks
Word of the day: JsonGymnastics 😂