I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.
Issue:
Trying to access a JSON file that is behind an app proxy using Power Automate. However, when they try to access the API directly, they receive a 302-error redirecting them to login, which terminates the flow.
Solution:
To fix this issue please follow below steps:
- Build a custom connector in power Automate and direct it to the proxy
- make sure proxy is on same tenant as power automate. despite the tenant being set, it didn't work when the proxy was on a different tenant, worked after moving it
- if your api is not Azure AD log in but is oauth, you might need to do the work around we did and tell the api to look at a different header for authorization. You can't set authorization header in custom connector, so we passed an access-token header and got the API to swap this to auth header when it received the request.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
I hope this helps! Thank you again for your time and patience throughout this issue.
Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.