Adding REST API as Custom Column - Error: "We cannot convert a value of type Record to type List"

[Anonymous]

Hello All,

I have a table of identifiers using a rest API call. The table looks like this:

identifier	URL	datecreated	authorizeddate
a7f8sy9hh7g8ft55	https://api.neogov.com/rest/personnelactions/hire/a7f8sy9hh7g8ft55	2023-02-15T10:25:14.0270000	2023-02-15T10:25:14.0270000
sjgg839hkwjr0fkt	https://api.neogov.com/rest/personnelactions/hire/sjgg839hkwjr0fkt	2023-02-15T10:25:14.0270000	2023-02-15T10:25:14.0270000

I am adding a custom column that calls another api that reads the identifier and returns the api information.  Here is the code I use for the custom column. 

let

Source= Json.Document(Web.Contents("https://api.neogov.com/rest/personnelactions/hire/" & [ID], [Headers=[#"Content-Type" = "application/json",#"Authorization"= "Basic Token"]])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"

It errors for all rows saying a record can not be converted to list. Any help would be appreciated.

[Anonymous · Accepted solution]

I removed a conversion to table and just clalled the records then expanded the record. Here was teh code that worked:

let

Source= Json.Document(Web.Contents("https://api.neogov.com/rest/personnelactions/hire/" & [ID], [Headers=[#"Content-Type" = "application/json",#"Authorization"= "Basic Token"]]))

in

source

[lbendlin]

Please read the Web.Contents documentation again (especially the RelativePath section). Also make sure that your API call returns data and not an error message.