Exploring and understanding managed associations in CAP - Part 4

In the last part of this mini-series, we work through the construction of the link entity for a many-to-many relationship between our entities. As always, diving into and discussing the details at every turn. Everyone welcome, especially beginners!

Topics:
Managed associations, CAP, OData, miller, CSV

Links:
This week's SAP Developer News: https://groups.community.sap.com/t5/application-development/sap-developer-news-june-1st-2023/m-p/263855
Back-to-basics managed association guide: https://github.com/qmacro/managed-associations-in-cap/tree/main/guide
Miller documentation: https://miller.readthedocs.io/en/6.7.0/
A talk on OData v4 and CAP: https://github.com/qmacro/odata-v4-and-cap/blob/main/slides.md

Chapters:
00:00 Welcome and introduction
04:55 Looking at where we left off last time
08:50 Understanding and fixing the CSV import error with the csvdelfield script
15:00 Exposing the Books_Authors link entity in the Z service
18:30 Examining the beauty of the metadata details
21:57 Confirming that the new LinkEntity entity set, and the navigation properties that point into there, are currently empty
25:15 Adding data to the link entity to relate books and authors
28:30 Checking the new data in the LinkEntity entity set and seeing how they're just pairs of IDs
29:55 Starting to traverse the first step from books to the link entity and understanding that this is only the first of two steps in the books to authors navigation that we really want
31:45 Using the power of OData v4 to "expand the expand" and take that second step!
34:00 Figuring out the subtle difference between the 'authors' and 'author' navigation properties, by following the trail in the metadata
39:08 Ending on a literary note (on Emily Brontë vs Ellis Bell) by creating a multiple author for a single book scenario via a further CSV record (a pair of IDs) for the link entity
42:42 Treating the participants to a terrible rendition of Kate Bush's Wuthering Heights (https://youtu.be/-1pMMIe4hb4?t=42)
43:15 Following the authors navigation property to see the two authors, and expanding the expand (via the author navigation property) to see the names
44:25 Wrapping up (including a subconscious reference to the "same person" scene from Hot Fuzz https://www.youtube.com/watch?v=rFbUsPEv4dY)