{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/113272339e424218b5dd5ccebd245c33\" 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/113272339e424218b5dd5ccebd245c33-bf6699be690ae573.gif","duration":803.414,"title":"Connecting to the Hawkin Dynamics API with Power Query Scripts v1.20260109","description":"In this video, I walk you through our template file for connecting to the Operating Dynamics API using Power Query. I explain how to input your credentials, including your region and organization name, and how to set the start date for loading historical data to avoid errors from overloading the system. I also highlight the importance of adjusting privacy settings to ensure smooth data retrieval. Please make sure to follow the steps I outlined, especially regarding the date format and security settings, to successfully load your data. If you have any questions or encounter issues, feel free to reach out!"}