MemberSuite MCP by usefulapi

Return the API user and tenant that this connection uses, including ReceivesMemberBenefits status fields. Good first call. REST: GET /platform/v2/whoami.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Search individual contacts (people) with an MSQL statement, for example SELECT LocalID, FirstName, LastName, EmailAddress FROM Individual WHERE (LastName = 'Smith'). Use the ID column to update a person later. REST: GET /crm/v1/individuals/{tenantId}?msql=.

{
  "type": "object",
  "properties": {
    "msql": {
      "type": "string",
      "minLength": 1,
      "maxLength": 20000,
      "description": "MSQL statement, from a MemberSuite Console Advanced Search (choose MSQL in the output dropdown)."
    },
    "page": {
      "description": "Page number, starting at 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "page_size": {
      "description": "Records per page (1-100).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    }
  },
  "required": [
    "msql"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Search membership records with an MSQL statement, for example SELECT Owner.Name, Type.Name, JoinDate, ExpirationDate, ReceivesMemberBenefits FROM Membership. ReceivesMemberBenefits = true means an active member. REST: GET /membership/v1/memberships/{tenantId}?msql=.

{
  "type": "object",
  "properties": {
    "msql": {
      "type": "string",
      "minLength": 1,
      "maxLength": 20000,
      "description": "MSQL statement, from a MemberSuite Console Advanced Search (choose MSQL in the output dropdown)."
    },
    "page": {
      "description": "Page number, starting at 1.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "page_size": {
      "description": "Records per page (1-100).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    }
  },
  "required": [
    "msql"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Run any MSQL statement across modules, including joins. Use it for event registrations, for example SELECT LocalID, Individual.FirstName, Individual.LastName FROM EventRegistration('{eventGuid}') WHERE (CancellationDate IS NULL AND OnWaitList = 0). Pages with startPosition (row offset). REST: POST /platform/v2/dataSuite/executeSearch.

{
  "type": "object",
  "properties": {
    "msql": {
      "type": "string",
      "minLength": 1,
      "maxLength": 20000,
      "description": "MSQL statement, from a MemberSuite Console Advanced Search (choose MSQL in the output dropdown)."
    },
    "start_position": {
      "description": "Record offset of the first row (0 = first page).",
      "type": "integer",
      "minimum": 0,
      "maximum": 9007199254740991
    }
  },
  "required": [
    "msql"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

List the public saved searches in the Console, with their IDs. Filter by part of the name (letters, digits, spaces, _ . -). Use an ID with membersuite_run_saved_search. REST: POST /platform/v2/dataSuite/executeSearch with SavedSearch MSQL.

{
  "type": "object",
  "properties": {
    "name_contains": {
      "description": "Part of the saved search name.",
      "type": "string",
      "pattern": "^[A-Za-z0-9 _.-]{1,80}$"
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Run one public saved search by its ID and return its records. The ID comes from membersuite_list_saved_searches. REST: GET /platform/v2/dataSuite/executeSavedSearch/{savedSearchId}.

{
  "type": "object",
  "properties": {
    "saved_search_id": {
      "type": "string",
      "pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
      "description": "The saved search GUID."
    }
  },
  "required": [
    "saved_search_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Change the listed fields of one individual (contact). Only the fields you pass change. Pass standard fields in fields (for example FirstName, EmailAddress, Work_PhoneNumber) and custom fields (names ending __c) in custom_fields. Idempotent: the same call twice leaves the same data. Test in a MemberSuite Sandbox first. REST: PATCH /crm/v1/individuals/patch/{individualId}.

{
  "type": "object",
  "properties": {
    "individual_id": {
      "type": "string",
      "pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$",
      "description": "Individual GUID (the ID column from membersuite_search_individuals)."
    },
    "fields": {
      "description": "Standard fields to change, for example { \"FirstName\": \"Joey\" }.",
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {
        "type": [
          "string",
          "number",
          "boolean",
          "null"
        ]
      }
    },
    "custom_fields": {
      "description": "Custom fields to change; names end in __c, for example { \"AreaofExpertise__c\": \"Doctor\" }.",
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {
        "type": "string"
      }
    }
  },
  "required": [
    "individual_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}