如何通过Postman获取MongoDB中store文档的products数组？

解决方案 #

要获取store文档内的products数组，你可以通过添加字段投影功能实现，既保留原有接口灵活性，又能按需返回指定字段：

1. 修改StoreDAO的getStore方法

在方法参数中新增projection选项，并在store.find()中传入该参数，让MongoDB只返回需要的字段：

static async getStore({ filters = null, page = 0, storePerPage = 20, projection = {} } = {}) {
  let query;
  if (filters) {
    if ("name" in filters) {
      query = { $text: { $search: filters["name"] } };
    } else if ("zipcode" in filters) {
      query = { zipcode: { $eq: filters["zipcode"] } };
    }
  }

  let cursor;

  try {
    // 传入projection参数
    cursor = await store.find(query, projection);
  } catch (e) {
    console.error(`Unable to issue find command, ${e}`);
    return { storeList: [], totalNumStore: 0 };
  }

  const displayCursor = cursor.limit(storePerPage).skip(storePerPage * page);

  try {
    const storeList = await displayCursor.toArray();
    const totalNumStore = await store.countDocuments(query);

    return { storeList, totalNumStore };
  } catch (e) {
    console.error(
      `Unable to convert cursor to array or problem counting documents, ${e}`
    );
    return { storeList: [], totalNumStore: 0 };
  }
}

2. 在StoreController中处理字段参数

添加对fields查询参数的解析，支持指定单个或多个字段：

static async apiGetStore(req, res, next) {
  const storePerPage = req.query.storePerPage
    ? parseInt(req.query.storePerPage, 10)
    : 20;
  const page = req.query.page ? parseInt(req.query.page, 10) : 0;

  let filters = {};
  if (req.query.zipcode) {
    filters.zipcode = req.query.zipcode;
  } else if (req.query.name) {
    filters.name = req.query.name;
  }

  // 新增字段投影逻辑
  let projection = {};
  if (req.query.fields) {
    const fields = req.query.fields.split(',');
    fields.forEach(field => {
      projection[field.trim()] = 1;
    });
    // 可选：不需要返回_id字段则添加此行
    // projection._id = 0;
  }

  const { storeList, totalNumStore } = await storeDao.getStore({
    filters,
    page,
    storePerPage,
    projection // 传入投影参数
  });

  let response = {
    store: storeList,
    page: page,
    filters: filters,
    entries_per_page: storePerPage,
    total_results: totalNumStore,
    requested_fields: req.query.fields || "全部字段"
  };
  res.json(response);
}

3. 在Postman中使用

发送GET请求，通过fields参数指定只返回products：

GET http://localhost:5002/api/v1/store?name=Apple&fields=products

需要同时返回多个字段时，用逗号分隔：

GET http://localhost:5002/api/v1/store?name=Apple&fields=name,products

备选方案：新增专门端点

如果需要更清晰的接口设计，可以新增端点（比如/api/v1/store/:storeId/products）直接返回指定store的products数组，避免和原有列表接口混淆。

内容的提问来源于stack exchange，提问作者Shagufta