Forum Discussion

danielsaf's avatar
danielsaf
Regular Visitor
7 years ago
Solved

Get API data in XML format and transform

Hello,   I'm loading XML data from a legacy SOAP WS (great post here on how to get it). Some of the tags are empty and the Get Data interprets it as [Table] array.      I need to get rid ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    danielsaf,

    Please add an step into Advanced Editor of your query.

    #"expandcolumn"= Table.TransformColumns(yourpreviousstep , {{"LIMITED_PERMISSION", each if Value.Is(_, type table) then 0 else _ }} )



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

danielsaf,

Please add an step into Advanced Editor of your query.

#"expandcolumn"= Table.TransformColumns(yourpreviousstep , {{"LIMITED_PERMISSION", each if Value.Is(_, type table) then 0 else _ }} )



Regards,
Lydia