blog.atwork.at

news and infos about microsoft, technology, cloud and more

How to access files stored in OneDrive or in a SharePoint site with Microsoft Graph and the Excel API

The Microsoft Graph API is the new unified endpoint for developers accessing data from an Office 365 tenant. Amongst many other features, you can work with OneDrive and SharePoint files with the Graph REST API. Additionally, you can directly work with Excel files through the Graph Excel API. Since all samples I found just use the personal OneDrive for Business (OFB) file storage, I wanted to document how to access files that are stored in a SharePoint Online site (SPO) as well. So, here we go!

Import and export data to an Azure SQL Database

BCP, the bulk copy program utility is still around - and it’s helpful! It’s a long time, since I used this tool, but nowadays it got promoted for one of my daily jobs. See a short description how to use the Microsoft Command Line Utilities with Azure SQL Database for connecting and importing and exporting data quickly.

atwork participates at "The Art of Data Management" event

The new GDPR comes in force in 6 months. From then on, every business processing personal data has to fulfil the statutory European data privacy laws. A violation can result in high fines and penalties. Within the cost free seminar series "The Art of Data Management", taking place in Germany and Austria, atwork prepares you for the statutory changes.

See you at Thrive conference in Slovenia!

SharePoint Days conference has evolved to Thrive conference! We are looking forward to Thrive conference in beautiful Rimske Terme/Slovenia from 8th to 9th November! Join us and a bunch of experts and MVP fellows at this great event that’s close to Austria and Central Europe!

Forward emails from a Microsoft Account to a Work Account

Many of us have a Microsoft Account (MSA) that we use for Microsoft Azure or similar Microsoft services. But in reality, with Office 365, we’re used to work with our Work-or-School Account (AAD). So, often it is helpful to forward all mails from one MSA to the work account primarily used. This can be accomplished easily!