Forum Discussion

melanieArugula's avatar
melanieArugula
Frequent Visitor
5 years ago
Solved

Expression.Error: We cannot apply field access to the type Text.

I'm trying to get a list of solutions to vulnerabilities. The API link uses the vulnerability ID which is a combination of text and numbers. The error is in the GetSolution function where I'm using t...
Need Help
  • melanieArugula's avatar
    melanieArugula
    5 years ago

    This helped a lot, but I don't know exactly why, maybe because I was able to call the column from the table I was using. As I'm writing this I realize I could really condense the link situation, but in any case, I'm glad it's working. Thanks for your help! 

     

    let
    Source1 = Json.Document(Web.Contents("https://[link]/api/")),
    page = Source1[page],
    count = Number.ToText (page[totalResources]),
    Source2 = Json.Document(Web.Contents("https://[link]/api/?page=0&size=" & count & "&sort=id,asc")),
    Resources = Source2[resources],
    Table = Table.FromList(Resources, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Expand = Table.ExpandRecordColumn(Table, "Column1", {"id"}, {"id"}),
    txt = Table.TransformColumnTypes(Expand,{{"id", type text}}),
    Solution = Table.AddColumn(txt, "Solution", each Json.Document(Web.Contents("https://[link]/api/" & [id] & "/solutions"))),
    #"Expanded Solution" = Table.ExpandRecordColumn(Solution, "Solution", {"resources"}, {"Solution.resources"}),
    #"Expanded Solution.resources" = Table.ExpandListColumn(#"Expanded Solution", "Solution.resources")
    in
    #"Expanded Solution.resources"

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Since you are pulling a solution for each vulnerability why not integrate the second web call into the Vulnerabilities function? It would go in after the Expand line.

melanieArugula's avatar
melanieArugula
Frequent Visitor
5 years ago

This helped a lot, but I don't know exactly why, maybe because I was able to call the column from the table I was using. As I'm writing this I realize I could really condense the link situation, but in any case, I'm glad it's working. Thanks for your help! 

 

let
Source1 = Json.Document(Web.Contents("https://[link]/api/")),
page = Source1[page],
count = Number.ToText (page[totalResources]),
Source2 = Json.Document(Web.Contents("https://[link]/api/?page=0&size=" & count & "&sort=id,asc")),
Resources = Source2[resources],
Table = Table.FromList(Resources, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Expand = Table.ExpandRecordColumn(Table, "Column1", {"id"}, {"id"}),
txt = Table.TransformColumnTypes(Expand,{{"id", type text}}),
Solution = Table.AddColumn(txt, "Solution", each Json.Document(Web.Contents("https://[link]/api/" & [id] & "/solutions"))),
#"Expanded Solution" = Table.ExpandRecordColumn(Solution, "Solution", {"resources"}, {"Solution.resources"}),
#"Expanded Solution.resources" = Table.ExpandListColumn(#"Expanded Solution", "Solution.resources")
in
#"Expanded Solution.resources"