I wanted to kickstart something here – we/I get a lot of questions from various places about “how to do X” with the API. The API documentation itself is great, but it doesn’t really tell you how to think your way through a particular problem set. If you aren’t familiar with the Shotgun schema or how different entities interrelate, you can have a hard time figuring out how to find the exact information you’re looking for. I know that when I started out, I oftentimes knew what I needed, but had a hard time figuring out how to ask the right question.
If you find yourself in the same boat, you’re in the right place! In this topic, I’m going to post examples of a few things that I’ve had to figure out in the past, in hopes that it will help someone else out there. The examples are specific-to-general, but the thing I like about them is that each one has bits in it that are 100% applicable to other kinds of queries. If you’ve had a particularly gnarly “how can I get at X data from Shotgun” in the past, please feel free to share here with a post of your own! The more, the merrier.