Hi,
I am trying to connect to sf hosted mcp server using named query api as a tool(was trying something related to headless 360).
Above is screenshot for Named Query API in org. I have enabled this in API catalog too. I have tried connecting this MCP server as a claude connector. Still getting issues. Am I missing something here ?
Can someone please suggest if I am missing something here ?
#Integration
@Amiya Das Sandip's right, fix the casing first, that's definitely causing the query to fail.
But even after that, getting the SF-hosted MCP server talking to Claude cleanly is its own headache. A few things that have caught people out:
Your connected app needs cdp_query_api scope explicitly — general api scope isn't enough for Named Query / Data Cloud endpoints.
Double check the MCP server URL is your org-specific one, not a generic Salesforce endpoint.
Claude's MCP connector can be finicky with Salesforce's OAuth flow specifically, it doesn't always complete the handshake correctly even when everything looks right on the Salesforce side.
If you've sorted the query bug and the connection is still unreliable , I've seen people work around it by routing through DataGrout, it sits between your Salesforce tools and the MCP client and handles the auth layer so you're not fighting the connector. Not saying that's your only option but worth a look if you're still stuck.