Using CC api in Excel Power Query

[AccessPhil]

I want to use the CC api in excel power query. This means I need an api url and an authorization = token key. I don't see anything in the docs to help me set this up

[Courtney_E]

Hello AccessPhil,

Thank you for reaching out to Constant Contact API Developer Support. My team is here to assist outside software developers with questions about building into Constant Contact's API.

Please note that Microsoft Power Query  is a 3rd party product and not built or supported by Constant Contact, so we are limited in the support we can provide, but will try to answer any questions to the best of our ability as they pertain to Constant Contact’s API endpoints and functionality. Constant Contact makes these endpoints available for 3rd party developers to create integrations with our system.

I have linked Microsoft's process for implementing an OAuth flow below, as well as their Power Platform community and support links:

Learn > Power > Platform > Power Query  > Handling authentication

https://learn.microsoft.com/en-us/power-query/handling-authentication

Power Platform forums
https://community.powerplatform.com/

Power Platform Community Support Form
https://aka.ms/PowerPlatformCommunitySupport

Please have a look and let us know if you have any other questions!