• September 9, 2021

VIDEO – Query Blackboard REST API with PowerShell (HTTP POST)

Wanted to share full demo for how to query Blackboard REST API including steps below and PowerShell code.

1) Create Amazon AWS EC2 instance from AMI template
2) Default “administrator” login with instance ID
3) Register on Blackboard Developer portal (https://developer.blackboard.com)
4) Grant access to Amazon AWS instance of Blackboard
5) Run PowerShell for access token
6) Run PowerShell for query Courses (JSON success)

Cheers.

Video

Code

• https://github.com/spjeff/Blackboard-REST-API/blob/main/Blackboard-REST-API.ps1

Screenshots

References

• https://aws.amazon.com/marketplace/seller-profile?id=f6f7de05-e6d2-47f8-96e8-51cc4b38182b
• https://www.alltheducks.com/blog/using-curl-to-access-the-blackboard-rest-api

• September 9, 2021
• No Comments
• Uncategorized

• September 6, 2021

SharePoint Migration Tool (SPMT) – Move TEMP Drive

Running migration jobs with SPMT requires TEMP storage. Often 50+ GB and more than available C:\ drive. We see Windows O/S drive fill 100% with no free storage.

By default SPMT writes temp storage to [C:\Users\%USERNAME%\AppData\Roaming\Microsoft\] in the User Profile for current user running SPMT “microsoft.sharepoint.migrationtool.advancedapp.exe” Note how SPMT installs to the User Profile folder at [C:\Users\%USERNAME%\AppData\Local\Apps\SharePointMigrationTool\SPMT]

Before running SPMT migration, run CMD prompt and MKLINK /D to point a Symbolic Link folder and move TEMP drive. SPMT application will see the same original folder. However, files and folders added written are directed to different destination. Avoids full C:\ drive and halted migration. Cheers.

Video

Screenshots

Code

REM — REPLACE DRIVE LETTER X: AS NEEDED —

cd C:\Users\%USERNAME%\AppData\Roaming\Microsoft\
mklink /D MigrationToolStorage X:\MigrationToolStorage

References

• https://aka.ms/spmt
• https://aka.ms/spmt-ga-page
• https://spmt.sharepointonline.com/install/default.htm
• https://www.howtogeek.com/howto/16226/complete-guide-to-symbolic-links-symlinks-on-windows-or-linux/
• https://blogs.windows.com/windowsdeveloper/2016/12/02/symlinks-windows-10/

• September 6, 2021
• No Comments
• Uncategorized

• August 22, 2021

VIDEO – Query MS Dataverse tables with FetchXML Builder and XRMToolBox

Wanted to share awesome demo with complete end-to-end steps for how to download, install, configure, and use Fetch XML Builder to query Microsoft Dataverse Tables for PowerPlatform, PowerApps, PowerAutomate, and more.

Cheers

Video

Code

<fetch top="50" aggregate="true" >
  <entity name="contact" >
    <attribute name="address1_stateorprovince" alias="contactstate" groupby="true" />
    <attribute name="contactid" alias="contactcount" aggregate="count" />
  </entity>
</fetch>

Screenshots

References

• https://ajitpatra.com/2020/09/28/powerautomate-perform-group-by-operation-on-data/
• https://crmkeeper.com/2019/08/31/cds-list-records-filter-query-using-flow/
• https://fetchxmlbuilder.com/features/
• https://www.inogic.com/blog/2011/04/group-by-using-fetchxml/
• https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-aggregation?WT.mc_id=BA-MVP-5002475&utm_source=FetchXMLBuilder&utm_medium=XrmToolBox
• https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-aggregation?WT.mc_id=BA-MVP-5002475&utm_source=FetchXMLBuilder&utm_medium=XrmToolBox#group-by
• https://fetchxmlbuilder.com/
• https://www.xrmtoolbox.com/

• August 22, 2021
• No Comments
• Uncategorized

• August 21, 2021

VIDEO – MS Flow Try/Catch with SCOPE

Wanted to record brief demo of SCOPE feature and how we can use “Run After” conditions to continue action steps. For robust and reliable workflow, we isolate single action errors to continue. Cheers.

Screenshot

Video

References

• August 21, 2021
• No Comments
• Uncategorized