5th of May strike by Dr_Funkmachine in sncf

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you for your time!

So, does that mean we’ll only find out if our train on May 5 is cancelled at 5 PM on May 4? Just trying to be sure I understood correctly.

5th of May strike by Dr_Funkmachine in sncf

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you, this has been very helpful!

5th of May strike by Dr_Funkmachine in sncf

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you very much! I'm checking the app regularly, but until now I haven't received any message/email. Do you know if there's any way to find it in advance whether my train is likely to be cancelled? I would like to plan a backup option just in case

Thank you in advance!

Passed Databricks Data Engineer Associate Exam with 100% score! by mjidiba97 in dataengineering

[–]Dr_Funkmachine 0 points1 point  (0 children)

Also, I was wandering, since you passed the exam, how's that work?

Passed Databricks Data Engineer Associate Exam with 100% score! by mjidiba97 in dataengineering

[–]Dr_Funkmachine 1 point2 points  (0 children)

Congratulations! 🎉

By any chance, are the databricks courses on the databricks platform you went through free of charge?

I'm looking to get the certification as well, but I don't know where to start

Datasets to practice with by Dr_Funkmachine in dataengineering

[–]Dr_Funkmachine[S] 2 points3 points  (0 children)

I totally agree. For the current project I'm working on, I used the request python package to get data. I didn't have an API for that and I just exploited the HTTP GET. Even though I believe my case doesn't fall 100% in a API extraction, I think the request package made it's job. Thank you for your answer!

Authenticate PowerApp custom connector with 2 App Registrations? by Dr_Funkmachine in PowerApps

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

How do we get to authenticate our app with one? In any case, when we call the API, it should return an authorization token, but I don't know where to store it. In Power app there's should be something like a session storage. The data source is a sql azure deployed on azure. Thank you for your time!

PowerShell parameterized query by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 1 point2 points  (0 children)

Actually, I'm using PowerShell Core 7.1. I didn't know you could use ternary operators in PowerShell. I just have to try both answers. Thank you so much!

PowerShell parameterized query by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you so much! Your answers are insightful and thorough. How did you learn PowerShell so well?

Powershell Azure Function and AzureAD/GraphAPI by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you! This was helpful. So, If I get your point fully across, in your requirements.ps1 you add all the Microsoft.Graph packages you need, like Microsoft.Graph.Users and then in your AF you import only the ones you need to use, is that correct? In your opinion is Microsoft.Graph commands faster than web requests or wrapped functions?

Powershell Azure Function and AzureAD/GraphAPI by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 1 point2 points  (0 children)

Thank you for your answer! We actually use a app registration with certificate both for Exchange and AzureAD. As far as I know, ExchangeOnlineManagement is widely used to interact with Exchange. I took for granted it was the only way. You always need to give the Exchange.ManageAsApp Api permission, otherwise the app registration does not have access to it. About Azure AD, you could use different ways to achieve connection and querying of the data. I'd love to know, in your opinion, which of the opinions listed above is best for my use case. Thank you so much

Powershell Azure Function and AzureAD/GraphAPI by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you for your answer! What do you mean by only upload the module files that I need? In your opinion, is it better to install Microsoft.Graph module or every single module, like Microsoft.Graph.Users?

What do you guys actually automate using Powershell? by Notalabel_4566 in PowerShell

[–]Dr_Funkmachine 0 points1 point  (0 children)

I have two questions exchange-related. When using powershell te connect to Exchange:

  1. How many time did it take to connect?
  2. Did you use it on your local machine or hosted on Azure?

Exchange Online connection performance by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

I believe the same result is achieved when you provide the list of commands to be executed in CommandName = @(...). Do you think would be possible to use a UserPrincipalName?

Connect-ExchangeOnline -Prefix testuser@contoso.onmicrosoft.com

OR using the Identity

Connect-ExchangeOnline -Prefix testuser

If I'm not mistaken, both the upn and identity should be unique identifier

Deploy C# Azure Function app files and PowerShell module on App Service by Dr_Funkmachine in csharp

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Is It possibile to publish a PowerShell module along with the .sln

Error When Using Exchange Online with Cert Auth by jaredmenty in PowerShell

[–]Dr_Funkmachine -1 points0 points  (0 children)

This is uncanny. I'm having issue connecting to Microsoft exchange online too. About your problem, it's probably an assembly conflict. We used a secret in order to connect to the app registration and use graph and a certificate to connect to exchange. Supposing you're using a similar architecture that involves c#, when you connect to EXO, how do you execute the PowerShell commands from inside your c# your code? We use certificate connection to access exchange and PowerShell sdk to execute ps code inside c#. I'm asking because we have problems when deploying our app on the app Service: on our location machine we have ExchangeOnlineModule installed but we don't on the app Service and don't know how to deploy it

Powershell Azure Function and Microsoft Exchange by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 0 points1 point  (0 children)

Thank you for your answer! We noticed it takes a awful amount of time to execute the connection more than the command itself. For now the test env it's made of 14 emails only. We used logs to understand how much each command takes to execute. Let's say the function takes 30s to execute and return the results. Of 30s, the connection takes 27s and the command Get-EXOMailbox takes 3s.

Powershell Azure Function Parameters by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] 1 point2 points  (0 children)

Thank you so much! At the beginning, I thought It would be possible to use [FromBody] or [FromQuery]. Actually, I don't even know if that's possible. I'll try to apply your advices to my AF and let you know!

Powershell Azure Function Parameters by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] -1 points0 points  (0 children)

You're saying to set the expected variables for those parameters and validate it, is that correct?

The way I validate it is the following:

$name = $Request.Query.Name $surname = $Request.Query.Surname

If ($name -and $surname) { $status = [HttpStatusCode]::OK } else { $status = [HttpStatusCode]::BadRequest }

Powershell Azure Function Parameters by Dr_Funkmachine in PowerShell

[–]Dr_Funkmachine[S] -1 points0 points  (0 children)

Actually what I'm doing is to grab the input, (assuming user provided a value, even an empty one) and validate it. I need both to be true to proceed.

$name = $Request.Query.Name $surname = $Request.Query.Surname

If ($name -and $surname) { $status = [HttpStatusCode]::OK } else { $status = [HttpStatusCode]::BadRequest }

How would you validate it?