Hi All,

I am getting this error message:

Expression.Error: We cannot convert a value of type Record to type Number. Details: Value=[Record] Type=[Type]

with the following Power Query code

let
Source = Excel.CurrentWorkbook(){[Name="ARV_Table"]}[Content],

// Step 1: Filter data
FilteredRows = Table.SelectRows(Source, each [Address] <> null and [DCK ARV] = null),

// Step 2: Construct API URLs
ConstructedURLs = Table.AddColumn(FilteredRows, "API_URL", each "https://api.rentcast.io/v1/avm/value?address=" & Uri.EscapeDataString([Address]) & "%2C%20" & Uri.EscapeDataString([City]) & "%2C%20TX%2C%20" & Text.From([ZipCode])),

// Step 3: Invoke the API and parse the JSON response
InvokeAPI = Table.AddColumn(ConstructedURLs, "API_Response", each Record.Field(Json.Document(Web.Contents([API_URL]{0}), "price"), [Headers=[#"X-API-Key"="api-key"]])),

// Step 4: Extract the Price value from the JSON response
ExtractPrice = Table.AddColumn(InvokeAPI, "Price", each [API_Response][price]),

// Step 5: Remove unnecessary columns
Result = Table.SelectColumns(ExtractPrice, {"Address", "DCK ARV", "Price"})
in
Result

The data table is Address, City, ZipCode, DCK ARV

I have provided code only in place of the workbook because it contains API keys. I retracted the sensitive data. Please help if you can, I appreciate any guidance.

Regards,

Greg Sasser