Skip to main content
Glama

mcp-google-sheets

index.ts3.2 kB
import { createPiece, PieceAuth, OAuth2PropertyValue, } from '@activepieces/pieces-framework'; import { PieceCategory } from '@activepieces/shared'; import { createFolderAction } from './lib/actions/create-folder'; import { createListAction } from './lib/actions/create-list'; import { createListItemAction } from './lib/actions/create-list-item'; import { updateListItemAction } from './lib/actions/update-list-item'; import { deleteListItemAction } from './lib/actions/delete-list-item'; import { findListItemAction } from './lib/actions/search-list-item'; import { uploadFile } from './lib/actions/upload-file'; import { createCustomApiCallAction } from '@activepieces/pieces-common'; const authDesc = ` 1. Sign in to [Microsoft Azure Portal](https://portal.azure.com/). 2. From the left sidebar, go to **Microsoft Enfra ID**. 3. Under **Manage**, click on **App registrations**. 4. Click the **New registration** button. 5. Enter a **Name** for your app. 6. For **Supported account types**, choose: - **Accounts in any organizational directory (Any Microsoft Entra ID tenant - Multitenant) and personal Microsoft accounts** - Or select based on your requirement. 7. In **Redirect URI**, select **Web** and add the given URL. 8. Click **Register**. 9. After registration, you’ll be redirected to the app’s overview page. Copy the **Application (client) ID**. 10. From the left menu, go to **Certificates & secrets**. - Under **Client secrets**, click **New client secret**. - Provide a description, set an expiry, and click **Add**. - Copy the **Value** of the client secret (this will not be shown again). 11. Go to **API permissions** from the left menu. - Click **Add a permission**. - Select **Power BI Service** → **Delegated permissions**. - Add the following scopes: - Sites.Manage.All - Files.ReadWrite - openid - email - profile - offline_access - Click **Add permissions**. 12. Copy your **Client ID** and **Client Secret**. ` export const microsoftSharePointAuth = PieceAuth.OAuth2({ description: authDesc, authUrl: 'https://login.microsoftonline.com/common/oauth2/v2.0/authorize', tokenUrl: 'https://login.microsoftonline.com/common/oauth2/v2.0/token', required: true, scope: [ 'openid', 'email', 'profile', 'offline_access', 'Sites.Manage.All', 'Files.ReadWrite', ], prompt: 'omit' }); export const microsoftSharePoint = createPiece({ displayName: 'Microsoft SharePoint', auth: microsoftSharePointAuth, minimumSupportedRelease: '0.27.1', logoUrl: 'https://cdn.activepieces.com/pieces/microsoft-sharepoint.png', categories: [PieceCategory.CONTENT_AND_FILES], authors: ['kishanprmr'], actions: [ createFolderAction, createListAction, createListItemAction, updateListItemAction, deleteListItemAction, findListItemAction, uploadFile, createCustomApiCallAction({ auth: microsoftSharePointAuth, baseUrl: () => 'https://graph.microsoft.com/v1.0/sites', authMapping: async (auth) => ({ Authorization: `Bearer ${(auth as OAuth2PropertyValue).access_token}`, }), }), ], triggers: [], });

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/activepieces/activepieces'

If you have feedback or need assistance with the MCP directory API, please join our Discord server