Unable to convert a value of type List in the Record Type in Query

[googlogmob]

Hi

I am trying to get records from а web-service

Using this code I have got an error

Unable to convert a value of type List in the Record Type.

http://prntscr.com/drhibr

let
    #"campaignsId_List"= Table.FromList(Table.Column(campaigns, "campaignId"), null, {"campaignId"}, null, null),

    Ссылка = "campaigns/statistics/balance?query[campaignId]=PGp8n",

    #"Запрос http" = Table.AddColumn(#"campaignsId_List", "responseJson", each Record.ToTable( Json.Document(Web.Contents(URL & Ссылка & [campaignId], [Headers=[#"X-Auth-Token"="api-key "& Token, #"X-Domain"= Domain , #"Content-Type"="application/json"]]))))
in
    #"Запрос http"

What is а cause of this error?

[ImkeF]

It could be that the Json.Document doesn't return a record, but a list instead.

Try the expression without the "Record.ToTable"-conversion and check the format of the returned Json.

[googlogmob]

ImkeF, Thank you

This error was because Record.ToTable have gotten null-string

Is there any way to exclude null-records?

[ImkeF]

Yes, you can use if .. then (for conditions) or try ... otherwise (as the error-handler).

What exactly shall happen: Skip the step & continue with the previous step instead or return a default-value?

[googlogmob]

ImleF, I need use "Skip the step & continue with the previous step"

Here is screen http://prntscr.com/drxkgm

Please help add this check to the code

let
    #"campaignsId_List"= Table.FromList(Table.Column(campaigns, "campaignId"), null, {"campaignId"}, null, null),

    Ссылка = "campaigns/statistics/balance?query[campaignId]=",

    #"Запрос http" = Table.AddColumn(#"campaignsId_List", "responseJson", each Record.ToTable( Json.Document(Web.Contents(URL & Ссылка & [campaignId], [Headers=[#"X-Auth-Token"="api-key "& Token, #"X-Domain"= Domain , #"Content-Type"="application/json"]]))))
in
    #"Запрос http"

[ImkeF · Accepted solution]

Had a closer look at your code and to me it looks as if you need to remove Errors from your column "responseJSON" (check the column -> righclick with mouse -> select "Remove Errors".

[googlogmob]

ImkeF, yes, it works!

Thank You 🙂