### Execute Repository Workflow Commands Source: https://codeappjs.com Standard npm commands for installing dependencies and starting the development server. ```bash npm install npm start npm run start:codeapp ``` -------------------------------- ### SharePoint Connection Reference Configuration Source: https://codeappjs.com Example configuration for a SharePoint Online connection reference. This defines how the application connects to SharePoint. ```json "connectionReferences": { "sharepointonline": { "id": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline", "displayName": "SharePoint", "dataSources": ["sharepointonline"], "authenticationType": null, "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Call Teams Operation Example Source: https://codeappjs.com Example of calling a generic Teams operation using the `callTeamsOperation` helper. Use this for operations not directly exposed as specific helper functions. ```javascript await callTeamsOperation('GetAllTeams', {}); ``` -------------------------------- ### Dataverse Connection Reference Configuration Source: https://codeappjs.com Example configuration for a Microsoft Dataverse connection reference. Ensure 'databaseReferences.default.cds.dataSources' entries match your entity set names. ```json "connectionReferences": { "dataverse": { "id": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps", "displayName": "Microsoft Dataverse", "dataSources": ["commondataserviceforapps"], "authenticationType": null, "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Get SQL Tables Source: https://codeappjs.com Retrieves tables from a SQL Server database. Server and database can be specified, defaulting to 'default' if omitted. ```javascript await getSqlTables({ server: 'default', database: 'default' }); ``` -------------------------------- ### Get a contact Source: https://codeappjs.com Retrieves details for a specific contact. ```javascript await getContact('Contacts', sContactId); ``` -------------------------------- ### Jira Connection Reference Configuration Source: https://codeappjs.com Configuration for the Jira connection reference. This setup includes an API token for authentication and specifies the Jira site via the `X-Request-Jirainstance` header. ```json "connectionReferences": { "jira": { "id": "/providers/Microsoft.PowerApps/apis/shared_jira", "displayName": "Jira", "dataSources": ["jira"], "authenticationType": "APIToken", "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Enable Debugger in Dataverse Source: https://codeappjs.com Call this function to enable the debugger for Dataverse operations. No specific setup is required. ```javascript enableDebugger(); ``` -------------------------------- ### Get Email Source: https://codeappjs.com Retrieves an email by message ID with optional settings. ```javascript await getEmail(sMessageId, { includeAttachments: true }); ``` -------------------------------- ### Get mail tips Source: https://codeappjs.com Retrieves mail tips for a specific mailbox address. ```javascript await getMailTips({ mailboxAddress: 'alex@contoso.com' }); ``` -------------------------------- ### Teams Connection Reference Configuration Source: https://codeappjs.com Configuration for the Microsoft Teams connection reference. This setup is used to establish a connection to the Teams API. ```json "connectionReferences": { "teams": { "id": "/providers/Microsoft.PowerApps/apis/shared_teams", "displayName": "Microsoft Teams", "dataSources": ["teams"], "authenticationType": null, "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Get SQL Rows Source: https://codeappjs.com Fetches rows from a specified SQL table with optional filtering, ordering, and limiting. Server and database default to 'default'. ```javascript await getSqlRows({ table: '[dbo].[Employees]', filter: "Department eq 'Engineering'", top: 50, orderBy: 'LastName asc' }); ``` -------------------------------- ### Execute PAC CLI Deployment Commands Source: https://codeappjs.com Commands for authenticating, managing connections, and deploying the application to Power Platform. ```bash pac auth create pac auth list pac env select --environment "environment-id" pac connection list pac connection create --name "connection-name" --application-id "app-id" --client-secret "secret" --tenant-id "tenant-id" pac code add-data-source -a "connection-name" -c "connection-id" pac code push --solutionName YourSolutionName ``` -------------------------------- ### power.config.json Configuration Source: https://codeappjs.com This is the main app manifest file. It defines display name, environment, build output, connection references, and Dataverse sources for your Code App. ```json { "appDisplayName": "YOUR APP NAME", "description": "", "environmentId": "", "buildPath": "./dist", "buildEntryPoint": "index.html", "logoPath": "./dist/icon-512.png", "localAppUrl": "http://localhost:3000", "region": "prod", "connectionReferences": {}, "databaseReferences": {} } ``` -------------------------------- ### Get an Outlook event Source: https://codeappjs.com Retrieves details for a specific event. ```javascript await getEvent(sEventId, 'Calendar'); ``` -------------------------------- ### Get Email Attachment Source: https://codeappjs.com Retrieves an attachment from an email by ID. ```javascript await getEmailAttachment(sMessageId, sAttachmentId, { mailboxAddress: 'shared@contoso.com' }); ``` -------------------------------- ### Create a contact Source: https://codeappjs.com Adds a new contact to the specified folder. ```javascript await createContact('Contacts', { GivenName: 'Alex', Surname: 'Wilber', EmailAddresses: [{ Address: 'alex@contoso.com' }] }); ``` -------------------------------- ### Define connection references Source: https://codeappjs.com Configuration object for Office 365 Groups connection. ```json "connectionReferences": { "office365groups": { "id": "/providers/Microsoft.PowerApps/apis/shared_office365groups", "displayName": "Office 365 Groups", "dataSources": ["office365groups"], "authenticationType": null, "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Get Outlook calendar view Source: https://codeappjs.com Retrieves events within a specific date range for a calendar. ```javascript await getCalendarView({ calendarId: 'Calendar', startDateTimeUtc: '2026-04-01T00:00:00Z', endDateTimeUtc: '2026-04-02T00:00:00Z' }); ``` -------------------------------- ### Supported Raw Jira Actions Source: https://codeappjs.com A list of all supported raw Jira connector actions. ```APIDOC ## Raw Jira Actions ### Description This section lists all the raw actions available for the Jira connector. ### Actions - AddComment_V2 - CancelTask_V2 - CreateIssue_V3 - EditIssue_V2 - GetCurrentUser - GetIssue_V2 - ListFilters_V2 - ListIssues - ListProjects_V2 - GetTask_V2 - GetUser_V2 - EditIssue - DeleteProject - UpdateProject - DeleteProject_V2 - UpdateProject_V2 - GetAllProjectCategories - CreateProjectCategory - GetAllProjectCategories_V2 - CreateProjectCategory_V2 - RemoveProjectCategory - RemoveProjectCategory_V2 - GetTask - CancelTask - GetUser - CreateIssue - CreateIssueV2 - GetIssue - UpdateIssue - UpdateIssue_V2 - AddComment - ListIssueTypes - ListIssueTypes_V2 - ListIssueTypesFields - ListIssueTypesFields_V2 - ListProjects - CreateProject - CreateProject_V2 - ListProjects_V3 - ListStatuses - ListStatuses_V2 - ListProjectUsers - ListProjectUsers_V2 - ListAssignableUsers - ListAssignableUsers_V2 - ListPriorityTypes - ListPriorityTypes_V2 - ListFilters - ListResources - ListIssues_Datacenter - ListTransitions - UpdateTransition - OnNewIssue - OnNewIssue_V2 - OnNewIssue_Datacenter - OnCloseIssue - OnCloseIssue_V2 - OnCloseIssue_Datacenter - OnUpdateIssue - OnUpdateIssue_V2 - OnUpdateIssue_Datacenter - OnNewIssueJQL - OnNewIssueJQL_V2 - OnNewIssueJQL_Datacenter - mcp_JiraIssueManagement ``` -------------------------------- ### Get Team Helper Source: https://codeappjs.com Helper function to retrieve details for a specific team. Requires the `teamId` as a parameter. ```javascript await getTeam('00000000-0000-0000-0000-000000000000'); ``` -------------------------------- ### Workspace Layout for Agents and Skills Source: https://codeappjs.com This is the recommended directory structure for VS Code to automatically discover custom agents and skills. Place agent files in `.github/agents/` and skill files in `.github/skills//`. ```plaintext .github/ agents/ codeapp.agent.md skills/ connections/SKILL.md dataverse/SKILL.md environment-variables/SKILL.md frontend-design/SKILL.md jira/SKILL.md office365-groups/SKILL.md office365-outlook/SKILL.md office365-users/SKILL.md sharepoint/SKILL.md sql/SKILL.md teams/SKILL.md ``` -------------------------------- ### Get Item from Dataverse Source: https://codeappjs.com Retrieves a specific item from a Dataverse table by its ID. You can specify which fields to select. ```javascript await getItem('cr_contacts', 'cr_contactid', sContactId, ['cr_name', 'createdon']); ``` -------------------------------- ### Add Data Source using PAC CLI Source: https://codeappjs.com Run this command after creating a connector connection to generate typed source files for connectors. This ensures operation names, parameter shapes, and return models are up-to-date. ```bash pac code add-data-source -a "connection-name" -c "connection-id" ``` -------------------------------- ### Execute SQL Query Source: https://codeappjs.com Executes a raw SQL query against the database. Server and database default to 'default'. ```javascript await executeSqlQuery({ query: "SELECT TOP 10 * FROM [dbo].[Employees] WHERE Department = 'Engineering'" }); ``` -------------------------------- ### Get Office 365 User Photo Source: https://codeappjs.com Retrieve the profile photo for a specific user, identified by their user ID. ```javascript await getUserPhoto('alex@contoso.com'); ``` -------------------------------- ### Call SQL Operation Source: https://codeappjs.com Use this helper to call any raw SQL operation. Defaults for server and database are 'default' if not supplied. ```javascript await callSqlOperation('GetTables_V2', { body: { server: 'default', database: 'default' } }); ``` -------------------------------- ### Get Single SQL Row Source: https://codeappjs.com Retrieves a single row from a SQL table by its ID. Server and database default to 'default'. ```javascript await getSqlRow({ table: '[dbo].[Employees]', id: 42 }); ``` -------------------------------- ### Create SharePoint File Source: https://codeappjs.com Creates a new file in a specified SharePoint document library. Requires the site URL, library name, file name, and content. ```javascript await createFile('https://contoso.sharepoint.com/sites/demo', '/Shared Documents', 'notes.txt', 'Draft notes'); ``` -------------------------------- ### List Azure Key Vault Key Versions Source: https://codeappjs.com Fetches all versions of a specific key from Azure Key Vault. Provide the key name as an argument. ```javascript await listKeyVersions('app-encryption-key'); ``` -------------------------------- ### Define Connection Reference Source: https://codeappjs.com Configuration object for establishing an Office 365 Outlook connection reference. ```json "connectionReferences": { "Office365Outlook": { "id": "/providers/Microsoft.PowerApps/apis/shared_office365", "displayName": "Office 365 Outlook", "dataSources": ["Office365Outlook"], "authenticationType": null, "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Get Azure Key Vault Secret Source: https://codeappjs.com Retrieves a specific secret from Azure Key Vault. The secret name is required. ```javascript await getSecret('codeapp-api-key'); ``` -------------------------------- ### Get My Trending Documents Source: https://codeappjs.com Retrieve a list of documents that are trending for the current user. Supports filtering based on document properties. ```javascript await getMyTrendingDocuments({ filter: "resourceVisualization/title ne null" }); ``` -------------------------------- ### Get Current User Information (Dataverse) Source: https://codeappjs.com Retrieves the current user's ID. This is a simple utility function with no parameters. ```javascript const sUserId = await whoAmI(); ``` -------------------------------- ### Retrieve Jira Configuration and Users Source: https://codeappjs.com Functions to list statuses, users, priorities, resources, and current user details. ```javascript await listJiraStatuses({ jiraInstance: 'https://contoso.atlassian.net', projectId: '10000', issueType: 'Bug' }); ``` ```javascript await listJiraProjectUsers({ jiraInstance: 'https://contoso.atlassian.net', projectKey: 'DEMO' }); ``` ```javascript await listJiraAssignableUsers({ jiraInstance: 'https://contoso.atlassian.net', projectKey: 'DEMO' }); ``` ```javascript await listJiraPriorityTypes({ jiraInstance: 'https://contoso.atlassian.net' }); ``` ```javascript await listJiraResources(); ``` ```javascript await getCurrentJiraUser({ jiraInstance: 'https://contoso.atlassian.net', expand: ['groups'] }); ``` ```javascript await getJiraUser('5b10a2844c20165700ede21g', { jiraInstance: 'https://contoso.atlassian.net', expand: ['groups'] }); ``` -------------------------------- ### Get Environment Variable from Dataverse Source: https://codeappjs.com Retrieves the value of a specified environment variable from Dataverse. Ensure the variable name is correct. ```javascript const sSite = await getEnvironmentVariable('wd_sharepointsite'); ``` -------------------------------- ### Get Channel Details Helper Source: https://codeappjs.com Helper function to retrieve details for a specific channel within a team. Requires both `teamId` and `channelId`. ```javascript await getChannelDetails('00000000-0000-0000-0000-000000000000', '19:demochannel@thread.tacv2'); ``` -------------------------------- ### Configure Dataverse Data Source Map Source: https://codeappjs.com Defines the environment variable tables within the database references configuration. ```json { "databaseReferences": { "default.cds": { "dataSources": { "environmentvariabledefinitions": { "entitySetName": "environmentvariabledefinitions", "logicalName": "environmentvariabledefinition", "isHidden": false }, "environmentvariablevalues": { "entitySetName": "environmentvariablevalues", "logicalName": "environmentvariablevalue", "isHidden": false } } } } } ``` -------------------------------- ### Enable Application Debugging Source: https://codeappjs.com Initialize the debug panel to inspect API interactions within the browser. ```javascript import { enableDebugger } from './codeapp.js'; enableDebugger(); ``` -------------------------------- ### Get Relevant People for Office 365 User Source: https://codeappjs.com Retrieve a list of people relevant to a specific user, identified by their user ID. ```javascript await getRelevantPeople('alex@contoso.com'); ``` -------------------------------- ### Get SharePoint File Metadata Source: https://codeappjs.com Retrieves metadata for a specific file in SharePoint using its file ID. Requires the site URL. ```javascript await getFileMetadata('https://contoso.sharepoint.com/sites/demo', '01ABCDEF234567...'); ``` -------------------------------- ### Create SharePoint Item Source: https://codeappjs.com Creates a new item in a SharePoint list. Provide the site URL, list ID, and the fields for the new item. ```javascript await createSpItem('https://contoso.sharepoint.com/sites/demo', '{12345678-abcd-1234-abcd-123456789012}', { Title: 'New task' }); ``` -------------------------------- ### Get Single SharePoint Item Source: https://codeappjs.com Retrieves a single item from a SharePoint list by its ID. Requires the site URL and list ID. ```javascript await getSpItem('https://contoso.sharepoint.com/sites/demo', '{12345678-abcd-1234-abcd-123456789012}', 42); ``` -------------------------------- ### List contact folders Source: https://codeappjs.com Retrieves all contact folders. ```javascript await listContactFolders(); ``` -------------------------------- ### List Jira Issues in Datacenter Source: https://codeappjs.com Retrieves a list of Jira issues from a datacenter instance. ```javascript await listJiraIssuesDatacenter({ jiraInstance: 'https://contoso.atlassian.net' }); ``` -------------------------------- ### List rooms Source: https://codeappjs.com Retrieves available rooms. ```javascript await listRooms(); ``` -------------------------------- ### Define Azure Key Vault Connection Reference Source: https://codeappjs.com Configures the connection reference for Azure Key Vault authentication. ```json "connectionReferences": { "keyvault": { "id": "/providers/Microsoft.PowerApps/apis/shared_keyvault", "displayName": "Azure Key Vault", "dataSources": ["keyvault"], "authenticationType": "oauthDefault", "sharedConnectionId": null, "dataSets": {} } } ``` -------------------------------- ### Get Azure Key Vault Secret Metadata Source: https://codeappjs.com Retrieves metadata for a specific secret in Azure Key Vault. The secret name is required. ```javascript await getSecretMetadata('codeapp-api-key'); ``` -------------------------------- ### SharePoint Connector Actions Source: https://codeappjs.com This section lists the available actions for interacting with SharePoint, including file operations and data retrieval. ```APIDOC ## SharePoint Connector Actions ### Available Actions - `GetItems` - `GetItem` - `PostItem` - `PatchItem` - `DeleteItem` - `GetTables` - `GetDataSetsMetadata` - `CreateFile` - `UpdateFile` - `DeleteFile` - `MoveFile` - `GetFileMetadata` ### `callOutlookHttpRequest({ uri, method, body, contentType, customHeaders })` #### Description Makes an HTTP request to the Outlook API. #### Method N/A (Helper function) #### Parameters - **uri** (string) - Required - The URI for the HTTP request. - **method** (string) - Required - The HTTP method (e.g., 'GET', 'POST'). - **body** (object) - Optional - The request body. - **contentType** (string) - Optional - The content type of the request body. - **customHeaders** (object) - Optional - Custom headers for the request. #### Request Example ```javascript await callOutlookHttpRequest({ method: 'GET', uri: 'https://graph.microsoft.com/v1.0/me/messages?$top=5' }); ``` ``` -------------------------------- ### Get Azure Key Vault Key Metadata Source: https://codeappjs.com Retrieves metadata for a specific key in Azure Key Vault. The key name is required. ```javascript await getKeyMetadata('app-encryption-key'); ``` -------------------------------- ### Get Team Tag Mention Token Helper Source: https://codeappjs.com Helper function to generate a mention token for a team tag. Requires `teamId` and `tagId`. ```javascript await getTeamTagMentionToken('00000000-0000-0000-0000-000000000000', 'tag-id'); ``` -------------------------------- ### Manage Jira Projects Source: https://codeappjs.com Functions for listing, creating, updating, and deleting Jira projects. ```javascript await listJiraProjects({ jiraInstance: 'https://contoso.atlassian.net' }); ``` ```javascript await createJiraProject({ jiraInstance: 'https://contoso.atlassian.net', key: 'DOCS', name: 'Docs Project' }); ``` ```javascript await updateJiraProject('DOCS', { jiraInstance: 'https://contoso.atlassian.net', name: 'Docs Project Updated' }); ``` ```javascript await deleteJiraProject('DOCS', { jiraInstance: 'https://contoso.atlassian.net', enableUndo: true }); ``` -------------------------------- ### Manage Jira Project Categories Source: https://codeappjs.com Functions for listing, creating, and removing project categories. ```javascript await listJiraProjectCategories({ jiraInstance: 'https://contoso.atlassian.net' }); ``` ```javascript await createJiraProjectCategory({ jiraInstance: 'https://contoso.atlassian.net', name: 'Internal Apps' }); ``` ```javascript await removeJiraProjectCategory(10000, { jiraInstance: 'https://contoso.atlassian.net' }); ``` -------------------------------- ### Get User Mention Token Helper Source: https://codeappjs.com Helper function to generate a mention token for a user. Requires the user's email address. ```javascript await getUserMentionToken('alex@contoso.com'); ``` -------------------------------- ### Get Office 365 User Photo Metadata Source: https://codeappjs.com Retrieve metadata for a specific user's profile photo, identified by their user ID. ```javascript await getUserPhotoMetadata('alex@contoso.com'); ``` -------------------------------- ### SQL Server Helper Functions Source: https://codeappjs.com Functions for interacting with SQL Server databases. ```APIDOC ## SQL Server Helper Functions ### Description Provides a set of helper functions to interact with SQL Server databases. ### Functions #### `callSqlOperation(operationName, parameters)` - **Description**: Calls a specified SQL Server operation. - **Parameters**: - `operationName` (string) - Required - The name of the SQL operation to call. - `parameters` (object) - Required - Parameters for the operation. Defaults for `server` and `database` are 'default'. - **Example**: ```javascript await callSqlOperation('GetTables_V2', { body: { server: 'default', database: 'default' } }); ``` #### `getSqlTables({ server, database })` - **Description**: Retrieves a list of tables from a SQL Server database. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - **Example**: ```javascript await getSqlTables({ server: 'default', database: 'default' }); ``` #### `getSqlRows({ server, database, table, filter, orderBy, top, select })` - **Description**: Retrieves rows from a SQL Server table. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `table` (string) - Required - The name of the table. - `filter` (string) - Optional - A filter expression for the rows. - `orderBy` (string) - Optional - An expression to order the rows by. - `top` (number) - Optional - The maximum number of rows to retrieve. - `select` (string) - Optional - A comma-separated list of columns to select. - **Example**: ```javascript await getSqlRows({ table: '[dbo].[Employees]', filter: "Department eq 'Engineering'", top: 50, orderBy: 'LastName asc' }); ``` #### `getSqlRow({ server, database, table, id })` - **Description**: Retrieves a single row from a SQL Server table by its ID. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `table` (string) - Required - The name of the table. - `id` (number) - Required - The ID of the row to retrieve. - **Example**: ```javascript await getSqlRow({ table: '[dbo].[Employees]', id: 42 }); ``` #### `insertSqlRow({ server, database, table, item })` - **Description**: Inserts a new row into a SQL Server table. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `table` (string) - Required - The name of the table. - `item` (object) - Required - The data for the new row. - **Example**: ```javascript await insertSqlRow({ table: '[dbo].[Employees]', item: { FirstName: 'Jane', LastName: 'Doe', Department: 'Engineering' } }); ``` #### `updateSqlRow({ server, database, table, id, item })` - **Description**: Updates an existing row in a SQL Server table by its ID. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `table` (string) - Required - The name of the table. - `id` (number) - Required - The ID of the row to update. - `item` (object) - Required - The updated data for the row. - **Example**: ```javascript await updateSqlRow({ table: '[dbo].[Employees]', id: 42, item: { Department: 'Product' } }); ``` #### `deleteSqlRow({ server, database, table, id })` - **Description**: Deletes a row from a SQL Server table by its ID. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `table` (string) - Required - The name of the table. - `id` (number) - Required - The ID of the row to delete. - **Example**: ```javascript await deleteSqlRow({ table: '[dbo].[Employees]', id: 42 }); ``` #### `executeSqlQuery({ server, database, query })` - **Description**: Executes a raw SQL query against a SQL Server database. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `query` (string) - Required - The SQL query to execute. - **Example**: ```javascript await executeSqlQuery({ query: "SELECT TOP 10 * FROM [dbo].[Employees] WHERE Department = 'Engineering'" }); ``` #### `executeSqlStoredProcedure({ server, database, procedure, parameters })` - **Description**: Executes a stored procedure in a SQL Server database. - **Parameters**: - `server` (string) - Optional - The SQL Server instance name. Defaults to 'default'. - `database` (string) - Optional - The database name. Defaults to 'default'. - `procedure` (string) - Required - The name of the stored procedure. - `parameters` (object) - Optional - Parameters for the stored procedure. - **Example**: ```javascript await executeSqlStoredProcedure({ procedure: '[dbo].[usp_GetTeamMembers]', parameters: { TeamId: 5 } }); ``` ``` -------------------------------- ### Jira Issue Listing (Datacenter) Source: https://codeappjs.com Lists Jira issues from a datacenter instance. ```APIDOC ## GET /api/jira/issues/datacenter ### Description Lists Jira issues from a datacenter Jira instance. ### Method GET ### Endpoint /api/jira/issues/datacenter ### Parameters #### Query Parameters - **oOptions** (object) - Required - Options for listing issues. - **jiraInstance** (string) - Required - The URL of the Jira datacenter instance. ### Request Example ```javascript await listJiraIssuesDatacenter({ jiraInstance: 'https://contoso.atlassian.net' }); ``` ### Response #### Success Response (200) - **issues** (array) - A list of Jira issues. #### Response Example ```json { "issues": [ { "id": "10002", "key": "DEMO-1" } ] } ``` ``` -------------------------------- ### Get Office 365 User Profile Source: https://codeappjs.com Retrieve the profile information for a specific user, identified by their user ID. Allows selecting specific fields. ```javascript await getUserProfile('alex@contoso.com', { select: ['displayName', 'department'] }); ``` -------------------------------- ### List SharePoint Libraries Source: https://codeappjs.com Retrieves a list of all available document libraries within a SharePoint site. Requires the site URL. ```javascript await listLibrary('https://contoso.sharepoint.com/sites/demo'); ``` -------------------------------- ### Get SharePoint Items Source: https://codeappjs.com Retrieves items from a SharePoint list. Requires the site URL and list ID. Options can specify sorting and the number of items. ```javascript await getItems('https://contoso.sharepoint.com/sites/demo', '{12345678-abcd-1234-abcd-123456789012}', { top: 20, orderBy: 'Modified desc' }); ``` -------------------------------- ### Draft Email Source: https://codeappjs.com Creates a draft email with the provided options. ```javascript await draftEmail({ to: 'alex@contoso.com', subject: 'Draft status', body: 'Review this first.' }); ``` -------------------------------- ### Create Item in Dataverse Source: https://codeappjs.com Creates a new item in a specified Dataverse table. Provide the table name, primary key, and the record data. ```javascript await createItem('cr_contacts', 'cr_contactid', { cr_name: 'Jane Doe' }); ``` -------------------------------- ### Get Specific Azure Key Vault Secret Version Source: https://codeappjs.com Retrieves a specific version of a secret from Azure Key Vault. Both secret name and secret version are required. ```javascript await getSecretVersion('codeapp-api-key', 'secret-version-id'); ``` -------------------------------- ### Get Office 365 User Manager Source: https://codeappjs.com Retrieve the manager of a specific user, identified by their user ID. Allows selecting specific fields of the manager's profile. ```javascript await getManager('alex@contoso.com', { select: ['displayName', 'mail'] }); ``` -------------------------------- ### List room lists Source: https://codeappjs.com Retrieves available room lists. ```javascript await listRoomLists(); ``` -------------------------------- ### List Office 365 Group Members Source: https://codeappjs.com Get a list of members for a specific Office 365 group. You can specify the number of members to retrieve using the 'top' option. ```javascript await listGroupMembers('00000000-0000-0000-0000-000000000000', { top: 25 }); ``` -------------------------------- ### Respond to an event invite Source: https://codeappjs.com Accepts or declines an event invitation with an optional comment. ```javascript await respondToEventInvite(sEventId, 'accept', { comment: 'See you there.' }); ``` -------------------------------- ### Subscribe to New Office 365 Group Events Source: https://codeappjs.com Set up a subscription to receive notifications when a new event is created in a specified Office 365 group. ```javascript await onNewGroupEvent('00000000-0000-0000-0000-000000000000'); ``` -------------------------------- ### Get Azure Key Vault Secret Version Metadata Source: https://codeappjs.com Retrieves metadata for a specific version of a secret in Azure Key Vault. Both secret name and secret version are required. ```javascript await getSecretVersionMetadata('codeapp-api-key', 'secret-version-id'); ``` -------------------------------- ### Get Azure Key Vault Key Version Metadata Source: https://codeappjs.com Retrieves metadata for a specific version of a key in Azure Key Vault. Both key name and key version are required. ```javascript await getKeyVersionMetadata('app-encryption-key', 'key-version-id'); ``` -------------------------------- ### Create an Outlook event Source: https://codeappjs.com Creates a new calendar event with specified subject, time range, and attendees. ```javascript await createEvent({ subject: 'Sprint review', start: '2026-03-14T16:00:00Z', end: '2026-03-14T17:00:00Z', attendees: ['alex@contoso.com'] }); ``` -------------------------------- ### Get Trending Documents for Office 365 User Source: https://codeappjs.com Retrieve a list of documents that are trending for a specific user, identified by their user ID. Supports filtering based on document properties. ```javascript await getTrendingDocuments('alex@contoso.com', { filter: "lastModifiedBy ne null" }); ``` -------------------------------- ### Execute Jira Operation Source: https://codeappjs.com Executes a generic Jira operation by name with provided parameters. ```javascript await callJiraOperation('ListProjects_V2', {}); ```