Forum Discussion
How to use API to get data
- 1 year ago
Please follow the documentation. Use the payload parameter to make it a POST. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2
This is what i'm putting in m query:
let
url = "https://microworkcloud.com.br/api/integracao/terceiro",
headers = [
#"Content-Type" = "application/json",
#"Authorization" = "Bearer SUA_CREDENCIAL"
],
body = Json.FromValue([
idrelatorioconfiguracao = 375,
idrelatorioconsulta = 186,
idrelatorioconfiguracaoleiaute = 857,
idrelatoriousuarioleiaute = null,
ididioma = 1,
listaempresas = {1,2,3,4,5,6,7,8,9,10,11},
filtros = "DataInicialFiltrar=2025-02-14;ContaFinanceiraFiltrar=null;TipoContaFiltrar=null"
]),
response = Web.Contents(
url,
[
Headers = headers,
Content = body,
ManualStatusHandling = {400, 401, 500},
ManualCredentials = true
]
),
jsonResponse = Json.Document(response) // ← Sem encoding!
in
jsonResponse
But i have this error:
Expression.Error: 'ManualCredentials' não é uma opção de Web.Contents válida. As opções válidas são:
ApiKeyName, Content, ExcludedFromCacheKey, Headers, IsRetry, ManualStatusHandling, Query, RelativePath, Timeout