Is there a way to get the attached file from a record?

The only join I've seen for this is from Message records. There's no other join to Files for any other record type. It's a bit frustrating. I've used a hybrid search and query merging in the past to do this in mass.

Thanks @burkybang I have used the search in the script to avoid the double API calls.