Discussion on using GROQ queries to download files and resolving asset references in block content.

// GROQ query
*[_type == 'movie'] {
  title,
  "manuscriptURL": manuscript.asset->url
}

// Then you can use the URL in HTML for example like this:
// <a href={`${manuscriptURL}?dl=`}>Manuscript</a>

  "body": body[]{
    ...,
    _type == 'file' => {
      ...,
      "documentUrl": asset->url
    }
  }

    attachments[]{
      ...,
      "documentUrl": asset->url,
      "documentSize": asset->size,
      "documentOriginalFilename": asset->originalFilename,
    }

buildFileUrl(attachment._key, { dataset, projectId })

// Merge a single subquery into the root level of the result
*[_type == "category"] {
  title,
  "slug": slug.current,
  ...(parent-> {
    "parentTitle": title,
    "parentSlug": slug.current
  }) 
}

// Return all fields and resolve all fields in all 'categories' references
*[_type == "product" && defined(salePrice) && salePrice < displayPrice]{
  ...,
  categories[]->
}

  "services": *[_type == "service" && references(^._id)]{
    ...,
    attachments[]->
  },

 attachments: [
    {
      asset: [Object],
      _type: 'file',
      name: 'Senior Connections Resource Guide',
      _key: 'cc0020b7ff8d'
    }
  ],

"body": body[]{
  ...,
  _type == 'file' => {
    ...,
    "documentUrl": asset->url
  }
}

{
  asset: {
    _ref: 'file-f4005335534eb49e6edffea0b1596cd211b670e8-pdf',
    _type: 'reference'
  },
  _type: 'file',
  description: 'Maricopa Community Center Senior Programming Calendar for May 2023',
  _key: '96b1944a9636',
  documentUrl: 'MY DOCUMENT URL'
}