Connecting to MS Office 365 Graph API through  on-premise SSIS

Frequent Visitor

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ė

0 Replies