I would like to have a custom module where Youtube videos will be embedded as a CCK field.
The video field will not be manually set. Instead, it will do a search query on Youtube API (something like searchListByKeyword) based on other CCK fields and get the first hit and embed this video.
I will give an example to make it more understandable and for a moment let's assume that this site was built on Drupal: https://www.lyrics.com/lyric/25244898/Talking+Heads/Born+Under+Punches
In this page you can guess that the embedded video was dynamically added to the page.
The search query was generated by the artist name and the song title. The query was send to YouTube's API and it returned the first result and embedded that video.
This is exactly what I want to achieve. Where the embedded video, is a CCK field that was loaded dynamically based on search query of existing CCK fields (in this example artist name and song title).
The module should provide a UI for selecting from which CCK field it will generate the search query, along with an option to enter additional text string.
I guess the whole process should take place on page loading of the node (drupal_render_page?).
But I am open to suggestions.