Cannot convert value to type List

[AlexS2023]

Hi All,

I'm trying to use API's to pull data into PowerBI. Below is meant to pass my authentication details and return a bearer token for use in other queries. But I'm running into an error:

An error occurred in the ‘’ query. Expression.Error: We cannot convert the value "eyJhbGciOiJIUzUxMiJ9..." to type List.
Details:
Value=eyJhbGciOiJIUzUxMiJ9...
Type=[Type]

As you can see the function is finding a value, just not storing it correctly. Any ideas what I'm doing wrong?

Here is my function:

() =>
let
    body = [credentials=[username="MyUsername",password="MyPassword",company="MyCompany"]],
    Data=Json.Document(Web.Contents("https://secure.workforceready.eu/ta/rest/v1/login", 
        [Headers=[#"Content-Type"="application/json", #"Accept"="application/json",#"API-Key"="MyApiKey"], 
        Content=Json.FromValue(body)])),
    result = Record.Field(Data[token]{0},"token")
in
    result

TIA 🙂

[ImkeF · Accepted solution]

Hi @AlexS2023 ,
please try this one:

() =>
let
    body = [credentials=[username="MyUsername",password="MyPassword",company="MyCompany"]],
    Data=Json.Document(Web.Contents("https://secure.workforceready.eu/ta/rest/v1/login", 
        [Headers=[#"Content-Type"="application/json", #"Accept"="application/json",#"API-Key"="MyApiKey"], 
        Content=Json.FromValue(body)])),
    result = Data[token]
in
    result

[AlexS2023]

It worked! And I guess I was overcomplicating things.

Thank you you're a life saver.

[ImkeF]

Hi @AlexS2023 ,
you could try omitting the {0} like so:

() =>
let
    body = [credentials=[username="MyUsername",password="MyPassword",company="MyCompany"]],
    Data=Json.Document(Web.Contents("https://secure.workforceready.eu/ta/rest/v1/login", 
        [Headers=[#"Content-Type"="application/json", #"Accept"="application/json",#"API-Key"="MyApiKey"], 
        Content=Json.FromValue(body)])),
    result = Record.Field(Data[token],"token")
in
    result

[AlexS2023]

Thank you, sadly that didn't work. The new error message says it can't convert to type Record. I know there's something obvious I'm missing just can't see it yet 😄

An error occurred in the ‘’ query. Expression.Error: We cannot convert the value "eyJhbGciOiJIUzUxMiJ9..." to type Record.
Details:
Value=eyJhbGciOiJIUzUxMiJ9.eyJ...
Type=[Type]