Which Azure service should I use to get the Bing ads performance (like costs and clicks) via API?

Question

Which Azure service should I use to get the Bing ads performance (like costs and clicks) via API? My ultimate goal is to load Bing ads performance to AWS S3/ Redshift. I was able to prove it out that I could load Google ads performance data to S3/ Redshift using AWS Glue (similar excercise).

A little more context why I asked the Azure service I should use, I was trying to set up all prerequisite and was in the step of authentication oauth register. I was following the below instruction link (see 1) so that I can get the Bing ads performance report via API. When I clicked the another link referred in step 1, it returned the error from Microsoft Azure page (see 2). So I guess I need to register with Azure service and wonder which service I should use for API reporting. If so, Azure DevOps seems a good option?

1) Document to make api call: https://learn.microsoft.com/en-us/advertising/guides/authentication-oauth-register?view=bingads-13

2) Error:
Microsoft Azure
my work email
You don't have access to this
Your sign-in was successful but you don't have permission to access this resource.

Answer 1

Hi. @JadeNguyen

Is your account an organizational account?
This step requires you to register your application with Azure AD. In many companies, in order to manage employees with Azure AD, it is often the case that the operation authority to Azure AD is controlled.

You should share the document URL with the administrator of your organization and grant them Azure AD operation privileges.