Very educational and very helpful demonstration. Should you ever decided to revisit this topic, it would be helpful to cover some examples that treated BC record handling--e.g., working with master and detail BC records in and out of json structures; how json works with RecordRef situations. Also: in what types of scenarios are the Type of a Token actually unknown? Thanks again.
Do you know when to use Dictionary/List instead of a JsonObject/JsonArray, is there a significant performance difference between these models (a reason not to just always use Json types)? You also did a video on TextBuilder vs Text for big concats of strings which made a huge difference. Is there a similar example for Json structures? The Base app has some old codeunits that manage read/write of Json structures with some kind of a TextBuilder, would that make sense or is JsonObject.Add (n-times) + WriteTo(txt) better than JsonBuilder.Add (n-times) + ToText? Have you done any benchmarks on those? :)
@@Hougaard yes, that's why I'm wondering about where they shine, since compared to the Json types they are very limited. Do you know what the tradeoff is? Thanks for the regular content btw. it's always fun to watch :)
@@bjarkihall2876 I have begun using dictionaries as "alternative" keys, like for a "HasSeen" structure. In BCCL I keep all data internally as JSON but use Dictionaries for list od fields etc...
@@Hougaard I've been using them the same way but I had been wondering if it really had any benefits. I guess it's the type validation and ease of use (e.g. you can declare them as Dictionary of [Guid, Boolean], so nothing else gets in) and potentially it has some performance benefits too, as long as we don't need to convert the structure to/from text/json/stream (though, it's possible to do it with a loop).
Hi Erik, I need assistance if you could help me out or guide. I have added a repeater in the sales order form. Now, whatever inputs i give in particular cells, the same values get reflected even in the next sales order that is going to be filled in. :(
@@LandscapeInMotion All data export has to be done with OData web services right now. I have an alternative solution in the works, but not ready to be revealed :)
![SAFEPLANET - ดาวเคราะห์ [ THE PLANET ]](http://i.ytimg.com/vi/4X1XL3I_k3c/mqdefault.jpg)
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
An absolute gem for us old Navigator coders that can barely spell to JSON ;)
Thank you for this video. Very helpful to get into the subject. I will look at other json videos you did, before I ask some questions...🙂
Awesome explanations Erik, thanks a lot!
Very educational and very helpful demonstration. Should you ever decided to revisit this topic, it would be helpful to cover some examples that treated BC record handling--e.g., working with master and detail BC records in and out of json structures; how json works with RecordRef situations. Also: in what types of scenarios are the Type of a Token actually unknown? Thanks again.
Great video once again Erik. One of my favorites!!
Great video Eric. Thanks a lot!
Thank you Master, great explanations and interesting as always!!
Great video on Jason
Hi Erik, would you be kind to demonstrate how can we have a JsonObject and store it in a blob field. thank you
Do you know when to use Dictionary/List instead of a JsonObject/JsonArray,
is there a significant performance difference between these models (a reason not to just always use Json types)?
You also did a video on TextBuilder vs Text for big concats of strings which made a huge difference. Is there a similar example for Json structures? The Base app has some old codeunits that manage read/write of Json structures with some kind of a TextBuilder, would that make sense or is JsonObject.Add (n-times) + WriteTo(txt) better than JsonBuilder.Add (n-times) + ToText?
Have you done any benchmarks on those? :)
The datatype in Dictionary/List are only the primitive type, so that reduces the usefulness of them. For complex structures json is the way to go.
@@Hougaard yes, that's why I'm wondering about where they shine, since compared to the Json types they are very limited. Do you know what the tradeoff is?
Thanks for the regular content btw. it's always fun to watch :)
@@bjarkihall2876 I have begun using dictionaries as "alternative" keys, like for a "HasSeen" structure. In BCCL I keep all data internally as JSON but use Dictionaries for list od fields etc...
@@Hougaard I've been using them the same way but I had been wondering if it really had any benefits. I guess it's the type validation and ease of use (e.g. you can declare them as Dictionary of [Guid, Boolean], so nothing else gets in) and potentially it has some performance benefits too, as long as we don't need to convert the structure to/from text/json/stream (though, it's possible to do it with a loop).
Hi Erik, I need assistance if you could help me out or guide. I have added a repeater in the sales order form. Now, whatever inputs i give in particular cells, the same values get reflected even in the next sales order that is going to be filled in. :(
I need a bit more information to be able to help you, what is the sourcetable of the page that has the repeater element?
The source table is sales order
@@Hougaard Thankyou Erik, i would like to know if there is a way to initialize a whole repeater?
Thanks - how to add new form fields to existing forms with AL?
Good suggestion, keep watching the channel.
@@Hougaard also, what’s the easiest way to export business central online data to a SQL data warehouse with live data feeds?
@@LandscapeInMotion All data export has to be done with OData web services right now. I have an alternative solution in the works, but not ready to be revealed :)
@@Hougaard great! Odata will only export the entities, but not the raw sql tables right?
@@LandscapeInMotion Well, if you get all records and all fields (if you create API pages to do that), then it equal to raw SQL.
Please make a video on How to Integrated Currency exchange rate service with XE.com