[BC Idea]: Pagination for MicrosoftGraph module

[Drakonian]

BC Idea Link

https://experience.dynamics.com/ideas/idea/?ideaid=4cd79c04-344c-f011-a2da-7c1e52b4c1ef

Description

While working on the SharePoint Graph module #3655, I noticed that the MicrosoftGraph module lacks direct support for pagination. So I created something similar within the SharePoint Graph module. However, as rightly pointed out in the PR, pagination is generally applicable to any section of the Graph API.

Therefore, it might be a good idea to implement additional functionality in the Microsoft Graph module to handle pagination. We could then also use this functionality within the SharePoint Graph module.

I have prepared one possible implementation of pagination for MicrosoftGraph module and would welcome any comments. (soon it will be in new PR)

I will provide the implementation for this BC Idea

• I will provide the implementation for this BC Idea

[Drakonian]

Right now fighting vs. error in process of dev container creation

.\build\scripts\DevEnv\NewDevEnv.ps1 -ContainerName 'BCApps-Dev3' -ProjectPaths '.\src\System Application\*'

Publishing apps...
Publishing Microsoft_System Application_27.0.0.0.app to http://172.25.223.189:7049/BC/dev/apps?SchemaUpdateMode=forcesync&Depen
dencyPublishingOption=ignore&tenant=default
Status Code 422 : Unprocessable Entity
Publishing failed due to 'Could not install the extension 'MCP API' by 'Microsoft' (version '27.0.0.0') on tenant 'default' and
 company 'CRONUS International Ltd.' due to the following error: 'This application is not supported in the current environment.
' and AL stack trace: 
"MCP API Install"(CodeUnit 1576).OnInstallAppPerCompany line 3 - MCP API by Microsoft version 27.0.0.0
"Extension Triggers"(CodeUnit 2000000010).OnInstallAppPerCompany(Event) line 2
'. The original extensions could not be restored due to No published extensions match the specified parameter values..
Extensions that were previously installed but could not be reinstalled. These extensions should be manually reinstalled. If the
y are part of your current workspace, you can use the 'Full Dependency Publishing' command to do so

[JesperSchulz]

Right now fighting vs. error in process of dev container creation

.\build\scripts\DevEnv\NewDevEnv.ps1 -ContainerName 'BCApps-Dev3' -ProjectPaths '.\src\System Application\*'

Publishing apps...
Publishing Microsoft_System Application_27.0.0.0.app to http://172.25.223.189:7049/BC/dev/apps?SchemaUpdateMode=forcesync&Depen
dencyPublishingOption=ignore&tenant=default
Status Code 422 : Unprocessable Entity
Publishing failed due to 'Could not install the extension 'MCP API' by 'Microsoft' (version '27.0.0.0') on tenant 'default' and
 company 'CRONUS International Ltd.' due to the following error: 'This application is not supported in the current environment.
' and AL stack trace: 
"MCP API Install"(CodeUnit 1576).OnInstallAppPerCompany line 3 - MCP API by Microsoft version 27.0.0.0
"Extension Triggers"(CodeUnit 2000000010).OnInstallAppPerCompany(Event) line 2
'. The original extensions could not be restored due to No published extensions match the specified parameter values..
Extensions that were previously installed but could not be reinstalled. These extensions should be manually reinstalled. If the
y are part of your current workspace, you can use the 'Full Dependency Publishing' command to do so

For this we need @aholstrup1 / @mazhelez. Could you please take a look?

[JesperSchulz]

Generally sounds like a good idea. Approved.

[aholstrup1]

@Drakonian can you try:
.\build\scripts\DevEnv\NewDevEnv.ps1 -ContainerName 'BCApps-Dev3' -ProjectPaths '.\src\System Application\*' -RebuildApps

[Drakonian]

@aholstrup1

Thanks, this parameter helped.
I thought clearing the artifacts folder is same as this param, but looks like it does more.

Also, I want to point out a recurring problem, I face it all the time. The latest tests usually break the build, I always have to delete these tests, create a container, and then return new tests back. Looks like some kind of caching or build queue issue. After I deleted/commented all the problematic tests. (EmailRetry/PDFDocument,etc) It starts to works.

