Hey there!
So, I heard you're in need of a Power BI custom connector using the Power Query SDK in Visual Studio for a RESTful API. Well, fear not, because I'm here to save the day! I understand that you can't spill the beans on the API details just yet, but no worries, I'm a pro at handling confidential information.
From what I gather, we'll be performing 4 separate API calls, retrieving JSON data, and transforming it into a format Power BI can gobble up. Easy-peasy, right? Authentication is a piece of cake with just an API key, and we'll be juggling those unique IDs like a pro circus performer.
Oh, and let's not forget about those user-specified 'start' and 'end' data parameters, because we definitely don't want to leave them hanging. And hey, if there's a limit on the number of rows, no sweat! We'll make multiple calls to get all that juicy data.
If you think I'm the right person for this quirky adventure, let's connect and have a chat. I'm all ears for any questions you may have. Looking forward to saving the day together!
Cheers!