Great video once again Erik. One of my favorites!!

Awesome explanations Erik, thanks a lot!

Great video Eric. Thanks a lot!

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...🙂

An absolute gem for us old Navigator coders that can barely spell to JSON ;)

Thank you Master, great explanations and interesting as always!!

Great video on Jason

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.

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? :)

@Hougaard

3 жыл бұрын

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.

@bjarkihall2876

3 жыл бұрын

​@@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 :)

@Hougaard

3 жыл бұрын

@@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...

@bjarkihall2876

3 жыл бұрын

@@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. :(

@Hougaard

2 жыл бұрын

I need a bit more information to be able to help you, what is the sourcetable of the page that has the repeater element?

@greycatstechllp3545

2 жыл бұрын

The source table is sales order

@greycatstechllp3545

2 жыл бұрын

@@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?

@Hougaard

3 жыл бұрын

Good suggestion, keep watching the channel.

@LandscapeInMotion

3 жыл бұрын

@@Hougaard also, what’s the easiest way to export business central online data to a SQL data warehouse with live data feeds?

@Hougaard

3 жыл бұрын

@@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 :)

@LandscapeInMotion

3 жыл бұрын

@@Hougaard great! Odata will only export the entities, but not the raw sql tables right?

@Hougaard

3 жыл бұрын

@@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