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

Sorry, I'm new to this forum so I may created a post that was too long. What happens in the example above is that I receive an error message if i fetch 3 orderID's at the time. The error message telling me that it's impossible to convert 'RENTALORDER' to a type table. 

 

If I fetch 4 orderID's at the time (in the example there are 3 subsequent text fields) I will be able to Apply the query to the model. 

 

In the actual case I fetched 30 orderID's at the time instead of 10 - and i was able to work around this, but off course i wonder why this happens (and I also wonder why a empty field is loaded as a table insted of null value)