能否通过GraphQL基于name字段合并两个REST API数据？

Absolutely! GraphQL is perfectly suited for this kind of data aggregation and merging task. It’s exactly the kind of problem GraphQL was built to solve—acting as a single, flexible gateway that pulls data from multiple sources (like your two REST APIs) and shapes it into the exact format your client needs.

How to implement this with GraphQL #

You’ll need to set up a GraphQL server as a middle layer between your client and the two REST APIs. Here’s a step-by-step breakdown of how to make this work:

1. Define your GraphQL Schema #

First, create a schema that describes the merged data shape your client wants. We’ll define a Product type that includes all fields from both APIs, plus a query to fetch the combined results:

type Product {
  id: ID!
  name: String!
  price: Float!
  color: String!
  size: String!
}

type Query {
  getMergedProducts: [Product!]!
}

2. Write Resolvers to Fetch and Merge Data #

Resolvers are the functions that handle fetching data from your REST APIs and combining it. Here’s a practical example using JavaScript/Node.js (with fetch for simplicity):

// Helper to fetch data from a REST API
async function fetchAPI(url) {
  const res = await fetch(url);
  return res.json();
}

// Resolver logic for the query
const resolvers = {
  Query: {
    async getMergedProducts() {
      // Fetch data from both APIs in parallel
      const [products, priceData] = await Promise.all([
        fetchAPI("https://your-products-api.com/products"),
        fetchAPI("https://your-price-api.com/prices")
      ]);

      // Create a quick lookup map for prices (using name as the key)
      const priceMap = new Map(priceData.map(item => [item.name, item.price]));

      // Merge the product data with matching prices
      return products.map(product => ({
        ...product,
        price: priceMap.get(product.name)
      }));
    }
  }
};

3. Run the Query #

Once your server is up, your client can send a GraphQL query to get the merged data:

query {
  getMergedProducts {
    id
    name
    price
    color
    size
  }
}

And you’ll get exactly the response you’re targeting:

[ 
  { "id": "0001", "name": "a name", "price": 10, "color": "black", "size": "L" }, 
  { "id": "0002", "name": "an other name", "price": 20, "color": "red", "size": "M" } 
]

Why GraphQL is a great fit here #

• Single endpoint: Your client only needs to talk to one GraphQL gateway instead of two separate REST APIs, simplifying frontend logic.
• No over/under-fetching: You get exactly the fields you ask for—no extra data you don’t need, no missing data you have to fetch separately.
• Scalability: If you add more APIs later (like inventory or product reviews), you can extend the schema and resolvers without breaking existing client requests.

A quick note: Ensure the name field is a reliable unique identifier for matching products. If there’s a chance of duplicate names, use a more unique value (like a shared product ID) if both APIs expose one.

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