After several nights of pure frustration trying to get OAuth working in VBA/Excel I got the latter to work. However YDL seems more intuitive to me and possibly more flexible\powerful.
My first question is if either technique is more/less advantageous than the other. For instance using YDL you can join multiple tables, but you cannot in the API. Not sure if that's true, just an example.
My second question is how do I get YDL to work with the whole OAuth process. I tried replacing my resource with the YDL but got OST_OAUTH_SIGNATURE_INVALID_ERROR. I tried separating the base url out and adding the query as a parameter, but got the same result. I'm guessing I just don't have stuff in the right spot but I can't find an example to go off of.
If I can get the same data using the API that I can from using YDL then I'll just go that route since I have it working, but if YDL provides more options then I'd like figure this out.
I started out very excited about this API, but I'm close to throwing my laptop through the deck door and curling up in the fetal position. Hopefully someone can help me and restore my excitement.