{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/83ef99454231464b91f90d6c7604432a\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/83ef99454231464b91f90d6c7604432a-00001.gif","duration":296.894,"title":"Using Power Query M to Grab Data with the Mcast API","description":"In this video, I will show you how to use Power Query M to grab data with the Mcast API. I will start by generating an API key and then demonstrate how to set up the query in Excel using the ReadMe example. I will walk you through the steps of selecting the data source, accessing the Advanced Editor, and copying and pasting the code. Finally, I will make some adjustments to the code to customize the query. No action is required from you, this video is for informational purposes only."}