Sep 09 2020 06:01 AM
Need help connecting to MS Office 365 Graph API through on-premise SSIS. Standard SSIS components don't work due to authentication (need OAuth 2.0)
I do have a code from Power BI (M Query) that works, so most probably need an equivalent in C#.
" = () as text => let Source = Json.Document(Web.Contents("https://login.microsoftonline.com/" & #"Tenant Id" & "/oauth2/token", [Content = Text.ToBinary("client_id=" & #"Client Id" & "&resource=https%3A%2F%2Fgraph.microsoft.com" & "&client_secret=" & #"Client Secret" & "&grant_type=client_credentials") ,Headers=[#"Content-Type"="application/x-www-form-urlencoded", Accept="application/json"]])), access_token = Source[access_token] in access_token " #"Tenant Id", #"Client Id", #"Client Secret" are parameters that I am planning to pass.
What and how should be used in SSIS?
Thank you,
Dovilė