Using CC api in Excel Power Query

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