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.:)

karekaasamoen's avatar
karekaasamoen
Frequent Visitor
10 years ago

I'll have a look into it. I can try to send you two xml-files, one from a problematic post and one from a non-problematic. I'll try to look into it through the day

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
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.:)