Forum Discussion

karekaasamoen's avatar
karekaasamoen
Frequent Visitor
10 years ago
Solved

Strange behaviour when connection to a REST Api

I experienced some strange behaviour, fetching data from a REST Api resource. The resource is using cursor based pagination so I created to functions, GetPage and GetNumberOfPages to create a list of...
Need Help
Show and Tell
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    karekaasamoen

     

    Thanks for your XML samples. :) I've observed that strange behavior, the column is expanded as a table when the element in XML is blank otherwise as a normal string.

     

    In my opinion it is really an abnormal behavior. I will report this internally and post back if there comes any update. One workaround so far I can think of.

     

    #"Added Custom" = Table.AddColumn(#"Expanded Details1", "Type", each try Text.From([Details.Type]) otherwise "")

     

    Thanks again for your feedback.:)