.\build\scripts\DevEnv\NewDevEnv.ps1 -ContainerName 'BCApps-Dev6' -ProjectPaths '.\src\System Application\*' -RebuildApps

Compiling...
.\alc.exe /project:"C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test" /packagecachepath:"C:\Users\Drakonian\D
ocuments\AL\BCApps\artifacts\BCApps-Dev6" /out:"C:\Users\Drakonian\Documents\AL\BCApps\artifacts\BCApps-Dev6\Microsoft_System A
pplication Test_27.0.0.0.app" /BuildBy:BcContainerHelper,6.1.6 /assemblyprobingpaths:C:\Users\Drakonian\Documents\AL\BCApps\art
ifacts\BCApps-Dev6\CompilerFolder\dlls\OpenXML,C:\Program Files\dotnet\shared\Microsoft.NETCore.App\8.0.17,C:\Program Files\dot
net\shared\Microsoft.AspNetCore.App\8.0.17,C:\Users\Drakonian\Documents\AL\BCApps\artifacts\BCApps-Dev6\CompilerFolder\dlls\Ser
vice,C:\Users\Drakonian\Documents\AL\BCApps\artifacts\BCApps-Dev6\CompilerFolder\dlls\Mock Assemblies
Microsoft (R) AL Compiler version 16.0.23.64921
Copyright (C) Microsoft Corporation. All rights reserved

Compilation started for project 'System Application Test' containing '221' files at '15:16:13.393'.

C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(22,29): error AL0185: T
able 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(41,21): error AL0185: T
able 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(78,21): error AL0185: T
able 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(115,21): error AL0185: 
Table 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(151,21): error AL0185: 
Table 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(471,69): error AL0185: 
Page 'Email Retry Detail' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(471,47): error AL0240: 
The signature of procedure 'EmailRetryDetailPageHandler' does not match the signature required by attribute 'ModalPageHandler':
 parameter 1 is expected to be of type 'var TestPage' but found type 'var '. The expected signature is: EmailRetryDetailPageHan
dler(var Page: TestPage).
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(197,21): error AL0185: 
Table 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(262,21): error AL0185: 
Table 'Email Retry' is missing
C:\Users\Drakonian\Documents\AL\BCApps\src\System Application\Test\Email\src\EmailRetryTest.Codeunit.al(451,21): error AL0185: 
Table 'Email Retry' is missing

Compilation ended at '15:16:18.645'.

Compile-AppWithBcCompilerFolder Telemetry Correlation Id: e13cb1cb-1dd8-474f-8616-161908852c2c
Error building apps: App generation failed
Removing compiler folder C:\Users\Drakonian\Documents\AL\BCApps\artifacts\BCApps-Dev6\CompilerFolder
Skipped creating container as it already exists. You can access the webclient by going to http://BCApps-Dev6/BC/ in your browse
r
Skipped building apps.
Skipped publishing apps.
App generation failed
At C:\Program 
Files\WindowsPowerShell\Modules\BCContainerHelper\6.1.6\CompilerFolderHandling\Compile-AppWithBcCompilerFolder.ps1:520 char:9
+         throw "App generation failed"
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (App generation failed:String) [], RuntimeException
    + FullyQualifiedErrorId : App generation failed

[Drakonian]

@aholstrup1

Even though the container-creation script ran successfully, I’m still having problems. I can’t load Business Central in the browser. I’ve tried both Microsoft Edge and Google Chrome, but all I get is the endless “Getting ready…” spinner. The browser console shows errors.

error place

---

I also used -AlwaysPull to grab the latest Docker image, but that didn’t help. What’s more, if I create a container with a simple New-BcContainer command, it works fine (for BC26), so this doesn’t look like a Docker issue on my Windows 10 machine.

Get-BcContainerGenericTag -container BCAppsDev
1.0.2.71

Do you have any ideas on what I should look into?

[Drakonian]

Looks like related to
microsoft/navcontainerhelper#3971